iframe-proxy | Sunbelt Computer Software

51 lines (39 loc) · 1.63 KB

import logging
sys.path.insert(0, "../src")
import cs50
db = cs50.SQL("sqlite:///foo.db")
logging.getLogger("cs50").disabled = False
logging.getLogger("cs50").setLevel(logging.ERROR)
db.execute("DROP TABLE IF EXISTS bar")
db.execute("CREATE TABLE bar (firstname STRING UNIQUE)")
db.execute("INSERT INTO bar VALUES (?)", None)
db.execute("INSERT INTO bar VALUES (?)", "baz")
db.execute("INSERT INTO bar VALUES (?)", "qux")
db.execute("SELECT * FROM bar WHERE firstname IN (?)", ("baz", "qux"))
print(db.execute("SELECT * FROM bar"))
#db.execute("DELETE FROM bar")
db = cs50.SQL("postgresql://postgres@localhost/test")
print(db.execute("DROP TABLE IF EXISTS cs50"))
print(db.execute("CREATE TABLE cs50 (id SERIAL PRIMARY KEY, val VARCHAR(16), bin BYTEA)"))
print(db.execute("INSERT INTO cs50 (val) VALUES('foo')"))
print(db.execute("SELECT * FROM cs50"))
print(db.execute("DROP TABLE IF EXISTS cs50"))
print(db.execute("CREATE TABLE cs50 (val VARCHAR(16), bin BYTEA)"))
print(db.execute("INSERT INTO cs50 (val) VALUES('foo')"))
print(db.execute("SELECT * FROM cs50"))
print(db.execute("DROP TABLE IF EXISTS cs50"))
print(db.execute("CREATE TABLE cs50 (id SERIAL PRIMARY KEY, val VARCHAR(16), bin BYTEA)"))
print(db.execute("INSERT INTO cs50 (val) VALUES('foo')"))
print(db.execute("INSERT INTO cs50 (val) VALUES('bar')"))
print(db.execute("INSERT INTO cs50 (val) VALUES('baz')"))
print(db.execute("SELECT * FROM cs50"))
    print(db.execute("INSERT INTO cs50 (id, val) VALUES(1, 'bar')"))
except Exception as e:
    print(e)
print(db.execute("INSERT INTO cs50 (val) VALUES('qux')"))
#print(db.execute("DELETE FROM cs50"))

Sunbelt Computer Software

PL/B Language Development and Support

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Sunbelt Computer Software

PL/B Language Development and Support

Uh oh!

FilesExpand file tree

foo.py

Latest commit

History

foo.py

File metadata and controls