x
/
iotronic
Code Issues Proposed changes

New table for wamp session. 

Change-Id: Ic273fb6bb5f365049165002a68a18c7c0dc558a6
This commit is contained in:
Fabio Verboso 2018-09-06 16:58:30 +02:00
parent 4d11b00e56
commit ea3b97693a
2 changed files with 13 additions and 18 deletions
Show Stats Download Patch File Download Diff File Expand all files Collapse all files

10
iotronic/db/sqlalchemy/alembic/versions/df35e9cbeaff_init_schema.py
View File

@ -19,7 +19,6 @@ import sqlalchemy as sa
def upgrade():
op.create_table('boards',
sa.Column('created_at', sa.DateTime(), nullable=True),
sa.Column('updated_at', sa.DateTime(), nullable=True),
@ -161,17 +160,16 @@ def upgrade():
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('valid', sa.Boolean(), nullable=True),
sa.Column('session_id', sa.String(length=15),
sa.Column('session_id', sa.String(length=20),
nullable=True),
sa.Column('board_uuid', sa.String(length=36),
nullable=True),
sa.Column('board_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['board_id'], ['boards.id'], ),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('board_uuid',
name='uniq_board_uuid0board_uuid'),
sa.UniqueConstraint('session_id',
name='uniq_session_id0session_id')
sa.UniqueConstraint(
'session_id', 'board_uuid',
name='uniq_board_session_id0session_id')
)

21
iotronic/db/sqlalchemy/models.py
View File

@ -178,15 +178,12 @@ class SessionWP(Base):
__tablename__ = 'sessions'
__table_args__ = (
schema.UniqueConstraint(
'session_id',
name='uniq_session_id0session_id'),
schema.UniqueConstraint(
'board_uuid',
name='uniq_board_uuid0board_uuid'),
'session_id', 'board_uuid',
name='uniq_board_session_id0session_id'),
table_args())
id = Column(Integer, primary_key=True)
valid = Column(Boolean, default=True)
session_id = Column(String(15))
session_id = Column(String(20))
board_uuid = Column(String(36))
board_id = Column(Integer, ForeignKey('boards.id'))
@ -254,17 +251,17 @@ class Port(Base):
"""Represents a port on board."""
__tablename__ = 'ports_on_boards'
# __table_args__ = (
# schema.UniqueConstraint('port_uuid', name='uniq_ports0uuid'),
# table_args()
# )
# __table_args__ = (
# schema.UniqueConstraint('port_uuid', name='uniq_ports0uuid'),
# table_args()
# )
id = Column(Integer, primary_key=True)
board_uuid = Column(String(40), ForeignKey('boards.uuid'))
uuid = Column(String(40))
VIF_name = Column(String(30))
# project = Column(String(36))
# project = Column(String(36))
MAC_add = Column(String(32))
ip = Column(String(36))
# status = Column(String(36))
# status = Column(String(36))
network = Column(String(36))
# security_groups = Column(String(40))