Changes between Version 8 and Version 9 of DatabaseBasedAnalysis/table2sql
- Timestamp:
- 08/10/18 23:05:30 (6 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
DatabaseBasedAnalysis/table2sql
v8 v9 58 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 == Changing Column Names == 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. 61 62 63 === Changing Column Names === 61 64 62 65 Sometimes the leaves' names might be quite inconvenient like in the example above. To allow to simplify column names, regular expressions (using boost's regex) can be defined to change the names. A helpful resource for regex testing is https://www.regextester.com/. Note, that these regular expressions are applied one by one on each leaf's name. A valid expression could be: … … 169 172 170 173 For test purposes, the number of events and the events which are processed can be altered with `--first` and `--max`. 171 172 == Arrays ==173 174 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.175 174 176 175 == Performance ==