class BookCategory(Base): __tablename__ = 'book_category' id = sa.Column( postgresql_types.INTEGER(), primary_key=True, unique=True, nullable=False, autoincrement=True, ) book_id = sa.Column( postgresql_types.UUID(), sa.ForeignKey(column="book.id", ondelete="CASCADE"), primary_key=False, unique=False, nullable=False, ) category_id = sa.Column( postgresql_types.INTEGER(), sa.ForeignKey(column="category.id", ondelete="CASCADE"), primary_key=False, unique=False, nullable=False, autoincrement=True, ) book = sa.orm.relationship( 'Book', foreign_keys="[book_category.c.book_id]", remote_side=None, ) category = sa.orm.relationship( 'Category', foreign_keys="[book_category.c.category_id]", remote_side=None, )
class Permission(Base): __tablename__ = 'auth_permission' id = sa.Column( postgresql_types.INTEGER(), primary_key=True, unique=True, nullable=False, autoincrement=True, ) name = sa.Column( postgresql_types.VARCHAR(length=255), primary_key=False, unique=False, nullable=False, ) content_type_id = sa.Column( postgresql_types.INTEGER(), sa.ForeignKey(column="django_content_type.id", ondelete="CASCADE"), primary_key=False, unique=False, nullable=False, autoincrement=True, ) codename = sa.Column( postgresql_types.VARCHAR(length=100), primary_key=False, unique=False, nullable=False, ) content_type = sa.orm.relationship( 'ContentType', foreign_keys="[auth_permission.c.content_type_id]", remote_side=None, )
class CategoryRelation(Base): __tablename__ = 'category_relation' id = sa.Column( postgresql_types.INTEGER(), primary_key=True, unique=True, nullable=False, autoincrement=True, doc="testtest", ) category1_id = sa.Column( postgresql_types.INTEGER(), sa.ForeignKey(column="category.id", ondelete="CASCADE"), primary_key=False, unique=False, nullable=False, autoincrement=True, doc="testtest", ) category2_id = sa.Column( postgresql_types.INTEGER(), sa.ForeignKey(column="category.id", ondelete="CASCADE"), primary_key=False, unique=False, nullable=False, autoincrement=True, doc="testtest", ) type = sa.Column( postgresql_types.VARCHAR(length=30), primary_key=False, unique=False, nullable=True, doc="testtest", ) category1 = sa.orm.relationship( 'Category', foreign_keys="[category_relation.c.category1_id]", remote_side=None, backref="parents", ) category2 = sa.orm.relationship( 'Category', foreign_keys="[category_relation.c.category2_id]", remote_side=None, backref="children", )
class Author(Base): __tablename__ = 'author' id = sa.Column( postgresql_types.INTEGER(), primary_key=True, unique=True, nullable=False, autoincrement=True, ) name = sa.Column( postgresql_types.VARCHAR(length=255), primary_key=False, unique=False, nullable=False, ) age = sa.Column( postgresql_types.SMALLINT(), primary_key=False, unique=False, nullable=False, ) email = sa.Column( postgresql_types.VARCHAR(length=254), primary_key=False, unique=False, nullable=True, )
class Book(Base): __tablename__ = 'book' id = sa.Column( postgresql_types.UUID(), default=GET_DEFAULT('books.models.Book.id'), primary_key=True, unique=True, nullable=False, ) price = sa.Column( postgresql_types.JSONB(), primary_key=False, unique=False, nullable=False, ) title = sa.Column( postgresql_types.VARCHAR(length=255), primary_key=False, unique=False, nullable=False, ) description = sa.Column( postgresql_types.TEXT(), primary_key=False, unique=False, nullable=True, ) author_id = sa.Column( postgresql_types.INTEGER(), sa.ForeignKey(column="author.id", ondelete="SET_NULL"), primary_key=False, unique=False, nullable=True, autoincrement=True, ) content = sa.Column( postgresql_types.BYTEA(), primary_key=False, unique=False, nullable=False, ) tags = sa.Column( postgresql_types.ARRAY(item_type=postgresql_types.VARCHAR, dimensions=1), primary_key=False, unique=False, nullable=False, ) author = sa.orm.relationship( 'Author', foreign_keys="[book.c.author_id]", remote_side=None, ) category = sa.orm.relationship( 'Category', secondary="book_category", foreign_keys="[book_category.c.book_id, book_category.c.category_id]", remote_side=None, )
class Category(Base): __tablename__ = 'category' id = sa.Column( postgresql_types.INTEGER(), primary_key=True, unique=True, nullable=False, autoincrement=True, ) name = sa.Column( CIText(), primary_key=False, unique=False, nullable=False, ) created = sa.Column( postgresql_types.TIMESTAMP(), primary_key=False, unique=False, nullable=False, ) related_coming = sa.orm.relationship( 'Category', secondary="category_relation", foreign_keys="[category_relation.c.category1_id]", remote_side="[category.c.id]", )
class ContentType(Base): __tablename__ = 'django_content_type' id = sa.Column( postgresql_types.INTEGER(), primary_key=True, unique=True, nullable=False, autoincrement=True, doc="testtest", ) app_label = sa.Column( postgresql_types.VARCHAR(length=100), primary_key=False, unique=False, nullable=False, doc="testtest", ) model = sa.Column( postgresql_types.VARCHAR(length=100), primary_key=False, unique=False, nullable=False, doc="testtest", )
class Group(Base): __tablename__ = 'auth_group' id = sa.Column( postgresql_types.INTEGER(), primary_key=True, unique=True, nullable=False, autoincrement=True, doc="testtest", ) name = sa.Column( postgresql_types.VARCHAR(length=150), primary_key=False, unique=True, nullable=False, doc="testtest", ) permissions = sa.orm.relationship( 'Permission', secondary="auth_group_permissions", foreign_keys= "[auth_group_permissions.c.group_id, auth_group_permissions.c.permission_id]", remote_side=None, backref="group", )
def upgrade(): load_stored_proc(op, ['update_gccrashes.sql', 'backfill_gccrashes.sql', 'backfill_matviews.sql']) op.create_table(u'gccrashes', sa.Column(u'report_date', postgresql.TIMESTAMP(timezone=True), nullable=False), sa.Column(u'product_version_id', postgresql.INTEGER(), nullable=False), sa.Column(u'build', sa.NUMERIC(), nullable=True), sa.Column(u'is_gc_count', sa.INTEGER(), nullable=False) ) fix_permissions(op, 'gccrashes')
class UserUserPermissions(Base): __tablename__ = 'auth_user_user_permissions' id = sa.Column( postgresql_types.INTEGER(), primary_key=True, unique=True, nullable=False, autoincrement=True, doc="testtest", ) user_id = sa.Column( postgresql_types.INTEGER(), sa.ForeignKey(column="auth_user.id", ondelete="CASCADE"), primary_key=False, unique=False, nullable=False, autoincrement=True, doc="testtest", ) permission_id = sa.Column( postgresql_types.INTEGER(), sa.ForeignKey(column="auth_permission.id", ondelete="CASCADE"), primary_key=False, unique=False, nullable=False, autoincrement=True, doc="testtest", ) user = sa.orm.relationship( 'User', foreign_keys="[auth_user_user_permissions.c.user_id]", remote_side=None, backref="user_user_permissions", ) permission = sa.orm.relationship( 'Permission', foreign_keys="[auth_user_user_permissions.c.permission_id]", remote_side=None, backref="user_user_permissions", )
class UserGroups(Base): __tablename__ = 'auth_user_groups' id = sa.Column( postgresql_types.INTEGER(), primary_key=True, unique=True, nullable=False, autoincrement=True, ) user_id = sa.Column( postgresql_types.INTEGER(), sa.ForeignKey(column="auth_user.id", ondelete="CASCADE"), primary_key=False, unique=False, nullable=False, autoincrement=True, ) group_id = sa.Column( postgresql_types.INTEGER(), sa.ForeignKey(column="auth_group.id", ondelete="CASCADE"), primary_key=False, unique=False, nullable=False, autoincrement=True, ) user = sa.orm.relationship( 'User', foreign_keys="[auth_user_groups.c.user_id]", remote_side=None, ) group = sa.orm.relationship( 'Group', foreign_keys="[auth_user_groups.c.group_id]", remote_side=None, )
class GroupPermissions(Base): __tablename__ = 'auth_group_permissions' id = sa.Column( postgresql_types.INTEGER(), primary_key=True, unique=True, nullable=False, autoincrement=True, ) group_id = sa.Column( postgresql_types.INTEGER(), sa.ForeignKey(column="auth_group.id", ondelete="CASCADE"), primary_key=False, unique=False, nullable=False, autoincrement=True, ) permission_id = sa.Column( postgresql_types.INTEGER(), sa.ForeignKey(column="auth_permission.id", ondelete="CASCADE"), primary_key=False, unique=False, nullable=False, autoincrement=True, ) group = sa.orm.relationship( 'Group', foreign_keys="[auth_group_permissions.c.group_id]", remote_side=None, ) permission = sa.orm.relationship( 'Permission', foreign_keys="[auth_group_permissions.c.permission_id]", remote_side=None, )
class Lake(Base): __tablename__ = 'lakes' id = sa.Column( postgresql_types.INTEGER(), primary_key=True, unique=True, nullable=False, autoincrement=True, ) name = sa.Column( postgresql_types.VARCHAR(length=100), primary_key=False, unique=False, nullable=False, ) geom = sa.Column( geotypes.Geometry(geometry_type="POLYGON", srid=4326, dimension=2, spatial_index=True), primary_key=False, unique=False, nullable=False, )
class Address(Base): __tablename__ = 'addresses' id = sa.Column( postgresql_types.INTEGER(), primary_key=True, unique=True, nullable=False, autoincrement=True, ) detail = sa.Column( postgresql_types.VARCHAR(length=255), primary_key=False, unique=False, nullable=False, ) geom = sa.Column( geotypes.Geometry(geometry_type="POINT", srid=4326, dimension=2, spatial_index=True), primary_key=False, unique=False, nullable=False, )
class LogEntry(Base): __tablename__ = 'django_admin_log' id = sa.Column( postgresql_types.INTEGER(), primary_key=True, unique=True, nullable=False, autoincrement=True, ) action_time = sa.Column( postgresql_types.TIMESTAMP(), default=GET_DEFAULT( 'django.contrib.admin.models.LogEntry.action_time'), primary_key=False, unique=False, nullable=False, ) user_id = sa.Column( postgresql_types.INTEGER(), sa.ForeignKey(column="auth_user.id", ondelete="CASCADE"), primary_key=False, unique=False, nullable=False, autoincrement=True, ) content_type_id = sa.Column( postgresql_types.INTEGER(), sa.ForeignKey(column="django_content_type.id", ondelete="SET_NULL"), primary_key=False, unique=False, nullable=True, autoincrement=True, ) object_id = sa.Column( postgresql_types.TEXT(), primary_key=False, unique=False, nullable=True, ) object_repr = sa.Column( postgresql_types.VARCHAR(length=200), primary_key=False, unique=False, nullable=False, ) action_flag = sa.Column( postgresql_types.SMALLINT(), primary_key=False, unique=False, nullable=False, ) change_message = sa.Column( postgresql_types.TEXT(), primary_key=False, unique=False, nullable=False, ) user = sa.orm.relationship( 'User', foreign_keys="[django_admin_log.c.user_id]", remote_side=None, ) content_type = sa.orm.relationship( 'ContentType', foreign_keys="[django_admin_log.c.content_type_id]", remote_side=None, )
byte_map = { MYSQL: mysql.TINYINT(), ORACLE: oracle.NUMBER(3), POSTGRES: postgresql.SMALLINT(), } short_map = { MYSQL: mysql.SMALLINT(), ORACLE: oracle.NUMBER(5), POSTGRES: postgresql.SMALLINT(), } # Skip Oracle int_map = { MYSQL: mysql.INTEGER(), POSTGRES: postgresql.INTEGER(), } long_map = { MYSQL: mysql.BIGINT(), ORACLE: oracle.NUMBER(38, 0), POSTGRES: postgresql.BIGINT(), } float_map = { MYSQL: mysql.FLOAT(), ORACLE: oracle.BINARY_FLOAT(), POSTGRES: postgresql.FLOAT(), } double_map = {
def upgrade(): op.create_table( 'project', sa.Column('id', postgresql.INTEGER(), nullable=False, primary_key=True), sa.Column('name', postgresql.VARCHAR(255), nullable=False), sa.Column('data_source_query', postgresql.VARCHAR(1024), nullable=True) ) op.create_table( 'team', sa.Column('id', postgresql.INTEGER(), nullable=False, primary_key=True), sa.Column('name', postgresql.VARCHAR(255), nullable=False), sa.Column('bugfix_rate', postgresql.FLOAT(), nullable=False), ) op.create_table( 'project_history', sa.Column('begin_datetime', postgresql.TIMESTAMP(), nullable=False), sa.Column('end_datetime', postgresql.TIMESTAMP(), nullable=True), sa.Column('project_id', postgresql.INTEGER(), nullable=False), sa.Column('scope_complete_datetime', postgresql.TIMESTAMP(), nullable=False), sa.Column('feature_complete_datetime', postgresql.TIMESTAMP(), nullable=False), sa.Column('ready_to_manufacture_datetime', postgresql.TIMESTAMP(), nullable=False), sa.Column('owner_team_id', postgresql.INTEGER(), nullable=False), sa.Column('comment', postgresql.TEXT(), nullable=True), sa.ForeignKeyConstraint( ('project_id',), ('project.id',), name='project_history_project_id_fk', ), sa.ForeignKeyConstraint( ('owner_team_id',), ('team.id',), name='project_history_owner_team_id_fk', ), sa.UniqueConstraint('begin_datetime', 'project_id', name='project_history_begin_datetime_project_id_idx'), ) op.create_table( 'known_bugs_count_history', sa.Column('begin_datetime', postgresql.TIMESTAMP(), nullable=False), sa.Column('end_datetime', postgresql.TIMESTAMP(), nullable=True), sa.Column('project_id', postgresql.INTEGER(), nullable=False), sa.Column('team_id', postgresql.INTEGER(), nullable=False), sa.Column('known_bugs_count', postgresql.INTEGER(), nullable=False), sa.ForeignKeyConstraint( ('project_id',), ('project.id',), name='project_history_project_id_fk', ), sa.ForeignKeyConstraint( ('team_id',), ('team.id',), name='project_history_owner_team_id_fk', ), sa.UniqueConstraint( 'begin_datetime', 'project_id', 'team_id', name='known_bugs_count_history_begin_datetime_project_id_team_id_idx' ), ) op.create_table( 'person', sa.Column('id', postgresql.INTEGER(), nullable=False, primary_key=True), sa.Column('firstname', postgresql.VARCHAR(255), nullable=False), sa.Column('lastname', postgresql.VARCHAR(255), nullable=False), sa.Column('issue_tracker_name', postgresql.VARCHAR(255), nullable=False), ) op.create_table( 'person_history', sa.Column('begin_datetime', postgresql.TIMESTAMP(), nullable=False), sa.Column('end_datetime', postgresql.TIMESTAMP(), nullable=True), sa.Column('person_id', postgresql.INTEGER(), nullable=False), sa.Column('team_id', postgresql.INTEGER(), nullable=False), sa.Column('project_id', postgresql.INTEGER(), nullable=False), sa.Column('project_assignment', postgresql.FLOAT(), nullable=False), sa.Column('comment', postgresql.TEXT(), nullable=True), sa.ForeignKeyConstraint( ('person_id',), ('person.id',), name='person_history_person_id_fk', ), sa.ForeignKeyConstraint( ('team_id',), ('team.id',), name='person_history_team_id_fk', ), sa.ForeignKeyConstraint( ('project_id',), ('project.id',), name='person_history_project_id_fk', ), sa.UniqueConstraint( 'begin_datetime', 'person_id', 'team_id', 'project_id', name='person_history_begin_datetime_person_id_team_id_project_id_idx' ), ) op.create_table( 'issue_type', sa.Column('id', postgresql.INTEGER(), nullable=False, primary_key=True), sa.Column('name', postgresql.VARCHAR(255), nullable=False), ) op.create_table( 'implementation_type', sa.Column('id', postgresql.INTEGER(), nullable=False, primary_key=True), sa.Column('name', postgresql.VARCHAR(255), nullable=False), ) op.create_table( 'issue', sa.Column('id', postgresql.BIGINT(), nullable=False, primary_key=True), sa.Column('key', postgresql.VARCHAR(64), nullable=False), sa.Column('url', postgresql.VARCHAR(255), nullable=False), sa.Column('created', postgresql.TIMESTAMP(), nullable=False), ) op.create_table( 'issue_history', sa.Column('begin_datetime', postgresql.TIMESTAMP(), nullable=False), sa.Column('end_datetime', postgresql.TIMESTAMP(), nullable=True), sa.Column('issue_id', postgresql.BIGINT(), nullable=False), sa.Column('type_id', postgresql.INTEGER(), nullable=False), sa.Column('resolved', postgresql.INTEGER(), nullable=True, default=None), sa.Column('due', postgresql.DATE(), nullable=True, default=None), sa.Column('summary', postgresql.VARCHAR(255), nullable=False), sa.Column('components', postgresql.VARCHAR(255), nullable=True), sa.Column('assignee_id', postgresql.INTEGER(), nullable=False), sa.Column('reporter_id', postgresql.INTEGER(), nullable=False), sa.Column('status', postgresql.VARCHAR(255), nullable=False), sa.Column('reqs_level', postgresql.FLOAT(), nullable=True), sa.Column('design_level', postgresql.FLOAT(), nullable=True), sa.Column('comment', postgresql.TEXT(), nullable=True), sa.ForeignKeyConstraint( ('issue_id',), ('issue.id',), name='issue_history_issue_id_fk', ), sa.ForeignKeyConstraint( ('type_id',), ('issue_type.id',), name='issue_history_type_id_fk', ), sa.ForeignKeyConstraint( ('assignee_id',), ('person.id',), name='issue_history_assignee_id_fk', ), sa.ForeignKeyConstraint( ('reporter_id',), ('person.id',), name='issue_history_reporter_id_fk', ), sa.UniqueConstraint( 'begin_datetime', 'issue_id', name='issue_history_begin_datetime_issue_id_idx' ), ) op.create_table( 'original_estimate', sa.Column('begin_datetime', postgresql.TIMESTAMP(), nullable=False), sa.Column('end_datetime', postgresql.TIMESTAMP(), nullable=True), sa.Column('issue_id', postgresql.BIGINT(), nullable=False), sa.Column('team_id', postgresql.INTEGER(), nullable=False), sa.Column('implementation_type_id', postgresql.INTEGER(), nullable=False), sa.Column('estimation', postgresql.FLOAT(), nullable=True), sa.Column('comment', postgresql.TEXT(), nullable=True), sa.ForeignKeyConstraint( ('issue_id',), ('issue.id',), name='original_estimate_issue_id_fk', ), sa.ForeignKeyConstraint( ('team_id',), ('team.id',), name='original_estimate_team_id_fk', ), sa.ForeignKeyConstraint( ('implementation_type_id',), ('implementation_type.id',), name='original_estimate_implementation_type_id_fk', ), sa.UniqueConstraint( 'begin_datetime', 'issue_id', 'team_id', name='original_estimate_begin_datetime_issue_id_team_id_idx' ), ) op.create_table( 'remaining_estimate', sa.Column('begin_datetime', postgresql.TIMESTAMP(), nullable=False), sa.Column('end_datetime', postgresql.TIMESTAMP(), nullable=True), sa.Column('issue_id', postgresql.BIGINT(), nullable=False), sa.Column('team_id', postgresql.INTEGER(), nullable=False), sa.Column('implementation_type_id', postgresql.INTEGER(), nullable=False), sa.Column('estimation', postgresql.FLOAT(), nullable=True), sa.Column('comment', postgresql.TEXT(), nullable=True), sa.ForeignKeyConstraint( ('issue_id',), ('issue.id',), name='remaining_estimate_issue_id_fk', ), sa.ForeignKeyConstraint( ('team_id',), ('team.id',), name='remaining_estimate_team_id_fk', ), sa.ForeignKeyConstraint( ('implementation_type_id',), ('implementation_type.id',), name='remaining_estimate_implementation_type_id_fk', ), sa.UniqueConstraint( 'begin_datetime', 'issue_id', 'team_id', name='remaining_estimate_begin_datetime_issue_id_team_id_idx' ), )
def test_integer(self): result = format_partition_value(postgresql.INTEGER(), 1) assert result == '1'
class User(Base): __tablename__ = 'auth_user' id = sa.Column( postgresql_types.INTEGER(), primary_key=True, unique=True, nullable=False, autoincrement=True, ) password = sa.Column( postgresql_types.VARCHAR(length=128), primary_key=False, unique=False, nullable=False, ) last_login = sa.Column( postgresql_types.TIMESTAMP(), primary_key=False, unique=False, nullable=True, ) is_superuser = sa.Column( mysql_types.BOOLEAN(), default=GET_DEFAULT('django.contrib.auth.models.User.is_superuser'), primary_key=False, unique=False, nullable=False, ) username = sa.Column( postgresql_types.VARCHAR(length=150), primary_key=False, unique=True, nullable=False, ) first_name = sa.Column( postgresql_types.VARCHAR(length=150), primary_key=False, unique=False, nullable=False, ) last_name = sa.Column( postgresql_types.VARCHAR(length=150), primary_key=False, unique=False, nullable=False, ) email = sa.Column( postgresql_types.VARCHAR(length=254), primary_key=False, unique=False, nullable=False, ) is_staff = sa.Column( mysql_types.BOOLEAN(), default=GET_DEFAULT('django.contrib.auth.models.User.is_staff'), primary_key=False, unique=False, nullable=False, ) is_active = sa.Column( mysql_types.BOOLEAN(), default=GET_DEFAULT('django.contrib.auth.models.User.is_active'), primary_key=False, unique=False, nullable=False, ) date_joined = sa.Column( postgresql_types.TIMESTAMP(), default=GET_DEFAULT('django.contrib.auth.models.User.date_joined'), primary_key=False, unique=False, nullable=False, ) groups = sa.orm.relationship( 'Group', secondary="auth_user_groups", foreign_keys= "[auth_user_groups.c.user_id, auth_user_groups.c.group_id]", remote_side=None, ) user_permissions = sa.orm.relationship( 'Permission', secondary="auth_user_user_permissions", foreign_keys= "[auth_user_user_permissions.c.user_id, auth_user_user_permissions.c.permission_id]", remote_side=None, )