Mercurial > hg > syntilista

comparison src/sqlmodels.cpp @ 255:55581d90c55d

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Change API for slCheckAndReportSQLError().
author Matti Hamalainen <ccr@tnsp.org>
date Wed, 10 Oct 2018 13:21:51 +0300
parents 43a5e09bb832
children 0f345852b3ed
comparison
equal deleted inserted replaced
254:0e0ad52994ca 255:55581d90c55d
56 np.addBindValue(info.extraInfo); 56 np.addBindValue(info.extraInfo);
57 np.addBindValue(QDateTime::currentDateTimeUtc()); 57 np.addBindValue(QDateTime::currentDateTimeUtc());
58 np.addBindValue(info.id); 58 np.addBindValue(info.id);
59 np.exec(); 59 np.exec();
60 60
61 if (!slCheckAndReportSQLError("SLPersonSQLModel::updatePerson()", np.lastError())) 61 if (!slCheckAndReportSQLError(np, "SLPersonSQLModel::updatePerson()"))
62 return -1; 62 return -1;
63 63
64 QSqlDatabase::database().commit(); 64 QSqlDatabase::database().commit();
65 updateModel(); 65 updateModel();
66 return 0; 66 return 0;
76 np.addBindValue(info.extraInfo); 76 np.addBindValue(info.extraInfo);
77 np.addBindValue(QDateTime::currentDateTimeUtc()); 77 np.addBindValue(QDateTime::currentDateTimeUtc());
78 np.addBindValue(QDateTime::currentDateTimeUtc()); 78 np.addBindValue(QDateTime::currentDateTimeUtc());
79 np.exec(); 79 np.exec();
80 80
81 if (!slCheckAndReportSQLError("SLPersonSQLModel::addPerson()", np.lastError())) 81 if (!slCheckAndReportSQLError(np, "SLPersonSQLModel::addPerson()"))
82 return -1; 82 return -1;
83 83
84 QSqlDatabase::database().commit(); 84 QSqlDatabase::database().commit();
85 85
86 QVariant idp = np.lastInsertId(); 86 QVariant idp = np.lastInsertId();
97 97
98 del.prepare(QStringLiteral("DELETE FROM people WHERE id=?")); 98 del.prepare(QStringLiteral("DELETE FROM people WHERE id=?"));
99 del.addBindValue(id); 99 del.addBindValue(id);
100 del.exec(); 100 del.exec();
101 101
102 if (!slCheckAndReportSQLError("delete user", del.lastError())) 102 if (!slCheckAndReportSQLError(del, "delete user"))
103 { 103 {
104 QSqlDatabase::database().rollback(); 104 QSqlDatabase::database().rollback();
105 return -1; 105 return -1;
106 } 106 }
107 107
108 del.prepare(QStringLiteral("DELETE FROM transactions WHERE person=?")); 108 del.prepare(QStringLiteral("DELETE FROM transactions WHERE person=?"));
109 del.addBindValue(id); 109 del.addBindValue(id);
110 del.exec(); 110 del.exec();
111 111
112 if (!slCheckAndReportSQLError("delete user transactions", del.lastError())) 112 if (!slCheckAndReportSQLError(del, "delete user transactions"))
113 { 113 {
114 QSqlDatabase::database().rollback(); 114 QSqlDatabase::database().rollback();
115 return -2; 115 return -2;
116 } 116 }
117 117