Changeset: 56a7d6dedec2 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=56a7d6dedec2 Modified Files: sql/backends/monet5/vaults/mseed.mx sql/backends/monet5/vaults/mseed.sql Branch: sciql Log Message:
made mseed.sql somewhat working by: - actually creating the table needed (the CREATE TABLE was statement only in the documentation in mseed.mx) - cleaning up all functions, tables created - Synced the mseed.mx documentation with mseed.sql diffs (42 lines): diff --git a/sql/backends/monet5/vaults/mseed.mx b/sql/backends/monet5/vaults/mseed.mx --- a/sql/backends/monet5/vaults/mseed.mx +++ b/sql/backends/monet5/vaults/mseed.mx @@ -28,7 +28,9 @@ The mseed catalog initialization script should have been run. @begin verbatim -- this schema is intended to experiment with accessing mseed files -DROP FUNCTION mseedImport(); +DROP FUNCTION mseedImport; +DROP FUNCTION mseedLoad; +DROP TABLE mseed; DROP TABLE mseedCatalog; -- all records in the mseed files correspond to a row in the catalog diff --git a/sql/backends/monet5/vaults/mseed.sql b/sql/backends/monet5/vaults/mseed.sql --- a/sql/backends/monet5/vaults/mseed.sql +++ b/sql/backends/monet5/vaults/mseed.sql @@ -1,5 +1,7 @@ -- this schema is intended to experiment with accessing mseed files -DROP FUNCTION mseedImport(); +DROP FUNCTION mseedImport; +DROP FUNCTION mseedLoad; +DROP TABLE mseed; DROP TABLE mseedCatalog; -- all records in the mseed files correspond to a row in the catalog @@ -22,6 +24,15 @@ maxval float ); +-- The reference table for querying is simply +CREATE TABLE mseed( +mseed int, -- Vault file id +seqno int, -- SEED record sequence number, should be between 0 and 999999 +time timestamp, -- click +data int, -- The actual measurement value. +FOREIGN KEY (mseed,seqno) REFERENCES mseedCatalog(mseed,seqno) +); + -- this function inserts the mseed record information into the catalog -- errors are returned for off-line analysis. _______________________________________________ Checkin-list mailing list [email protected] http://mail.monetdb.org/mailman/listinfo/checkin-list
