Creating sqlite table columns from a list Python

Question

I am trying to use the strings in a list as the columns names in an sqllite database I am creating. I currently have the following code (using sqlalchemy):

db = create_engine('sqlite:///strings.db')
db.echo = False
metadata = MetaData(db)
lang_array = []
lang_array.append(Column("id", Integer, primary_key = True))
for lang in lang_keys:
    lang_array.append(Column(lang, String))

strings = Table("strings", metadata, lang_array)

Where lang_keys is a list of strings. Is it possible to pass a list in the Table method like above? I am getting the error AttributeError: 'list' object has no attribute 'schema. What am I doing wrong here?

metmirr · Accepted Answer · 2017-02-18 11:39:42Z

1

You can use append_column() method:

strings = Table("strings", metadata)
for column in lang_array:
    strings.append_column(column)

answered Feb 18, 2017 at 11:39

metmirr

4,3222 gold badges23 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Creating sqlite table columns from a list Python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related