def save(self):
cur = conn.cursor()
if not self.id:
now = dbtime.make_time_str()
cur.execute(
'INSERT INTO paragraphs VALUES'
'(NULL, ?, ?, ?, ?, ?, ?, ?);',
(self.content, self.parent_id, self.votes,
self.author_id, self.approved,
self.story_id, now))
self.id = cur.lastrowid
self.created = now
else:
cur.execute(
'''UPDATE paragraphs
SET content = ?,
parent_id = ?,
votes = ?,
author_id = ?,
approved = ?,
story_id = ?
WHERE id = ?''', (self.content, self.parent_id, self.votes,
self.author_id, self.approved, self.story_id,
self.id))
# Commit data
conn.commit()
# Return this object
return self
def create(fname, lname, username, password, dob, email, location, bio):
s = sha_hash()
unhashed = username+password
unhashed = bytes(unhashed, encoding='utf8')
s.update(unhashed)
password = s.hexdigest()
joindate = dbtime.make_time_str()
return User(None, fname, lname, username, password, dob, email, joindate, location, bio, admin_level)
def save(self):
cur = conn.cursor()
if self.id is None:
time = dbtime.make_time_str()
self.created_time = dbtime.get_time_from_str(time)
cur.execute("INSERT INTO stories VALUES (NULL, ?, ?, ?, ?, ?);",
(self.author_id,self.title,time,self.author_init_comment, self.votes))
self.id = cur.lastrowid
else:
cur.execute('''UPDATE stories SET
author_id=?,
title=?,
WHERE id=?'''(self.author_id,self.title,self.id))
conn.commit()
return self
def save(self):
cur = conn.cursor()
if self.id == None:
time = dbtime.make_time_str()
self.created_time = dbtime.get_time_from_str(time)
cur.execute("INSERT INTO comments VALUES (NULL, ?, ?, ?, ?);",
(self.author_id,self.story_id,self.content,self.created_time))
self.id = cur.lastrowid
else:
cur.execute('''UPDATE comments SET
author_id=?,
story_id=?,
content=?,
WHERE id=?'''(self.author_id,self.story_id,self.content,self.id))
conn.commit()
def create(cls, fname, lname, username, password, dob, email, location, bio, admin_level=0):
password = cls._hash(username, password)
joindate = dbtime.make_time_str()
return User(None, fname, lname, username, password, dob, email, joindate, location, bio, admin_level)
