Difference between revisions of "Tracker Databases"
Jump to navigation
Jump to search
Line 1: | Line 1: | ||
= Tracker Databases = | = Tracker Databases = | ||
+ | |||
+ | == FNAL Planes Database == | ||
+ | The database for the plane construction at FNAL (not in mu2e_tracker_prd). | ||
+ | |||
+ | === Importing === | ||
+ | To import to mu2e_tracker_prd: | ||
+ | |||
+ | ssh -XY username@mu2egpvmXX.fnal.gov | ||
+ | cd /mu2e/app/users/username/ | ||
+ | git clone https://github.com/Mu2e/TrackerHardwareDB | ||
+ | cd TrackerHardwareDB/python | ||
+ | python3 create_imported_fnal_planesdb.py path/to/fnal/planesdb | ||
+ | |||
+ | This will create two .sql files. You will need mu2e_tracker_admin privileges to then do | ||
+ | cd ../sql | ||
+ | psql -h ifdb08 -p 5459 mu2e_tracker_prd < create_imported_fnal_planesdb.sql | ||
+ | psql -h ifdb08 -p 5459 mu2e_tracker_prd < insert_imported_fnal_planesdb.sql | ||
+ | |||
+ | The information can then be viewed using the panel QC viewer below. | ||
== Panel QC Database == | == Panel QC Database == | ||
+ | The panel QC database that is stored in mu2e_tracker_prd | ||
=== Viewer === | === Viewer === |
Revision as of 22:07, 27 February 2023
Tracker Databases
FNAL Planes Database
The database for the plane construction at FNAL (not in mu2e_tracker_prd).
Importing
To import to mu2e_tracker_prd:
ssh -XY username@mu2egpvmXX.fnal.gov cd /mu2e/app/users/username/ git clone https://github.com/Mu2e/TrackerHardwareDB cd TrackerHardwareDB/python python3 create_imported_fnal_planesdb.py path/to/fnal/planesdb
This will create two .sql files. You will need mu2e_tracker_admin privileges to then do
cd ../sql psql -h ifdb08 -p 5459 mu2e_tracker_prd < create_imported_fnal_planesdb.sql psql -h ifdb08 -p 5459 mu2e_tracker_prd < insert_imported_fnal_planesdb.sql
The information can then be viewed using the panel QC viewer below.
Panel QC Database
The panel QC database that is stored in mu2e_tracker_prd
Viewer
Installation
To install the panel QC viewer:
ssh -XY username@mu2egpvmXX.fnal.gov cd /mu2e/app/users/username/ git clone https://github.com/Mu2e/TrackerHardwareDB cd TrackerHardwareDB/panel-qc-viewer/ npm install
Running
To run the panel QC viewer:
ssh -L 3000:localhost:3000 -XY username@mu2egpvmXX.fnal.gov cd /mu2e/app/users/username/TrackerHardwareDB/panel-qc-viewer npm start
Then you can open a browser and go to localhost:3000 on your local machine
To run on a different port you can type:
PORT=XXXX npm start