Python MassSpecDatabaseAdapter.kind Examples

Example #1

# ============= 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)

Example #2

File: mass_spec_utilities.py Project: ael-noblegas/pychron

from __future__ import absolute_import
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():