import asyncio

from sqlalchemy import (
    Column, Integer,
    SmallInteger, String, BigInteger, Boolean, ForeignKey, MetaData

)
from sqlalchemy.ext.asyncio import create_async_engine, AsyncSession
from sqlalchemy.ext.declarative import declarative_base


engine = create_async_engine(
    'postgresql+asyncpg://username:pass@server'
    ':5432/database',
    isolation_level='REPEATABLE READ',
    future=True,
)

async_session = AsyncSession(engine, expire_on_commit=False)
metadata = MetaData()
Base = declarative_base()


class Key_table(Base):
    __tablename__ = 'key_table'
    id = Column(BigInteger, primary_key=True)
    user_id = Column(Integer, nullable=False)
    key = Column(String(29), nullable=False, unique=True)
    count = Column(SmallInteger, nullable=False)
    status = Column(Boolean, nullable=False)
    is_admin = Column(Boolean, nullable=True)
    __mapper_args__ = {"eager_defaults": True}


class Enter_table(Base):
    __tablename__ = 'enter_table'
    id = Column(BigInteger, primary_key=True)
    user_id = Column(Integer, nullable=False)
    key = Column(String, nullable=False)
    __mapper_args__ = {"eager_defaults": True}


class Key_value1(Base):
    __tablename__ = 'key_value1'
    id = Column(BigInteger, primary_key=True)
    key = Column(ForeignKey('key_table.key'), nullable=False)
    value = Column(String)
    order = Column(SmallInteger, nullable=False)
    __mapper_args__ = {"eager_defaults": True}


class Key_value2(Base):
    __tablename__ = 'key_value2'
    id = Column(BigInteger, primary_key=True)
    key = Column(ForeignKey('key_table.key'), nullable=False)
    value = Column(String)
    order = Column(SmallInteger, nullable=False)
    __mapper_args__ = {"eager_defaults": True}


class Key_value3(Base):
    __tablename__ = 'key_value3'
    id = Column(BigInteger, primary_key=True)
    key = Column(ForeignKey('key_table.key'), nullable=False)
    value = Column(String)
    order = Column(SmallInteger, nullable=False)
    __mapper_args__ = {"eager_defaults": True}


class Key_value4(Base):
    __tablename__ = 'key_value4'
    id = Column(BigInteger, primary_key=True)
    key = Column(ForeignKey('key_table.key'), nullable=False)
    value = Column(String)
    order = Column(SmallInteger, nullable=False)
    __mapper_args__ = {"eager_defaults": True}


class Key_value5(Base):
    __tablename__ = 'key_value5'
    id = Column(BigInteger, primary_key=True)
    key = Column(ForeignKey('key_table.key'), nullable=False)
    value = Column(String)
    order = Column(SmallInteger, nullable=False)
    __mapper_args__ = {"eager_defaults": True}


class Key_value6(Base):
    __tablename__ = 'key_value6'
    id = Column(BigInteger, primary_key=True)
    key = Column(ForeignKey('key_table.key'), nullable=False)
    value = Column(String)
    order = Column(SmallInteger, nullable=False)
    __mapper_args__ = {"eager_defaults": True}


class Key_value7(Base):
    __tablename__ = 'key_value7'
    id = Column(BigInteger, primary_key=True)
    key = Column(ForeignKey('key_table.key'), nullable=False)
    value = Column(String)
    order = Column(SmallInteger, nullable=False)
    __mapper_args__ = {"eager_defaults": True}


class Key_value8(Base):
    __tablename__ = 'key_value8'
    id = Column(BigInteger, primary_key=True)
    key = Column(ForeignKey('key_table.key'), nullable=False)
    value = Column(String)
    order = Column(SmallInteger, nullable=False)
    __mapper_args__ = {"eager_defaults": True}


class Key_value9(Base):
    __tablename__ = 'key_value9'
    id = Column(BigInteger, primary_key=True)
    key = Column(ForeignKey('key_table.key'), nullable=False)
    value = Column(String)
    order = Column(SmallInteger, nullable=False)
    __mapper_args__ = {"eager_defaults": True}


class Key_value10(Base):
    __tablename__ = 'key_value10'
    id = Column(BigInteger, primary_key=True)
    key = Column(ForeignKey('key_table.key'), nullable=False)
    value = Column(String)
    order = Column(SmallInteger, nullable=False)
    __mapper_args__ = {"eager_defaults": True}


class User(Base):
    __tablename__ = 'user_table'
    id = Column(Integer, primary_key=True)
    user_id = Column(Integer, unique=True, nullable=False)
    language = Column(String, nullable=False)
    __mapper_args__ = {"eager_defaults": True}


async def main():
    async with engine.begin() as conn:
        await conn.run_sync(Base.metadata.create_all)