]>
git.datanom.net - gtk_lensdatabase.git/blob - src/sqlite-storage.c
4 * Copyright 2024 Michael Rasmussen <mir@datanom.net>
6 * This program is free software; you can redistribute it and/or modify
7 * it under the terms of the GNU General Public License as published by
8 * the Free Software Foundation; either version 3 of the License, or
9 * (at your option) any later version.
11 * This program is distributed in the hope that it will be useful,
12 * but WITHOUT ANY WARRANTY; without even the implied warranty of
13 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
14 * GNU General Public License for more details.
16 * You should have received a copy of the GNU General Public License
17 * along with this program; if not, write to the Free Software
18 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,
25 #include "sqlite-storage.h"
27 #define DBNAME "lensdb.db"
29 static sqlite3
* db
= NULL
;
30 static gchar
* lensmaker
= "create table lensmaker("
31 "id integer not null,"
32 "maker text not null UNIQUE,"
33 "page int DEFAULT -1,"
34 "PRIMARY KEY(id AUTOINCREMENT));";
35 static gchar
* lens
= "create table lens("
36 "id integer not null,"
38 "maker integer not null,"
39 "description text not null,"
41 "date_added datetime DEFAULT current_timestamp,"
42 "PRIMARY KEY(id AUTOINCREMENT),"
43 "constraint fk_maker foreign key (maker) references lensmaker (id)"
44 " on delete cascade);";
45 static gchar
* search
= "SELECT l.id, l.sn, l.description, l.notes, l.maker"
46 " FROM lens l JOIN lensmaker m on l.maker = m.id";
47 static gchar
* all
= "SELECT m.maker,l.sn,l.description,l.notes,l.date_added"
48 " FROM lensmaker m JOIN lens l on m.id = l.maker";
49 static gchar
* db_path
= NULL
;
51 void close_storage() {
59 gint
init_storage(const gchar
* path
) {
60 gboolean init_db
= FALSE
;
64 gchar
* filename
= g_strconcat(path
, "/", DBNAME
, NULL
);
65 if (!g_file_test(filename
, G_FILE_TEST_EXISTS
)) {
68 rc
= sqlite3_open(filename
, &db
);
72 gchar
* err
= g_strdup_printf("Failed to open DB: %s\n", sqlite3_errmsg(db
));
74 show_message(GTK_MESSAGE_ERROR
, err
);
78 db_path
= g_strdup(path
);
81 rc
= sqlite3_exec(db
, "PRAGMA foreign_keys = ON", 0, 0, &ErrMsg
);
82 if (rc
!= SQLITE_OK
) {
83 gchar
* err
= g_strdup_printf("SQL error: %s\n", ErrMsg
);
85 show_message(GTK_MESSAGE_ERROR
, err
);
90 rc
= sqlite3_exec(db
, lensmaker
, 0, 0, &ErrMsg
);
91 if (rc
!= SQLITE_OK
) {
92 gchar
* err
= g_strdup_printf("SQL error: %s\n", ErrMsg
);
94 show_message(GTK_MESSAGE_ERROR
, err
);
99 rc
= sqlite3_exec(db
, lens
, 0, 0, &ErrMsg
);
100 if (rc
!= SQLITE_OK
) {
101 gchar
* err
= g_strdup_printf("SQL error: %s\n", ErrMsg
);
102 fprintf(stderr
, err
);
103 show_message(GTK_MESSAGE_ERROR
, err
);
105 sqlite3_free(ErrMsg
);
112 gint
add_lens(Row
* row
) {
117 rc
= sqlite3_prepare_v2(db
, "insert into lens (sn, maker, description, notes) values (?1, ?2, ?3, ?4) returning id", -1, &stmt
, 0);
118 if (rc
!= SQLITE_OK
) {
119 gchar
* err
= g_strdup_printf("Couldn't prepare sql statement: %s\n", sqlite3_errmsg(db
));
120 fprintf(stderr
, err
);
121 show_message(GTK_MESSAGE_ERROR
, err
);
123 sqlite3_finalize(stmt
);
127 rc
= sqlite3_bind_text(stmt
, 1, row
->sn
, -1, NULL
);
129 gchar
* err
= g_strdup_printf("Couldn't bind to prepared sql stmt: %s\n", sqlite3_errmsg(db
));
130 fprintf(stderr
, err
);
131 show_message(GTK_MESSAGE_ERROR
, err
);
133 sqlite3_finalize(stmt
);
137 rc
= sqlite3_bind_int(stmt
, 2, row
->maker
);
139 gchar
* err
= g_strdup_printf("Couldn't bind to prepared sql stmt: %s\n", sqlite3_errmsg(db
));
140 fprintf(stderr
, err
);
141 show_message(GTK_MESSAGE_ERROR
, err
);
143 sqlite3_finalize(stmt
);
147 rc
= sqlite3_bind_text(stmt
, 3, row
->data
, -1, NULL
);
149 gchar
* err
= g_strdup_printf("Couldn't bind to prepared sql stmt: %s\n", sqlite3_errmsg(db
));
150 fprintf(stderr
, err
);
151 show_message(GTK_MESSAGE_ERROR
, err
);
153 sqlite3_finalize(stmt
);
157 rc
= sqlite3_bind_text(stmt
, 4, row
->notes
, -1, NULL
);
159 gchar
* err
= g_strdup_printf("Couldn't bind to prepared sql stmt: %s\n", sqlite3_errmsg(db
));
160 fprintf(stderr
, err
);
161 show_message(GTK_MESSAGE_ERROR
, err
);
163 sqlite3_finalize(stmt
);
167 rc
= sqlite3_step(stmt
);
168 if (rc
!= SQLITE_ROW
) {
169 gchar
* err
= g_strdup_printf("Step failure: %s\n", sqlite3_errmsg(db
));
170 fprintf(stderr
, err
);
171 show_message(GTK_MESSAGE_ERROR
, err
);
174 row
->id
= sqlite3_column_int64(stmt
, 0);
178 sqlite3_finalize(stmt
);
183 gint
update_lens(const Row
* row
) {
188 rc
= sqlite3_prepare_v2(db
, "update lens set sn = ?1, description = ?2, notes = ?3 where id = ?4", -1, &stmt
, 0);
189 if (rc
!= SQLITE_OK
) {
190 gchar
* err
= g_strdup_printf("Couldn't prepare sql statement: %s\n", sqlite3_errmsg(db
));
191 fprintf(stderr
, err
);
192 show_message(GTK_MESSAGE_ERROR
, err
);
194 sqlite3_finalize(stmt
);
198 rc
= sqlite3_bind_text(stmt
, 1, row
->sn
, -1, NULL
);
200 gchar
* err
= g_strdup_printf("Couldn't bind to prepared sql stmt: %s\n", sqlite3_errmsg(db
));
201 fprintf(stderr
, err
);
202 show_message(GTK_MESSAGE_ERROR
, err
);
204 sqlite3_finalize(stmt
);
208 rc
= sqlite3_bind_text(stmt
, 2, row
->data
, -1, NULL
);
210 gchar
* err
= g_strdup_printf("Couldn't bind to prepared sql stmt: %s\n", sqlite3_errmsg(db
));
211 fprintf(stderr
, err
);
212 show_message(GTK_MESSAGE_ERROR
, err
);
214 sqlite3_finalize(stmt
);
218 rc
= sqlite3_bind_text(stmt
, 3, row
->notes
, -1, NULL
);
220 gchar
* err
= g_strdup_printf("Couldn't bind to prepared sql stmt: %s\n", sqlite3_errmsg(db
));
221 fprintf(stderr
, err
);
222 show_message(GTK_MESSAGE_ERROR
, err
);
224 sqlite3_finalize(stmt
);
228 rc
= sqlite3_bind_int64(stmt
, 4, row
->id
);
230 gchar
* err
= g_strdup_printf("Couldn't bind to prepared sql stmt: %s\n", sqlite3_errmsg(db
));
231 fprintf(stderr
, err
);
232 show_message(GTK_MESSAGE_ERROR
, err
);
234 sqlite3_finalize(stmt
);
238 rc
= sqlite3_step(stmt
);
239 if (rc
!= SQLITE_DONE
) {
240 gchar
* err
= g_strdup_printf("Step failure: %s\n", sqlite3_errmsg(db
));
241 fprintf(stderr
, err
);
242 show_message(GTK_MESSAGE_ERROR
, err
);
248 sqlite3_finalize(stmt
);
253 gint
update_lens_maker(const Row
* row
) {
258 rc
= sqlite3_prepare_v2(db
, "update lens set maker = ?1 where id = ?2", -1, &stmt
, 0);
259 if (rc
!= SQLITE_OK
) {
260 gchar
* err
= g_strdup_printf("Couldn't prepare sql statement: %s\n", sqlite3_errmsg(db
));
261 fprintf(stderr
, err
);
262 show_message(GTK_MESSAGE_ERROR
, err
);
264 sqlite3_finalize(stmt
);
268 rc
= sqlite3_bind_int64(stmt
, 1, row
->maker
);
270 gchar
* err
= g_strdup_printf("Couldn't bind to prepared sql stmt: %s\n", sqlite3_errmsg(db
));
271 fprintf(stderr
, err
);
272 show_message(GTK_MESSAGE_ERROR
, err
);
274 sqlite3_finalize(stmt
);
278 rc
= sqlite3_bind_int64(stmt
, 2, row
->id
);
280 gchar
* err
= g_strdup_printf("Couldn't bind to prepared sql stmt: %s\n", sqlite3_errmsg(db
));
281 fprintf(stderr
, err
);
282 show_message(GTK_MESSAGE_ERROR
, err
);
284 sqlite3_finalize(stmt
);
288 rc
= sqlite3_step(stmt
);
289 if (rc
!= SQLITE_DONE
) {
290 gchar
* err
= g_strdup_printf("Step failure: %s\n", sqlite3_errmsg(db
));
291 fprintf(stderr
, err
);
292 show_message(GTK_MESSAGE_ERROR
, err
);
298 sqlite3_finalize(stmt
);
303 gint
delete_lens(const Row
* row
) {
308 rc
= sqlite3_prepare_v2(db
, "delete from lens where id = ?1", -1, &stmt
, 0);
309 if (rc
!= SQLITE_OK
) {
310 gchar
* err
= g_strdup_printf("Couldn't prepare sql statement: %s\n", sqlite3_errmsg(db
));
311 fprintf(stderr
, err
);
312 show_message(GTK_MESSAGE_ERROR
, err
);
314 sqlite3_finalize(stmt
);
318 rc
= sqlite3_bind_int64(stmt
, 1, row
->id
);
320 gchar
* err
= g_strdup_printf("Couldn't bind to prepared sql stmt: %s\n", sqlite3_errmsg(db
));
321 fprintf(stderr
, err
);
322 show_message(GTK_MESSAGE_ERROR
, err
);
324 sqlite3_finalize(stmt
);
328 rc
= sqlite3_step(stmt
);
329 if (rc
!= SQLITE_DONE
) {
330 gchar
* err
= g_strdup_printf("Step failure: %s\n", sqlite3_errmsg(db
));
331 fprintf(stderr
, err
);
332 show_message(GTK_MESSAGE_ERROR
, err
);
338 sqlite3_finalize(stmt
);
343 gint
add_maker(const gchar
* maker
, gchar
** error
) {
348 rc
= sqlite3_prepare_v2(db
, "insert into lensmaker (maker) values (?1) returning id", -1, &stmt
, 0);
349 if (rc
!= SQLITE_OK
) {
350 gchar
* err
= g_strdup_printf("Couldn't prepare sql statement: %s\n", sqlite3_errmsg(db
));
351 fprintf(stderr
, err
);
352 show_message(GTK_MESSAGE_ERROR
, err
);
355 *error
= g_strdup(sqlite3_errmsg(db
));
356 sqlite3_finalize(stmt
);
360 rc
= sqlite3_bind_text(stmt
, 1, maker
, -1, NULL
);
362 gchar
* err
= g_strdup_printf("Couldn't bind to prepared sql stmt: %s\n", sqlite3_errmsg(db
));
363 fprintf(stderr
, err
);
364 show_message(GTK_MESSAGE_ERROR
, err
);
367 *error
= g_strdup(sqlite3_errmsg(db
));
368 sqlite3_finalize(stmt
);
372 rc
= sqlite3_step(stmt
);
373 if (rc
!= SQLITE_ROW
) {
374 gchar
* err
= g_strdup_printf("Couldn't insert maker: %s\n", sqlite3_errmsg(db
));
375 fprintf(stderr
, err
);
376 show_message(GTK_MESSAGE_ERROR
, err
);
379 *error
= g_strdup(sqlite3_errmsg(db
));
381 id
= sqlite3_column_int64(stmt
, 0);
384 sqlite3_finalize(stmt
);
389 Maker
* get_maker(gint id
) {
394 rc
= sqlite3_prepare_v2(db
, "select maker, page from lensmaker where id = ?1", -1, &stmt
, 0);
395 if (rc
!= SQLITE_OK
) {
396 gchar
* err
= g_strdup_printf("Couldn't prepare sql statement: %s\n", sqlite3_errmsg(db
));
397 fprintf(stderr
, err
);
398 show_message(GTK_MESSAGE_ERROR
, err
);
400 sqlite3_finalize(stmt
);
404 rc
= sqlite3_bind_int64(stmt
, 1, id
);
406 gchar
* err
= g_strdup_printf("Couldn't bind to prepared sql stmt: %s\n", sqlite3_errmsg(db
));
407 fprintf(stderr
, err
);
408 show_message(GTK_MESSAGE_ERROR
, err
);
410 sqlite3_finalize(stmt
);
414 if (sqlite3_step(stmt
) == SQLITE_ROW
) {
415 maker
= g_new0(Maker
, 1);
417 maker
->maker_name
= g_strdup((const gchar
*)sqlite3_column_text(stmt
, 0));
418 maker
->page
= sqlite3_column_int(stmt
, 1);
421 sqlite3_finalize(stmt
);
426 void update_maker(const Maker
* maker
) {
430 rc
= sqlite3_prepare_v2(db
, "update lensmaker set page = ?1 where id = ?2", -1, &stmt
, 0);
431 if (rc
!= SQLITE_OK
) {
432 gchar
* err
= g_strdup_printf("Couldn't prepare sql statement: %s\n", sqlite3_errmsg(db
));
433 fprintf(stderr
, err
);
434 show_message(GTK_MESSAGE_ERROR
, err
);
436 sqlite3_finalize(stmt
);
440 rc
= sqlite3_bind_int(stmt
, 1, maker
->page
);
442 gchar
* err
= g_strdup_printf("Couldn't bind to prepared sql stmt: %s\n", sqlite3_errmsg(db
));
443 fprintf(stderr
, err
);
444 show_message(GTK_MESSAGE_ERROR
, err
);
446 sqlite3_finalize(stmt
);
450 rc
= sqlite3_bind_int64(stmt
, 2, maker
->id
);
452 gchar
* err
= g_strdup_printf("Couldn't bind to prepared sql stmt: %s\n", sqlite3_errmsg(db
));
453 fprintf(stderr
, err
);
454 show_message(GTK_MESSAGE_ERROR
, err
);
456 sqlite3_finalize(stmt
);
460 //fprintf(stderr, "%s\n", sqlite3_expanded_sql(stmt));
461 rc
= sqlite3_step(stmt
);
462 if (rc
!= SQLITE_DONE
) {
463 gchar
* err
= g_strdup_printf("Step failure: %s\n", sqlite3_errmsg(db
));
464 fprintf(stderr
, err
);
465 show_message(GTK_MESSAGE_ERROR
, err
);
467 sqlite3_finalize(stmt
);
470 sqlite3_finalize(stmt
);
473 void maker_free(Maker
* maker
) {
475 g_free(maker
->maker_name
);
480 gint
delete_maker(const gchar
* maker
, gchar
** error
) {
485 gint id
= get_maker_id(maker
);
486 rc
= sqlite3_prepare_v2(db
, "delete from lensmaker where id = ?1", -1, &stmt
, 0);
487 if (rc
!= SQLITE_OK
) {
488 gchar
* err
= g_strdup_printf("Couldn't prepare sql statement: %s\n", sqlite3_errmsg(db
));
489 fprintf(stderr
, err
);
490 show_message(GTK_MESSAGE_ERROR
, err
);
493 *error
= g_strdup(sqlite3_errmsg(db
));
494 sqlite3_finalize(stmt
);
499 rc
= sqlite3_bind_int(stmt
, 1, id
);
501 gchar
* err
= g_strdup_printf("Couldn't bind to prepared sql stmt: %s\n", sqlite3_errmsg(db
));
502 fprintf(stderr
, err
);
503 show_message(GTK_MESSAGE_ERROR
, err
);
506 *error
= g_strdup(sqlite3_errmsg(db
));
507 sqlite3_finalize(stmt
);
512 //fprintf(stderr, "%s\n", sqlite3_expanded_sql(stmt));
513 rc
= sqlite3_step(stmt
);
514 if (rc
!= SQLITE_DONE
) {
515 gchar
* err
= g_strdup_printf("Step failure: %s\n", sqlite3_errmsg(db
));
516 fprintf(stderr
, err
);
517 show_message(GTK_MESSAGE_ERROR
, err
);
520 *error
= g_strdup(sqlite3_errmsg(db
));
521 sqlite3_finalize(stmt
);
526 sqlite3_finalize(stmt
);
531 GSList
* get_makers() {
534 GSList
* makers
= NULL
;
536 rc
= sqlite3_prepare_v2(db
, "select maker from lensmaker order by id", -1, &stmt
, 0);
537 if (rc
!= SQLITE_OK
) {
538 gchar
* err
= g_strdup_printf("Failed to fetch data: %s\n", sqlite3_errmsg(db
));
539 fprintf(stderr
, err
);
540 show_message(GTK_MESSAGE_ERROR
, err
);
542 sqlite3_finalize(stmt
);
546 while (sqlite3_step(stmt
) == SQLITE_ROW
) {
547 gchar
* maker
= g_strdup((const gchar
*)sqlite3_column_text(stmt
, 0));
548 makers
= g_slist_append(makers
, maker
);
551 sqlite3_finalize(stmt
);
556 gint
get_maker_id(const gchar
* maker
) {
561 rc
= sqlite3_prepare_v2(db
, "select id from lensmaker where maker = ?1", -1, &stmt
, 0);
562 if (rc
!= SQLITE_OK
) {
563 gchar
* err
= g_strdup_printf("Couldn't prepare sql statement: %s\n", sqlite3_errmsg(db
));
564 fprintf(stderr
, err
);
565 show_message(GTK_MESSAGE_ERROR
, err
);
567 sqlite3_finalize(stmt
);
571 rc
= sqlite3_bind_text(stmt
, 1, maker
, -1, NULL
);
573 gchar
* err
= g_strdup_printf("Couldn't bind to prepared sql stmt: %s\n", sqlite3_errmsg(db
));
574 fprintf(stderr
, err
);
575 show_message(GTK_MESSAGE_ERROR
, err
);
577 sqlite3_finalize(stmt
);
581 if (sqlite3_step(stmt
) == SQLITE_ROW
) {
582 id
= sqlite3_column_int64(stmt
, 0);
585 sqlite3_finalize(stmt
);
590 GSList
* get_lens_by_maker(gint id
) {
593 GSList
* lenses
= NULL
;
595 rc
= sqlite3_prepare_v2(db
, "select sn, description, notes, id from lens where maker = ?1", -1, &stmt
, 0);
596 if (rc
!= SQLITE_OK
) {
597 gchar
* err
= g_strdup_printf("Couldn't prepare sql statement: %s\n", sqlite3_errmsg(db
));
598 fprintf(stderr
, err
);
599 show_message(GTK_MESSAGE_ERROR
, err
);
601 sqlite3_finalize(stmt
);
605 rc
= sqlite3_bind_int64(stmt
, 1, id
);
607 gchar
* err
= g_strdup_printf("Couldn't bind to prepared sql stmt: %s\n", sqlite3_errmsg(db
));
608 fprintf(stderr
, err
);
609 show_message(GTK_MESSAGE_ERROR
, err
);
611 sqlite3_finalize(stmt
);
615 while (sqlite3_step(stmt
) == SQLITE_ROW
) {
616 Row
* row
= row_new();
617 row
->sn
= g_strdup((const gchar
*)sqlite3_column_text(stmt
, 0));
618 row
->data
= g_strdup((const gchar
*)sqlite3_column_text(stmt
, 1));
619 row
->notes
= g_strdup((const gchar
*)sqlite3_column_text(stmt
, 2));
620 row
->id
= sqlite3_column_int64(stmt
, 3);
621 lenses
= g_slist_append(lenses
, row
);
624 sqlite3_finalize(stmt
);
629 GSList
* get_lens_by_search(const Row
* row
) {
632 GSList
* lenses
= NULL
;
637 if (row
->notes
&& row
->data
) {
638 sql
= g_strconcat(search
, " where ",
639 "upper(m.maker) like '%' || upper(?1) || '%' and upper(l.description) like '%' || upper(?2) || '%'",
641 bind1
= g_strdup(row
->notes
);
642 bind2
= g_strdup(row
->data
);
643 } else if (!row
->notes
&& !row
->data
) {
644 sql
= g_strconcat(search
, NULL
);
647 sql
= g_strconcat(search
, " where upper(m.maker) like '%' || upper(?1) || '%'", NULL
);
648 bind1
= g_strdup(row
->notes
);
650 sql
= g_strconcat(search
, " where upper(l.description) like '%' || upper(?1) || '%'", NULL
);
651 bind1
= g_strdup(row
->data
);
655 rc
= sqlite3_prepare_v2(db
, sql
, -1, &stmt
, 0);
656 if (rc
!= SQLITE_OK
) {
657 gchar
* err
= g_strdup_printf("Couldn't prepare sql statement: %s\n", sqlite3_errmsg(db
));
658 fprintf(stderr
, err
);
659 show_message(GTK_MESSAGE_ERROR
, err
);
661 sqlite3_finalize(stmt
);
666 rc
= sqlite3_bind_text(stmt
, 1, bind1
, -1, NULL
);
668 gchar
* err
= g_strdup_printf("Couldn't bind to prepared sql stmt: %s\n", sqlite3_errmsg(db
));
669 fprintf(stderr
, err
);
670 show_message(GTK_MESSAGE_ERROR
, err
);
672 sqlite3_finalize(stmt
);
678 rc
= sqlite3_bind_text(stmt
, 2, bind2
, -1, NULL
);
680 gchar
* err
= g_strdup_printf("Couldn't bind to prepared sql stmt: %s\n", sqlite3_errmsg(db
));
681 fprintf(stderr
, err
);
682 show_message(GTK_MESSAGE_ERROR
, err
);
684 sqlite3_finalize(stmt
);
689 while (sqlite3_step(stmt
) == SQLITE_ROW
) {
690 Row
* row
= row_new();
691 row
->id
= sqlite3_column_int64(stmt
, 0);
692 row
->sn
= g_strdup((const gchar
*)sqlite3_column_text(stmt
, 1));
693 row
->data
= g_strdup((const gchar
*)sqlite3_column_text(stmt
, 2));
694 row
->notes
= g_strdup((const gchar
*)sqlite3_column_text(stmt
, 3));
695 row
->maker
= sqlite3_column_int64(stmt
, 4);
696 lenses
= g_slist_append(lenses
, row
);
699 sqlite3_finalize(stmt
);
707 Row
* row
= g_new0(Row
, 1);
713 void row_free(gpointer data
, gpointer user_data
) {
714 Row
* row
= (Row
*) data
;
721 void dump_storage(CsvParser
* parser
) {
724 CvsError
* err
= NULL
;
726 if (parser
== NULL
) return;
728 rc
= sqlite3_prepare_v2(db
, all
, -1, &stmt
, 0);
729 if (rc
!= SQLITE_OK
) {
730 gchar
* err
= g_strdup_printf("Couldn't prepare sql statement: %s\n", sqlite3_errmsg(db
));
731 fprintf(stderr
, err
);
732 show_message(GTK_MESSAGE_ERROR
, err
);
734 sqlite3_finalize(stmt
);
738 Record
* row
= g_new0(Record
, 1);
739 row
->maker
= g_strdup("maker");
740 row
->sn
= g_strdup("sn");
741 row
->data
= g_strdup("lens");
742 row
->notes
= g_strdup("notes");
743 row
->date
= g_strdup("date");
744 csv_parser_dump_row(parser
, row
, &err
);
745 csv_record_free(row
);
747 gchar
* msg
= g_strdup_printf("%zu: %s\n", err
->line
, err
->message
);
748 fprintf(stderr
, msg
);
749 show_message(GTK_MESSAGE_ERROR
, msg
);
751 csv_error_clear(&err
);
752 sqlite3_finalize(stmt
);
756 while (sqlite3_step(stmt
) == SQLITE_ROW
) {
757 row
= g_new0(Record
, 1);
758 row
->maker
= g_strdup((const gchar
*)sqlite3_column_text(stmt
, 0));
759 row
->sn
= g_strdup((const gchar
*)sqlite3_column_text(stmt
, 1));
760 row
->data
= g_strdup((const gchar
*)sqlite3_column_text(stmt
, 2));
761 row
->notes
= g_strdup((const gchar
*)sqlite3_column_text(stmt
, 3));
762 row
->date
= g_strdup((const gchar
*)sqlite3_column_text(stmt
, 4));
763 csv_parser_dump_row(parser
, row
, &err
);
764 csv_record_free(row
);
766 gchar
* msg
= g_strdup_printf("%zu: %s\n", err
->line
, err
->message
);
767 fprintf(stderr
, msg
);
768 show_message(GTK_MESSAGE_ERROR
, msg
);
770 csv_error_clear(&err
);
771 sqlite3_finalize(stmt
);
776 sqlite3_finalize(stmt
);
779 gchar
* storage_get_path() {
780 gchar
* s
= (db_path
== NULL
) ? NULL
: g_strdup(db_path
);
This page took 1.336161 seconds and 6 git commands to generate.