-
Notifications
You must be signed in to change notification settings - Fork 4
/
cdb.cpp
45 lines (32 loc) · 1000 Bytes
/
cdb.cpp
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
#include "cdb.h"
CDB *g_pDb;
CDB::CDB(const QSqlDatabase &other) :
QSqlDatabase(other)
{
}
////////////////
bool CDB::init()
////////////////
{
// create tables
QSqlQuery q = exec("create table gallery (name char[64], path char[256], common_name char[64], id INTEGER PRIMARY KEY)");
if (q.lastError().type() != QSqlError::NoError)
return(false);
return(true);
}
////////////////////////////////////////////////////////////////////////////////
bool CDB::addToGallery(const QString name, const QString id, const QString path)
////////////////////////////////////////////////////////////////////////////////
{
QString name2 = name;
QString id2 = id;
name2 = name2.replace("'", "''");
id2 = id2.replace("'", "''");
QString cmd = QString("insert into gallery (name, path, common_name) values('%1', '%2', '%3')").arg(id2).arg(path).arg(name2);
QSqlQuery q = exec(cmd);
if (q.lastError().type() != QSqlError::NoError)
{
return(false);
}
return(true);
}