dedupe: SqliteDBLink.cpp annotate

annotate SqliteDBLink.cpp @ 31:bf3dce7fedcb

Remove all references to QDebug

author	Tom Fredrik Blenning Klaussen <bfg@blenning.no>
date	Thu, 06 Sep 2012 19:14:58 +0200
parents	06166d6c083b
children	c978d4a6514d

rev	line source
2 2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	1 #include "SqliteDBLink.hpp"
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	2
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	3 #include <QtCore/QStringList>
31 bf3dce7fedcb Remove all references to QDebug Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 16 diff changeset	4 #include <QtCore/QVariant>
bf3dce7fedcb Remove all references to QDebug Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 16 diff changeset	5
2 2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	6
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	7 #include <QtSql/QSqlQuery>
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	8 #include <QtSql/QSqlError>
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	9 #include <QtSql/QSqlRecord>
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	10
31 bf3dce7fedcb Remove all references to QDebug Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 16 diff changeset	11 #include "Exception/SQLException.hpp"
bf3dce7fedcb Remove all references to QDebug Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 16 diff changeset	12
9 b5943e4bf676 Fix up header includes. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 7 diff changeset	13 #include <cassert>
b5943e4bf676 Fix up header includes. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 7 diff changeset	14
2 2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	15 SqliteDBLink::SqliteDBLink(const QString& dbPath)
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	16 {
16 06166d6c083b Add configuration processing. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 9 diff changeset	17 db = QSqlDatabase::addDatabase("QSQLITE", "SqliteDBLink");
2 2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	18 db.setDatabaseName(dbPath);
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	19 bool ok = db.open();
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	20 assert(ok);
16 06166d6c083b Add configuration processing. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 9 diff changeset	21 QSqlQuery query(db);
2 2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	22 if (!query.exec(QString("SELECT * FROM files;"))) {
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	23 query.exec("CREATE TABLE files(path VARCHAR PRIMARY KEY ASC, size INTEGER, mtime TEXT, checksum TEXT);");
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	24 }
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	25 if (!query.exec(QString("SELECT * FROM files;"))) {
31 bf3dce7fedcb Remove all references to QDebug Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 16 diff changeset	26 throw SQLException("No database");
2 2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	27 }
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	28
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	29 }
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	30
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	31 SqliteDBLink::~SqliteDBLink()
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	32 {
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	33 db.close();
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	34 }
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	35
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	36 bool SqliteDBLink::exists(const QString& path)
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	37 {
16 06166d6c083b Add configuration processing. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 9 diff changeset	38 QSqlQuery query(db);
2 2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	39 query.prepare("SELECT path FROM files WHERE path = :path;");
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	40 query.bindValue(":path", path);
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	41 if (!query.exec()) {
31 bf3dce7fedcb Remove all references to QDebug Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 16 diff changeset	42 throw SQLException(query);
2 2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	43 }
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	44 return query.last();
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	45 }
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	46
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	47 FileDBLink::DBStatus SqliteDBLink::existsWithMtime(const QString& path, const QDateTime& mtime)
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	48 {
16 06166d6c083b Add configuration processing. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 9 diff changeset	49 QSqlQuery query(db);
2 2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	50 query.prepare("SELECT mtime FROM files WHERE path = :path;");
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	51 query.bindValue(":path", path);
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	52 if (!query.exec()) {
31 bf3dce7fedcb Remove all references to QDebug Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 16 diff changeset	53 throw SQLException(query);
2 2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	54 }
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	55 if (query.next()) {
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	56 int dateIndex = query.record().indexOf("mtime");
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	57 QDateTime mtimeEntry = query.value(dateIndex).toDateTime();
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	58 if (mtimeEntry == mtime)
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	59 return SAME;
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	60 return MTIME_DIFFERENT;
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	61 }
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	62 return NONE;
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	63 }
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	64
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	65 void SqliteDBLink::addFile(const QString& path, qint64 size, const QDateTime& dtime, const QByteArray& hash)
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	66 {
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	67 addFile(DBInfo(path, size, dtime, hash));
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	68 }
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	69
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	70 bool SqliteDBLink::tryAddFile(const DBInfo& dbinfo)
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	71 {
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	72 if (exists(dbinfo.path()))
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	73 return false;
16 06166d6c083b Add configuration processing. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 9 diff changeset	74 QSqlQuery query(db);
2 2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	75 query.prepare("INSERT INTO files (path, size, mtime, checksum) "
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	76 "VALUES (:path, :size, :mtime, :checksum)");
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	77 query.bindValue(":path", dbinfo.path());
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	78 query.bindValue(":size", dbinfo.size());
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	79 query.bindValue(":mtime", dbinfo.mtime());
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	80 query.bindValue(":checksum", dbinfo.checksum());
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	81 if (!query.exec()) {
31 bf3dce7fedcb Remove all references to QDebug Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 16 diff changeset	82 throw SQLException(query);
2 2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	83 }
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	84 return true;
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	85 }
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	86
7 d6fdca3bf24e Make sure everything works for MemoryDBLink. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 5 diff changeset	87 void SqliteDBLink::updateFile(const QString& path, qint64 size, const QDateTime& dtime, const QByteArray& hash)
d6fdca3bf24e Make sure everything works for MemoryDBLink. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 5 diff changeset	88 {
d6fdca3bf24e Make sure everything works for MemoryDBLink. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 5 diff changeset	89 updateFile(DBInfo(path, size, dtime, hash));
d6fdca3bf24e Make sure everything works for MemoryDBLink. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 5 diff changeset	90 }
d6fdca3bf24e Make sure everything works for MemoryDBLink. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 5 diff changeset	91
2 2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	92 void SqliteDBLink::updateFile(const DBInfo& dbinfo)
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	93 {
16 06166d6c083b Add configuration processing. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 9 diff changeset	94 QSqlQuery query(db);
2 2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	95 query.prepare("UPDATE files SET size=:size, mtime=:mtime, checksum=:checksum WHERE path=:path");
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	96 query.bindValue(":path", dbinfo.path());
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	97 query.bindValue(":size", dbinfo.size());
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	98 query.bindValue(":mtime", dbinfo.mtime());
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	99 query.bindValue(":checksum", dbinfo.checksum());
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	100 if (!query.exec()) {
31 bf3dce7fedcb Remove all references to QDebug Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 16 diff changeset	101 throw SQLException(query);
2 2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	102 }
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	103 }
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	104
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	105 void SqliteDBLink::addFile(const DBInfo& dbinfo)
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	106 {
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	107 if (!tryAddFile(dbinfo)) {
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	108 abort(); //Should throw exception
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	109 }
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	110 }
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	111
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	112
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	113 QStringList SqliteDBLink::toStringList()
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	114 {
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	115 abort();
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	116 QStringList list;
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	117 /*
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	118 foreach(QSharedPointer<DBInfo> info, entries) {
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	119 list << info->serialize();
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	120 }
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	121 */
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	122 return list;
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	123 }
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	124
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	125 const QList<QSharedPointer<FileDBLink::DBInfo> > SqliteDBLink::values(const QString& prefix) const
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	126 {
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	127 QList<QSharedPointer<FileDBLink::DBInfo> > values;
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	128
16 06166d6c083b Add configuration processing. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 9 diff changeset	129 QSqlQuery query(db);
2 2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	130
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	131 if (prefix.size() > 0) {
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	132 query.prepare("SELECT * FROM files WHERE path LIKE :prefix");
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	133 query.bindValue(":prefix", QString("%1%").arg(prefix));
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	134 }
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	135 else {
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	136 query.prepare("SELECT * FROM files");
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	137 }
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	138
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	139 if (!query.exec()) {
31 bf3dce7fedcb Remove all references to QDebug Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 16 diff changeset	140 throw SQLException(query);
2 2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	141 }
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	142
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	143 int pathIndex = query.record().indexOf("path");
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	144 int sizeIndex = query.record().indexOf("size");
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	145 int dateIndex = query.record().indexOf("mtime");
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	146 int checksumIndex = query.record().indexOf("checksum");
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	147 while (query.next()) {
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	148 QString path = query.value(pathIndex).toString();
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	149 qint64 size = query.value(sizeIndex).toInt();
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	150 QDateTime mtime = query.value(dateIndex).toDateTime();
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	151 QByteArray checksum = query.value(checksumIndex).toByteArray();
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	152
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	153 values << QSharedPointer<FileDBLink::DBInfo>(new FileDBLink::DBInfo(path, size, mtime, checksum));
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	154 //qDebug() << path << size << mtime << checksum.toHex();
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	155 }
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	156
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	157 return values;
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	158 }
5 5e4985407feb Add commandline tool updateDeDupe. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 2 diff changeset	159
5e4985407feb Add commandline tool updateDeDupe. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 2 diff changeset	160 void SqliteDBLink::deleteFileFromDB(const QString& path)
5e4985407feb Add commandline tool updateDeDupe. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 2 diff changeset	161 {
16 06166d6c083b Add configuration processing. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 9 diff changeset	162 QSqlQuery query(db);
06166d6c083b Add configuration processing. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 9 diff changeset	163 query.prepare("DELETE FROM files WHERE path = :path");
06166d6c083b Add configuration processing. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 9 diff changeset	164 query.bindValue(":path", path);
06166d6c083b Add configuration processing. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 9 diff changeset	165 if (!query.exec()) {
31 bf3dce7fedcb Remove all references to QDebug Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 16 diff changeset	166 throw SQLException(query);
16 06166d6c083b Add configuration processing. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 9 diff changeset	167 }
5 5e4985407feb Add commandline tool updateDeDupe. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 2 diff changeset	168 }
5e4985407feb Add commandline tool updateDeDupe. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 2 diff changeset	169
5e4985407feb Add commandline tool updateDeDupe. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 2 diff changeset	170
5e4985407feb Add commandline tool updateDeDupe. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 2 diff changeset	171 void SqliteDBLink::keepOnlyFromPrefix(const QString& prefix, const QStringList& files)
5e4985407feb Add commandline tool updateDeDupe. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 2 diff changeset	172 {
5e4985407feb Add commandline tool updateDeDupe. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 2 diff changeset	173 QStringList list;
5e4985407feb Add commandline tool updateDeDupe. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 2 diff changeset	174 foreach(QSharedPointer<DBInfo> info, values(prefix)) {
5e4985407feb Add commandline tool updateDeDupe. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 2 diff changeset	175 if (!files.contains(info->path())) {
5e4985407feb Add commandline tool updateDeDupe. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 2 diff changeset	176 list << info->path();
5e4985407feb Add commandline tool updateDeDupe. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 2 diff changeset	177 }
5e4985407feb Add commandline tool updateDeDupe. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 2 diff changeset	178 }
5e4985407feb Add commandline tool updateDeDupe. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 2 diff changeset	179 foreach(QString path, list) {
5e4985407feb Add commandline tool updateDeDupe. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 2 diff changeset	180 deleteFileFromDB(path);
5e4985407feb Add commandline tool updateDeDupe. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 2 diff changeset	181 }
5e4985407feb Add commandline tool updateDeDupe. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 2 diff changeset	182 }

Mercurial > dedupe

annotate SqliteDBLink.cpp @ 31:bf3dce7fedcb