Lines Matching refs:rv

219   nsresult rv = aDBConn->CreateStatement(  in CreateRoot()  local
229 if (NS_FAILED(rv)) return rv; in CreateRoot()
231 rv = stmt->BindInt32ByName("item_type"_ns, in CreateRoot()
233 if (NS_FAILED(rv)) return rv; in CreateRoot()
234 rv = stmt->BindInt32ByName("item_position"_ns, position); in CreateRoot()
235 if (NS_FAILED(rv)) return rv; in CreateRoot()
236 rv = stmt->BindUTF8StringByName("item_title"_ns, titleString); in CreateRoot()
237 if (NS_FAILED(rv)) return rv; in CreateRoot()
238 rv = stmt->BindInt64ByName("date_added"_ns, timestamp); in CreateRoot()
239 if (NS_FAILED(rv)) return rv; in CreateRoot()
240 rv = stmt->BindInt64ByName("last_modified"_ns, timestamp); in CreateRoot()
241 if (NS_FAILED(rv)) return rv; in CreateRoot()
242 rv = stmt->BindUTF8StringByName("guid"_ns, aGuid); in CreateRoot()
243 if (NS_FAILED(rv)) return rv; in CreateRoot()
244 rv = stmt->BindInt32ByName("sync_status"_ns, in CreateRoot()
246 if (NS_FAILED(rv)) return rv; in CreateRoot()
247 rv = stmt->Execute(); in CreateRoot()
248 if (NS_FAILED(rv)) return rv; in CreateRoot()
256 nsresult rv; in SetupDurability() local
262 rv = aDBConn->ExecuteSimpleSQL("PRAGMA synchronous = OFF"_ns); in SetupDurability()
263 NS_ENSURE_SUCCESS(rv, rv); in SetupDurability()
273 rv = aDBConn->ExecuteSimpleSQL(checkpointPragma); in SetupDurability()
274 NS_ENSURE_SUCCESS(rv, rv); in SetupDurability()
283 rv = aDBConn->ExecuteSimpleSQL("PRAGMA synchronous = FULL"_ns); in SetupDurability()
284 NS_ENSURE_SUCCESS(rv, rv); in SetupDurability()
309 nsresult rv = aDBConn->CreateStatement("ATTACH DATABASE :path AS "_ns + aName, in AttachDatabase() local
311 NS_ENSURE_SUCCESS(rv, rv); in AttachDatabase()
312 rv = stmt->BindUTF8StringByName("path"_ns, aPath); in AttachDatabase()
313 NS_ENSURE_SUCCESS(rv, rv); in AttachDatabase()
314 rv = stmt->Execute(); in AttachDatabase()
315 NS_ENSURE_SUCCESS(rv, rv); in AttachDatabase()
370 DebugOnly<nsresult> rv = in GetProfileChangeTeardownPhase() local
372 MOZ_ASSERT(NS_SUCCEEDED(rv)); in GetProfileChangeTeardownPhase()
387 DebugOnly<nsresult> rv = in GetProfileBeforeChangePhase() local
389 MOZ_ASSERT(NS_SUCCEEDED(rv)); in GetProfileBeforeChangePhase()
452 DebugOnly<nsresult> rv = shutdownPhase->AddBlocker( in Init() local
455 MOZ_ASSERT(NS_SUCCEEDED(rv)); in Init()
465 DebugOnly<nsresult> rv = shutdownPhase->AddBlocker( in Init() local
468 MOZ_ASSERT(NS_SUCCEEDED(rv)); in Init()
514 nsresult rv = NS_GetSpecialDirectory(NS_APP_USER_PROFILE_50_DIR, in EnsureConnection() local
516 NS_ENSURE_SUCCESS(rv, rv); in EnsureConnection()
519 rv = profileDir->Clone(getter_AddRefs(databaseFile)); in EnsureConnection()
520 NS_ENSURE_SUCCESS(rv, rv); in EnsureConnection()
521 rv = databaseFile->Append(DATABASE_FILENAME); in EnsureConnection()
522 NS_ENSURE_SUCCESS(rv, rv); in EnsureConnection()
524 rv = databaseFile->Exists(&databaseExisted); in EnsureConnection()
525 NS_ENSURE_SUCCESS(rv, rv); in EnsureConnection()
541 rv = BackupAndReplaceDatabaseFile(storage, corruptDbName, true, false); in EnsureConnection()
542 NS_ENSURE_SUCCESS(rv, rv); in EnsureConnection()
549 rv = storage->OpenUnsharedDatabase(databaseFile, getter_AddRefs(mMainConn)); in EnsureConnection()
550 if (NS_SUCCEEDED(rv) && !databaseExisted) { in EnsureConnection()
552 } else if (rv == NS_ERROR_FILE_CORRUPTED) { in EnsureConnection()
554 rv = BackupAndReplaceDatabaseFile(storage, DATABASE_FILENAME, true, true); in EnsureConnection()
557 NS_ENSURE_SUCCESS(rv, rv); in EnsureConnection()
562 rv = SetupDatabaseConnection(storage); in EnsureConnection()
564 if (NS_SUCCEEDED(rv)) { in EnsureConnection()
566 rv = InitSchema(&databaseMigrated); in EnsureConnection()
567 if (NS_FAILED(rv)) { in EnsureConnection()
571 if (rv == NS_ERROR_STORAGE_BUSY || rv == NS_ERROR_FILE_IS_LOCKED || in EnsureConnection()
572 rv == NS_ERROR_FILE_NO_DEVICE_SPACE || in EnsureConnection()
573 rv == NS_ERROR_OUT_OF_MEMORY) { in EnsureConnection()
579 rv = InitSchema(&databaseMigrated); in EnsureConnection()
580 if (NS_FAILED(rv)) { in EnsureConnection()
581 rv = NS_ERROR_FILE_IS_LOCKED; in EnsureConnection()
584 rv = NS_ERROR_FILE_CORRUPTED; in EnsureConnection()
588 if (NS_WARN_IF(NS_FAILED(rv))) { in EnsureConnection()
589 if (rv != NS_ERROR_FILE_IS_LOCKED) { in EnsureConnection()
594 if (rv == NS_ERROR_FILE_CORRUPTED) { in EnsureConnection()
596 rv = BackupAndReplaceDatabaseFile(storage, DATABASE_FAVICONS_FILENAME, in EnsureConnection()
598 NS_ENSURE_SUCCESS(rv, rv); in EnsureConnection()
599 rv = BackupAndReplaceDatabaseFile(storage, DATABASE_FILENAME, in EnsureConnection()
601 NS_ENSURE_SUCCESS(rv, rv); in EnsureConnection()
603 rv = SetupDatabaseConnection(storage); in EnsureConnection()
604 NS_ENSURE_SUCCESS(rv, rv); in EnsureConnection()
605 rv = InitSchema(&databaseMigrated); in EnsureConnection()
608 NS_ENSURE_SUCCESS(rv, rv); in EnsureConnection()
619 rv = InitTempEntities(); in EnsureConnection()
620 NS_ENSURE_SUCCESS(rv, rv); in EnsureConnection()
622 rv = CheckRoots(); in EnsureConnection()
623 NS_ENSURE_SUCCESS(rv, rv); in EnsureConnection()
655 nsresult rv = databaseFile->Append(DATABASE_FAVICONS_FILENAME); in EnsureFaviconsDatabaseAttached() local
656 NS_ENSURE_SUCCESS(rv, rv); in EnsureFaviconsDatabaseAttached()
658 rv = databaseFile->GetPath(iconsPath); in EnsureFaviconsDatabaseAttached()
659 NS_ENSURE_SUCCESS(rv, rv); in EnsureFaviconsDatabaseAttached()
669 rv = aStorage->OpenUnsharedDatabase(databaseFile, getter_AddRefs(conn)); in EnsureFaviconsDatabaseAttached()
670 NS_ENSURE_SUCCESS(rv, rv); in EnsureFaviconsDatabaseAttached()
684 rv = conn->ExecuteSimpleSQL("PRAGMA auto_vacuum = INCREMENTAL"_ns); in EnsureFaviconsDatabaseAttached()
685 NS_ENSURE_SUCCESS(rv, rv); in EnsureFaviconsDatabaseAttached()
690 rv = conn->ExecuteSimpleSQL("PRAGMA temp_store = MEMORY"_ns); in EnsureFaviconsDatabaseAttached()
691 NS_ENSURE_SUCCESS(rv, rv); in EnsureFaviconsDatabaseAttached()
695 rv = conn->GetDefaultPageSize(&defaultPageSize); in EnsureFaviconsDatabaseAttached()
696 NS_ENSURE_SUCCESS(rv, rv); in EnsureFaviconsDatabaseAttached()
697 rv = SetupDurability(conn, defaultPageSize); in EnsureFaviconsDatabaseAttached()
698 NS_ENSURE_SUCCESS(rv, rv); in EnsureFaviconsDatabaseAttached()
705 rv = conn->ExecuteSimpleSQL(CREATE_MOZ_ICONS); in EnsureFaviconsDatabaseAttached()
706 NS_ENSURE_SUCCESS(rv, rv); in EnsureFaviconsDatabaseAttached()
707 rv = conn->ExecuteSimpleSQL(CREATE_IDX_MOZ_ICONS_ICONURLHASH); in EnsureFaviconsDatabaseAttached()
708 NS_ENSURE_SUCCESS(rv, rv); in EnsureFaviconsDatabaseAttached()
709 rv = conn->ExecuteSimpleSQL(CREATE_MOZ_PAGES_W_ICONS); in EnsureFaviconsDatabaseAttached()
710 NS_ENSURE_SUCCESS(rv, rv); in EnsureFaviconsDatabaseAttached()
711 rv = conn->ExecuteSimpleSQL(CREATE_IDX_MOZ_PAGES_W_ICONS_ICONURLHASH); in EnsureFaviconsDatabaseAttached()
712 NS_ENSURE_SUCCESS(rv, rv); in EnsureFaviconsDatabaseAttached()
713 rv = conn->ExecuteSimpleSQL(CREATE_MOZ_ICONS_TO_PAGES); in EnsureFaviconsDatabaseAttached()
714 NS_ENSURE_SUCCESS(rv, rv); in EnsureFaviconsDatabaseAttached()
715 rv = transaction.Commit(); in EnsureFaviconsDatabaseAttached()
716 NS_ENSURE_SUCCESS(rv, rv); in EnsureFaviconsDatabaseAttached()
721 rv = AttachDatabase(mMainConn, NS_ConvertUTF16toUTF8(iconsPath), in EnsureFaviconsDatabaseAttached()
723 NS_ENSURE_SUCCESS(rv, rv); in EnsureFaviconsDatabaseAttached()
742 nsresult rv = NS_GetSpecialDirectory(NS_APP_USER_PROFILE_50_DIR, in BackupAndReplaceDatabaseFile() local
744 NS_ENSURE_SUCCESS(rv, rv); in BackupAndReplaceDatabaseFile()
746 rv = profDir->Clone(getter_AddRefs(databaseFile)); in BackupAndReplaceDatabaseFile()
747 NS_ENSURE_SUCCESS(rv, rv); in BackupAndReplaceDatabaseFile()
748 rv = databaseFile->Append(aDbFilename); in BackupAndReplaceDatabaseFile()
749 NS_ENSURE_SUCCESS(rv, rv); in BackupAndReplaceDatabaseFile()
756 rv = profDir->Clone(getter_AddRefs(corruptFile)); in BackupAndReplaceDatabaseFile()
757 NS_ENSURE_SUCCESS(rv, rv); in BackupAndReplaceDatabaseFile()
759 rv = corruptFile->Append(corruptFilename); in BackupAndReplaceDatabaseFile()
760 NS_ENSURE_SUCCESS(rv, rv); in BackupAndReplaceDatabaseFile()
764 rv = profDir->Clone(getter_AddRefs(corruptFile)); in BackupAndReplaceDatabaseFile()
765 NS_ENSURE_SUCCESS(rv, rv); in BackupAndReplaceDatabaseFile()
767 rv = corruptFile->Append(corruptFilename); in BackupAndReplaceDatabaseFile()
768 NS_ENSURE_SUCCESS(rv, rv); in BackupAndReplaceDatabaseFile()
769 rv = corruptFile->Remove(false); in BackupAndReplaceDatabaseFile()
770 if (NS_FAILED(rv) && rv != NS_ERROR_FILE_TARGET_DOES_NOT_EXIST && in BackupAndReplaceDatabaseFile()
771 rv != NS_ERROR_FILE_NOT_FOUND) { in BackupAndReplaceDatabaseFile()
772 return rv; in BackupAndReplaceDatabaseFile()
811 rv = mMainConn->SpinningSynchronousClose(); in BackupAndReplaceDatabaseFile()
812 NS_ENSURE_SUCCESS(rv, rv); in BackupAndReplaceDatabaseFile()
818 rv = databaseFile->Remove(false); in BackupAndReplaceDatabaseFile()
819 if (NS_FAILED(rv) && rv != NS_ERROR_FILE_TARGET_DOES_NOT_EXIST && in BackupAndReplaceDatabaseFile()
820 rv != NS_ERROR_FILE_NOT_FOUND) { in BackupAndReplaceDatabaseFile()
821 return rv; in BackupAndReplaceDatabaseFile()
829 rv = TryToCloneTablesFromCorruptDatabase(aStorage, databaseFile); in BackupAndReplaceDatabaseFile()
830 if (NS_SUCCEEDED(rv)) { in BackupAndReplaceDatabaseFile()
842 rv = aStorage->OpenUnsharedDatabase(databaseFile, in BackupAndReplaceDatabaseFile()
844 NS_ENSURE_SUCCESS(rv, rv); in BackupAndReplaceDatabaseFile()
859 nsresult rv = aDatabaseFile->GetLeafName(filename); in TryToCloneTablesFromCorruptDatabase() local
862 rv = aDatabaseFile->Clone(getter_AddRefs(corruptFile)); in TryToCloneTablesFromCorruptDatabase()
863 NS_ENSURE_SUCCESS(rv, rv); in TryToCloneTablesFromCorruptDatabase()
864 rv = corruptFile->SetLeafName(getCorruptFilename(filename)); in TryToCloneTablesFromCorruptDatabase()
865 NS_ENSURE_SUCCESS(rv, rv); in TryToCloneTablesFromCorruptDatabase()
867 rv = corruptFile->GetPath(path); in TryToCloneTablesFromCorruptDatabase()
868 NS_ENSURE_SUCCESS(rv, rv); in TryToCloneTablesFromCorruptDatabase()
871 rv = aDatabaseFile->Clone(getter_AddRefs(recoverFile)); in TryToCloneTablesFromCorruptDatabase()
872 NS_ENSURE_SUCCESS(rv, rv); in TryToCloneTablesFromCorruptDatabase()
873 rv = recoverFile->SetLeafName(getRecoverFilename(filename)); in TryToCloneTablesFromCorruptDatabase()
874 NS_ENSURE_SUCCESS(rv, rv); in TryToCloneTablesFromCorruptDatabase()
876 rv = recoverFile->Remove(false); in TryToCloneTablesFromCorruptDatabase()
877 if (NS_FAILED(rv) && rv != NS_ERROR_FILE_TARGET_DOES_NOT_EXIST && in TryToCloneTablesFromCorruptDatabase()
878 rv != NS_ERROR_FILE_NOT_FOUND) { in TryToCloneTablesFromCorruptDatabase()
879 return rv; in TryToCloneTablesFromCorruptDatabase()
890 rv = aStorage->OpenUnsharedDatabase(recoverFile, getter_AddRefs(conn)); in TryToCloneTablesFromCorruptDatabase()
891 NS_ENSURE_SUCCESS(rv, rv); in TryToCloneTablesFromCorruptDatabase()
892 rv = AttachDatabase(conn, NS_ConvertUTF16toUTF8(path), "corrupt"_ns); in TryToCloneTablesFromCorruptDatabase()
893 NS_ENSURE_SUCCESS(rv, rv); in TryToCloneTablesFromCorruptDatabase()
906 rv = stmt->ExecuteStep(&hasResult); in TryToCloneTablesFromCorruptDatabase()
907 NS_ENSURE_SUCCESS(rv, rv); in TryToCloneTablesFromCorruptDatabase()
909 rv = conn->SetSchemaVersion(schemaVersion); in TryToCloneTablesFromCorruptDatabase()
910 NS_ENSURE_SUCCESS(rv, rv); in TryToCloneTablesFromCorruptDatabase()
913 rv = conn->CreateStatement( in TryToCloneTablesFromCorruptDatabase()
918 NS_ENSURE_SUCCESS(rv, rv); in TryToCloneTablesFromCorruptDatabase()
921 rv = stmt->GetUTF8String(0, name); in TryToCloneTablesFromCorruptDatabase()
922 NS_ENSURE_SUCCESS(rv, rv); in TryToCloneTablesFromCorruptDatabase()
924 rv = stmt->GetUTF8String(1, query); in TryToCloneTablesFromCorruptDatabase()
925 NS_ENSURE_SUCCESS(rv, rv); in TryToCloneTablesFromCorruptDatabase()
926 rv = conn->ExecuteSimpleSQL(query); in TryToCloneTablesFromCorruptDatabase()
927 NS_ENSURE_SUCCESS(rv, rv); in TryToCloneTablesFromCorruptDatabase()
929 rv = conn->ExecuteSimpleSQL("INSERT INTO main."_ns + name + in TryToCloneTablesFromCorruptDatabase()
931 if (NS_FAILED(rv)) { in TryToCloneTablesFromCorruptDatabase()
932 rv = conn->ExecuteSimpleSQL("INSERT INTO main."_ns + name + in TryToCloneTablesFromCorruptDatabase()
936 NS_ENSURE_SUCCESS(rv, rv); in TryToCloneTablesFromCorruptDatabase()
940 rv = conn->CreateStatement( in TryToCloneTablesFromCorruptDatabase()
945 NS_ENSURE_SUCCESS(rv, rv); in TryToCloneTablesFromCorruptDatabase()
949 rv = stmt->GetUTF8String(0, query); in TryToCloneTablesFromCorruptDatabase()
950 NS_ENSURE_SUCCESS(rv, rv); in TryToCloneTablesFromCorruptDatabase()
951 rv = conn->ExecuteSimpleSQL(query); in TryToCloneTablesFromCorruptDatabase()
952 NS_ENSURE_SUCCESS(rv, rv); in TryToCloneTablesFromCorruptDatabase()
954 rv = stmt->Finalize(); in TryToCloneTablesFromCorruptDatabase()
955 NS_ENSURE_SUCCESS(rv, rv); in TryToCloneTablesFromCorruptDatabase()
957 rv = transaction.Commit(); in TryToCloneTablesFromCorruptDatabase()
958 NS_ENSURE_SUCCESS(rv, rv); in TryToCloneTablesFromCorruptDatabase()
962 rv = recoverFile->RenameTo(nullptr, filename); in TryToCloneTablesFromCorruptDatabase()
963 NS_ENSURE_SUCCESS(rv, rv); in TryToCloneTablesFromCorruptDatabase()
977 nsresult rv = mMainConn->SetDefaultTransactionType( in SetupDatabaseConnection() local
979 NS_ENSURE_SUCCESS(rv, rv); in SetupDatabaseConnection()
989 rv = mMainConn->CreateStatement( in SetupDatabaseConnection()
992 NS_ENSURE_SUCCESS(rv, rv); in SetupDatabaseConnection()
994 rv = statement->ExecuteStep(&hasResult); in SetupDatabaseConnection()
995 NS_ENSURE_TRUE(NS_SUCCEEDED(rv) && hasResult, NS_ERROR_FILE_CORRUPTED); in SetupDatabaseConnection()
996 rv = statement->GetInt32(0, &mDBPageSize); in SetupDatabaseConnection()
997 NS_ENSURE_TRUE(NS_SUCCEEDED(rv) && mDBPageSize > 0, in SetupDatabaseConnection()
1004 rv = mMainConn->ExecuteSimpleSQL(nsLiteralCString( in SetupDatabaseConnection()
1006 NS_ENSURE_SUCCESS(rv, rv); in SetupDatabaseConnection()
1009 rv = SetupDurability(mMainConn, mDBPageSize); in SetupDatabaseConnection()
1010 NS_ENSURE_SUCCESS(rv, rv); in SetupDatabaseConnection()
1017 rv = mMainConn->ExecuteSimpleSQL(nsLiteralCString( in SetupDatabaseConnection()
1019 NS_ENSURE_SUCCESS(rv, NS_ERROR_FILE_CORRUPTED); in SetupDatabaseConnection()
1037 rv = EnsureFaviconsDatabaseAttached(aStorage); in SetupDatabaseConnection()
1038 if (NS_FAILED(rv)) { in SetupDatabaseConnection()
1041 rv = NS_GetSpecialDirectory(NS_APP_USER_PROFILE_50_DIR, in SetupDatabaseConnection()
1043 NS_ENSURE_SUCCESS(rv, rv); in SetupDatabaseConnection()
1044 rv = iconsFile->Append(DATABASE_FAVICONS_FILENAME); in SetupDatabaseConnection()
1045 NS_ENSURE_SUCCESS(rv, rv); in SetupDatabaseConnection()
1046 rv = iconsFile->Remove(false); in SetupDatabaseConnection()
1047 if (NS_FAILED(rv) && rv != NS_ERROR_FILE_TARGET_DOES_NOT_EXIST && in SetupDatabaseConnection()
1048 rv != NS_ERROR_FILE_NOT_FOUND) { in SetupDatabaseConnection()
1049 return rv; in SetupDatabaseConnection()
1051 rv = EnsureFaviconsDatabaseAttached(aStorage); in SetupDatabaseConnection()
1052 NS_ENSURE_SUCCESS(rv, rv); in SetupDatabaseConnection()
1056 rv = mMainConn->ExecuteSimpleSQL(CREATE_ICONS_AFTERINSERT_TRIGGER); in SetupDatabaseConnection()
1057 NS_ENSURE_SUCCESS(rv, rv); in SetupDatabaseConnection()
1060 rv = InitFunctions(); in SetupDatabaseConnection()
1061 NS_ENSURE_SUCCESS(rv, rv); in SetupDatabaseConnection()
1072 nsresult rv = mMainConn->GetSchemaVersion(&currentSchemaVersion); in InitSchema() local
1073 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1118 rv = MigrateV44Up(); in InitSchema()
1119 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1123 rv = MigrateV45Up(); in InitSchema()
1124 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1128 rv = MigrateV46Up(); in InitSchema()
1129 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1133 rv = MigrateV47Up(); in InitSchema()
1134 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1140 rv = MigrateV48Up(); in InitSchema()
1141 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1145 rv = MigrateV49Up(); in InitSchema()
1146 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1150 rv = MigrateV50Up(); in InitSchema()
1151 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1155 rv = MigrateV51Up(); in InitSchema()
1156 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1160 rv = MigrateV52Up(); in InitSchema()
1161 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1168 rv = MigrateV53Up(); in InitSchema()
1169 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1176 rv = MigrateV54Up(); in InitSchema()
1177 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1183 rv = MigrateV55Up(); in InitSchema()
1184 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1188 rv = MigrateV56Up(); in InitSchema()
1189 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1193 rv = MigrateV57Up(); in InitSchema()
1194 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1210 rv = mMainConn->ExecuteSimpleSQL(CREATE_MOZ_ORIGINS); in InitSchema()
1211 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1214 rv = mMainConn->ExecuteSimpleSQL(CREATE_MOZ_PLACES); in InitSchema()
1215 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1216 rv = mMainConn->ExecuteSimpleSQL(CREATE_IDX_MOZ_PLACES_URL_HASH); in InitSchema()
1217 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1218 rv = mMainConn->ExecuteSimpleSQL(CREATE_IDX_MOZ_PLACES_REVHOST); in InitSchema()
1219 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1220 rv = mMainConn->ExecuteSimpleSQL(CREATE_IDX_MOZ_PLACES_VISITCOUNT); in InitSchema()
1221 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1222 rv = mMainConn->ExecuteSimpleSQL(CREATE_IDX_MOZ_PLACES_FRECENCY); in InitSchema()
1223 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1224 rv = mMainConn->ExecuteSimpleSQL(CREATE_IDX_MOZ_PLACES_LASTVISITDATE); in InitSchema()
1225 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1226 rv = mMainConn->ExecuteSimpleSQL(CREATE_IDX_MOZ_PLACES_GUID); in InitSchema()
1227 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1228 rv = mMainConn->ExecuteSimpleSQL(CREATE_IDX_MOZ_PLACES_ORIGIN_ID); in InitSchema()
1229 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1232 rv = mMainConn->ExecuteSimpleSQL(CREATE_MOZ_HISTORYVISITS); in InitSchema()
1233 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1234 rv = mMainConn->ExecuteSimpleSQL(CREATE_IDX_MOZ_HISTORYVISITS_PLACEDATE); in InitSchema()
1235 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1236 rv = mMainConn->ExecuteSimpleSQL(CREATE_IDX_MOZ_HISTORYVISITS_FROMVISIT); in InitSchema()
1237 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1238 rv = mMainConn->ExecuteSimpleSQL(CREATE_IDX_MOZ_HISTORYVISITS_VISITDATE); in InitSchema()
1239 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1242 rv = mMainConn->ExecuteSimpleSQL(CREATE_MOZ_INPUTHISTORY); in InitSchema()
1243 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1246 rv = mMainConn->ExecuteSimpleSQL(CREATE_MOZ_BOOKMARKS); in InitSchema()
1247 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1248 rv = mMainConn->ExecuteSimpleSQL(CREATE_MOZ_BOOKMARKS_DELETED); in InitSchema()
1249 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1250 rv = mMainConn->ExecuteSimpleSQL(CREATE_IDX_MOZ_BOOKMARKS_PLACETYPE); in InitSchema()
1251 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1252 rv = mMainConn->ExecuteSimpleSQL(CREATE_IDX_MOZ_BOOKMARKS_PARENTPOSITION); in InitSchema()
1253 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1254 rv = in InitSchema()
1256 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1257 rv = mMainConn->ExecuteSimpleSQL(CREATE_IDX_MOZ_BOOKMARKS_DATEADDED); in InitSchema()
1258 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1259 rv = mMainConn->ExecuteSimpleSQL(CREATE_IDX_MOZ_BOOKMARKS_GUID); in InitSchema()
1260 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1263 rv = mMainConn->ExecuteSimpleSQL(CREATE_MOZ_KEYWORDS); in InitSchema()
1264 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1265 rv = mMainConn->ExecuteSimpleSQL(CREATE_IDX_MOZ_KEYWORDS_PLACEPOSTDATA); in InitSchema()
1266 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1269 rv = mMainConn->ExecuteSimpleSQL(CREATE_MOZ_ANNO_ATTRIBUTES); in InitSchema()
1270 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1273 rv = mMainConn->ExecuteSimpleSQL(CREATE_MOZ_ANNOS); in InitSchema()
1274 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1275 rv = mMainConn->ExecuteSimpleSQL(CREATE_IDX_MOZ_ANNOS_PLACEATTRIBUTE); in InitSchema()
1276 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1279 rv = mMainConn->ExecuteSimpleSQL(CREATE_MOZ_ITEMS_ANNOS); in InitSchema()
1280 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1281 rv = mMainConn->ExecuteSimpleSQL(CREATE_IDX_MOZ_ITEMSANNOS_PLACEATTRIBUTE); in InitSchema()
1282 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1285 rv = mMainConn->ExecuteSimpleSQL(CREATE_MOZ_META); in InitSchema()
1286 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1289 rv = mMainConn->ExecuteSimpleSQL(CREATE_MOZ_PLACES_METADATA); in InitSchema()
1290 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1291 rv = mMainConn->ExecuteSimpleSQL( in InitSchema()
1293 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1296 rv = mMainConn->ExecuteSimpleSQL(CREATE_MOZ_PLACES_METADATA_SEARCH_QUERIES); in InitSchema()
1297 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1303 rv = mMainConn->SetSchemaVersion(DATABASE_SCHEMA_VERSION); in InitSchema()
1304 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1306 rv = transaction.Commit(); in InitSchema()
1307 NS_ENSURE_SUCCESS(rv, rv); in InitSchema()
1327 nsresult rv = mMainConn->CreateStatement( in CheckRoots() local
1335 NS_ENSURE_SUCCESS(rv, rv); in CheckRoots()
1342 rv = stmt->GetUTF8String(0, guid); in CheckRoots()
1343 NS_ENSURE_SUCCESS(rv, rv); in CheckRoots()
1368 rv = EnsureBookmarkRoots(maxPosition + 1, shouldReparentRoots); in CheckRoots()
1369 NS_ENSURE_SUCCESS(rv, rv); in CheckRoots()
1378 nsresult rv; in EnsureBookmarkRoots() local
1382 rv = CreateRoot(mMainConn, "places"_ns, "root________"_ns, ""_ns, 0, in EnsureBookmarkRoots()
1385 if (NS_FAILED(rv)) return rv; in EnsureBookmarkRoots()
1393 rv = CreateRoot(mMainConn, "menu"_ns, "menu________"_ns, "menu"_ns, in EnsureBookmarkRoots()
1395 if (NS_FAILED(rv)) return rv; in EnsureBookmarkRoots()
1400 rv = CreateRoot(mMainConn, "toolbar"_ns, "toolbar_____"_ns, "toolbar"_ns, in EnsureBookmarkRoots()
1402 if (NS_FAILED(rv)) return rv; in EnsureBookmarkRoots()
1407 rv = CreateRoot(mMainConn, "tags"_ns, "tags________"_ns, "tags"_ns, in EnsureBookmarkRoots()
1409 if (NS_FAILED(rv)) return rv; in EnsureBookmarkRoots()
1414 rv = CreateRoot(mMainConn, "unfiled"_ns, "unfiled_____"_ns, "unfiled"_ns, in EnsureBookmarkRoots()
1416 if (NS_FAILED(rv)) return rv; in EnsureBookmarkRoots()
1425 rv = mMainConn->CreateStatement( in EnsureBookmarkRoots()
1429 if (NS_FAILED(rv)) return rv; in EnsureBookmarkRoots()
1431 rv = mobileRootSyncStatusStmt->BindInt32ByName( in EnsureBookmarkRoots()
1433 if (NS_FAILED(rv)) return rv; in EnsureBookmarkRoots()
1434 rv = mobileRootSyncStatusStmt->BindInt64ByName("id"_ns, mobileRootId); in EnsureBookmarkRoots()
1435 if (NS_FAILED(rv)) return rv; in EnsureBookmarkRoots()
1437 rv = mobileRootSyncStatusStmt->Execute(); in EnsureBookmarkRoots()
1438 if (NS_FAILED(rv)) return rv; in EnsureBookmarkRoots()
1451 rv = mMainConn->ExecuteSimpleSQL(nsLiteralCString( in EnsureBookmarkRoots()
1472 if (NS_FAILED(rv)) return rv; in EnsureBookmarkRoots()
1479 rv = mMainConn->CreateStatement( in EnsureBookmarkRoots()
1487 if (NS_FAILED(rv)) return rv; in EnsureBookmarkRoots()
1489 rv = reparentStmt->BindInt64ByName("root_id"_ns, mRootId); in EnsureBookmarkRoots()
1490 if (NS_FAILED(rv)) return rv; in EnsureBookmarkRoots()
1491 rv = reparentStmt->BindInt64ByName("menu_root_id"_ns, mMenuRootId); in EnsureBookmarkRoots()
1492 if (NS_FAILED(rv)) return rv; in EnsureBookmarkRoots()
1493 rv = reparentStmt->BindInt64ByName("toolbar_root_id"_ns, mToolbarRootId); in EnsureBookmarkRoots()
1494 if (NS_FAILED(rv)) return rv; in EnsureBookmarkRoots()
1495 rv = reparentStmt->BindInt64ByName("tags_root_id"_ns, mTagsRootId); in EnsureBookmarkRoots()
1496 if (NS_FAILED(rv)) return rv; in EnsureBookmarkRoots()
1497 rv = reparentStmt->BindInt64ByName("unfiled_root_id"_ns, mUnfiledRootId); in EnsureBookmarkRoots()
1498 if (NS_FAILED(rv)) return rv; in EnsureBookmarkRoots()
1499 rv = reparentStmt->BindInt64ByName("mobile_root_id"_ns, mMobileRootId); in EnsureBookmarkRoots()
1500 if (NS_FAILED(rv)) return rv; in EnsureBookmarkRoots()
1502 rv = reparentStmt->Execute(); in EnsureBookmarkRoots()
1503 if (NS_FAILED(rv)) return rv; in EnsureBookmarkRoots()
1511 nsresult rv = GetUnreversedHostFunction::create(mMainConn); in InitFunctions() local
1512 NS_ENSURE_SUCCESS(rv, rv); in InitFunctions()
1513 rv = MatchAutoCompleteFunction::create(mMainConn); in InitFunctions()
1514 NS_ENSURE_SUCCESS(rv, rv); in InitFunctions()
1515 rv = CalculateFrecencyFunction::create(mMainConn); in InitFunctions()
1516 NS_ENSURE_SUCCESS(rv, rv); in InitFunctions()
1517 rv = GenerateGUIDFunction::create(mMainConn); in InitFunctions()
1518 NS_ENSURE_SUCCESS(rv, rv); in InitFunctions()
1519 rv = IsValidGUIDFunction::create(mMainConn); in InitFunctions()
1520 NS_ENSURE_SUCCESS(rv, rv); in InitFunctions()
1521 rv = FixupURLFunction::create(mMainConn); in InitFunctions()
1522 NS_ENSURE_SUCCESS(rv, rv); in InitFunctions()
1523 rv = StoreLastInsertedIdFunction::create(mMainConn); in InitFunctions()
1524 NS_ENSURE_SUCCESS(rv, rv); in InitFunctions()
1525 rv = HashFunction::create(mMainConn); in InitFunctions()
1526 NS_ENSURE_SUCCESS(rv, rv); in InitFunctions()
1527 rv = GetQueryParamFunction::create(mMainConn); in InitFunctions()
1528 NS_ENSURE_SUCCESS(rv, rv); in InitFunctions()
1529 rv = GetPrefixFunction::create(mMainConn); in InitFunctions()
1530 NS_ENSURE_SUCCESS(rv, rv); in InitFunctions()
1531 rv = GetHostAndPortFunction::create(mMainConn); in InitFunctions()
1532 NS_ENSURE_SUCCESS(rv, rv); in InitFunctions()
1533 rv = StripPrefixAndUserinfoFunction::create(mMainConn); in InitFunctions()
1534 NS_ENSURE_SUCCESS(rv, rv); in InitFunctions()
1535 rv = IsFrecencyDecayingFunction::create(mMainConn); in InitFunctions()
1536 NS_ENSURE_SUCCESS(rv, rv); in InitFunctions()
1537 rv = NoteSyncChangeFunction::create(mMainConn); in InitFunctions()
1538 NS_ENSURE_SUCCESS(rv, rv); in InitFunctions()
1539 rv = InvalidateDaysOfHistoryFunction::create(mMainConn); in InitFunctions()
1540 NS_ENSURE_SUCCESS(rv, rv); in InitFunctions()
1548 nsresult rv = in InitTempEntities() local
1550 NS_ENSURE_SUCCESS(rv, rv); in InitTempEntities()
1551 rv = mMainConn->ExecuteSimpleSQL(CREATE_HISTORYVISITS_AFTERDELETE_TRIGGER); in InitTempEntities()
1552 NS_ENSURE_SUCCESS(rv, rv); in InitTempEntities()
1555 rv = mMainConn->ExecuteSimpleSQL(CREATE_UPDATEORIGINSINSERT_TEMP); in InitTempEntities()
1556 NS_ENSURE_SUCCESS(rv, rv); in InitTempEntities()
1557 rv = mMainConn->ExecuteSimpleSQL( in InitTempEntities()
1559 NS_ENSURE_SUCCESS(rv, rv); in InitTempEntities()
1560 rv = mMainConn->ExecuteSimpleSQL(CREATE_PLACES_AFTERINSERT_TRIGGER); in InitTempEntities()
1561 NS_ENSURE_SUCCESS(rv, rv); in InitTempEntities()
1562 rv = mMainConn->ExecuteSimpleSQL(CREATE_UPDATEORIGINSDELETE_TEMP); in InitTempEntities()
1563 NS_ENSURE_SUCCESS(rv, rv); in InitTempEntities()
1564 rv = mMainConn->ExecuteSimpleSQL( in InitTempEntities()
1566 NS_ENSURE_SUCCESS(rv, rv); in InitTempEntities()
1567 rv = mMainConn->ExecuteSimpleSQL(CREATE_PLACES_AFTERDELETE_TRIGGER); in InitTempEntities()
1568 NS_ENSURE_SUCCESS(rv, rv); in InitTempEntities()
1569 rv = mMainConn->ExecuteSimpleSQL(CREATE_UPDATEORIGINSUPDATE_TEMP); in InitTempEntities()
1570 NS_ENSURE_SUCCESS(rv, rv); in InitTempEntities()
1571 rv = mMainConn->ExecuteSimpleSQL( in InitTempEntities()
1573 NS_ENSURE_SUCCESS(rv, rv); in InitTempEntities()
1574 rv = mMainConn->ExecuteSimpleSQL(CREATE_PLACES_AFTERUPDATE_FRECENCY_TRIGGER); in InitTempEntities()
1575 NS_ENSURE_SUCCESS(rv, rv); in InitTempEntities()
1577 rv = mMainConn->ExecuteSimpleSQL( in InitTempEntities()
1579 NS_ENSURE_SUCCESS(rv, rv); in InitTempEntities()
1580 rv = mMainConn->ExecuteSimpleSQL( in InitTempEntities()
1582 NS_ENSURE_SUCCESS(rv, rv); in InitTempEntities()
1583 rv = mMainConn->ExecuteSimpleSQL( in InitTempEntities()
1585 NS_ENSURE_SUCCESS(rv, rv); in InitTempEntities()
1587 rv = mMainConn->ExecuteSimpleSQL( in InitTempEntities()
1589 NS_ENSURE_SUCCESS(rv, rv); in InitTempEntities()
1590 rv = mMainConn->ExecuteSimpleSQL( in InitTempEntities()
1592 NS_ENSURE_SUCCESS(rv, rv); in InitTempEntities()
1593 rv = mMainConn->ExecuteSimpleSQL( in InitTempEntities()
1595 NS_ENSURE_SUCCESS(rv, rv); in InitTempEntities()
1596 rv = in InitTempEntities()
1598 NS_ENSURE_SUCCESS(rv, rv); in InitTempEntities()
1599 rv = in InitTempEntities()
1601 NS_ENSURE_SUCCESS(rv, rv); in InitTempEntities()
1603 rv = mMainConn->ExecuteSimpleSQL( in InitTempEntities()
1605 NS_ENSURE_SUCCESS(rv, rv); in InitTempEntities()
1615 nsresult rv = mMainConn->ExecuteSimpleSQL(nsLiteralCString( in MigrateV44Up() local
1630 if (NS_FAILED(rv)) return rv; in MigrateV44Up()
1634 rv = mMainConn->ExecuteSimpleSQL(nsLiteralCString( in MigrateV44Up()
1654 if (NS_FAILED(rv)) return rv; in MigrateV44Up()
1658 rv = mMainConn->ExecuteSimpleSQL( in MigrateV44Up()
1667 if (NS_FAILED(rv)) return rv; in MigrateV44Up()
1671 rv = mMainConn->CreateStatement( in MigrateV44Up()
1688 if (NS_FAILED(rv)) return rv; in MigrateV44Up()
1690 rv = deleteStmt->Execute(); in MigrateV44Up()
1691 if (NS_FAILED(rv)) return rv; in MigrateV44Up()
1697 rv = mMainConn->ExecuteSimpleSQL( in MigrateV44Up()
1703 if (NS_FAILED(rv)) return rv; in MigrateV44Up()
1706 rv = mMainConn->ExecuteSimpleSQL( in MigrateV44Up()
1708 if (NS_FAILED(rv)) return rv; in MigrateV44Up()
1709 rv = in MigrateV44Up()
1711 if (NS_FAILED(rv)) return rv; in MigrateV44Up()
1712 rv = mMainConn->ExecuteSimpleSQL( in MigrateV44Up()
1714 if (NS_FAILED(rv)) return rv; in MigrateV44Up()
1717 rv = mMainConn->ExecuteSimpleSQL( in MigrateV44Up()
1725 if (NS_FAILED(rv)) return rv; in MigrateV44Up()
1732 nsresult rv = mMainConn->CreateStatement("SELECT 1 FROM moz_meta"_ns, in MigrateV45Up() local
1734 if (NS_FAILED(rv)) { in MigrateV45Up()
1735 rv = mMainConn->ExecuteSimpleSQL(CREATE_MOZ_META); in MigrateV45Up()
1736 NS_ENSURE_SUCCESS(rv, rv); in MigrateV45Up()
1744 nsresult rv = mMainConn->ExecuteSimpleSQL(nsLiteralCString( in MigrateV46Up() local
1757 rv = mMainConn->ExecuteSimpleSQL( in MigrateV46Up()
1762 NS_ENSURE_SUCCESS(rv, rv); in MigrateV46Up()
1765 rv = mMainConn->ExecuteSimpleSQL(nsLiteralCString( in MigrateV46Up()
1773 NS_ENSURE_SUCCESS(rv, rv); in MigrateV46Up()
1781 nsresult rv = mMainConn->ExecuteSimpleSQL( in MigrateV47Up() local
1786 NS_ENSURE_SUCCESS(rv, rv); in MigrateV47Up()
1788 rv = mMainConn->ExecuteSimpleSQL(nsLiteralCString( in MigrateV47Up()
1795 NS_ENSURE_SUCCESS(rv, rv); in MigrateV47Up()
1802 nsresult rv = mMainConn->CreateStatement("SELECT * FROM moz_origins; "_ns, in MigrateV48Up() local
1804 if (NS_FAILED(rv)) { in MigrateV48Up()
1805 rv = mMainConn->ExecuteSimpleSQL(CREATE_MOZ_ORIGINS); in MigrateV48Up()
1806 NS_ENSURE_SUCCESS(rv, rv); in MigrateV48Up()
1808 rv = mMainConn->ExecuteSimpleSQL(nsLiteralCString( in MigrateV48Up()
1812 NS_ENSURE_SUCCESS(rv, rv); in MigrateV48Up()
1815 rv = mMainConn->CreateStatement("SELECT origin_id FROM moz_places; "_ns, in MigrateV48Up()
1817 if (NS_FAILED(rv)) { in MigrateV48Up()
1818 rv = mMainConn->ExecuteSimpleSQL(nsLiteralCString( in MigrateV48Up()
1821 NS_ENSURE_SUCCESS(rv, rv); in MigrateV48Up()
1823 rv = mMainConn->ExecuteSimpleSQL(CREATE_IDX_MOZ_PLACES_ORIGIN_ID); in MigrateV48Up()
1824 NS_ENSURE_SUCCESS(rv, rv); in MigrateV48Up()
1825 rv = mMainConn->ExecuteSimpleSQL(nsLiteralCString( in MigrateV48Up()
1831 NS_ENSURE_SUCCESS(rv, rv); in MigrateV48Up()
1857 nsresult rv = mMainConn->CreateStatement( in MigrateV50Up() local
1863 if (NS_FAILED(rv)) return rv; in MigrateV50Up()
1871 rv = stmt->GetInt64(0, &placeId); in MigrateV50Up()
1872 if (NS_FAILED(rv)) return rv; in MigrateV50Up()
1873 rv = stmt->GetUTF8String(1, url); in MigrateV50Up()
1874 if (NS_FAILED(rv)) return rv; in MigrateV50Up()
1890 rv = ConvertOldStyleQuery(url); in MigrateV50Up()
1892 if (NS_WARN_IF(NS_FAILED(rv))) { in MigrateV50Up()
1897 rv = mMainConn->CreateStatement( in MigrateV50Up()
1902 if (NS_FAILED(rv)) return rv; in MigrateV50Up()
1904 rv = URIBinder::Bind(updateStmt, "url"_ns, url); in MigrateV50Up()
1905 if (NS_FAILED(rv)) return rv; in MigrateV50Up()
1906 rv = updateStmt->BindInt64ByName("placeId"_ns, placeId); in MigrateV50Up()
1907 if (NS_FAILED(rv)) return rv; in MigrateV50Up()
1909 rv = updateStmt->Execute(); in MigrateV50Up()
1910 if (NS_FAILED(rv)) return rv; in MigrateV50Up()
1914 rv = mMainConn->CreateStatement( in MigrateV50Up()
1919 if (NS_FAILED(rv)) return rv; in MigrateV50Up()
1921 rv = syncStmt->BindInt64ByName("placeId"_ns, placeId); in MigrateV50Up()
1922 if (NS_FAILED(rv)) return rv; in MigrateV50Up()
1924 rv = syncStmt->Execute(); in MigrateV50Up()
1925 if (NS_FAILED(rv)) return rv; in MigrateV50Up()
1939 nsresult rv = mMainConn->CreateStatement( in MigrateV51Up() local
1945 if (NS_FAILED(rv)) { in MigrateV51Up()
1951 rv = stmt->BindUTF8StringByName("anno_name"_ns, LAST_USED_ANNO); in MigrateV51Up()
1952 NS_ENSURE_SUCCESS(rv, rv); in MigrateV51Up()
1973 rv = mMainConn->CreateStatement( in MigrateV51Up()
1977 NS_ENSURE_SUCCESS(rv, rv); in MigrateV51Up()
1979 rv = stmt->BindUTF8StringByName("key"_ns, LAST_USED_FOLDERS_META_KEY); in MigrateV51Up()
1980 NS_ENSURE_SUCCESS(rv, rv); in MigrateV51Up()
1981 rv = stmt->BindUTF8StringByName("value"_ns, json); in MigrateV51Up()
1982 NS_ENSURE_SUCCESS(rv, rv); in MigrateV51Up()
1983 rv = stmt->Execute(); in MigrateV51Up()
1984 NS_ENSURE_SUCCESS(rv, rv); in MigrateV51Up()
1987 rv = mMainConn->CreateStatement( in MigrateV51Up()
1992 NS_ENSURE_SUCCESS(rv, rv); in MigrateV51Up()
1993 rv = stmt->BindUTF8StringByName("anno_name"_ns, LAST_USED_ANNO); in MigrateV51Up()
1994 NS_ENSURE_SUCCESS(rv, rv); in MigrateV51Up()
1995 rv = stmt->Execute(); in MigrateV51Up()
1996 NS_ENSURE_SUCCESS(rv, rv); in MigrateV51Up()
1998 rv = mMainConn->CreateStatement( in MigrateV51Up()
2002 NS_ENSURE_SUCCESS(rv, rv); in MigrateV51Up()
2003 rv = stmt->BindUTF8StringByName("anno_name"_ns, LAST_USED_ANNO); in MigrateV51Up()
2004 NS_ENSURE_SUCCESS(rv, rv); in MigrateV51Up()
2005 rv = stmt->Execute(); in MigrateV51Up()
2006 NS_ENSURE_SUCCESS(rv, rv); in MigrateV51Up()
2037 nsresult rv = navHistory->RecalculateOriginFrecencyStats(nullptr); in Run() local
2038 NS_ENSURE_SUCCESS(rv, rv); in Run()
2044 nsresult rv = mDBConn->ExecuteSimpleSQL(nsLiteralCString( in Run() local
2057 NS_ENSURE_SUCCESS(rv, rv); in Run()
2060 rv = mDBConn->CreateStatement(nsLiteralCString("SELECT 1 " in Run()
2065 NS_ENSURE_SUCCESS(rv, rv); in Run()
2067 rv = selectStmt->ExecuteStep(&hasResult); in Run()
2068 NS_ENSURE_SUCCESS(rv, rv); in Run()
2110 nsresult rv = in MigrateV52Up() local
2112 NS_ENSURE_SUCCESS(rv, rv); in MigrateV52Up()
2116 rv = in MigrateV52Up()
2123 NS_ENSURE_SUCCESS(rv, rv); in MigrateV52Up()
2130 nsresult rv = mMainConn->CreateStatement("SELECT 1 FROM moz_items_annos"_ns, in MigrateV53Up() local
2132 if (NS_FAILED(rv)) { in MigrateV53Up()
2138 rv = mMainConn->CreateStatement( in MigrateV53Up()
2145 NS_ENSURE_SUCCESS(rv, rv); in MigrateV53Up()
2146 rv = stmt->BindUTF8StringByName("anno_name"_ns, in MigrateV53Up()
2148 NS_ENSURE_SUCCESS(rv, rv); in MigrateV53Up()
2149 rv = stmt->Execute(); in MigrateV53Up()
2150 NS_ENSURE_SUCCESS(rv, rv); in MigrateV53Up()
2152 rv = mMainConn->ExecuteSimpleSQL(nsLiteralCString( in MigrateV53Up()
2160 NS_ENSURE_SUCCESS(rv, rv); in MigrateV53Up()
2168 nsresult rv = mMainConn->CreateStatement( in MigrateV54Up() local
2170 if (NS_FAILED(rv)) { in MigrateV54Up()
2171 rv = mMainConn->ExecuteSimpleSQL( in MigrateV54Up()
2174 NS_ENSURE_SUCCESS(rv, rv); in MigrateV54Up()
2179 rv = mMainConn->ExecuteSimpleSQL( in MigrateV54Up()
2184 NS_ENSURE_SUCCESS(rv, rv); in MigrateV54Up()
2192 nsresult rv = mMainConn->CreateStatement( in MigrateV55Up() local
2194 if (NS_FAILED(rv)) { in MigrateV55Up()
2196 rv = mMainConn->ExecuteSimpleSQL(CREATE_MOZ_PLACES_METADATA); in MigrateV55Up()
2197 NS_ENSURE_SUCCESS(rv, rv); in MigrateV55Up()
2199 rv = mMainConn->ExecuteSimpleSQL(CREATE_MOZ_PLACES_METADATA_SEARCH_QUERIES); in MigrateV55Up()
2200 NS_ENSURE_SUCCESS(rv, rv); in MigrateV55Up()
2215 nsresult rv = mMainConn->CreateStatement( in MigrateV57Up() local
2218 if (NS_FAILED(rv)) { in MigrateV57Up()
2219 rv = mMainConn->ExecuteSimpleSQL( in MigrateV57Up()
2222 NS_ENSURE_SUCCESS(rv, rv); in MigrateV57Up()
2225 rv = mMainConn->CreateStatement( in MigrateV57Up()
2228 if (NS_FAILED(rv)) { in MigrateV57Up()
2229 rv = mMainConn->ExecuteSimpleSQL( in MigrateV57Up()
2232 NS_ENSURE_SUCCESS(rv, rv); in MigrateV57Up()
2239 nsresult rv = TokenizeQueryString(aURL, &tokens); in ConvertOldStyleQuery() local
2240 NS_ENSURE_SUCCESS(rv, rv); in ConvertOldStyleQuery()
2256 int64_t itemId = kvp.value.ToInteger(&rv); in ConvertOldStyleQuery()
2257 if (NS_SUCCEEDED(rv)) { in ConvertOldStyleQuery()
2260 nsresult rv = mMainConn->CreateStatement( in ConvertOldStyleQuery() local
2264 if (NS_FAILED(rv)) return rv; in ConvertOldStyleQuery()
2266 rv = stmt->BindInt64ByName("itemId"_ns, itemId); in ConvertOldStyleQuery()
2267 if (NS_FAILED(rv)) return rv; in ConvertOldStyleQuery()
2271 rv = stmt->GetUTF8String(0, guid); in ConvertOldStyleQuery()
2272 if (NS_FAILED(rv)) return rv; in ConvertOldStyleQuery()
2318 nsresult rv = mMainConn->CreateStatement( in CreateMobileRoot() local
2327 if (NS_FAILED(rv)) return -1; in CreateMobileRoot()
2329 rv = createStmt->BindInt32ByName("item_type"_ns, in CreateMobileRoot()
2331 if (NS_FAILED(rv)) return -1; in CreateMobileRoot()
2332 rv = createStmt->BindUTF8StringByName("item_title"_ns, in CreateMobileRoot()
2334 if (NS_FAILED(rv)) return -1; in CreateMobileRoot()
2335 rv = createStmt->BindInt64ByName("timestamp"_ns, RoundedPRNow()); in CreateMobileRoot()
2336 if (NS_FAILED(rv)) return -1; in CreateMobileRoot()
2337 rv = createStmt->BindUTF8StringByName("guid"_ns, in CreateMobileRoot()
2339 if (NS_FAILED(rv)) return -1; in CreateMobileRoot()
2341 rv = createStmt->Execute(); in CreateMobileRoot()
2342 if (NS_FAILED(rv)) return -1; in CreateMobileRoot()
2347 rv = mMainConn->CreateStatement( in CreateMobileRoot()
2350 if (NS_FAILED(rv)) return -1; in CreateMobileRoot()
2352 rv = findIdStmt->BindUTF8StringByName("guid"_ns, in CreateMobileRoot()
2354 if (NS_FAILED(rv)) return -1; in CreateMobileRoot()
2357 rv = findIdStmt->ExecuteStep(&hasResult); in CreateMobileRoot()
2358 if (NS_FAILED(rv) || !hasResult) return -1; in CreateMobileRoot()
2361 rv = findIdStmt->GetInt64(0, &rootId); in CreateMobileRoot()
2362 if (NS_FAILED(rv)) return -1; in CreateMobileRoot()
2390 nsresult rv = in Shutdown() local
2395 MOZ_ASSERT(NS_SUCCEEDED(rv)); in Shutdown()
2396 rv = stmt->ExecuteStep(&hasResult); in Shutdown()
2397 MOZ_ASSERT(NS_SUCCEEDED(rv)); in Shutdown()
2399 rv = mMainConn->CreateStatement(nsLiteralCString("SELECT 1 " in Shutdown()
2403 MOZ_ASSERT(NS_SUCCEEDED(rv)); in Shutdown()
2404 rv = stmt->ExecuteStep(&hasResult); in Shutdown()
2405 MOZ_ASSERT(NS_SUCCEEDED(rv)); in Shutdown()
2410 rv = mMainConn->CreateStatement( in Shutdown()
2416 MOZ_ASSERT(NS_SUCCEEDED(rv)); in Shutdown()
2417 rv = stmt->ExecuteStep(&hasResult); in Shutdown()
2418 MOZ_ASSERT(NS_SUCCEEDED(rv)); in Shutdown()
2422 rv = mMainConn->CreateStatement( in Shutdown()
2424 MOZ_ASSERT(NS_SUCCEEDED(rv)); in Shutdown()
2425 rv = stmt->ExecuteStep(&hasResult); in Shutdown()
2426 MOZ_ASSERT(NS_SUCCEEDED(rv)); in Shutdown()
2430 rv = mMainConn->CreateStatement( in Shutdown()
2434 MOZ_ASSERT(NS_SUCCEEDED(rv)); in Shutdown()
2435 rv = stmt->ExecuteStep(&hasResult); in Shutdown()
2436 MOZ_ASSERT(NS_SUCCEEDED(rv)); in Shutdown()
2440 rv = mMainConn->CreateStatement( in Shutdown()
2442 MOZ_ASSERT(NS_SUCCEEDED(rv)); in Shutdown()
2443 rv = stmt->ExecuteStep(&hasResult); in Shutdown()
2444 MOZ_ASSERT(NS_SUCCEEDED(rv)); in Shutdown()