Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- from sqlalchemy import create_engine
- import logging
- logging.basicConfig(filename = "sqlalchemypy3.log")
- logging.getLogger('sqlalchemy.engine').setLevel(logging.INFO)
- engine = create_engine("postgresql+pg8000://postgres@localhost:15432/pg8000")
- c = engine.connect()
- c.execute("delete from prueba")
- words = "first look at sqlalchemy from python3 using pg8000 module"
- aWords = ["('{0}')".format(x) for x in words.split()]
- sql = "insert into prueba(nombre) values {0} returning nombre".format(",".join(aWords))
- for row in c.execute(sql):
- print(row["nombre"])
- print("\nahora los tuples ordenados por nombre\n")
- sql = "select nombre from prueba order by nombre"
- for row in c.execute(sql):
- print(row["nombre"])
- c.close()
Add Comment
Please, Sign In to add comment