gint add_maker(const gchar* maker, gchar** error) {
gint rc;
sqlite3_stmt* stmt;
- gint status = 1;
+ gint status = -1;
- rc = sqlite3_prepare_v2(db, "insert into lensmaker (maker) values (?1)", -1, &stmt, 0);
+ rc = sqlite3_prepare_v2(db, "insert into lensmaker (maker) values (?1) returning id", -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);
}
rc = sqlite3_step(stmt);
- if (rc != SQLITE_DONE) {
- gchar* err = g_strdup_printf("Couldn't bind to prepared sql stmt: %s\n", sqlite3_errmsg(db));
+ if (rc != SQLITE_ROW) {
+ gchar* err = g_strdup_printf("Couldn't insert maker: %s\n", sqlite3_errmsg(db));
fprintf(stderr, err);
show_err_msg(GTK_MESSAGE_ERROR, err);
g_free(err);
if (error)
*error = g_strdup(sqlite3_errmsg(db));
- sqlite3_finalize(stmt);
- return status;
- }
-
- status = 0;
+ } else {
+ status = sqlite3_column_int64(stmt, 0);
+ }
+
sqlite3_finalize(stmt);
return status;
gint get_maker_id(const gchar* maker) {
gint rc;
sqlite3_stmt* stmt;
- gint id = 0;
+ gint id = -1;
rc = sqlite3_prepare_v2(db, "select id from lensmaker where maker = ?1", -1, &stmt, 0);
if (rc != SQLITE_OK) {