DB_Track/README.md

# Track reconstruction from database export
## Prerequisities
* System which runs CERN Root (Tested on MacOS High Sierra 10.13.4)
* CERN Root (Tested on 6.13/03)

## Build and run
* Clone this repository

```
git clone https://git.divaldo.hu/divaldo/DB_Track.git
```
* Create a working directory or use the Debug folder which already contains a data file
* If you decided to use another folder, then copy the data.txt to it
* You can use make -jN to use N number of CPU cores to build the app

```
cd DB_Track/Debug
cmake ../
make
```
* If complete, you can run it with the following command:

```
./DB_Track
```
* Use Ctrl + C to exit

## If you have newer data
* Export format is CSV
* Columns separated with space (" ")
* Columns enclosed with nothing
* Columns escaped with nothing
* The query order: ch_id, time_sec, time_ns, peak_amp
* Ascending by time_sec and time_ns

Use this query:
```
SELECT ch_id, time_sec, time_ns, peak_amp FROM adatok.fb55 ORDER BY time_sec ASC, time_ns ASC INTO OUTFILE '/tmp/fb55_exp.csv' FIELDS TERMINATED BY ' ' ENCLOSED BY '' LINES TERMINATED BY '\n';
```