def massspec_db_factory(path, remove=True): from pychron.mass_spec.database.massspec_database_adapter import MassSpecDatabaseAdapter from pychron.mass_spec.database.massspec_orm import Base if remove and os.path.isfile(path): os.remove(path) db = MassSpecDatabaseAdapter() # db.verbose_retrieve_query = True db.trait_set(kind='sqlite', path=path) db.connect() metadata = Base.metadata db.create_all(metadata) return db
def massspec_db_factory(path, remove=True): from pychron.mass_spec.database.massspec_database_adapter import MassSpecDatabaseAdapter from pychron.mass_spec.database.massspec_orm import Base if remove and os.path.isfile(path): os.remove(path) db = MassSpecDatabaseAdapter() # db.verbose_retrieve_query = True db.trait_set(kind='sqlite', path=path) db.connect() metadata = Base.metadata db.create_all(metadata) return db
# ============= enthought library imports ======================= import os # ============= standard library imports ======================== # ============= local library imports ========================== os.environ['MassSpecDBVersion'] = '16' from pychron.mass_spec.database.massspec_database_adapter import MassSpecDatabaseAdapter from pychron.mass_spec.database.massspec_orm import AnalysesTable, IsotopeTable, DetectorTable db = MassSpecDatabaseAdapter(bind=False) db.host = '129.138.12.160' db.name = 'massspecdata' db.username = '******' db.password = '******' db.kind = 'mysql' db.connect(test=False) def fix_reference_detector(rd, aid): with db.session_ctx() as sess: q = sess.query(AnalysesTable) q = q.filter(AnalysesTable.AnalysisID == aid) record = q.one() q = sess.query(DetectorTable) q = q.join(IsotopeTable) q = q.join(AnalysesTable) q = q.filter(AnalysesTable.AnalysisID == aid) for r in q.all():
from __future__ import print_function import os # ============= standard library imports ======================== # ============= local library imports ========================== os.environ['MassSpecDBVersion'] = '16' from pychron.mass_spec.database.massspec_database_adapter import MassSpecDatabaseAdapter from pychron.mass_spec.database.massspec_orm import AnalysesTable, IsotopeTable, DetectorTable db = MassSpecDatabaseAdapter(bind=False) db.host = '129.138.12.160' db.name = 'massspecdata' db.username = '******' db.password = '******' db.kind = 'mysql' db.connect(test=False) def fix_reference_detector(rd, aid): q = db.session.query(AnalysesTable) q = q.filter(AnalysesTable.AnalysisID == aid) record = q.one() q = db.session.query(DetectorTable) q = q.join(IsotopeTable) q = q.join(AnalysesTable) q = q.filter(AnalysesTable.AnalysisID == aid) for r in q.all(): if r.Label == rd: