Skip to content

Instantly share code, notes, and snippets.

@dltacube
Created November 5, 2016 18:01
Show Gist options
  • Save dltacube/6368824e60d5c3e462d528073cf47cd4 to your computer and use it in GitHub Desktop.
Save dltacube/6368824e60d5c3e462d528073cf47cd4 to your computer and use it in GitHub Desktop.
def query():
submissions = []
cursor = db.execute('SELECT * FROM links WHERE submitter_id = 62443 ORDER BY submitted_time ASC')
for link_tuple in cursor:
link = Link(*link_tuple)
submissions.append(link.id)
return submissions
print query()
submissions = []
def query():
cursor = db.execute('SELECT * FROM links WHERE submitter_id = 62443 ORDER BY submitted_time ASC')
for link_tuple in cursor:
link = Link(*link_tuple)
submissions.append(link.id)
return submissions
print query()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment