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,
)
