How can i execute a database script within Qt?

[NoRulez]

Hey @all,

i have a sql script in the resource file, which creates all necessary database tables, indexes and insert some initial data.

How can i execute these script?

Here is an example of such script:

CREATE TABLE "table1" (
    "id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
    "bla1" TEXT,
);
CREATE TABLE "table2" (
    "id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
    "bla2" TEXT,
);

CREATE TABLE "table1" (
    "id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
    "bla1" TEXT,
);
CREATE TABLE "table2" (
    "id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
    "bla2" TEXT,
);

To copy to clipboard, switch view to plain text mode 

Best Regards
NoRulez