]> git.datanom.net - lensdb.git/blobdiff - src/sqlite-storage.c
Handle length of NULL strings
[lensdb.git] / src / sqlite-storage.c
index 8957fd3f7310acf02e98a9b78f7b11864d3acd6f..a4ff57a8d33a925f0aa9a41235e999bc19a2bc93 100644 (file)
@@ -245,6 +245,56 @@ gint update_lens(const Row* row) {
        return status;
 }
 
        return status;
 }
 
+gint update_lens_maker(const Row* row) {
+       gint rc;
+       sqlite3_stmt* stmt;
+       gint status = 1;
+       
+       rc = sqlite3_prepare_v2(db, "update lens set maker = ?1 where id = ?2", -1, &stmt, 0);
+       if (rc != SQLITE_OK) {   
+               gchar* err = g_strdup_printf("Couldn't prepare sql statement: %s\n", sqlite3_errmsg(db));
+               fprintf(stderr, err);
+               show_message(GTK_MESSAGE_ERROR, err);
+               g_free(err);
+               sqlite3_finalize(stmt);
+        return status;
+    }  
+    
+    rc = sqlite3_bind_int64(stmt, 1, row->maker);
+    if (rc) {
+               gchar* err = g_strdup_printf("Couldn't bind to prepared sql stmt: %s\n", sqlite3_errmsg(db));
+               fprintf(stderr, err);
+               show_message(GTK_MESSAGE_ERROR, err);
+               g_free(err);
+               sqlite3_finalize(stmt);
+               return status;
+       }
+       
+    rc = sqlite3_bind_int64(stmt, 2, row->id);
+    if (rc) {
+               gchar* err = g_strdup_printf("Couldn't bind to prepared sql stmt: %s\n", sqlite3_errmsg(db));
+               fprintf(stderr, err);
+               show_message(GTK_MESSAGE_ERROR, err);
+               g_free(err);
+               sqlite3_finalize(stmt);
+               return status;
+       }
+       
+       rc = sqlite3_step(stmt); 
+    if (rc != SQLITE_DONE) {
+               gchar* err = g_strdup_printf("Step failure: %s\n", sqlite3_errmsg(db));
+               fprintf(stderr, err);
+               show_message(GTK_MESSAGE_ERROR, err);
+               g_free(err);
+    } else {
+               status = 0;
+       }
+    
+    sqlite3_finalize(stmt);
+
+       return status;
+}
+
 gint delete_lens(const Row* row) {
        gint rc;
        sqlite3_stmt* stmt;
 gint delete_lens(const Row* row) {
        gint rc;
        sqlite3_stmt* stmt;
This page took 0.523242 seconds and 5 git commands to generate.