-
Notifications
You must be signed in to change notification settings - Fork 0
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Load 'air freshener' dose data #151
Comments
Note: Data was loaded to DEVELOPMENT database LOAD DATA LOCAL INFILE '/home/kdionisio/HEMDBLoad/S2D_daily_all_airfreshener.csv' INTO TABLE hem_app_dose FIELDS TERMINATED BY ',' ENCLOSED BY '"' ignore 1 lines (person_id, @chemical, day, dir_derm_exp, dir_derm_max, dir_derm_abs, dir_inhal_exp, dir_inhal_mass, dir_inhal_max, dir_inhal_abs, dir_ingest_exp, dir_ingest_abs, hem_app_dose.release, ind_derm_exp, ind_derm_max, ind_derm_abs, ind_inhal_exp, ind_inhal_max, ind_inhal_mass, ind_inhal_abs, ind_ingest_exp, ind_ingest_abs, out_sur, out_air, drain, waste) SET created_at = NOW(), updated_at = NOW(), chemical_id = (SELECT id FROM hem_app_chemical WHERE dtxsid = @chemical), runparams_id=3; |
currently includes 1 chemical |
Dose results not valid; must re-run with updated code and re-loaded into DB |
Command to load dose results into DB after chemical_id matching has been done in R. Dose results are from 8/3 S2D version. LOAD DATA LOCAL INFILE '/home/kdionisio/HEM/output/S2D/airfreshener_OPP/Daily/S2D_daily_all_airfreshener_OPP.csv' INTO TABLE hem_app_dose FIELDS TERMINATED BY ',' ENCLOSED BY '"' ignore 1 lines (person_id, chemical_id, day, dir_derm_exp, dir_derm_max, dir_derm_abs, dir_inhal_exp, dir_inhal_mass, dir_inhal_max, dir_inhal_abs, dir_ingest_exp, dir_ingest_abs, hem_app_dose.release, ind_derm_exp, ind_derm_max, ind_derm_abs, ind_inhal_exp, ind_inhal_max, ind_inhal_mass, ind_inhal_abs, ind_ingest_exp, ind_ingest_abs, out_sur, out_air, drain, waste) SET created_at = NOW(), updated_at = NOW(), runparams_id=3; |
Loaded into prod_hem |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Load directly to production database, after #146 is complete
The text was updated successfully, but these errors were encountered: