import phoenixdbimport phoenixdb.cursorurl = 'http://localhost:8765/'conn = phoenixdb.connect(url, autocommit=True)cursor = conn.cursor()# cursor.execute("DROP TABLE users")cursor.execute("CREATE TABLE users (id INTEGER PRIMARY KEY, username VARCHAR, password VARCHAR)")cursor.execute("UPSERT INTO users VALUES (?, ?, ?)", (1, 'admin', 'Letmein'))cursor.execute("UPSERT INTO users VALUES (?, ?, ?)", (2, 'kongxx', 'Letmein'))cursor.execute("SELECT * FROM users")print cursor.fetchall()cursor = conn.cursor(cursor_factory=phoenixdb.cursor.DictCursor)cursor.execute("SELECT * FROM users WHERE id=1")user = cursor.fetchone()print user['USERNAME']print user['PASSWORD'] 
