def upgrade(migrate_engine): # Upgrade operations go here. Don't create your own engine; bind # migrate_engine to your metadata meta.bind = migrate_engine #########################Account """ A view stores a specific configuration of a visualisation widget. """ country = Table('country', meta, Column('id', Integer, primary_key=True), Column('gid', Integer, unique=True), Column('geounit', Unicode(300), unique=True), Column('label', Unicode(300)), Column('pagesettings', MutableDict.as_mutable(JSONType), default=dict) ) country.create() pass
def upgrade(migrate_engine): # Upgrade operations go here. Don't create your own engine; bind # migrate_engine to your metadata meta.bind = migrate_engine #########################Account """ A view stores a specific configuration of a visualisation widget. """ country = Table( 'country', meta, Column('id', Integer, primary_key=True), Column('gid', Integer, unique=True), Column('geounit', Unicode(300), unique=True), Column('label', Unicode(300)), Column('pagesettings', MutableDict.as_mutable(JSONType), default=dict)) country.create() pass
def upgrade(migrate_engine): # Upgrade operations go here. Don't create your own engine; bind # migrate_engine to your metadata meta.bind = migrate_engine account = Table('account', meta, autoload=True) account = Table('dataset', meta, autoload=True) #########################Account dataview = Table('dataview', meta, Column('id', Integer, primary_key=True), Column('title', Unicode(500)), Column('description', Unicode()), Column('created_at', DateTime), Column('updated_at', DateTime), Column('urlhash', Unicode(2000)), Column('account_id', Integer, ForeignKey('account.id')), Column('cloned_dataview_id', Integer, ForeignKey('dataview.id')), Column('settings', MutableDict.as_mutable(JSONType), default=dict) ) dataview.create() ################## ManytoMany accounts to datasets dataview_dataset_table = Table( 'dataview_dataset', meta, Column('dataview_id', Integer, ForeignKey('dataview.id'), primary_key=True), Column('dataset_id', Integer, ForeignKey('dataset.id'), primary_key=True) ) dataview_dataset_table.create() pass
def upgrade(migrate_engine): # Upgrade operations go here. Don't create your own engine; bind # migrate_engine to your metadata meta.bind = migrate_engine account = Table('account', meta, autoload=True) account = Table('dataset', meta, autoload=True) #########################Account dataview = Table( 'dataview', meta, Column('id', Integer, primary_key=True), Column('title', Unicode(500)), Column('description', Unicode()), Column('created_at', DateTime), Column('updated_at', DateTime), Column('urlhash', Unicode(2000)), Column('account_id', Integer, ForeignKey('account.id')), Column('cloned_dataview_id', Integer, ForeignKey('dataview.id')), Column('settings', MutableDict.as_mutable(JSONType), default=dict)) dataview.create() ################## ManytoMany accounts to datasets dataview_dataset_table = Table( 'dataview_dataset', meta, Column('dataview_id', Integer, ForeignKey('dataview.id'), primary_key=True), Column('dataset_id', Integer, ForeignKey('dataset.id'), primary_key=True)) dataview_dataset_table.create() pass
def upgrade(migrate_engine): # Upgrade operations go here. Don't create your own engine; bind # migrate_engine to your metadata meta.bind = migrate_engine #########################Account account = Table('account', meta, Column('id', Integer, primary_key=True), Column('fullname', Unicode(2000)), Column('email', Unicode(2000), unique=True), Column('password', Unicode(2000)), Column('api_key', Unicode(2000)), Column('usg_group', Unicode(2000)), Column('login_hash', Unicode(2000)), Column('admin', Boolean, default=False), Column('verified', Boolean, default=False) ) account.create() ##################MetadataOrg metadataorg = Table('metadataorg', meta, Column('id', Integer, primary_key=True), Column('label', Unicode(2000)), Column('description', Unicode()), Column('contactName', Unicode(2000)), Column('contactEmail', Unicode(2000)), Column('accessLevel', Unicode(2000)), Column('bureauCode', Unicode(2000)), Column('lastUpdated', DateTime) ) metadataorg.create() ################## DataOrg dataorg = Table('dataorg', meta, Column('id', Integer, primary_key=True), Column('label', Unicode(2000)), Column('description', Unicode()), Column('ORTemplate', MutableDict.as_mutable(JSONType), default=dict), Column('mappingTemplate', MutableDict.as_mutable(JSONType), default=dict), Column('prefuncs', MutableDict.as_mutable(JSONType), default=dict), Column('lastUpdated', DateTime), Column('metadataorg_id', Integer, ForeignKey('metadataorg.id')) ) dataorg.create() #####@###############Source source = Table('source', meta, Column('id', Integer, primary_key=True), Column('name', Unicode(255)), Column('url', Unicode), Column('created_at', DateTime, default=datetime.utcnow), Column('updated_at', DateTime, default=datetime.utcnow, onupdate=datetime.utcnow), Column('ORid', BigInteger) ) source.create() ##################### SourceFile sourcefile = Table('sourcefile', meta, Column('id', Integer, primary_key=True), Column('rawfile', Unicode), Column('source_id', Integer, ForeignKey('source.id')), Column('created_at', DateTime, default=datetime.utcnow), Column('updated_at', DateTime, default=datetime.utcnow, onupdate=datetime.utcnow) ) sourcefile.create() ####################Dataset dataset = Table('dataset', meta, Column('id', Integer, primary_key=True), Column('name', Unicode(255), unique=True), Column('label', Unicode(2000)), Column('description', Unicode), Column('category', Unicode()), Column('private', Boolean), Column('created_at', DateTime, default=datetime.utcnow), Column('updated_at', DateTime, default=datetime.utcnow, onupdate=datetime.utcnow), Column('datalastupdated', DateTime, default=datetime.utcnow), Column('source_id', Integer, ForeignKey('source.id')), Column('mapping', MutableDict.as_mutable(JSONType), default=dict), Column('ORoperations', MutableDict.as_mutable(JSONType), default=dict), Column('prefuncs', MutableDict.as_mutable(JSONType), default=dict), Column('dataType', Unicode(2000)), Column('published', Boolean, default=False), Column('loaded', Boolean, default=False), Column('tested', Boolean, default=False), Column('dataorg_id', Integer, ForeignKey('dataorg.id')) ) dataset.create() ###########################Runs runs = Table('run', meta, Column('id', Integer, primary_key=True), Column('operation', Unicode(2000)), Column('status', Unicode(2000)), Column('time_start', DateTime, default=datetime.utcnow), Column('time_end', DateTime), Column('dataset_id', Integer, ForeignKey('dataset.id'), nullable=True), Column('source_id', Integer, ForeignKey('source.id'), nullable=True) ) runs.create() ################## ManytoMany accounts to datasets account_dataset_table = Table( 'account_dataset', meta, Column('dataset_id', Integer, ForeignKey('dataset.id'), primary_key=True), Column('account_id', Integer, ForeignKey('account.id'), primary_key=True) ) account_dataset_table.create() pass