Das deutsche Python-Forum

Code: Alles auswählen

from sqlalchemy import create_engine
from sqlalchemy.schema import MetaData, Column, Table
from sqlalchemy.types import Integer, String, BigInteger, DateTime

engine = create_engine('mysql://root@localhost/')
metadata = MetaData(bind=engine)

test_table = Table('test_table', metadata,
              Column('id', Integer, primary_key=True),
              Column('name', String(40)),
              Column('age', Integer)
              )

column_list = [Column('test1', String(40), Column('test2', Integer), Column('test3', BigInteger)]

for column in column_list:
    # Hier möchte ich nun die Column-Objekte aus "column_list" der Tabelle "test_table" anhängen