Changeset 5193

Timestamp:

Sep 29, 2005, 1:19:25 PM (21 years ago)

Author:

jhoblitt

Message:

add file_id to ::Image::New
rename ::Image::New's table from 'new' -> 'image_new'
add ::Metadata::new

File:

• trunk/PS-IPP-MetaDB/lib/PS/IPP/MetaDB.pm (modified) (5 diffs)

trunk/PS-IPP-MetaDB/lib/PS/IPP/MetaDB.pm

@@ -1 +1 @@
 # Copyright (C) 2005  Joshua Hoblitt
 #
-# $Id: MetaDB.pm,v 1.7 2005-09-29 23:08:14 jhoblitt Exp $
+# $Id: MetaDB.pm,v 1.8 2005-09-29 23:19:25 jhoblitt Exp $
 
 package PS::IPP::MetaDB;
@@ -136 +136 @@
 =over 4
 
-=item * new
+=item * image_new
 
 This table contains a list of new data waiting to be downloaded from the
@@ -165 +165 @@
 Date/Time stamp of file when the file became available.
 
+=item * file_id
+
+OTIS's ID string for the file, i.e. it's filename.
+
 =item * size
 
@@ -189 +193 @@
 sub init
 {
-    __PACKAGE__->table("new");
+    __PACKAGE__->table("image_new");
     __PACKAGE__->create_table(q{
         exp_id      BIGINT          NOT NULL PRIMARY KEY,
@@ -196 +200 @@
         camera      VARCHAR(255),
         stamp       DATETIME,
+        file_id     VARCHAR(255),
+        size        INT,
+        md5         VARCHAR(32),
+        url         VARCHAR(255)    NOT NULL
+    });
+    __PACKAGE__->set_up_table;
+}
+
+=item * metadata_new
+
+This table contains a list of new metadata waiting to be downloaded from the
+summit.  XXX Are these files written to disk or just parsed in memory?
+
+Table description:
+
+=over 4
+
+=item * stamp
+
+Date/Time stamp of file when the file became available.
+
+=item * file_id
+
+OTIS's ID string for the file, i.e. it's filename.
+
+=item * size
+
+The size of the file in bytes.
+
+=item * md5
+
+The md5 checksum of the file in hexadecimal form (ASCII).
+
+=item * url
+
+URL to retrieve data from.
+
+=back
+
+=cut
+
+package PS::IPP::MetaDB::Metadata::New;
+
+use base qw( PS::IPP::MetaDB );
+
+__PACKAGE__->register_init(\&init);
+
+sub init
+{
+    __PACKAGE__->table("metadata_new");
+    __PACKAGE__->create_table(q{
+        stamp       DATETIME,
+        file_id     VARCHAR(255),
         size        INT,
         md5         VARCHAR(32),