Hi guys, i have file exported from mysql "db.sql" and i would like to improt it to Qtsql "data.db".
i tried to create the db with:
import sys, os
from PyQt4 import QtCore, QtSql
filename = "data.db"
create
= not QtCore.
QFile.
exists(filename
)db.setDatabaseName(filename)
db.open()
query.exec_("opencoffe.db < opencoffe.sql")
import sys, os
from PyQt4 import QtCore, QtSql
filename = "data.db"
create = not QtCore.QFile.exists(filename)
db = QtSql.QSqlDatabase.addDatabase("QSQLITE")
db.setDatabaseName(filename)
db.open()
query = QtSql.QSqlQuery()
query.exec_("opencoffe.db < opencoffe.sql")
To copy to clipboard, switch view to plain text mode
only create the file "data.db" but don't export anything.
Bookmarks