Mercurial > hg > rlgallery-misc

comparison py/setupdb.py @ 42:e1de8aeb5ed4

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Add depth and maxdepth columns to the RogueGame tables.
author John "Elwin" Edwards
date Sat, 11 Jan 2014 10:45:33 -0500
parents 25843238434a
children
comparison
equal deleted inserted replaced
41:d3ccdc195796 42:e1de8aeb5ed4
9 9
10 dbconn = psycopg2.connect("dbname=rlg") 10 dbconn = psycopg2.connect("dbname=rlg")
11 dbcur = dbconn.cursor() 11 dbcur = dbconn.cursor()
12 12
13 dbcur.execute("CREATE TABLE games ( gname varchar(20), offbytes int );") 13 dbcur.execute("CREATE TABLE games ( gname varchar(20), offbytes int );")
14 dbcur.execute("CREATE TABLE players (pname varchar(20) PRIMARY KEY);") 14 dbcur.execute("CREATE TABLE players (pname text PRIMARY KEY);")
15 dbconn.commit() 15 dbconn.commit()
16 16
17 for game in rlgall.gamelist: 17 for game in rlgall.gamelist:
18 dbcur.execute("INSERT INTO games VALUES (%s, %s);", (game.uname, 0)) 18 dbcur.execute("INSERT INTO games VALUES (%s, %s);", (game.uname, 0))
19 19