db. = sqlite3.connect(':memory:')
db.execute('create table links ' +
'(id integer, submitter_id integer, submitted_time integer, ' +
'votes integer, title text, url text)')
for l in links:
db.execute('insert into links values (?, ?, ?, ?, ?, ?)', l)
def query():
c = db.execute("select * from links")
def query():
cursor = db.execute("select * from links")
for link_tuple in cursor:
link = Link(*link_tuple)
print query()
def query():
cursor = db.execute("select * from links where submitter_id = 62443 and votes > 1000")
link = Link(*c.fetchone())
return link.id
order by
def query():
cursor = db.execute("select * from links where submitter_id = 62443 order by submitter_time asc")
for link_tuple in c:
link = Link(*link_tuple)
results.append(link.id)
return results
join
def link_by_id(link_id):
for l in links:
if l.id == link_id:
return l
scaling database is to 1.replicate, 2.shared.
