Changeset 20031 for trunk/Mars/hawc/processing/root2sql-callisto.rc

Timestamp:

01/07/21 14:38:53 (4 years ago)

Author:

tbretz

Message:

Included telescope id and the create query to the raw data extraction.

File:

• trunk/Mars/hawc/processing/root2sql-callisto.rc (modified) (1 diff)

trunk/Mars/hawc/processing/root2sql-callisto.rc

@@ +1 @@
+# link to database
 uri=hawcwrite:password@ihp-pc45.ethz.ch/hawcdata
 
-# Table's name, will be created if it is not existing already
-create=yes
-delete=yes
 # Tree's name
 tree=Events
 
+# Table's name, will be created if it is not existing already
+#table=Callisto
+
+# Create if not yet existing
+create=yes
+# Delete entries corresponding to consts
+delete=yes
+
+# Consts
+primary=Telescope
 primary=NIGHT
 primary=RUNID
+# Event ID
 primary=DAQEvtNumber
 
+# Manual specification of type for const columns
+sql-type=Telescope/TINYINT UNSIGNED NOT NULL
 sql-type=NIGHT/INT UNSIGNED NOT NULL
 sql-type=RUNID/MEDIUMINT UNSIGNED NOT NULL