dedupe: SqliteDBLink.cpp annotate

annotate SqliteDBLink.cpp @ 80:9bf00625988d

Disable shared libraries for now, as we get som errors on Linux.

author	Tom Fredrik Blenning Klaussen <bfg@bfgconsult.no>
date	Thu, 10 Oct 2013 14:08:25 +0200
parents	b9515dc35fe4
children	69a30d9f126e

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/QSqlRecord>
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	9
31 bf3dce7fedcb Remove all references to QDebug Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 16 diff changeset	10 #include "Exception/SQLException.hpp"
32 c978d4a6514d Replace unnecessary asserts with exceptions. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 31 diff changeset	11 #include "Exception/IOException.hpp"
9 b5943e4bf676 Fix up header includes. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 7 diff changeset	12
2 2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	13 SqliteDBLink::SqliteDBLink(const QString& dbPath)
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	14 {
16 06166d6c083b Add configuration processing. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 9 diff changeset	15 db = QSqlDatabase::addDatabase("QSQLITE", "SqliteDBLink");
2 2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	16 db.setDatabaseName(dbPath);
32 c978d4a6514d Replace unnecessary asserts with exceptions. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 31 diff changeset	17 if (!db.open())
64 b9515dc35fe4 Make sure no file has greater linewidth than 80. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 62 diff changeset	18 throw
b9515dc35fe4 Make sure no file has greater linewidth than 80. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 62 diff changeset	19 IOException(QString("Unable to open SQLite database with path '%1'")
b9515dc35fe4 Make sure no file has greater linewidth than 80. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 62 diff changeset	20 .arg(dbPath));
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;"))) {
64 b9515dc35fe4 Make sure no file has greater linewidth than 80. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 62 diff changeset	23 query.exec("CREATE TABLE files(path VARCHAR PRIMARY KEY ASC,"
b9515dc35fe4 Make sure no file has greater linewidth than 80. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 62 diff changeset	24 " size INTEGER, mtime TEXT, checksum TEXT);");
2 2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	25 }
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	26 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	27 throw SQLException("No database");
2 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
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	32 SqliteDBLink::~SqliteDBLink()
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	33 {
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	34 db.close();
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
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	37 bool SqliteDBLink::exists(const QString& path)
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	38 {
16 06166d6c083b Add configuration processing. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 9 diff changeset	39 QSqlQuery query(db);
2 2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	40 query.prepare("SELECT path FROM files WHERE path = :path;");
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	41 query.bindValue(":path", path);
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	42 if (!query.exec()) {
31 bf3dce7fedcb Remove all references to QDebug Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 16 diff changeset	43 throw SQLException(query);
2 2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	44 }
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	45 return query.last();
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
64 b9515dc35fe4 Make sure no file has greater linewidth than 80. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 62 diff changeset	48 FileDBLink::DBStatus SqliteDBLink::existsWithMtime(const QString& path,
b9515dc35fe4 Make sure no file has greater linewidth than 80. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 62 diff changeset	49 const QDateTime& mtime)
2 2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	50 {
16 06166d6c083b Add configuration processing. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 9 diff changeset	51 QSqlQuery query(db);
2 2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	52 query.prepare("SELECT mtime FROM files WHERE path = :path;");
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	53 query.bindValue(":path", path);
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	54 if (!query.exec()) {
31 bf3dce7fedcb Remove all references to QDebug Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 16 diff changeset	55 throw SQLException(query);
2 2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	56 }
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	57 if (query.next()) {
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	58 int dateIndex = query.record().indexOf("mtime");
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	59 QDateTime mtimeEntry = query.value(dateIndex).toDateTime();
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	60 if (mtimeEntry == mtime)
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	61 return SAME;
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	62 return MTIME_DIFFERENT;
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 return NONE;
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	65 }
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	66
64 b9515dc35fe4 Make sure no file has greater linewidth than 80. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 62 diff changeset	67 void SqliteDBLink::addFile(const QString& path, qint64 size,
b9515dc35fe4 Make sure no file has greater linewidth than 80. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 62 diff changeset	68 const QDateTime& dtime, const QByteArray& hash)
2 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 addFile(DBInfo(path, size, dtime, hash));
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
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	73 bool SqliteDBLink::tryAddFile(const DBInfo& dbinfo)
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	74 {
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	75 if (exists(dbinfo.path()))
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	76 return false;
16 06166d6c083b Add configuration processing. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 9 diff changeset	77 QSqlQuery query(db);
2 2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	78 query.prepare("INSERT INTO files (path, size, mtime, checksum) "
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	79 "VALUES (:path, :size, :mtime, :checksum)");
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	80 query.bindValue(":path", dbinfo.path());
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	81 query.bindValue(":size", dbinfo.size());
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	82 query.bindValue(":mtime", dbinfo.mtime());
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	83 query.bindValue(":checksum", dbinfo.checksum());
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	84 if (!query.exec()) {
31 bf3dce7fedcb Remove all references to QDebug Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 16 diff changeset	85 throw SQLException(query);
2 2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	86 }
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	87 return true;
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	88 }
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	89
64 b9515dc35fe4 Make sure no file has greater linewidth than 80. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 62 diff changeset	90 void SqliteDBLink::updateFile(const QString& path,
b9515dc35fe4 Make sure no file has greater linewidth than 80. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 62 diff changeset	91 qint64 size, const QDateTime& dtime,
b9515dc35fe4 Make sure no file has greater linewidth than 80. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 62 diff changeset	92 const QByteArray& hash)
7 d6fdca3bf24e Make sure everything works for MemoryDBLink. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 5 diff changeset	93 {
d6fdca3bf24e Make sure everything works for MemoryDBLink. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 5 diff changeset	94 updateFile(DBInfo(path, size, dtime, hash));
d6fdca3bf24e Make sure everything works for MemoryDBLink. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 5 diff changeset	95 }
d6fdca3bf24e Make sure everything works for MemoryDBLink. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 5 diff changeset	96
2 2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	97 void SqliteDBLink::updateFile(const DBInfo& dbinfo)
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	98 {
16 06166d6c083b Add configuration processing. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 9 diff changeset	99 QSqlQuery query(db);
64 b9515dc35fe4 Make sure no file has greater linewidth than 80. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 62 diff changeset	100 query.prepare("UPDATE files "
b9515dc35fe4 Make sure no file has greater linewidth than 80. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 62 diff changeset	101 "SET size=:size, mtime=:mtime, checksum=:checksum "
b9515dc35fe4 Make sure no file has greater linewidth than 80. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 62 diff changeset	102 "WHERE path=:path");
2 2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	103 query.bindValue(":path", dbinfo.path());
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	104 query.bindValue(":size", dbinfo.size());
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	105 query.bindValue(":mtime", dbinfo.mtime());
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	106 query.bindValue(":checksum", dbinfo.checksum());
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	107 if (!query.exec()) {
31 bf3dce7fedcb Remove all references to QDebug Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 16 diff changeset	108 throw SQLException(query);
2 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 void SqliteDBLink::addFile(const DBInfo& dbinfo)
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	113 {
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	114 if (!tryAddFile(dbinfo)) {
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	115 abort(); //Should throw exception
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	116 }
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
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	119
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	120 QStringList SqliteDBLink::toStringList()
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 abort();
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	123 QStringList list;
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	124 /*
64 b9515dc35fe4 Make sure no file has greater linewidth than 80. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 62 diff changeset	125 foreach(dbinf_ptr_t info, entries) {
2 2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	126 list << info->serialize();
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	127 }
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	128 */
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	129 return list;
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
64 b9515dc35fe4 Make sure no file has greater linewidth than 80. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 62 diff changeset	132 const QList<FileDBLink::dbinf_ptr_t >
b9515dc35fe4 Make sure no file has greater linewidth than 80. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 62 diff changeset	133 SqliteDBLink::values(const QString& prefix) const
2 2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	134 {
64 b9515dc35fe4 Make sure no file has greater linewidth than 80. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 62 diff changeset	135 QList<FileDBLink::dbinf_ptr_t > values;
2 2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	136
16 06166d6c083b Add configuration processing. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 9 diff changeset	137 QSqlQuery query(db);
2 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 (prefix.size() > 0) {
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	140 query.prepare("SELECT * FROM files WHERE path LIKE :prefix");
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	141 query.bindValue(":prefix", QString("%1%").arg(prefix));
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 else {
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	144 query.prepare("SELECT * FROM files");
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	145 }
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	146
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	147 if (!query.exec()) {
31 bf3dce7fedcb Remove all references to QDebug Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 16 diff changeset	148 throw SQLException(query);
2 2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	149 }
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	150
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	151 int pathIndex = query.record().indexOf("path");
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	152 int sizeIndex = query.record().indexOf("size");
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	153 int dateIndex = query.record().indexOf("mtime");
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	154 int checksumIndex = query.record().indexOf("checksum");
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	155 while (query.next()) {
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	156 QString path = query.value(pathIndex).toString();
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	157 qint64 size = query.value(sizeIndex).toInt();
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	158 QDateTime mtime = query.value(dateIndex).toDateTime();
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	159 QByteArray checksum = query.value(checksumIndex).toByteArray();
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	160
64 b9515dc35fe4 Make sure no file has greater linewidth than 80. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 62 diff changeset	161 values <<
b9515dc35fe4 Make sure no file has greater linewidth than 80. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 62 diff changeset	162 FileDBLink::dbinf_ptr_t(new FileDBLink::DBInfo(path,
b9515dc35fe4 Make sure no file has greater linewidth than 80. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 62 diff changeset	163 size, mtime, checksum));
2 2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	164 }
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	165
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: diff changeset	166 return values;
2833b7f8884a Sql backend is working. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 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 void SqliteDBLink::deleteFileFromDB(const QString& path)
5e4985407feb Add commandline tool updateDeDupe. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 2 diff changeset	170 {
16 06166d6c083b Add configuration processing. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 9 diff changeset	171 QSqlQuery query(db);
06166d6c083b Add configuration processing. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 9 diff changeset	172 query.prepare("DELETE FROM files WHERE path = :path");
06166d6c083b Add configuration processing. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 9 diff changeset	173 query.bindValue(":path", path);
06166d6c083b Add configuration processing. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 9 diff changeset	174 if (!query.exec()) {
31 bf3dce7fedcb Remove all references to QDebug Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 16 diff changeset	175 throw SQLException(query);
16 06166d6c083b Add configuration processing. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 9 diff changeset	176 }
5 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
64 b9515dc35fe4 Make sure no file has greater linewidth than 80. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 62 diff changeset	180 void SqliteDBLink::keepOnlyFromPrefix(const QString& prefix,
b9515dc35fe4 Make sure no file has greater linewidth than 80. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 62 diff changeset	181 const QStringList& files)
5 5e4985407feb Add commandline tool updateDeDupe. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 2 diff changeset	182 {
5e4985407feb Add commandline tool updateDeDupe. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 2 diff changeset	183 QStringList list;
64 b9515dc35fe4 Make sure no file has greater linewidth than 80. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 62 diff changeset	184 foreach(dbinf_ptr_t info, values(prefix)) {
5 5e4985407feb Add commandline tool updateDeDupe. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 2 diff changeset	185 if (!files.contains(info->path())) {
5e4985407feb Add commandline tool updateDeDupe. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 2 diff changeset	186 list << info->path();
5e4985407feb Add commandline tool updateDeDupe. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 2 diff changeset	187 }
5e4985407feb Add commandline tool updateDeDupe. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 2 diff changeset	188 }
5e4985407feb Add commandline tool updateDeDupe. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 2 diff changeset	189 foreach(QString path, list) {
5e4985407feb Add commandline tool updateDeDupe. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 2 diff changeset	190 deleteFileFromDB(path);
5e4985407feb Add commandline tool updateDeDupe. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 2 diff changeset	191 }
5e4985407feb Add commandline tool updateDeDupe. Tom Fredrik Blenning Klaussen <bfg@blenning.no> parents: 2 diff changeset	192 }

Mercurial > dedupe

annotate SqliteDBLink.cpp @ 80:9bf00625988d