formatter = logging.Formatter(format)
handler.setFormatter(formatter)
log.addHandler(handler)
metadata = MetaData()
# New table in changeset TODO:TODO
GenomeIndexToolData_table = Table(
"genome_index_tool_data", metadata, Column("id", Integer,
primary_key=True),
Column("job_id", Integer, ForeignKey("job.id"), index=True),
Column("dataset_id", Integer, ForeignKey("dataset.id"), index=True),
Column("deferred_job_id",
Integer,
ForeignKey("deferred_job.id"),
index=True),
Column("transfer_job_id",
Integer,
ForeignKey("transfer_job.id"),
index=True), Column("fasta_path", String(255)),
Column("created_time", DateTime, default=now),
Column("modified_time", DateTime, default=now, onupdate=now),
Column("indexer", String(64)),
Column("user_id", Integer, ForeignKey("galaxy_user.id"), index=True))
def upgrade(migrate_engine):
metadata.bind = migrate_engine
print(__doc__)
metadata.reflect()
from sqlalchemy import Column, Table
from sqlalchemy.types import UnicodeText
import meta
__all__ = ['term_translation_table']
term_translation_table = Table(
'term_translation',
meta.metadata,
Column('term', UnicodeText, nullable=False),
Column('term_translation', UnicodeText, nullable=False),
Column('lang_code', UnicodeText, nullable=False),
)
from sqlalchemy import MetaData, Table, Column, String
meta = MetaData()
chatLogs = Table("chatLogs", meta, Column("eID", String), Column("IP", String),
Column("username", String), Column("channel", String),
Column("date", String), Column("message", String))
states = Bunch(NEW='new',
WAITING='waiting',
QUEUED='queued',
RUNNING='running',
OK='ok',
ERROR='error')
def __init__(self, state=None, plugin=None, params=None):
self.state = state
self.plugin = plugin
self.params = params
DeferredJob.table = Table(
"deferred_job", metadata, Column("id", Integer, primary_key=True),
Column("create_time", DateTime, default=now),
Column("update_time", DateTime, default=now, onupdate=now),
Column("state", String(64), index=True),
Column("plugin", String(128), index=True), Column("params", JSONType))
mapper(DeferredJob, DeferredJob.table, properties={})
def upgrade(migrate_engine):
metadata.bind = migrate_engine
liftoverjobs = dict()
jobs = context.query(DeferredJob).filter_by(
plugin='LiftOverTransferPlugin').all()
for job in jobs:
* name : component name i.e: AC / board ...
## relation:
loction: locations has this component
type many to many relation
'''
__tablename__ = 'component'
id = Column(Integer, primary_key=True)
name = Column(String(150), nullable=False)
locations = relationship("Location",
secondary='component_location',
back_populates="compnents")
# many to many relation between locations and components
component_location = Table(
'component_location', Base.metadata,
Column('component_id', Integer, ForeignKey('component.id')),
Column('location_id', Integer, ForeignKey('location.id')))
#
class Department(Base):
'''
# Departments: -
maintains the following information for the department: -
✓ Id: Sequential number i.e. 1,2,3…
✓ Code: - unique string that identifies the department i.e. CVL, ELEC …
✓ Name: - Department name i.e. architectural Engineering
✓ Home Building: - the department’s home building which is to be selected from list of buildings (Screen A section 3.1.1).
# relations
locations : locations holds this department
import datetime
import logging
from sqlalchemy import Column, DateTime, ForeignKey, Integer, MetaData, String, Table, TEXT
log = logging.getLogger(__name__)
metadata = MetaData()
now = datetime.datetime.utcnow
Task_table = Table(
"task", metadata, Column("id", Integer, primary_key=True),
Column("create_time", DateTime, default=now),
Column("execution_time", DateTime),
Column("update_time", DateTime, default=now, onupdate=now),
Column("state", String(64), index=True), Column("command_line", TEXT),
Column("param_filename", String(1024)), Column("runner_name", String(255)),
Column("stdout", TEXT), Column("stderr", TEXT), Column("traceback", TEXT),
Column("job_id", Integer, ForeignKey("job.id"), index=True,
nullable=False), Column("part_file", String(1024)),
Column("task_runner_name", String(255)),
Column("task_runner_external_id", String(255)))
tables = [Task_table]
def upgrade(migrate_engine):
metadata.bind = migrate_engine
print(__doc__)
metadata.reflect()
for table in tables:
try:
