#ifndef DBTOOLS_H
#define DBTOOLS_H

#include <QObject>

class DBTools : QObject
{
    Q_OBJECT
public:
    explicit DBTools(QObject *parent = 0);
    ~DBTools();

public:
    void importCSV(QString fileName);
    void testDB();

signals:

public slots:

private:
    bool createDB();
    void insertContact( QString name, QString mobile, QString deskphone,
                        int xtn, QString email, QString skype,
                        QString twitter, QString title, int site,
                        int department, int floor);
    int getLastInsertRowId();
    bool createTable(QString sqlStmt);

};

#endif // DBTOOLS_H