data/RelationIndex.cpp
| Line | Branch | Exec | Source |
|---|---|---|---|
| 1 | #include "RelationIndex.h" | ||
| 2 | |||
| 3 | #include "RelationVocabulary.h" | ||
| 4 | |||
| 5 | #include "ContactIndex.h" | ||
| 6 | |||
| 7 | #include <QHash> | ||
| 8 | #include <QLoggingCategory> | ||
| 9 | #include <QSqlError> | ||
| 10 | #include <QSqlQuery> | ||
| 11 | #include <algorithm> | ||
| 12 | #include <QUrl> | ||
| 13 | #include <QVariant> | ||
| 14 | |||
| 15 | Q_DECLARE_LOGGING_CATEGORY(lcContactPeople) | ||
| 16 | |||
| 17 | namespace RelationIndex { | ||
| 18 | |||
| 19 | namespace { | ||
| 20 | |||
| 21 | struct CardInfo { | ||
| 22 | qint64 id = 0; | ||
| 23 | qint64 bookId = 0; | ||
| 24 | QString uid; | ||
| 25 | QString name; | ||
| 26 | QString href; | ||
| 27 | bool writable = true; | ||
| 28 | bool bookReadOnly = false; | ||
| 29 | QString gender; | ||
| 30 |
2/2✓ Branch 6 → 7 taken 1839 times.
✓ Branch 8 → 9 taken 1839 times.
|
7356 | QString key() const { return QStringLiteral("%1/%2").arg(bookId).arg(uid); } |
| 31 | }; | ||
| 32 | |||
| 33 | 20007 | QString bareUid(QString uid) { | |
| 34 |
1/1✓ Branch 2 → 3 taken 20007 times.
|
20007 | uid = uid.trimmed(); |
| 35 |
3/3✓ Branch 6 → 7 taken 20007 times.
✓ Branch 7 → 8 taken 1 time.
✓ Branch 7 → 12 taken 20006 times.
|
20007 | if (uid.startsWith(QLatin1String("urn:uuid:"), Qt::CaseInsensitive)) |
| 36 |
1/1✓ Branch 8 → 9 taken 1 time.
|
1 | uid = uid.mid(9); |
| 37 | 20007 | return uid.toLower(); | |
| 38 | } | ||
| 39 | |||
| 40 | 1624 | CardInfo cardInfo(const QSqlDatabase &db, qint64 cardId) { | |
| 41 |
1/1✓ Branch 2 → 3 taken 1624 times.
|
1624 | QSqlQuery q(db); |
| 42 |
1/1✓ Branch 6 → 7 taken 1624 times.
|
1624 | q.prepare(QStringLiteral("SELECT c.id, c.book_id, c.uid, c.display_name, c.href, c.writable, b.read_only," |
| 43 | " COALESCE(t.gender, '') FROM cards c JOIN address_books b ON b.id = c.book_id" | ||
| 44 | " LEFT JOIN card_traits t ON t.card_id = c.id WHERE c.id = ?")); | ||
| 45 |
1/1✓ Branch 11 → 12 taken 1624 times.
|
1624 | q.addBindValue(cardId); |
| 46 | 1624 | CardInfo info; | |
| 47 |
5/8✓ Branch 13 → 14 taken 1624 times.
✓ Branch 14 → 15 taken 1624 times.
✗ Branch 14 → 18 not taken.
✓ Branch 15 → 16 taken 1624 times.
✓ Branch 16 → 17 taken 1624 times.
✗ Branch 16 → 18 not taken.
✓ Branch 19 → 20 taken 1624 times.
✗ Branch 19 → 53 not taken.
|
1624 | if (q.exec() && q.next()) { |
| 48 |
2/2✓ Branch 20 → 21 taken 1624 times.
✓ Branch 21 → 22 taken 1624 times.
|
1624 | info.id = q.value(0).toLongLong(); |
| 49 |
2/2✓ Branch 23 → 24 taken 1624 times.
✓ Branch 24 → 25 taken 1624 times.
|
1624 | info.bookId = q.value(1).toLongLong(); |
| 50 |
2/2✓ Branch 26 → 27 taken 1624 times.
✓ Branch 27 → 28 taken 1624 times.
|
1624 | info.uid = q.value(2).toString(); |
| 51 |
2/2✓ Branch 31 → 32 taken 1624 times.
✓ Branch 32 → 33 taken 1624 times.
|
1624 | info.name = q.value(3).toString(); |
| 52 |
2/2✓ Branch 36 → 37 taken 1624 times.
✓ Branch 37 → 38 taken 1624 times.
|
1624 | info.href = q.value(4).toString(); |
| 53 |
2/2✓ Branch 41 → 42 taken 1624 times.
✓ Branch 42 → 43 taken 1624 times.
|
1624 | info.writable = q.value(5).toBool(); |
| 54 |
2/2✓ Branch 44 → 45 taken 1624 times.
✓ Branch 45 → 46 taken 1624 times.
|
1624 | info.bookReadOnly = q.value(6).toBool(); |
| 55 |
2/2✓ Branch 47 → 48 taken 1624 times.
✓ Branch 48 → 49 taken 1624 times.
|
1624 | info.gender = q.value(7).toString(); |
| 56 | } | ||
| 57 | 1624 | return info; | |
| 58 | 1624 | } | |
| 59 | |||
| 60 | // Cards whose UID equals `uid` in any of its forms, the holder's book first. | ||
| 61 | 19243 | qint64 byUid(const QSqlDatabase &db, qint64 holderBookId, const QString &uid) { | |
| 62 |
1/1✓ Branch 3 → 4 taken 19243 times.
|
19243 | const QString bare = bareUid(uid); |
| 63 |
2/2✓ Branch 6 → 7 taken 1492 times.
✓ Branch 6 → 8 taken 17751 times.
|
19243 | if (bare.isEmpty()) |
| 64 | 1492 | return 0; | |
| 65 |
1/1✓ Branch 8 → 9 taken 17751 times.
|
17751 | QSqlQuery q(db); |
| 66 |
1/1✓ Branch 12 → 13 taken 17751 times.
|
17751 | q.prepare(QStringLiteral("SELECT id FROM cards WHERE lower(uid) IN (?, ?) ORDER BY (book_id = ?) DESC, id LIMIT 1")); |
| 67 |
1/1✓ Branch 17 → 18 taken 17751 times.
|
17751 | q.addBindValue(bare); |
| 68 |
2/2✓ Branch 23 → 24 taken 17751 times.
✓ Branch 25 → 26 taken 17751 times.
|
17751 | q.addBindValue(QStringLiteral("urn:uuid:") + bare); |
| 69 |
1/1✓ Branch 32 → 33 taken 17751 times.
|
17751 | q.addBindValue(holderBookId); |
| 70 |
9/12✓ Branch 34 → 35 taken 17751 times.
✓ Branch 35 → 36 taken 17751 times.
✗ Branch 35 → 41 not taken.
✓ Branch 36 → 37 taken 17751 times.
✓ Branch 37 → 38 taken 17749 times.
✓ Branch 37 → 41 taken 2 times.
✓ Branch 38 → 39 taken 17749 times.
✓ Branch 39 → 40 taken 17749 times.
✓ Branch 43 → 44 taken 17749 times.
✓ Branch 43 → 45 taken 2 times.
✗ Branch 79 → 80 not taken.
✗ Branch 79 → 81 not taken.
|
17751 | return q.exec() && q.next() ? q.value(0).toLongLong() : 0; |
| 71 | 19243 | } | |
| 72 | |||
| 73 | 4 | qint64 byUri(const QSqlDatabase &db, const QString &uri) { | |
| 74 |
3/3✓ Branch 3 → 4 taken 4 times.
✓ Branch 4 → 5 taken 1 time.
✓ Branch 4 → 37 taken 3 times.
|
4 | if (uri.startsWith(QLatin1String("mailto:"), Qt::CaseInsensitive)) { |
| 75 |
1/1✓ Branch 5 → 6 taken 1 time.
|
1 | QSqlQuery q(db); |
| 76 |
1/1✓ Branch 9 → 10 taken 1 time.
|
1 | q.prepare(QStringLiteral("SELECT card_id FROM card_addresses WHERE address_key = ? ORDER BY card_id LIMIT 1")); |
| 77 |
5/5✓ Branch 13 → 14 taken 1 time.
✓ Branch 14 → 15 taken 1 time.
✓ Branch 15 → 16 taken 1 time.
✓ Branch 16 → 17 taken 1 time.
✓ Branch 18 → 19 taken 1 time.
|
1 | q.addBindValue(ContactIndex::addressKey(QUrl::fromPercentEncoding(uri.mid(7).toUtf8()))); |
| 78 |
7/12✓ Branch 24 → 25 taken 1 time.
✓ Branch 25 → 26 taken 1 time.
✗ Branch 25 → 31 not taken.
✓ Branch 26 → 27 taken 1 time.
✓ Branch 27 → 28 taken 1 time.
✗ Branch 27 → 31 not taken.
✓ Branch 28 → 29 taken 1 time.
✓ Branch 29 → 30 taken 1 time.
✓ Branch 33 → 34 taken 1 time.
✗ Branch 33 → 35 not taken.
✗ Branch 112 → 113 not taken.
✗ Branch 112 → 114 not taken.
|
1 | return q.exec() && q.next() ? q.value(0).toLongLong() : 0; |
| 79 | 1 | } | |
| 80 |
3/3✓ Branch 38 → 39 taken 3 times.
✓ Branch 39 → 40 taken 1 time.
✓ Branch 39 → 41 taken 2 times.
|
3 | if (!uri.startsWith(QLatin1String("http"), Qt::CaseInsensitive)) |
| 81 | 1 | return 0; | |
| 82 | // S106-170: the stored href is compared as text — inside LIKE its % and _ | ||
| 83 | // were wildcards — against the decoded and the percent-encoded path. | ||
| 84 |
1/1✓ Branch 41 → 42 taken 2 times.
|
2 | const QUrl url(uri); |
| 85 |
1/1✓ Branch 43 → 44 taken 2 times.
|
2 | const QString path = url.path(); |
| 86 |
1/1✓ Branch 45 → 46 taken 2 times.
|
2 | const QString encoded = url.path(QUrl::FullyEncoded); |
| 87 |
1/2✗ Branch 47 → 48 not taken.
✓ Branch 47 → 49 taken 2 times.
|
2 | if (path.isEmpty()) |
| 88 | ✗ | return 0; | |
| 89 |
1/1✓ Branch 49 → 50 taken 2 times.
|
2 | QSqlQuery q(db); |
| 90 |
1/1✓ Branch 53 → 54 taken 2 times.
|
2 | q.prepare(QStringLiteral("SELECT id FROM cards WHERE href <> '' AND (href IN (?, ?)" |
| 91 | " OR substr(?, -length(href)) = href OR substr(?, -length(href)) = href)" | ||
| 92 | " ORDER BY id LIMIT 1")); | ||
| 93 |
1/1✓ Branch 58 → 59 taken 2 times.
|
2 | q.addBindValue(path); |
| 94 |
1/1✓ Branch 62 → 63 taken 2 times.
|
2 | q.addBindValue(encoded); |
| 95 |
1/1✓ Branch 66 → 67 taken 2 times.
|
2 | q.addBindValue(path); |
| 96 |
1/1✓ Branch 70 → 71 taken 2 times.
|
2 | q.addBindValue(encoded); |
| 97 |
7/12✓ Branch 72 → 73 taken 2 times.
✓ Branch 73 → 74 taken 2 times.
✗ Branch 73 → 79 not taken.
✓ Branch 74 → 75 taken 2 times.
✓ Branch 75 → 76 taken 2 times.
✗ Branch 75 → 79 not taken.
✓ Branch 76 → 77 taken 2 times.
✓ Branch 77 → 78 taken 2 times.
✓ Branch 81 → 82 taken 2 times.
✗ Branch 81 → 83 not taken.
✗ Branch 144 → 145 not taken.
✗ Branch 144 → 146 not taken.
|
2 | return q.exec() && q.next() ? q.value(0).toLongLong() : 0; |
| 98 | 2 | } | |
| 99 | |||
| 100 | // A unique display name (folded), the holder's book first. | ||
| 101 | 743 | qint64 byName(const QSqlDatabase &db, qint64 holderBookId, const QString &name) { | |
| 102 |
1/1✓ Branch 2 → 3 taken 743 times.
|
743 | const QString folded = ContactIndex::foldForSort(name); |
| 103 |
1/2✗ Branch 4 → 5 not taken.
✓ Branch 4 → 6 taken 743 times.
|
743 | if (folded.isEmpty()) |
| 104 | ✗ | return 0; | |
| 105 |
1/1✓ Branch 6 → 7 taken 743 times.
|
743 | QSqlQuery q(db); |
| 106 |
1/1✓ Branch 10 → 11 taken 743 times.
|
743 | q.prepare(QStringLiteral("SELECT id, book_id FROM cards WHERE sort_display = ? AND kind <> 'group' LIMIT 3")); |
| 107 |
1/1✓ Branch 15 → 16 taken 743 times.
|
743 | q.addBindValue(folded); |
| 108 |
2/3✓ Branch 17 → 18 taken 743 times.
✗ Branch 18 → 19 not taken.
✓ Branch 18 → 20 taken 743 times.
|
743 | if (!q.exec()) |
| 109 | ✗ | return 0; | |
| 110 | 743 | QList<QPair<qint64, qint64>> hits; | |
| 111 |
3/3✓ Branch 30 → 31 taken 1121 times.
✓ Branch 31 → 21 taken 378 times.
✓ Branch 31 → 32 taken 743 times.
|
1121 | while (q.next()) |
| 112 |
5/5✓ Branch 21 → 22 taken 378 times.
✓ Branch 22 → 23 taken 378 times.
✓ Branch 23 → 24 taken 378 times.
✓ Branch 24 → 25 taken 378 times.
✓ Branch 26 → 27 taken 378 times.
|
378 | hits.append({q.value(0).toLongLong(), q.value(1).toLongLong()}); |
| 113 |
4/4✓ Branch 32 → 33 taken 743 times.
✓ Branch 33 → 34 taken 743 times.
✓ Branch 40 → 35 taken 378 times.
✓ Branch 40 → 41 taken 374 times.
|
752 | for (const auto &hit : hits) |
| 114 |
2/2✓ Branch 36 → 37 taken 369 times.
✓ Branch 36 → 38 taken 9 times.
|
378 | if (hit.second == holderBookId) |
| 115 | 369 | return hit.first; | |
| 116 |
3/3✓ Branch 42 → 43 taken 7 times.
✓ Branch 42 → 45 taken 367 times.
✓ Branch 43 → 44 taken 7 times.
|
374 | return hits.size() == 1 ? hits.first().first : 0; |
| 117 | 743 | } | |
| 118 | |||
| 119 | struct Stored { | ||
| 120 | qint64 cardId = 0; | ||
| 121 | int position = -1; | ||
| 122 | QString role, type, label, uid, uri, name, model; | ||
| 123 | }; | ||
| 124 | |||
| 125 | 1528 | QList<Stored> storedRows(QSqlQuery &q) { | |
| 126 | 1528 | QList<Stored> rows; | |
| 127 |
3/3✓ Branch 33 → 34 taken 3087 times.
✓ Branch 34 → 3 taken 1559 times.
✓ Branch 34 → 35 taken 1528 times.
|
3087 | while (q.next()) |
| 128 |
3/3✓ Branch 3 → 4 taken 1559 times.
✓ Branch 4 → 5 taken 1559 times.
✓ Branch 6 → 7 taken 1559 times.
|
6236 | rows.append({q.value(0).toLongLong(), q.value(1).toInt(), q.value(2).toString(), q.value(3).toString(), |
| 129 | 1559 | q.value(4).toString(), q.value(5).toString(), q.value(6).toString(), q.value(7).toString(), | |
| 130 | 1559 | q.value(8).toString()}); | |
| 131 | 1528 | return rows; | |
| 132 | 3118 | } | |
| 133 | |||
| 134 | const char *kStoredColumns = "card_id, position, role, type, label, target_uid, target_uri, target_name, model"; | ||
| 135 | |||
| 136 | 926 | Row rowFor(const Stored &stored, const CardInfo &holder, const CardInfo &other, bool inverse) { | |
| 137 | 926 | Row row; | |
| 138 | 926 | row.type = stored.type; | |
| 139 | 926 | row.label = stored.label; | |
| 140 | 926 | row.sourceIndex = stored.position; | |
| 141 | 926 | row.storedOnCardId = holder.id; | |
| 142 |
1/1✓ Branch 4 → 5 taken 926 times.
|
926 | row.storedOnKey = holder.key(); |
| 143 |
2/2✓ Branch 9 → 10 taken 138 times.
✓ Branch 9 → 24 taken 788 times.
|
926 | if (stored.role == QLatin1String("via")) |
| 144 |
6/6✓ Branch 10 → 11 taken 61 times.
✓ Branch 10 → 14 taken 77 times.
✓ Branch 19 → 20 taken 77 times.
✓ Branch 19 → 21 taken 61 times.
✓ Branch 21 → 22 taken 61 times.
✓ Branch 21 → 23 taken 77 times.
|
276 | row.role = inverse ? QStringLiteral("introduced") : QStringLiteral("via"); |
| 145 | else | ||
| 146 |
6/6✓ Branch 24 → 25 taken 383 times.
✓ Branch 24 → 28 taken 405 times.
✓ Branch 33 → 34 taken 405 times.
✓ Branch 33 → 35 taken 383 times.
✓ Branch 35 → 36 taken 383 times.
✓ Branch 35 → 37 taken 405 times.
|
1576 | row.role = inverse ? QStringLiteral("inverse") : QStringLiteral("relation"); |
| 147 |
5/6✓ Branch 40 → 41 taken 924 times.
✓ Branch 40 → 43 taken 2 times.
✓ Branch 41 → 42 taken 924 times.
✗ Branch 41 → 43 not taken.
✓ Branch 42 → 43 taken 1 time.
✓ Branch 42 → 44 taken 923 times.
|
926 | row.readOnly = stored.model == QLatin1String("legacy") || !holder.writable || holder.bookReadOnly; |
| 148 |
2/2✓ Branch 45 → 46 taken 913 times.
✓ Branch 45 → 51 taken 13 times.
|
926 | if (other.id > 0) { |
| 149 | 913 | row.otherCardId = other.id; | |
| 150 |
1/1✓ Branch 46 → 47 taken 913 times.
|
913 | row.otherKey = other.key(); |
| 151 | 913 | row.otherName = other.name; | |
| 152 | 913 | row.otherGender = other.gender; | |
| 153 | } else { | ||
| 154 | 13 | row.otherName = stored.name; | |
| 155 |
3/4✓ Branch 53 → 54 taken 12 times.
✓ Branch 53 → 56 taken 1 time.
✗ Branch 55 → 56 not taken.
✓ Branch 55 → 57 taken 12 times.
|
13 | row.dangling = !stored.uid.isEmpty() || !stored.uri.isEmpty(); |
| 156 | 13 | row.textOnly = !row.dangling; | |
| 157 | } | ||
| 158 | 926 | return row; | |
| 159 | ✗ | } | |
| 160 | |||
| 161 | } // namespace | ||
| 162 | |||
| 163 | 18496 | qint64 resolve(const QSqlDatabase &db, qint64 holderBookId, const QString &uid, const QString &uri, | |
| 164 | const QString &name) { | ||
| 165 |
2/2✓ Branch 3 → 4 taken 17749 times.
✓ Branch 3 → 5 taken 747 times.
|
18496 | if (const qint64 id = byUid(db, holderBookId, uid); id > 0) |
| 166 | 17749 | return id; | |
| 167 |
2/2✓ Branch 6 → 7 taken 747 times.
✓ Branch 10 → 11 taken 747 times.
|
1494 | if (const qint64 id = byUid(db, holderBookId, uri.startsWith(QLatin1String("urn:uuid:"), Qt::CaseInsensitive) |
| 168 |
3/4✓ Branch 7 → 8 taken 1 time.
✓ Branch 7 → 9 taken 746 times.
✗ Branch 12 → 13 not taken.
✓ Branch 12 → 14 taken 747 times.
|
1494 | ? uri |
| 169 | : QString()); | ||
| 170 | id > 0) | ||
| 171 | ✗ | return id; | |
| 172 |
2/2✓ Branch 15 → 16 taken 4 times.
✓ Branch 15 → 18 taken 743 times.
|
747 | if (!uri.isEmpty()) |
| 173 | 4 | return byUri(db, uri); | |
| 174 |
1/2✗ Branch 19 → 20 not taken.
✓ Branch 19 → 21 taken 743 times.
|
743 | if (!uid.isEmpty()) |
| 175 | ✗ | return 0; // a UID that names no card is dangling, never matched by name | |
| 176 | 743 | return byName(db, holderBookId, name); | |
| 177 | } | ||
| 178 | |||
| 179 | 764 | QList<Row> forCard(const QSqlDatabase &db, qint64 cardId, int limit) { | |
| 180 | 764 | QList<Row> rows; | |
| 181 |
1/1✓ Branch 2 → 3 taken 764 times.
|
764 | const CardInfo self = cardInfo(db, cardId); |
| 182 |
1/2✗ Branch 3 → 4 not taken.
✓ Branch 3 → 5 taken 764 times.
|
764 | if (self.id == 0) |
| 183 | ✗ | return rows; | |
| 184 | 764 | QHash<qint64, CardInfo> infos; | |
| 185 | 915 | const auto info = [&](qint64 id) { | |
| 186 |
2/2✓ Branch 3 → 4 taken 860 times.
✓ Branch 3 → 8 taken 55 times.
|
915 | if (!infos.contains(id)) |
| 187 |
2/2✓ Branch 4 → 5 taken 860 times.
✓ Branch 5 → 6 taken 860 times.
|
860 | infos.insert(id, cardInfo(db, id)); |
| 188 | 915 | return infos.value(id); | |
| 189 | 764 | }; | |
| 190 | // Stored on this card. | ||
| 191 |
1/1✓ Branch 5 → 6 taken 764 times.
|
764 | QSqlQuery own(db); |
| 192 |
1/1✓ Branch 12 → 13 taken 764 times.
|
2292 | own.prepare(QStringLiteral("SELECT %1 FROM card_relations WHERE card_id = ? ORDER BY role, position") |
| 193 |
1/1✓ Branch 11 → 12 taken 764 times.
|
2292 | .arg(QLatin1String(kStoredColumns))); |
| 194 |
1/1✓ Branch 18 → 19 taken 764 times.
|
764 | own.addBindValue(cardId); |
| 195 |
2/3✓ Branch 20 → 21 taken 764 times.
✗ Branch 21 → 22 not taken.
✓ Branch 21 → 40 taken 764 times.
|
764 | if (!own.exec()) |
| 196 | ✗ | qCWarning(lcContactPeople) << "Relations of card" << cardId << "could not be read:" << own.lastError().text(); | |
| 197 |
5/5✓ Branch 40 → 41 taken 764 times.
✓ Branch 41 → 42 taken 764 times.
✓ Branch 42 → 43 taken 764 times.
✓ Branch 58 → 44 taken 482 times.
✓ Branch 58 → 59 taken 764 times.
|
1246 | for (const Stored &stored : storedRows(own)) { |
| 198 |
1/2✗ Branch 46 → 47 not taken.
✓ Branch 46 → 48 taken 482 times.
|
482 | if (rows.size() >= limit) |
| 199 | ✗ | break; | |
| 200 |
1/1✓ Branch 48 → 49 taken 482 times.
|
482 | const qint64 target = resolve(db, self.bookId, stored.uid, stored.uri, stored.name); |
| 201 |
5/5✓ Branch 49 → 50 taken 469 times.
✓ Branch 49 → 51 taken 13 times.
✓ Branch 50 → 52 taken 469 times.
✓ Branch 52 → 53 taken 482 times.
✓ Branch 53 → 54 taken 482 times.
|
482 | rows.append(rowFor(stored, self, target > 0 ? info(target) : CardInfo{}, false)); |
| 202 | 764 | } | |
| 203 | // Stored on other cards and pointing here: candidates by UID, URI or name, | ||
| 204 | // confirmed by resolving them from their own book. | ||
| 205 |
1/1✓ Branch 61 → 62 taken 764 times.
|
764 | const QString bare = bareUid(self.uid); |
| 206 |
1/1✓ Branch 63 → 64 taken 764 times.
|
764 | QSqlQuery other(db); |
| 207 |
1/1✓ Branch 70 → 71 taken 764 times.
|
2292 | other.prepare(QStringLiteral("SELECT %1 FROM card_relations WHERE card_id <> ? AND (lower(target_uid) IN (?, ?)" |
| 208 | " OR lower(target_uri) IN (?, ?) OR (target_uid = '' AND target_uri <> '')" | ||
| 209 | " OR (target_uid = '' AND target_uri = ''))" | ||
| 210 | " ORDER BY card_id, position") | ||
| 211 |
1/1✓ Branch 69 → 70 taken 764 times.
|
2292 | .arg(QLatin1String(kStoredColumns))); |
| 212 |
1/1✓ Branch 76 → 77 taken 764 times.
|
764 | other.addBindValue(cardId); |
| 213 |
1/1✓ Branch 80 → 81 taken 764 times.
|
764 | other.addBindValue(bare); |
| 214 |
2/2✓ Branch 86 → 87 taken 764 times.
✓ Branch 88 → 89 taken 764 times.
|
764 | other.addBindValue(QStringLiteral("urn:uuid:") + bare); |
| 215 |
2/2✓ Branch 97 → 98 taken 764 times.
✓ Branch 99 → 100 taken 764 times.
|
764 | other.addBindValue(QStringLiteral("urn:uuid:") + bare); |
| 216 |
2/2✓ Branch 105 → 106 taken 764 times.
✓ Branch 107 → 108 taken 764 times.
|
764 | other.addBindValue(self.uid.toLower()); |
| 217 | // S106-155: name-only relations are matched with the same Unicode fold | ||
| 218 | // resolve() uses (SQL lower() folds ASCII only: MÜLLER never met Müller). | ||
| 219 |
1/1✓ Branch 110 → 111 taken 764 times.
|
764 | const QString selfName = ContactIndex::foldForSort(self.name); |
| 220 |
2/3✓ Branch 111 → 112 taken 764 times.
✗ Branch 112 → 113 not taken.
✓ Branch 112 → 126 taken 764 times.
|
764 | if (!other.exec()) |
| 221 | ✗ | qCWarning(lcContactPeople) << "Inverse relations of card" << cardId << "could not be read"; | |
| 222 |
5/5✓ Branch 126 → 127 taken 764 times.
✓ Branch 127 → 128 taken 764 times.
✓ Branch 128 → 129 taken 764 times.
✓ Branch 177 → 130 taken 1077 times.
✓ Branch 177 → 178 taken 764 times.
|
1841 | for (const Stored &stored : storedRows(other)) { |
| 223 |
1/2✗ Branch 132 → 133 not taken.
✓ Branch 132 → 134 taken 1077 times.
|
1077 | if (rows.size() >= limit) |
| 224 | ✗ | break; | |
| 225 |
10/13✓ Branch 135 → 136 taken 642 times.
✓ Branch 135 → 142 taken 435 times.
✓ Branch 137 → 138 taken 642 times.
✗ Branch 137 → 142 not taken.
✓ Branch 138 → 139 taken 642 times.
✓ Branch 140 → 141 taken 631 times.
✓ Branch 140 → 142 taken 11 times.
✓ Branch 143 → 144 taken 642 times.
✓ Branch 143 → 145 taken 435 times.
✓ Branch 145 → 146 taken 631 times.
✓ Branch 145 → 147 taken 446 times.
✗ Branch 282 → 283 not taken.
✗ Branch 282 → 284 not taken.
|
1077 | if (stored.uid.isEmpty() && stored.uri.isEmpty() && ContactIndex::foldForSort(stored.name) != selfName) |
| 226 | 633 | continue; | |
| 227 |
1/1✓ Branch 147 → 148 taken 446 times.
|
446 | const CardInfo holder = info(stored.cardId); |
| 228 |
2/3✓ Branch 148 → 149 taken 446 times.
✗ Branch 149 → 150 not taken.
✓ Branch 149 → 151 taken 446 times.
|
446 | if (resolve(db, holder.bookId, stored.uid, stored.uri, stored.name) != cardId) |
| 229 | ✗ | continue; | |
| 230 | // F103-22: entered on both cards ("A is B's parent" and "B is A's child"), | ||
| 231 | // a relationship shows once — the line on this card. | ||
| 232 |
1/1✓ Branch 151 → 152 taken 446 times.
|
446 | const QString mirrored = RelationVocabulary::inverseOf(stored.type); |
| 233 |
5/5✓ Branch 153 → 154 taken 377 times.
✓ Branch 153 → 159 taken 69 times.
✓ Branch 156 → 157 taken 377 times.
✓ Branch 157 → 158 taken 2 times.
✓ Branch 157 → 159 taken 375 times.
|
446 | const bool duplicate = !mirrored.isEmpty() && std::any_of(rows.cbegin(), rows.cend(), [&](const Row &row) { |
| 234 |
5/6✓ Branch 4 → 5 taken 697 times.
✓ Branch 4 → 10 taken 487 times.
✓ Branch 5 → 6 taken 2 times.
✓ Branch 5 → 10 taken 695 times.
✓ Branch 8 → 9 taken 2 times.
✗ Branch 8 → 10 not taken.
|
1186 | return row.role == QLatin1String("relation") && row.otherCardId == holder.id && |
| 235 |
3/5✓ Branch 6 → 7 taken 2 times.
✓ Branch 11 → 12 taken 2 times.
✓ Branch 11 → 13 taken 1182 times.
✗ Branch 15 → 16 not taken.
✗ Branch 15 → 17 not taken.
|
1186 | RelationVocabulary::canonical(row.type) == mirrored; |
| 236 | 446 | }); | |
| 237 |
2/2✓ Branch 160 → 161 taken 2 times.
✓ Branch 160 → 162 taken 444 times.
|
446 | if (duplicate) |
| 238 | 2 | continue; | |
| 239 |
2/2✓ Branch 162 → 163 taken 444 times.
✓ Branch 163 → 164 taken 444 times.
|
444 | rows.append(rowFor(stored, holder, holder, true)); |
| 240 | 1212 | } | |
| 241 | 764 | return rows; | |
| 242 | 764 | } | |
| 243 | |||
| 244 | 818 | QList<Edge> allEdges(const QSqlDatabase &db, int limit) { | |
| 245 | 818 | QList<Edge> edges; | |
| 246 |
1/1✓ Branch 2 → 3 taken 818 times.
|
818 | QSqlQuery q(db); |
| 247 |
1/1✓ Branch 6 → 7 taken 818 times.
|
818 | q.prepare(QStringLiteral("SELECT r.card_id, r.position, r.role, r.type, r.label, r.target_uid, r.target_uri," |
| 248 | " r.target_name, r.model, c.book_id FROM card_relations r JOIN cards c ON c.id = r.card_id" | ||
| 249 | " ORDER BY r.card_id, r.position LIMIT ?")); | ||
| 250 |
1/1✓ Branch 11 → 12 taken 818 times.
|
818 | q.addBindValue(limit); |
| 251 |
2/3✓ Branch 13 → 14 taken 818 times.
✗ Branch 14 → 15 not taken.
✓ Branch 14 → 16 taken 818 times.
|
818 | if (!q.exec()) |
| 252 | ✗ | return edges; | |
| 253 | struct Pending { | ||
| 254 | Stored stored; | ||
| 255 | qint64 bookId; | ||
| 256 | }; | ||
| 257 | 818 | QList<Pending> pending; | |
| 258 |
3/3✓ Branch 50 → 51 taken 18385 times.
✓ Branch 51 → 17 taken 17567 times.
✓ Branch 51 → 52 taken 818 times.
|
18385 | while (q.next()) |
| 259 |
3/3✓ Branch 17 → 18 taken 17567 times.
✓ Branch 18 → 19 taken 17567 times.
✓ Branch 20 → 21 taken 17567 times.
|
70268 | pending.append({{q.value(0).toLongLong(), q.value(1).toInt(), q.value(2).toString(), q.value(3).toString(), |
| 260 | 17567 | q.value(4).toString(), q.value(5).toString(), q.value(6).toString(), q.value(7).toString(), | |
| 261 | 17567 | q.value(8).toString()}, | |
| 262 |
1/1✓ Branch 36 → 37 taken 17567 times.
|
35134 | q.value(9).toLongLong()}); |
| 263 |
1/1✓ Branch 52 → 53 taken 818 times.
|
818 | q.finish(); |
| 264 |
4/4✓ Branch 53 → 54 taken 818 times.
✓ Branch 54 → 55 taken 818 times.
✓ Branch 66 → 56 taken 17567 times.
✓ Branch 66 → 67 taken 818 times.
|
18385 | for (const Pending &p : pending) { |
| 265 | 17567 | Edge edge; | |
| 266 | 17567 | edge.fromCardId = p.stored.cardId; | |
| 267 |
1/1✓ Branch 57 → 58 taken 17567 times.
|
17567 | edge.toCardId = resolve(db, p.bookId, p.stored.uid, p.stored.uri, p.stored.name); |
| 268 | 17567 | edge.role = p.stored.role; | |
| 269 | 17567 | edge.type = p.stored.type; | |
| 270 | 17567 | edge.label = p.stored.label; | |
| 271 | 17567 | edge.toName = p.stored.name; | |
| 272 | 17567 | edge.sourceIndex = p.stored.position; | |
| 273 |
1/1✓ Branch 62 → 63 taken 17567 times.
|
17567 | edges.append(edge); |
| 274 | 17567 | } | |
| 275 | 818 | return edges; | |
| 276 | 53519 | } | |
| 277 | |||
| 278 | } // namespace RelationIndex | ||
| 279 |