Create an instance of a class from SQL query

Question

I have the following class:

class SomeClass:
    def __init__(self, name, date):
        self.name = name
        self.date = date

Now I have a function in another module, which connects to a SQLite database and executes a query:

def getEntry(user):
    data = []
    connection = lite.connect(database)                                                                 
    with connection:                                                                 
        cur = connection.cursor()                                                    
        cur.execute("SELECT name, date FROM table WHERE column = ?", [user])
        events = cur.fetchall()                                                      
        # instantiate an instance of `SomeClass`
        return data

So how would I create an instance of SomeClass and pass name and date entries to my newly created instance?

Have you considered using a library to do this for you? Django is primarily a web framework, but its database support and ORM are phenomenal. — Arion
– Arion, Commented Nov 12, 2012 at 2:30
I'm already using cherryPy, don't really want to use Django on top of that. Can't be that hard to accomplish the above, or is it? — cherrun
– cherrun, Commented Nov 12, 2012 at 2:47

RocketDonkey · Accepted Answer · 2012-11-12 03:11:49Z

3

Since fetchall() returns a list of the rows, you should be able to do this (this should cover occasions where multiple results are returned as well):

for result in events:
    my_instance = SomeClass(result[0], result[1])
    # Do whatever you want to do with the instances, which looks like
    # it may be appending to data
    data.append(my_instance) # Or data.append(SomeClass(result[0], result[1]))

Can't test it right now, so apologies if it is way off :)

answered Nov 12, 2012 at 3:11

RocketDonkey

37.4k8 gold badges83 silver badges84 bronze badges

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

2 Comments

Steven Rumbalski Over a year ago

Or return [SomeClass(*row) for row in cur]

RocketDonkey Over a year ago

@StevenRumbalski Even better :)

Collectives™ on Stack Overflow

Create an instance of a class from SQL query

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related