Changes between Version 4 and Version 5 of DatabaseBasedAnalysis/table2sql

Timestamp:

08/07/18 16:42:59 (6 years ago)

Author:

tbretz

Comment:

--

DatabaseBasedAnalysis/table2sql

@@ -182 +182 @@
 A specialty of FITS-extensions is that they can contains fixed-size arrays of numbers. If the array is called ARR and has 3 fields, the SQL columns will be called ARR[0], ARR[1] and ARR[2]. All modifier options working on columns always alter all corresponding columns at once.
 
-
-
+== Example ==
+
+For example, my resource file to convert ''ganymed'' files to SQL tables looks like this:
+
+{{{
+# Database uri and credentials
+#uri=...
+
+# Regular expression to match columns which shell be ignored
+ignore=ThetaSquared\..*     
+ignore=Ghostbuster\..*
+ignore=MHillasSrc\..*
+ignore=MHillasSrcAnti\..*
+ignore=MSrcPosCam\..*
+ignore=MSrcPosAnti\..*
+ignore=DataType\..*
+ignore=.*\.fUniqueID
+ignore=.*\.fBits
+ignore=MPointingPos\.fHa
+
+# Regular expressions to simplify column names in table
+map=\.fVal/ 
+map=MHillas\.f/
+map=MHillasExt\.f/
+map=MPointingPos\.f/
+map=MImagePar\.f/
+map=MNewImagePar\.f/
+map=MTime\.fTime\.f/
+map=MTime\.f/
+
+# Overwrites the SQL data type for some columns
+sql-type=FileId/INT UNSIGNED
+sql-type=EvtNumber/INT UNSIGNED
+
+# Columsn to be setup as primary keys
+primary=FileId
+primary=EvtNumber
+}}}
+
+
+