import sys from PyQt5.QtCore import * from PyQt5.QtGui import * from PyQt5.QtWidgets import * from PyQt5.QtSql import * db = QSqlDatabase.addDatabase ("QSQLITE") # db.setDatabaseName (":memory:") db.setDatabaseName ("test.sqlite") db.open () query = db.exec_ ("CREATE TABLE IF NOT EXISTS colors (name TEXT," "red INTEGER, green INTEGER, blue INTEGER)") db.exec_ ("INSERT INTO colors (name, red, green, blue) VALUES (\"blue\", 0, 0, 255)") db.close ()