Column("id", Integer, primary_key=True),
Column("dataset_id", Integer, ForeignKey("dataset.id"), index=True),
Column("create_time", DateTime, default=now),
Column("update_time", DateTime, default=now, onupdate=now),
Column("copied_from_history_dataset_association_id",
Integer,
ForeignKey("history_dataset_association.id"),
nullable=True),
Column("copied_from_library_dataset_dataset_association_id",
Integer,
ForeignKey("library_dataset_dataset_association.id"),
nullable=True), Column("hid", Integer),
Column("name", TrimmedString(255)), Column("info", TrimmedString(255)),
Column("blurb", TrimmedString(255)), Column("peek", TEXT),
Column("extension", TrimmedString(64)),
Column("metadata", MetadataType(), key="_metadata"),
Column("parent_id",
Integer,
ForeignKey("history_dataset_association.id"),
nullable=True), Column("designation", TrimmedString(255)),
Column("deleted", Boolean, index=True, default=False),
Column("visible", Boolean))
LibraryDatasetDatasetAssociation.table = Table(
"library_dataset_dataset_association", metadata,
Column("id", Integer, primary_key=True),
Column("library_dataset_id",
Integer,
ForeignKey("library_dataset.id"),
index=True),
Column("dataset_id", Integer, ForeignKey("dataset.id"), index=True),
log.setLevel(logging.DEBUG)
metadata = MetaData()
HistoryDatasetAssociationHistory_table = Table(
"history_dataset_association_history",
metadata,
Column("id", Integer, primary_key=True),
Column("history_dataset_association_id",
Integer,
ForeignKey("history_dataset_association.id"),
index=True),
Column("update_time", DateTime, default=now),
Column("version", Integer, index=True),
Column("name", TrimmedString(255)),
Column("extension", TrimmedString(64)),
Column("metadata", MetadataType(), key='_metadata'),
Column("extended_metadata_id",
Integer,
ForeignKey("extended_metadata.id"),
index=True),
)
def upgrade(migrate_engine):
print(__doc__)
metadata.bind = migrate_engine
metadata.reflect()
try:
HistoryDatasetAssociationHistory_table.create()
log.debug("Created history_dataset_association_history table")
except Exception: