|
|
|
|
|
Information and URL http://home.fnal.gov/~dbox/cdf/codegen.odbc.text |
Comment |
|
Leader(s) |
Dennis Box(Fermilab, CEPA-DS), Lee Lueking (Fermilab, CEPA-DS), Dmitry Litvintsev (Fermilab, CD/CDF) |
|
|
Abstract and Goals |
An ODBC interface for DB access will allow to simplify maintenance and development of DBManager based DB Access back-end API for existing and future CDF DB applications. Currently there is a back-end per each supported DB flavor, hand written or auto-generated. The ODBC access layer will allow to eliminate redundant code and will made CDF s/w easily extendable to work with any ODBC supported DB implementation. Currently considered mySQL, Postgress. Goals: · Working ODBC for calibration DB · Make API that works with both OTL and ODBC |
|
|
Stakeholder Organizations |
CDF |
|
|
Participants and Effort |
CEPA-DS, CDF |
|
|
Timeline and Schedule |
· Make DBObjects/odbc subdirectory and modify makefiles for Codegen ODBC code (done, cvs commit pending turn of new codegen) · Create ODBC connection control code (ODB_connect, ODBC_disconnect) · Create ODBC transaction code (ODBC_statement) · Implement test cases for above code · Make ODBCDriverInfo and implement UsedSetODBC, RunListODBC, ValidSetODBC (partially done) · Make all necessary ODBC subdirectories in DBTemplates, modify codegen makefiles (done). Modify as necessary until code compiled (not yet done) · Get Codegen to generate code that uses ODBC transaction and connection control classes |
|
|
Deliverables |
ODBC DB access back-end API for DBManager |
|
|
Plans |
|
|
|
|
|
|
| dbox@fnal.gov, lueking@fnal.gov, litvinse@fnal.gov |
|