def approve_access(access_id):
sql = ('UPDATE blogger.blog_access SET status=1 WHERE access_id=%s')
try:
cur.execute(sql, (access_id,))
conn.commit()
except Exception as ex:
conn.rollback()
raise ex
def store_passwd(user_id, hashed):
sql = ('UPDATE blogger.users ' 'SET passwd=%s ' 'WHERE user_id=%s')
cur = conn.cursor()
try:
cur.execute(sql, (hashed, user_id))
conn.commit()
except Exception as ex:
conn.rollback()
raise ex
def create_access_request(blog_id, user_id):
sql = ('INSERT INTO blogger.blog_access '
'(blog_id, user_id) values (%s, %s) '
'RETURNING access_id') '
cur = conn.cursor()
try:
cur.execute(sql, (blog_id, user_id))
return cur.fetchone()[0]
except Exception as ex:
conn.rollback()
raise ex
def add_user(screen_name):
cur = get_cursor()
sql = ('INSERT INTO blogger.users '
'(screen_name) '
'values (%s) '
'RETURNING user_id')
try:
cur.execute(sql, (screen_name))
conn.commit()
user_id = cur.fetchone()[0]
return user_id
except Exception as ex:
conn.rollback()
raise ex
def create_post(blog_id, title, post_text):
sql = ('INSERT INTO blogger.posts (blog_id, title, post_text) '
' VALUES (%s, %s, %s) RETURNING post_id')
cur = conn.cursor()
try:
cur.execute(sql, (blog_id, title, post_text))
except Exception as ex:
print "Ex: %s" % ex
conn.rollback()
raise ex
conn.commit()
blog_id = cur.fetchone()[0]
return blog_id
def create_blog(title, blog_user_id):
sql = ('INSERT INTO blogger.blogs (title, blog_user_id) '
' VALUES (%s, %s) RETURNING blog_id')
cur = conn.cursor()
try:
cur.execute(sql, (title, blog_user_id))
except Exception as ex:
print "Ex: %s" % ex
conn.rollback()
raise ex
conn.commit()
blog_id = cur.fetchone()[0]
return blog_id