Attachment 315963 Details for Bug 461403 – Create indexes with IF NOT EXISTS

[patch] Create indexes with IF NOT EXISTS

0003-Create-indexes-with-IF-NOT-EXISTS.patch (text/plain), 3.78 KB, created by Ville Skyttä on 2008-09-07 10:55:26 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Ville Skyttä

Created: 2008-09-07 10:55:26 UTC

Size: 3.78 KB

patch

obsolete

>From b1f527e7bdd0cdd84aa407722cac57b89aac9f71 Mon Sep 17 00:00:00 2001
>From: =?utf-8?q?Ville=20Skytt=C3=A4?= <ville.skytta@iki.fi>
>Date: Sun, 7 Sep 2008 11:44:11 +0300
>Subject: [PATCH] Create indexes with IF NOT EXISTS.
>
>---
> db.c |   20 ++++++++++----------
> 1 files changed, 10 insertions(+), 10 deletions(-)
>
>diff --git a/db.c b/db.c
>index 59fad0e..a6af904 100644
>--- a/db.c
>+++ b/db.c
>@@ -420,7 +420,7 @@ yum_db_index_primary_tables (sqlite3 *db, GError **err)
>     int rc;
>     const char *sql;
> 
>-    sql = "CREATE INDEX packagename ON packages (name)";
>+    sql = "CREATE INDEX IF NOT EXISTS packagename ON packages (name)";
>     rc = sqlite3_exec (db, sql, NULL, NULL, NULL);
>     if (rc != SQLITE_OK) {
>         g_set_error (err, YUM_DB_ERROR, YUM_DB_ERROR,
>@@ -429,7 +429,7 @@ yum_db_index_primary_tables (sqlite3 *db, GError **err)
>         return;
>     }
>     
>-    sql = "CREATE INDEX packageId ON packages (pkgId)";
>+    sql = "CREATE INDEX IF NOT EXISTS packageId ON packages (pkgId)";
>     rc = sqlite3_exec (db, sql, NULL, NULL, NULL);
>     if (rc != SQLITE_OK) {
>         g_set_error (err, YUM_DB_ERROR, YUM_DB_ERROR,
>@@ -438,7 +438,7 @@ yum_db_index_primary_tables (sqlite3 *db, GError **err)
>         return;
>     }
> 
>-    sql = "CREATE INDEX filenames ON files (name)";
>+    sql = "CREATE INDEX IF NOT EXISTS filenames ON files (name)";
>     rc = sqlite3_exec (db, sql, NULL, NULL, NULL);
>     if (rc != SQLITE_OK) {
>         g_set_error (err, YUM_DB_ERROR, YUM_DB_ERROR,
>@@ -450,8 +450,8 @@ yum_db_index_primary_tables (sqlite3 *db, GError **err)
>     const char *deps[] = { "requires", "provides", "conflicts", "obsoletes", NULL };
>     int i;
> 
>-    const char *pkgindexsql = "CREATE INDEX pkg%s on %s (pkgKey)";
>-    const char *nameindexsql = "CREATE INDEX %sname ON %s (name)";
>+    const char *pkgindexsql = "CREATE INDEX IF NOT EXISTS pkg%s on %s (pkgKey)";
>+    const char *nameindexsql = "CREATE INDEX IF NOT EXISTS %sname ON %s (name)";
> 
>     for (i = 0; deps[i]; i++) {
>         char *query;
>@@ -711,7 +711,7 @@ yum_db_index_filelist_tables (sqlite3 *db, GError **err)
>     int rc;
>     const char *sql;
> 
>-    sql = "CREATE INDEX keyfile ON filelist (pkgKey)";
>+    sql = "CREATE INDEX IF NOT EXISTS keyfile ON filelist (pkgKey)";
>     rc = sqlite3_exec (db, sql, NULL, NULL, NULL);
>     if (rc != SQLITE_OK) {
>         g_set_error (err, YUM_DB_ERROR, YUM_DB_ERROR,
>@@ -720,7 +720,7 @@ yum_db_index_filelist_tables (sqlite3 *db, GError **err)
>         return;
>     }
> 
>-    sql = "CREATE INDEX pkgId ON packages (pkgId)";
>+    sql = "CREATE INDEX IF NOT EXISTS pkgId ON packages (pkgId)";
>     rc = sqlite3_exec (db, sql, NULL, NULL, NULL);
>     if (rc != SQLITE_OK) {
>         g_set_error (err, YUM_DB_ERROR, YUM_DB_ERROR,
>@@ -729,7 +729,7 @@ yum_db_index_filelist_tables (sqlite3 *db, GError **err)
>         return;
>     }
> 
>-    sql = "CREATE INDEX dirnames ON filelist (dirname)";
>+    sql = "CREATE INDEX IF NOT EXISTS dirnames ON filelist (dirname)";
>     rc = sqlite3_exec (db, sql, NULL, NULL, NULL);
>     if (rc != SQLITE_OK) {
>         g_set_error (err, YUM_DB_ERROR, YUM_DB_ERROR,
>@@ -893,7 +893,7 @@ yum_db_index_other_tables (sqlite3 *db, GError **err)
>     int rc;
>     const char *sql;
> 
>-    sql = "CREATE INDEX keychange ON changelog (pkgKey)";
>+    sql = "CREATE INDEX IF NOT EXISTS keychange ON changelog (pkgKey)";
>     rc = sqlite3_exec (db, sql, NULL, NULL, NULL);
>     if (rc != SQLITE_OK) {
>         g_set_error (err, YUM_DB_ERROR, YUM_DB_ERROR,
>@@ -902,7 +902,7 @@ yum_db_index_other_tables (sqlite3 *db, GError **err)
>         return;
>     }
> 
>-    sql = "CREATE INDEX pkgId ON packages (pkgId)";
>+    sql = "CREATE INDEX IF NOT EXISTS pkgId ON packages (pkgId)";
>     rc = sqlite3_exec (db, sql, NULL, NULL, NULL);
>     if (rc != SQLITE_OK) {
>         g_set_error (err, YUM_DB_ERROR, YUM_DB_ERROR,
>-- 
>1.5.5.1
>

Actions: View | Diff

Attachments on bug 461403: 315962 | 315963