Esempi in Python per MassSpecDatabaseAdapter.connect

Esempio n. 1

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

Esempio n. 2

File: test_helpers.py Progetto: NMGRL/pychron

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

Esempio n. 3

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

Esempio n. 4

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

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: