Esempio n. 1
0
def list(count):
  conn = connect()
  cur = conn.cursor()
  query = "SELECT id,title FROM %s ORDER BY id DESC LIMIT %d"
  query = query % (Config.DB_TABLE, count)
  cur.execute(query)

  result = Result()
  result.posts = []
  for row in cur.fetchall():
    post = Post()
    post.id = row[0]
    post.title = row[1]
    result.posts += [post]

  return result
Esempio n. 2
0
def get(id):
  conn = connect()
  cur = conn.cursor()
  cur.execute("SELECT * FROM %s WHERE id='%d'" % (Config.DB_TABLE, id))

  row = cur.fetchall()
  if len(row) == 0:
    return Result()
  row = row[0]
  result = Result()

  post = Post()
  post.id = row[0]
  post.title = row[1]
  post.content = row[2]
  post.date = str(row[3])
  result.posts = [post]

  return result
Esempio n. 3
0
    conn = connect()
    cur = conn.cursor()
    query = "INSERT INTO %s (title, date, content) VALUES ('%s', '%s', '%s')"
    query = query % (Config.DB_TABLE, title, date, content)
    cur.execute(query)
    last_id = cur.lastrowid
    conn.commit()

  except MySQLdb.Error, e:
    print "Error %d: %s" % (e.args[0], e.args[1])
    conn.rollback()

  finally:
    conn.close()

  result = Result()
  new_post = Post()
  new_post.id = last_id
  result.posts = [new_post]
  return result

def get(id):
  conn = connect()
  cur = conn.cursor()
  cur.execute("SELECT * FROM %s WHERE id='%d'" % (Config.DB_TABLE, id))

  row = cur.fetchall()
  if len(row) == 0:
    return Result()
  row = row[0]
  result = Result()