Python-сообщество

 import sys
from PyQt5.QtSql import QSqlDatabase, QSqlQuery
#Create the connection
con = QSqlDatabase.addDatabase("qsqlite")
con.setDatabaseName("human.sqlite")
#open the connection
if not con.open():
    print("DatabaseError: %s" % con.lastError().databaseText())
    sys.exit(1)
# Create a query and execute it right away .exec()
createTableQuery = QSqlQuery()
createTableQuery.exec("""
        create table human (
        id integer primary autoincrement unique not null,
        name varchar(100) not null,
        job varchar(100),
        email varchar(100))""")
print(con.tables())

  
>>> from PyQt5.QtSql import QSqlDatabase, QSqlQuery
>>> 
>>> con = QSqlDatabase.addDatabase("QSQLITE")
>>> con.setDatabaseName("human.sqlite")
>>> 
>>> con.open()
True
>>> 
>>> createTableQuery = QSqlQuery()
>>> 
>>> createTableQuery.exec("""
...         create table human (
...         id integer,
...         name varchar(100),
...         job varchar(100),
...         email varchar(100))""")
True
>>> 
>>> print(con.tables())
['human']
>>> 
>>> con.close()
>>>