#!/bin/env python

from PyQt4 import QtSql, QtGui
import os

def createConnection():
    #os.chdir("c:/tmp")
    nombase = os.getcwd()+"/cava.sqlite"
    #nombase = "essai.sqlite"
    db = QtSql.QSqlDatabase.addDatabase('QSQLITE')
    #db.setDatabaseName('/c:/tmp/lessai.sqlite')
    db.setDatabaseName(nombase)
    #db.setDatabaseName(':memory:')
    if not db.open():
        QtGui.QMessageBox.critical(None, QtGui.qApp.tr("Ouverture base impossible"),
                QtGui.qApp.tr("Impossible d'etablir une connexion a la base de donnees.\n"
                              "Cliquer sur Cancel pour quitter."),
                QtGui.QMessageBox.Cancel)
        return False

    query = QtSql.QSqlQuery()
    query.exec_("create table person(id int primary key, "
                "firstname varchar(20), lastname varchar(20))")
    query.exec_("insert into person values(101, 'Michael', 'Young')")
    query.exec_("insert into person values(102, 'Christine', 'Bravo')")
    query.exec_("insert into person values(103, 'Serge', 'Lama')")
    query.exec_("insert into person values(104, 'Charles', 'Trenet')")
    query.exec_("insert into person values(105, 'Maria', 'Carrey')")

    return True