Changes between Version 8 and Version 9 of DatabaseBasedAnalysis/table2sql


Ignore:
Timestamp:
08/10/18 23:05:30 (6 years ago)
Author:
tbretz
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • DatabaseBasedAnalysis/table2sql

    v8 v9  
    5858If the leaf with the basic data type is called ''MTime.fTime.fMilliSec', the column would be called ''MTime.fTime.fMilliSec'' as well.
    5959
    60 == Changing Column Names ==
     60Both, 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 ===
    6164
    6265Sometimes 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:
     
    169172
    170173For 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.
    175174
    176175== Performance ==