def setup_destination(self):
dest = MassSpecDatabaseAdapter()
dest.trait_set(name='massspecdata_crow',
kind='mysql',
username='******',
password='******')
self.destination = dest
def setup_destination(self):
dest = MassSpecDatabaseAdapter()
dest.trait_set(name='massspecdata_crow',
kind='mysql',
username='******',
password='******')
self.destination = dest
def _secondary_db_default(self):
from apptools.preferences.preference_binding import bind_preference
db = MassSpecDatabaseAdapter()
prefid = 'pychron.massspec.database'
bind_preference(db, 'host', '{}.host'.format(prefid))
bind_preference(db, 'username', '{}.username'.format(prefid))
bind_preference(db, 'name', '{}.name'.format(prefid))
bind_preference(db, 'password', '{}.password'.format(prefid))
return db
def massspec_db_factory(path, remove=True):
from pychron.database.adapters.massspec_database_adapter import MassSpecDatabaseAdapter
from pychron.database.orms.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.database.adapters.massspec_database_adapter import MassSpecDatabaseAdapter
from pychron.database.orms.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 _db_default(self):
db = MassSpecDatabaseAdapter(kind='mysql')
return db
def _db_default(self):
db = MassSpecDatabaseAdapter(kind='mysql', autoflush=False)
return db