X-Git-Url: http://dxcluster.net/gitweb/gitweb.cgi?a=blobdiff_plain;f=perl%2FDXSql%2FSQLite.pm;h=2330837f41cd4b2192dc2821f926ff917c00653b;hb=cbb522ef802d48991734a4ce803fa6ffa9774588;hp=9447505a56795f6536bd90f9865cd9736db1fc3f;hpb=da65011693cc9a7a33f09424f7a19a51937d986c;p=spider.git

diff --git a/perl/DXSql/SQLite.pm b/perl/DXSql/SQLite.pm
index 9447505a..2330837f 100644
--- a/perl/DXSql/SQLite.pm
+++ b/perl/DXSql/SQLite.pm
@@ -3,7 +3,7 @@
 #
 # Stuff like table creates and (later) alters
 #
-# $Id$
+#
 #
 # Copyright (c) 2005 Dirk Koopman G1TLH
 #
@@ -12,12 +12,7 @@ package DXSql::SQLite;
 
 use DXDebug;
 
-use vars qw($VERSION $BRANCH @ISA);
-$VERSION = sprintf( "%d.%03d", q$Revision$ =~ /(\d+)\.(\d+)/ );
-$BRANCH = sprintf( "%d.%03d", q$Revision$ =~ /\d+\.\d+\.(\d+)\.(\d+)/  || (0,0));
-$main::build += $VERSION;
-$main::branch += $BRANCH;
-
+use vars qw(@ISA);
 @ISA = qw{DXSql};
 
 sub show_tables
@@ -27,11 +22,36 @@ sub show_tables
 	my $sth = $self->prepare($s);
 	$sth->execute;
 	my @out;
-	push @out, $sth->fetchrow_array;
+	while (my @t = $sth->fetchrow_array) {
+		push @out, @t;
+	}
 	$sth->finish;
 	return @out;
 }
 
+sub has_ipaddr
+{
+	my $self = shift;
+	my $s = q(PRAGMA table_info(spot));
+	my $sth = $self->prepare($s);
+	$sth->execute;
+	while (my @t = $sth->fetchrow_array) {
+		if ($t[1] eq 'ipaddr') {
+			$sth->finish;
+			return 1;
+		}
+	}
+	$sth->finish;
+	return undef;
+}
+
+sub add_ipaddr
+{
+	my $self = shift;
+	my $s = q(alter table spot add column ipaddr text);
+	$self->do($s);
+}
+
 sub spot_create_table
 {
 	my $self = shift;
@@ -50,7 +70,8 @@ spotcq int,
 spotteritu int,
 spottercq int,
 spotstate text,
-spotterstate text
+spotterstate text,
+ipaddr text
 )};
 	$self->do($s);
 }
@@ -58,10 +79,10 @@ spotterstate text
 sub spot_add_indexes
 {
 	my $self = shift;
-	$self->do('create index spot_ix1 on spot(time desc)');
 	dbg('adding spot index ix1');
-	$self->do('create index spot_ix2 on spot(spotcall asc)');
+	$self->do('create index spot_ix1 on spot(time desc)');
 	dbg('adding spot index ix2');
+	$self->do('create index spot_ix2 on spot(spotcall asc)');
 }