<pre style='margin:0'>
Umesh Singla (umeshksingla) pushed a commit to branch gsoc17-migrate
in repository macports-base.

</pre>
<p><a href="https://github.com/macports/macports-base/commit/ca6fe756f62f079a1f944c5c70d10fbe8a8bf225">https://github.com/macports/macports-base/commit/ca6fe756f62f079a1f944c5c70d10fbe8a8bf225</a></p>
<pre style="white-space: pre; background: #F8F8F8"><span style='display:block; white-space:pre;color:#808000;'>commit ca6fe756f62f079a1f944c5c70d10fbe8a8bf225
</span>Author: Umesh Singla <umeshksingla@macports.org>
AuthorDate: Tue Aug 8 23:01:27 2017 +0530

<span style='display:block; white-space:pre;color:#404040;'>    Improve the SQL query to get snapshot elements
</span>---
 src/cregistry/entry.c | 7 ++++---
 1 file changed, 4 insertions(+), 3 deletions(-)

<span style='display:block; white-space:pre;color:#808080;'>diff --git a/src/cregistry/entry.c b/src/cregistry/entry.c
</span><span style='display:block; white-space:pre;color:#808080;'>index c66e3e8..075c22b 100644
</span><span style='display:block; white-space:pre;background:#e0e0ff;'>--- a/src/cregistry/entry.c
</span><span style='display:block; white-space:pre;background:#e0e0ff;'>+++ b/src/cregistry/entry.c
</span><span style='display:block; white-space:pre;background:#e0e0e0;'>@@ -1532,7 +1532,7 @@ int get_parsed_variants(char* variants_str, variant* all_variants, char* delim,
</span>     return 0;
 }
 
<span style='display:block; white-space:pre;background:#ffe0e0;'>-char* reg_snapshot_get_id(reg_registry* reg, char* id, reg_error* errPtr) {
</span><span style='display:block; white-space:pre;background:#e0ffe0;'>+char* reg_snapshot_get_id(reg_registry* reg, reg_error* errPtr) {
</span> 
     printf("inside cregistry get snapshot..\n");
     sqlite3_stmt* stmt = NULL;
<span style='display:block; white-space:pre;background:#e0e0e0;'>@@ -1548,7 +1548,8 @@ reg_snapshot* reg_snapshot_get(reg_registry* reg, char* id, reg_error* errPtr) {
</span>     sqlite3_stmt* stmt = NULL;
     reg_entry* entry = NULL;
 
<span style='display:block; white-space:pre;background:#ffe0e0;'>-    char* query = "SELECT * FROM registry.snapshots "
</span><span style='display:block; white-space:pre;background:#e0ffe0;'>+    char* query = "SELECT port_name, requested, variant_name, variant_sign "
</span><span style='display:block; white-space:pre;background:#e0ffe0;'>+        "FROM registry.snapshots "
</span>         "INNER JOIN "
         "registry.snapshot_ports ON "
         "snapshots.id=snapshot_ports.snapshots_id "
<span style='display:block; white-space:pre;background:#e0e0e0;'>@@ -1558,7 +1559,7 @@ reg_snapshot* reg_snapshot_get(reg_registry* reg, char* id, reg_error* errPtr) {
</span>         "WHERE snapshots.id=?";
 
     if ((sqlite3_prepare_v2(reg->db, query, -1, &stmt, NULL) == SQLITE_OK)
<span style='display:block; white-space:pre;background:#ffe0e0;'>-        && sqlite3_bind_int64(stmt, 1, sqlite_int64(id)) == SQLITE_OK ) {
</span><span style='display:block; white-space:pre;background:#e0ffe0;'>+        && sqlite3_bind_int64(stmt, 1, (sqlite_int64)id == SQLITE_OK ) {
</span> 
         int r;
         do {
</pre><pre style='margin:0'>

</pre>