X-Git-Url: http://git.datanom.net/lensdb.git/blobdiff_plain/1689100fc9cd30b34628a2ab6fac95ee7f0977db..refs/heads/release/0.9.2:/src/sqlite-storage.c diff --git a/src/sqlite-storage.c b/src/sqlite-storage.c index 2fc1147..cb910bb 100644 --- a/src/sqlite-storage.c +++ b/src/sqlite-storage.c @@ -38,11 +38,14 @@ static gchar* lens = "create table lens(" "maker integer not null," "description text not null," "notes text," + "date_added datetime DEFAULT current_timestamp," "PRIMARY KEY(id AUTOINCREMENT)," "constraint fk_maker foreign key (maker) references lensmaker (id)" " on delete cascade);"; static gchar* search = "SELECT l.id, l.sn, l.description, l.notes, l.maker" " FROM lens l JOIN lensmaker m on l.maker = m.id"; +static gchar* all = "SELECT m.maker,l.sn,l.description,l.notes,l.date_added" + " FROM lensmaker m JOIN lens l on m.id = l.maker"; void close_storage() { if (db != NULL) @@ -660,3 +663,62 @@ void row_free(gpointer data, gpointer user_data) { g_free(row); } +void dump_storage(CsvParser* parser) { + gint rc; + sqlite3_stmt* stmt; + CvsError* err = NULL; + + if (parser == NULL) return; + + rc = sqlite3_prepare_v2(db, all, -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_err_msg(GTK_MESSAGE_ERROR, err); + g_free(err); + sqlite3_finalize(stmt); + return; + } + + Record* row = g_new0(Record, 1); + row->maker = g_strdup("maker"); + row->sn = g_strdup("sn"); + row->data = g_strdup("lens"); + row->notes = g_strdup("notes"); + row->date = g_strdup("date"); + csv_parser_dump_row(parser, row, &err); + csv_record_free(row); + if (err) { + gchar* msg = g_strdup_printf("%zu: %s\n", err->line, err->message); + fprintf(stderr, msg); + show_err_msg(GTK_MESSAGE_ERROR, msg); + g_free(msg); + csv_error_clear(&err); + sqlite3_finalize(stmt); + return; + } + + while (sqlite3_step(stmt) == SQLITE_ROW) { + row = g_new0(Record, 1); + row->maker = g_strdup((const gchar*)sqlite3_column_text(stmt, 0)); + row->sn = g_strdup((const gchar*)sqlite3_column_text(stmt, 1)); + row->data = g_strdup((const gchar*)sqlite3_column_text(stmt, 2)); + row->notes = g_strdup((const gchar*)sqlite3_column_text(stmt, 3)); + row->date = g_strdup((const gchar*)sqlite3_column_text(stmt, 4)); + csv_parser_dump_row(parser, row, &err); + csv_record_free(row); + if (err) { + gchar* msg = g_strdup_printf("%zu: %s\n", err->line, err->message); + fprintf(stderr, msg); + show_err_msg(GTK_MESSAGE_ERROR, msg); + g_free(msg); + csv_error_clear(&err); + sqlite3_finalize(stmt); + return; + } + } + + sqlite3_finalize(stmt); +} + +