How to create a sqlite table from a python class?

Question

I'd like to create a function makeTable to create a sqlite table from a python class. I have this class:

class Foo(object):
    def __init__(self):
        self.a
        self.b
        self.c

I tried defining the function in this way:

def makeTable(obj):
    conn = sqlite3.connect(sqlfilename)
    cursor = conn.cursor()
    cursor.execute(sqlString)

But I have to create the sqlString such as:

"""CREATE TABLE foo (a text, b text)"""

How can I create this sqlString automatically from a given class?

@marcos-da-silva-sampaio, alecxe does not ask if you use one, but asks if you shouldnt use one as sqlalechmy does this job — user1593705
– user1593705, Commented Sep 4, 2013 at 12:37
Thanks. I didn't knew the OMR. I will try it to solve the question. — msampaio
– msampaio, Commented Sep 4, 2013 at 12:39
its ORM for Object Relational Mapping a tool that does what you expect ;) — user1593705
– user1593705, Commented Sep 4, 2013 at 12:44

Achim · Accepted Answer · 2013-10-01 22:44:32Z

1

Alecxe was not really asking a question, but proposes you to use an ORM like SqlAlchemy. Your approach is quite too simple and limited. In real live you have to figure out, which data type a column should have, which attributes/properties should go to the database and many other details. An ORM will do that for you and SqlAlchemy is the best one in my opinion.

I case you think that you're happy with a simpler solution, you have to describe that simple solution to us. Or even better: Show some code you wrote and which did not work.

edited Oct 1, 2013 at 22:44

answered Sep 4, 2013 at 12:39

Achim

15.7k15 gold badges92 silver badges161 bronze badges

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

1 Comment

user1593705 Over a year ago

do you mean In a real life?

Collectives™ on Stack Overflow

How to create a sqlite table from a python class?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related