def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.alter_column('informed_consent_document', 'html', existing_type=postgresql.BYTEA(), type_=postgresql.TEXT(), 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 Text(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(120), nullable=False, default=str(id)) text = db.Column(postgresql.TEXT(), nullable=False) created = db.Column(db.DateTime(), default=datetime.utcnow) restaurant_id = db.Column(db.Integer, db.ForeignKey('restaurant.id'), nullable=False) texts_active = db.relationship('TextActive', backref=db.backref('text', lazy='joined'), lazy=True) def to_dict(self): data = { 'id': self.id, 'title': html.unescape(self.title), 'text': html.unescape(self.text), 'created': self.created, '_links': { 'self': url_for('api.update_texts', id=self.id) } } return data def from_dict(self, data): for field in ['title', 'text']: if field in data: setattr(self, field, data[field]) db.session.add(self) def __repr__(self): return '<Text {}: {}>'.format(self.id, self.title)
class Subscription(Base): __tablename__ = 'subscriptions' id = Column(Integer, primary_key=True, autoincrement=True) platform = Column(Text, nullable=False) name = Column(Text, nullable=False) polarization = Column(ARRAY(postgresql.TEXT()), nullable=False) orbit_dir = Column(Text, nullable=False) paths = Column(ARRAY(postgresql.INT4RANGE()), nullable=False) location = Column(Geometry(geometry_type='MULTIPOLYGON', srid=4326), index=True, nullable=False) start_date = Column(Date) end_date = Column(Date) start_date_handled = Column(Boolean, nullable=False, server_default=sql.expression.text("false")) process_old = Column(Boolean, nullable=False) process_id = Column(ForeignKey('processes.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True) user_id = Column(ForeignKey('users.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True) crop_to_selection = Column(Boolean, nullable=False) extra_arguments = Column(Text) enabled = Column(Boolean, nullable=False, server_default=sql.expression.text("true")) project_id = Column(ForeignKey('projects.id')) description = Column(Text) priority = Column(Integer, nullable=False, server_default=sql.expression.text("10")) process = orm.relationship('Process') project = orm.relationship('Project') user = orm.relationship('User') groups = orm.relationship('Group', secondary=subscriptions_in_groups, lazy='joined')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.alter_column('informed_consent_document', 'html', existing_type=postgresql.TEXT(), type_=postgresql.BYTEA(), nullable=True) # ### end Alembic commands ### #, postgresql_using='html::varchar'
class Session(Base): __tablename__ = 'django_session' session_key = sa.Column( postgresql_types.VARCHAR(length=40), primary_key=True, unique=True, nullable=False, ) session_data = sa.Column( postgresql_types.TEXT(), primary_key=False, unique=False, nullable=False, ) expire_date = sa.Column( postgresql_types.TIMESTAMP(), 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, )
autoincrement=False), Column("collection", Integer, primary_key=True, nullable=False, autoincrement=False), Column("last_modified", BigInteger, nullable=False)) # Column definitions for BSO storage table/tables. # # This list class defines the columns used for storage of BSO records. # It is used to create either sharded or non-shareded BSO storage tables, # depending on the run-time settings of the application. PAYLOAD_TYPE = Text() PAYLOAD_TYPE = PAYLOAD_TYPE.with_variant(postgresql.TEXT(), 'postgresql') PAYLOAD_TYPE = PAYLOAD_TYPE.with_variant(mysql.MEDIUMTEXT(), 'mysql') # Common column definitions between BSO and batch upload item tables def _get_bso_columns(table_name): return ( Column("userid", Integer, primary_key=True, nullable=False, autoincrement=False), Column("collection", Integer, primary_key=True,
def test_text(self): result = format_partition_value(postgresql.TEXT(), 'something') assert result == '\'something\''
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' ), )