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 ) )
assign_mapper( context, DeferredJob, DeferredJob.table, properties = {} )
def upgrade():
print __doc__
liftoverjobs = dict()
jobs = context.query( DeferredJob ).filter_by( plugin='LiftOverTransferPlugin' ).all()
for job in jobs:
if job.params[ 'parentjob' ] not in liftoverjobs:
liftoverjobs[ job.params[ 'parentjob' ] ] = []
liftoverjobs[ job.params[ 'parentjob'] ].append( job.id )
for parent in liftoverjobs:
lifts = liftoverjobs[ parent ]
deferred = context.query( DeferredJob ).filter_by( id=parent ).first()
Column( "info", TrimmedString( 255 ), key="_info" ), #when not None/null this will supercede display in library (but not when imported into user's history?)
Column( "deleted", Boolean, index=True, default=False ) )
##mappers
assign_mapper( context, Dataset, Dataset.table,
properties=dict(
history_associations=relation(
HistoryDatasetAssociation,
primaryjoin=( Dataset.table.c.id == HistoryDatasetAssociation.table.c.dataset_id ) ),
active_history_associations=relation(
HistoryDatasetAssociation,
primaryjoin=( ( Dataset.table.c.id == HistoryDatasetAssociation.table.c.dataset_id ) & ( HistoryDatasetAssociation.table.c.deleted == False ) ) ),
library_associations=relation(
LibraryDatasetDatasetAssociation,
primaryjoin=( Dataset.table.c.id == LibraryDatasetDatasetAssociation.table.c.dataset_id ) ),
active_library_associations=relation(
LibraryDatasetDatasetAssociation,
primaryjoin=( ( Dataset.table.c.id == LibraryDatasetDatasetAssociation.table.c.dataset_id ) & ( LibraryDatasetDatasetAssociation.table.c.deleted == False ) ) )
) )
assign_mapper( context, HistoryDatasetAssociation, HistoryDatasetAssociation.table,
properties=dict(
dataset=relation(
Dataset,
primaryjoin=( Dataset.table.c.id == HistoryDatasetAssociation.table.c.dataset_id ), lazy=False ),
# .history defined in History mapper
##mappers
assign_mapper(
context,
Dataset,
Dataset.table,
properties=dict(
history_associations=relation(
HistoryDatasetAssociation,
primaryjoin=(Dataset.table.c.id ==
HistoryDatasetAssociation.table.c.dataset_id)),
active_history_associations=relation(
HistoryDatasetAssociation,
primaryjoin=(
(Dataset.table.c.id
== HistoryDatasetAssociation.table.c.dataset_id) &
(HistoryDatasetAssociation.table.c.deleted == False))),
library_associations=relation(
LibraryDatasetDatasetAssociation,
primaryjoin=(Dataset.table.c.id ==
LibraryDatasetDatasetAssociation.table.c.dataset_id)),
active_library_associations=relation(
LibraryDatasetDatasetAssociation,
primaryjoin=(
(Dataset.table.c.id
== LibraryDatasetDatasetAssociation.table.c.dataset_id) &
(LibraryDatasetDatasetAssociation.table.c.deleted == False)))))
assign_mapper(
context,