Guest User

Untitled

a guest
Jan 12th, 2019
147
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.07 KB | None | 0 0
  1. Creation and connection to a database by means of firebirdsql
  2. import firebirdsql
  3. s1='''
  4. create table CLIENTS
  5. (
  6. ID INTEGER NOT NULL,
  7. COMPANY VARCHAR(50),
  8. "LAST NAME" VARCHAR(50),
  9. "FIRST NAME" VARCHAR(50),
  10. "E-MAIL ADDRESS" VARCHAR(50),
  11. "JOB TITLE" VARCHAR(50),
  12. "BUSINESS PHONE" VARCHAR(25),
  13. "HOME PHONE" VARCHAR(25),
  14. "MOBILE PHONE" VARCHAR(25),
  15. "FAX NUMBER" VARCHAR(25),
  16. ADDRESS BLOB SUB_TYPE 1,
  17. CITY VARCHAR(50),
  18. "STATE/PROVINCE" VARCHAR(50),
  19. "ZIP/POSTAL CODE" VARCHAR(15),
  20. "COUNTRY/REGION" VARCHAR(50),
  21. "WEB-SITE" VARCHAR(25),
  22. NOTES BLOB SUB_TYPE 1,
  23. INCLUDING BLOB,
  24. CONSTRAINT PK_CLIENTS_ID PRIMARY KEY(ID)
  25. );
  26. '''
  27. conn=firebirdsql.create_database(host='localhost', database='test1.fdb',
  28. user='sysdba', password='masterkey')
  29. cur=conn.cursor()
  30. cur.execute(s1)
  31. conn.commit()
  32. conn.close()
  33.  
  34. conn = firebirdsql.connect(dsn='localhost/3050:/test1.fdb', user='sysdba',
  35. password='masterkey'), but result is same.
Add Comment
Please, Sign In to add comment