projects
/
id3fs.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
last_update: store in id3fs table, update when index is updated,
[id3fs.git]
/
lib
/
ID3FS
/
DB.pm
diff --git
a/lib/ID3FS/DB.pm
b/lib/ID3FS/DB.pm
index
11381c6
..
b6570ce
100644
(file)
--- a/
lib/ID3FS/DB.pm
+++ b/
lib/ID3FS/DB.pm
@@
-84,7
+84,8
@@
sub create
$self->{dbh}->do("CREATE INDEX $index ON " . $indexes{$index});
}
}
$self->{dbh}->do("CREATE INDEX $index ON " . $indexes{$index});
}
}
- $self->cmd("INSERT INTO id3fs (schema_version) VALUES (?)", $SCHEMA_VERSION);
+ $self->cmd("INSERT INTO id3fs (schema_version, last_update) VALUES (?, ?)",
+ $SCHEMA_VERSION, time());
}
sub checkschema
}
sub checkschema
@@
-99,6
+100,20
@@
sub checkschema
}
}
}
}
+sub last_update
+{
+ my($self, $newval)=@_;
+ if(defined($newval))
+ {
+ $self->cmd("UPDATE id3fs SET last_update=?", $newval);
+ }
+ else
+ {
+ ($newval)=$self->cmd_onerow("SELECT last_update from id3fs");
+ }
+ return $newval;
+}
+
sub cmd_sth
{
my($self, $sql, @params)=@_;
sub cmd_sth
{
my($self, $sql, @params)=@_;
@@
-548,7
+563,8
@@
sub last_insert_id
__DATA__
CREATE TABLE id3fs (
__DATA__
CREATE TABLE id3fs (
- schema_version INTEGER
+ schema_version INTEGER,
+ last_update
);
CREATE TABLE files (
);
CREATE TABLE files (