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 ()