Skip to content
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 new 'all chemicals' dose data set #150

Open
kdionisio opened this issue Jul 19, 2017 · 2 comments
Open

Load new 'all chemicals' dose data set #150

kdionisio opened this issue Jul 19, 2017 · 2 comments

Comments

@kdionisio
Copy link
Contributor

Load directly to production database, after #146 is complete

@kdionisio kdionisio self-assigned this Jul 19, 2017
@kdionisio kdionisio added this to the Production release 1.X milestone Jul 19, 2017
@kdionisio kdionisio added this to TODO in Fukuisaurus Jul 19, 2017
@kdionisio
Copy link
Contributor Author

kdionisio commented Aug 10, 2017

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/allPUCs_OPP/Daily/S2D_daily_all_allPUCs_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=1; 

@kdionisio
Copy link
Contributor Author

loaded into prod_hem

@kdionisio kdionisio moved this from TODO to QA in Fukuisaurus Aug 10, 2017
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
Development

No branches or pull requests

1 participant