Guest User

Untitled

a guest
Mar 16th, 2018
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.71 KB | None | 0 0
  1. from sqlalchemy import create_engine
  2. import logging
  3. logging.basicConfig(filename = "sqlalchemypy3.log")
  4. logging.getLogger('sqlalchemy.engine').setLevel(logging.INFO)
  5.  
  6. engine = create_engine("postgresql+pg8000://postgres@localhost:15432/pg8000")
  7. c = engine.connect()
  8. c.execute("delete from prueba")
  9. words = "first look at sqlalchemy from python3 using pg8000 module"
  10. aWords = ["('{0}')".format(x) for x in words.split()]
  11. sql = "insert into prueba(nombre) values {0} returning nombre".format(",".join(aWords))
  12.  
  13. for row in c.execute(sql):
  14. print(row["nombre"])
  15.  
  16. print("\nahora los tuples ordenados por nombre\n")
  17. sql = "select nombre from prueba order by nombre"
  18. for row in c.execute(sql):
  19. print(row["nombre"])
  20. c.close()
Add Comment
Please, Sign In to add comment