Changes between Version 16 and Version 17 of DatabaseBasedAnalysis/table2sql
- Timestamp:
- 09/02/18 14:51:31 (7 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
DatabaseBasedAnalysis/table2sql
v16 v17 50 50 }}} 51 51 52 In these three examples, the first one would read from a tree ''Events'' and write to table ''Events''. The second case would read from a tree '' MyTree'' and write to a table ''MyTree'' and the third case would read from a tree ''MyTree'' and write to a table ''MyTable''.52 In these three examples, the first one would read from a tree ''Events'' and write to table ''Events''. The second case would read from a tree ''!MyTree'' and write to a table ''!MyTree'' and the third case would read from a tree ''!MyTree'' and write to a table ''!MyTable''. 53 53 54 54 === Column Names === … … 56 56 The name of each column to which data is filled from a leave is obtained from the leaves' names. The leave names can be checked using `--print-leaves`. A `--print-branches` exists for convenience to print only the high-level branches. 57 57 58 If the leaf with the basic data type is called ''MTime.fTime.fMilliSec' , the column would be called ''MTime.fTime.fMilliSec'' as well.58 If the leaf with the basic data type is called ''MTime.fTime.fMilliSec'', the column would be called ''MTime.fTime.fMilliSec'' as well. 59 59 60 60 Both, root leaves and FITS-extension can contain fixes sized arrays of basic data types. 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. … … 90 90 --ignore=ThetaSq\..* 91 91 }}} 92 will skip all leaves which name contains with ' ThetaSq.'. This option can be given more than once.92 will skip all leaves which name contains with '!ThetaSq.'. This option can be given more than once. 93 93 94 94 The corresponding C++ call is `boost::regex_match(leafname, regex)` for `--ignore regex`.
