X-Git-Url: http://dxcluster.net/gitweb/gitweb.cgi?a=blobdiff_plain;f=perl%2FDXSql%2FSQLite.pm;h=d151f82e31ac314adae64d4982e13aa93e1b7084;hb=fd0a34c34ad4112ee21e0730f7307498ff437e18;hp=2f62461cdb0b2394d8180d8ff33745390e4d29d6;hpb=e5a96ae00d9c44c94cff828e73cadc5352e531ef;p=spider.git

diff --git a/perl/DXSql/SQLite.pm b/perl/DXSql/SQLite.pm
index 2f62461c..d151f82e 100644
--- a/perl/DXSql/SQLite.pm
+++ b/perl/DXSql/SQLite.pm
@@ -3,19 +3,61 @@
 #
 # Stuff like table creates and (later) alters
 #
-# $Id$
+#
 #
 # Copyright (c) 2005 Dirk Koopman G1TLH
 #
 
 package DXSql::SQLite;
 
-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 DXDebug;
 
+use vars qw(@ISA);
 @ISA = qw{DXSql};
 
+sub show_tables
+{
+	my $self = shift;
+	my $s = q(SELECT name FROM sqlite_master WHERE type='table' ORDER BY name);
+	my $sth = $self->prepare($s);
+	$sth->execute;
+	my @out;
+	push @out, $sth->fetchrow_array;
+	$sth->finish;
+	return @out;
+}
+
+sub spot_create_table
+{
+	my $self = shift;
+	my $s = q{create table spot (
+rowid integer primary key,
+freq real not null,
+spotcall text not null,
+time int not null,
+comment text,
+spotter text not null,
+spotdxcc int,
+spotterdxcc int,
+origin text,
+spotitu int,
+spotcq int,
+spotteritu int,
+spottercq int,
+spotstate text,
+spotterstate text
+)};
+	$self->do($s);
+}
+
+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)');
+	dbg('adding spot index ix2');
+}
+
+
 1;