Advertisement
Guest User

Untitled

a guest
Dec 12th, 2016
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.57 KB | None | 0 0
  1. import fdb
  2.  
  3. con = fdb.connect(
  4.     dsn='192.168.0.215:C:\PublicFolders\Services\Arena\DB\ARENA.GDB',
  5.     user='sysdba', password='masterkey'
  6.   )
  7. # Create a Cursor object that operates in the context of Connection con:
  8. cur = con.cursor()
  9. # Шоб полосочка такая
  10. print ('-' * 78)
  11. # Запрос в базу
  12. cur.execute("select first(10) uid,uet from visit where uid=294581 order by uet desc")
  13. # Retrieve all rows as a sequence and print that sequence:
  14. result = cur.fetchall()
  15. for row in result:
  16.     print(*row, sep = ' ID пациента - УЕТы ')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement