Sqlalchemy PRI and MUL Keys

I am creating a sqlalchemy python script to create tables in a sql database.

I need to create a table with keys like PRI and MUL.

And here's what I wrote for this.

test_table = Table('test', metadata, Column('ClientID', Integer, unique=False,
                                            autoincrement=False,
                                            primary_key=True, nullable=False,
                                            server_default=text('0')),
                   Column('UserID', Integer, unique=False, autoincrement=False,
                          primary_key=True, nullable=False),
                   Column('ContactID', Integer, unique=False,
                          autoincrement=False, primary_key=True,
                          nullable=False),
                   Column('ConvoID', Integer, unique=False,
                          autoincrement=False, primary_key=True,
                          nullable=False),
                   Column('Direction', String(4), unique=False,
                          autoincrement=False, primary_key=True,
                          nullable=False), Column('Variable', sa.Unicode(100,
                                                                         collation='utf8mb4_unicode_ci'),
                                                  primary_key=True,
                                                  nullable=False),
                   Column('Value',
                          sa.Unicode(255, collation='utf8mb4_unicode_ci'),
                          nullable=True),
                   Column('CreatedDate', DateTime,
                          server_default=text("CURRENT_TIMESTAMP"),
                          nullable=False),
                   Column('UpdatedDate', DateTime,
                          server_default=text("CURRENT_TIMESTAMP"),
                          nullable=False),
                   Index('UserID', 'UserID', 'ContactID', 'ConvoID'),
                   )

      

But the problem is that I cannot set these 3 columns ( UserID

, ContactID

and ConvoId

) as MUL keys.

Can anyone help me with this?

+3


source to share





All Articles