]>
git.datanom.net - lensdb.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";
50 void close_storage() {
55 gint
init_storage(const gchar
* path
) {
56 gboolean init_db
= FALSE
;
60 gchar
* file
= g_strconcat(path
, "/", DBNAME
, NULL
);
61 if (!g_file_test(file
, G_FILE_TEST_EXISTS
)) {
64 rc
= sqlite3_open(file
, &db
);
68 gchar
* err
= g_strdup_printf("Failed to open DB: %s\n", sqlite3_errmsg(db
));
70 show_message(GTK_MESSAGE_ERROR
, err
);
76 rc
= sqlite3_exec(db
, "PRAGMA foreign_keys = ON", 0, 0, &ErrMsg
);
77 if (rc
!= SQLITE_OK
) {
78 gchar
* err
= g_strdup_printf("SQL error: %s\n", ErrMsg
);
80 show_message(GTK_MESSAGE_ERROR
, err
);
85 rc
= sqlite3_exec(db
, lensmaker
, 0, 0, &ErrMsg
);
86 if (rc
!= SQLITE_OK
) {
87 gchar
* err
= g_strdup_printf("SQL error: %s\n", ErrMsg
);
89 show_message(GTK_MESSAGE_ERROR
, err
);
94 rc
= sqlite3_exec(db
, lens
, 0, 0, &ErrMsg
);
95 if (rc
!= SQLITE_OK
) {
96 gchar
* err
= g_strdup_printf("SQL error: %s\n", ErrMsg
);
98 show_message(GTK_MESSAGE_ERROR
, err
);
100 sqlite3_free(ErrMsg
);
107 gint
add_lens(Row
* row
) {
112 rc
= sqlite3_prepare_v2(db
, "insert into lens (sn, maker, description, notes) values (?1, ?2, ?3, ?4) returning id", -1, &stmt
, 0);
113 if (rc
!= SQLITE_OK
) {
114 gchar
* err
= g_strdup_printf("Couldn't prepare sql statement: %s\n", sqlite3_errmsg(db
));
115 fprintf(stderr
, err
);
116 show_message(GTK_MESSAGE_ERROR
, err
);
118 sqlite3_finalize(stmt
);
122 rc
= sqlite3_bind_text(stmt
, 1, row
->sn
, -1, NULL
);
124 gchar
* err
= g_strdup_printf("Couldn't bind to prepared sql stmt: %s\n", sqlite3_errmsg(db
));
125 fprintf(stderr
, err
);
126 show_message(GTK_MESSAGE_ERROR
, err
);
128 sqlite3_finalize(stmt
);
132 rc
= sqlite3_bind_int(stmt
, 2, row
->maker
);
134 gchar
* err
= g_strdup_printf("Couldn't bind to prepared sql stmt: %s\n", sqlite3_errmsg(db
));
135 fprintf(stderr
, err
);
136 show_message(GTK_MESSAGE_ERROR
, err
);
138 sqlite3_finalize(stmt
);
142 rc
= sqlite3_bind_text(stmt
, 3, row
->data
, -1, NULL
);
144 gchar
* err
= g_strdup_printf("Couldn't bind to prepared sql stmt: %s\n", sqlite3_errmsg(db
));
145 fprintf(stderr
, err
);
146 show_message(GTK_MESSAGE_ERROR
, err
);
148 sqlite3_finalize(stmt
);
152 rc
= sqlite3_bind_text(stmt
, 4, row
->notes
, -1, NULL
);
154 gchar
* err
= g_strdup_printf("Couldn't bind to prepared sql stmt: %s\n", sqlite3_errmsg(db
));
155 fprintf(stderr
, err
);
156 show_message(GTK_MESSAGE_ERROR
, err
);
158 sqlite3_finalize(stmt
);
162 rc
= sqlite3_step(stmt
);
163 if (rc
!= SQLITE_ROW
) {
164 gchar
* err
= g_strdup_printf("Step failure: %s\n", sqlite3_errmsg(db
));
165 fprintf(stderr
, err
);
166 show_message(GTK_MESSAGE_ERROR
, err
);
169 row
->id
= sqlite3_column_int64(stmt
, 0);
173 sqlite3_finalize(stmt
);
178 gint
update_lens(const Row
* row
) {
183 rc
= sqlite3_prepare_v2(db
, "update lens set sn = ?1, description = ?2, notes = ?3 where id = ?4", -1, &stmt
, 0);
184 if (rc
!= SQLITE_OK
) {
185 gchar
* err
= g_strdup_printf("Couldn't prepare sql statement: %s\n", sqlite3_errmsg(db
));
186 fprintf(stderr
, err
);
187 show_message(GTK_MESSAGE_ERROR
, err
);
189 sqlite3_finalize(stmt
);
193 rc
= sqlite3_bind_text(stmt
, 1, row
->sn
, -1, NULL
);
195 gchar
* err
= g_strdup_printf("Couldn't bind to prepared sql stmt: %s\n", sqlite3_errmsg(db
));
196 fprintf(stderr
, err
);
197 show_message(GTK_MESSAGE_ERROR
, err
);
199 sqlite3_finalize(stmt
);
203 rc
= sqlite3_bind_text(stmt
, 2, row
->data
, -1, NULL
);
205 gchar
* err
= g_strdup_printf("Couldn't bind to prepared sql stmt: %s\n", sqlite3_errmsg(db
));
206 fprintf(stderr
, err
);
207 show_message(GTK_MESSAGE_ERROR
, err
);
209 sqlite3_finalize(stmt
);
213 rc
= sqlite3_bind_text(stmt
, 3, row
->notes
, -1, NULL
);
215 gchar
* err
= g_strdup_printf("Couldn't bind to prepared sql stmt: %s\n", sqlite3_errmsg(db
));
216 fprintf(stderr
, err
);
217 show_message(GTK_MESSAGE_ERROR
, err
);
219 sqlite3_finalize(stmt
);
223 rc
= sqlite3_bind_int64(stmt
, 4, row
->id
);
225 gchar
* err
= g_strdup_printf("Couldn't bind to prepared sql stmt: %s\n", sqlite3_errmsg(db
));
226 fprintf(stderr
, err
);
227 show_message(GTK_MESSAGE_ERROR
, err
);
229 sqlite3_finalize(stmt
);
233 rc
= sqlite3_step(stmt
);
234 if (rc
!= SQLITE_DONE
) {
235 gchar
* err
= g_strdup_printf("Step failure: %s\n", sqlite3_errmsg(db
));
236 fprintf(stderr
, err
);
237 show_message(GTK_MESSAGE_ERROR
, err
);
243 sqlite3_finalize(stmt
);
248 gint
update_lens_maker(const Row
* row
) {
253 rc
= sqlite3_prepare_v2(db
, "update lens set maker = ?1 where id = ?2", -1, &stmt
, 0);
254 if (rc
!= SQLITE_OK
) {
255 gchar
* err
= g_strdup_printf("Couldn't prepare sql statement: %s\n", sqlite3_errmsg(db
));
256 fprintf(stderr
, err
);
257 show_message(GTK_MESSAGE_ERROR
, err
);
259 sqlite3_finalize(stmt
);
263 rc
= sqlite3_bind_int64(stmt
, 1, row
->maker
);
265 gchar
* err
= g_strdup_printf("Couldn't bind to prepared sql stmt: %s\n", sqlite3_errmsg(db
));
266 fprintf(stderr
, err
);
267 show_message(GTK_MESSAGE_ERROR
, err
);
269 sqlite3_finalize(stmt
);
273 rc
= sqlite3_bind_int64(stmt
, 2, row
->id
);
275 gchar
* err
= g_strdup_printf("Couldn't bind to prepared sql stmt: %s\n", sqlite3_errmsg(db
));
276 fprintf(stderr
, err
);
277 show_message(GTK_MESSAGE_ERROR
, err
);
279 sqlite3_finalize(stmt
);
283 rc
= sqlite3_step(stmt
);
284 if (rc
!= SQLITE_DONE
) {
285 gchar
* err
= g_strdup_printf("Step failure: %s\n", sqlite3_errmsg(db
));
286 fprintf(stderr
, err
);
287 show_message(GTK_MESSAGE_ERROR
, err
);
293 sqlite3_finalize(stmt
);
298 gint
delete_lens(const Row
* row
) {
303 rc
= sqlite3_prepare_v2(db
, "delete from lens where id = ?1", -1, &stmt
, 0);
304 if (rc
!= SQLITE_OK
) {
305 gchar
* err
= g_strdup_printf("Couldn't prepare sql statement: %s\n", sqlite3_errmsg(db
));
306 fprintf(stderr
, err
);
307 show_message(GTK_MESSAGE_ERROR
, err
);
309 sqlite3_finalize(stmt
);
313 rc
= sqlite3_bind_int64(stmt
, 1, row
->id
);
315 gchar
* err
= g_strdup_printf("Couldn't bind to prepared sql stmt: %s\n", sqlite3_errmsg(db
));
316 fprintf(stderr
, err
);
317 show_message(GTK_MESSAGE_ERROR
, err
);
319 sqlite3_finalize(stmt
);
323 rc
= sqlite3_step(stmt
);
324 if (rc
!= SQLITE_DONE
) {
325 gchar
* err
= g_strdup_printf("Step failure: %s\n", sqlite3_errmsg(db
));
326 fprintf(stderr
, err
);
327 show_message(GTK_MESSAGE_ERROR
, err
);
333 sqlite3_finalize(stmt
);
338 gint
add_maker(const gchar
* maker
, gchar
** error
) {
343 rc
= sqlite3_prepare_v2(db
, "insert into lensmaker (maker) values (?1) returning id", -1, &stmt
, 0);
344 if (rc
!= SQLITE_OK
) {
345 gchar
* err
= g_strdup_printf("Couldn't prepare sql statement: %s\n", sqlite3_errmsg(db
));
346 fprintf(stderr
, err
);
347 show_message(GTK_MESSAGE_ERROR
, err
);
350 *error
= g_strdup(sqlite3_errmsg(db
));
351 sqlite3_finalize(stmt
);
355 rc
= sqlite3_bind_text(stmt
, 1, maker
, -1, NULL
);
357 gchar
* err
= g_strdup_printf("Couldn't bind to prepared sql stmt: %s\n", sqlite3_errmsg(db
));
358 fprintf(stderr
, err
);
359 show_message(GTK_MESSAGE_ERROR
, err
);
362 *error
= g_strdup(sqlite3_errmsg(db
));
363 sqlite3_finalize(stmt
);
367 rc
= sqlite3_step(stmt
);
368 if (rc
!= SQLITE_ROW
) {
369 gchar
* err
= g_strdup_printf("Couldn't insert maker: %s\n", sqlite3_errmsg(db
));
370 fprintf(stderr
, err
);
371 show_message(GTK_MESSAGE_ERROR
, err
);
374 *error
= g_strdup(sqlite3_errmsg(db
));
376 id
= sqlite3_column_int64(stmt
, 0);
379 sqlite3_finalize(stmt
);
384 Maker
* get_maker(gint id
) {
389 rc
= sqlite3_prepare_v2(db
, "select maker, page from lensmaker where id = ?1", -1, &stmt
, 0);
390 if (rc
!= SQLITE_OK
) {
391 gchar
* err
= g_strdup_printf("Couldn't prepare sql statement: %s\n", sqlite3_errmsg(db
));
392 fprintf(stderr
, err
);
393 show_message(GTK_MESSAGE_ERROR
, err
);
395 sqlite3_finalize(stmt
);
399 rc
= sqlite3_bind_int64(stmt
, 1, id
);
401 gchar
* err
= g_strdup_printf("Couldn't bind to prepared sql stmt: %s\n", sqlite3_errmsg(db
));
402 fprintf(stderr
, err
);
403 show_message(GTK_MESSAGE_ERROR
, err
);
405 sqlite3_finalize(stmt
);
409 if (sqlite3_step(stmt
) == SQLITE_ROW
) {
410 maker
= g_new0(Maker
, 1);
412 maker
->maker_name
= g_strdup((const gchar
*)sqlite3_column_text(stmt
, 0));
413 maker
->page
= sqlite3_column_int(stmt
, 1);
416 sqlite3_finalize(stmt
);
421 void update_maker(const Maker
* maker
) {
425 rc
= sqlite3_prepare_v2(db
, "update lensmaker set page = ?1 where id = ?2", -1, &stmt
, 0);
426 if (rc
!= SQLITE_OK
) {
427 gchar
* err
= g_strdup_printf("Couldn't prepare sql statement: %s\n", sqlite3_errmsg(db
));
428 fprintf(stderr
, err
);
429 show_message(GTK_MESSAGE_ERROR
, err
);
431 sqlite3_finalize(stmt
);
435 rc
= sqlite3_bind_int(stmt
, 1, maker
->page
);
437 gchar
* err
= g_strdup_printf("Couldn't bind to prepared sql stmt: %s\n", sqlite3_errmsg(db
));
438 fprintf(stderr
, err
);
439 show_message(GTK_MESSAGE_ERROR
, err
);
441 sqlite3_finalize(stmt
);
445 rc
= sqlite3_bind_int64(stmt
, 2, maker
->id
);
447 gchar
* err
= g_strdup_printf("Couldn't bind to prepared sql stmt: %s\n", sqlite3_errmsg(db
));
448 fprintf(stderr
, err
);
449 show_message(GTK_MESSAGE_ERROR
, err
);
451 sqlite3_finalize(stmt
);
455 //fprintf(stderr, "%s\n", sqlite3_expanded_sql(stmt));
456 rc
= sqlite3_step(stmt
);
457 if (rc
!= SQLITE_DONE
) {
458 gchar
* err
= g_strdup_printf("Step failure: %s\n", sqlite3_errmsg(db
));
459 fprintf(stderr
, err
);
460 show_message(GTK_MESSAGE_ERROR
, err
);
462 sqlite3_finalize(stmt
);
465 sqlite3_finalize(stmt
);
468 void maker_free(Maker
* maker
) {
470 g_free(maker
->maker_name
);
475 gint
delete_maker(const gchar
* maker
, gchar
** error
) {
480 gint id
= get_maker_id(maker
);
481 rc
= sqlite3_prepare_v2(db
, "delete from lensmaker where id = ?1", -1, &stmt
, 0);
482 if (rc
!= SQLITE_OK
) {
483 gchar
* err
= g_strdup_printf("Couldn't prepare sql statement: %s\n", sqlite3_errmsg(db
));
484 fprintf(stderr
, err
);
485 show_message(GTK_MESSAGE_ERROR
, err
);
488 *error
= g_strdup(sqlite3_errmsg(db
));
489 sqlite3_finalize(stmt
);
494 rc
= sqlite3_bind_int(stmt
, 1, id
);
496 gchar
* err
= g_strdup_printf("Couldn't bind to prepared sql stmt: %s\n", sqlite3_errmsg(db
));
497 fprintf(stderr
, err
);
498 show_message(GTK_MESSAGE_ERROR
, err
);
501 *error
= g_strdup(sqlite3_errmsg(db
));
502 sqlite3_finalize(stmt
);
507 //fprintf(stderr, "%s\n", sqlite3_expanded_sql(stmt));
508 rc
= sqlite3_step(stmt
);
509 if (rc
!= SQLITE_DONE
) {
510 gchar
* err
= g_strdup_printf("Step failure: %s\n", sqlite3_errmsg(db
));
511 fprintf(stderr
, err
);
512 show_message(GTK_MESSAGE_ERROR
, err
);
515 *error
= g_strdup(sqlite3_errmsg(db
));
516 sqlite3_finalize(stmt
);
521 sqlite3_finalize(stmt
);
526 GSList
* get_makers() {
529 GSList
* makers
= NULL
;
531 rc
= sqlite3_prepare_v2(db
, "select maker from lensmaker order by id", -1, &stmt
, 0);
532 if (rc
!= SQLITE_OK
) {
533 gchar
* err
= g_strdup_printf("Failed to fetch data: %s\n", sqlite3_errmsg(db
));
534 fprintf(stderr
, err
);
535 show_message(GTK_MESSAGE_ERROR
, err
);
537 sqlite3_finalize(stmt
);
541 while (sqlite3_step(stmt
) == SQLITE_ROW
) {
542 gchar
* maker
= g_strdup((const gchar
*)sqlite3_column_text(stmt
, 0));
543 makers
= g_slist_append(makers
, maker
);
546 sqlite3_finalize(stmt
);
551 gint
get_maker_id(const gchar
* maker
) {
556 rc
= sqlite3_prepare_v2(db
, "select id from lensmaker where maker = ?1", -1, &stmt
, 0);
557 if (rc
!= SQLITE_OK
) {
558 gchar
* err
= g_strdup_printf("Couldn't prepare sql statement: %s\n", sqlite3_errmsg(db
));
559 fprintf(stderr
, err
);
560 show_message(GTK_MESSAGE_ERROR
, err
);
562 sqlite3_finalize(stmt
);
566 rc
= sqlite3_bind_text(stmt
, 1, maker
, -1, NULL
);
568 gchar
* err
= g_strdup_printf("Couldn't bind to prepared sql stmt: %s\n", sqlite3_errmsg(db
));
569 fprintf(stderr
, err
);
570 show_message(GTK_MESSAGE_ERROR
, err
);
572 sqlite3_finalize(stmt
);
576 if (sqlite3_step(stmt
) == SQLITE_ROW
) {
577 id
= sqlite3_column_int64(stmt
, 0);
580 sqlite3_finalize(stmt
);
585 GSList
* get_lens_by_maker(gint id
) {
588 GSList
* lenses
= NULL
;
590 rc
= sqlite3_prepare_v2(db
, "select sn, description, notes, id from lens where maker = ?1", -1, &stmt
, 0);
591 if (rc
!= SQLITE_OK
) {
592 gchar
* err
= g_strdup_printf("Couldn't prepare sql statement: %s\n", sqlite3_errmsg(db
));
593 fprintf(stderr
, err
);
594 show_message(GTK_MESSAGE_ERROR
, err
);
596 sqlite3_finalize(stmt
);
600 rc
= sqlite3_bind_int64(stmt
, 1, id
);
602 gchar
* err
= g_strdup_printf("Couldn't bind to prepared sql stmt: %s\n", sqlite3_errmsg(db
));
603 fprintf(stderr
, err
);
604 show_message(GTK_MESSAGE_ERROR
, err
);
606 sqlite3_finalize(stmt
);
610 while (sqlite3_step(stmt
) == SQLITE_ROW
) {
611 Row
* row
= row_new();
612 row
->sn
= g_strdup((const gchar
*)sqlite3_column_text(stmt
, 0));
613 row
->data
= g_strdup((const gchar
*)sqlite3_column_text(stmt
, 1));
614 row
->notes
= g_strdup((const gchar
*)sqlite3_column_text(stmt
, 2));
615 row
->id
= sqlite3_column_int64(stmt
, 3);
616 lenses
= g_slist_append(lenses
, row
);
619 sqlite3_finalize(stmt
);
624 GSList
* get_lens_by_search(const Row
* row
) {
627 GSList
* lenses
= NULL
;
632 if (row
->notes
&& row
->data
) {
633 sql
= g_strconcat(search
, " where ",
634 "upper(m.maker) like '%' || upper(?1) || '%' and upper(l.description) like '%' || upper(?2) || '%'",
636 bind1
= g_strdup(row
->notes
);
637 bind2
= g_strdup(row
->data
);
638 } else if (!row
->notes
&& !row
->data
) {
639 sql
= g_strconcat(search
, NULL
);
642 sql
= g_strconcat(search
, " where upper(m.maker) like '%' || upper(?1) || '%'", NULL
);
643 bind1
= g_strdup(row
->notes
);
645 sql
= g_strconcat(search
, " where upper(l.description) like '%' || upper(?1) || '%'", NULL
);
646 bind1
= g_strdup(row
->data
);
650 rc
= sqlite3_prepare_v2(db
, sql
, -1, &stmt
, 0);
651 if (rc
!= SQLITE_OK
) {
652 gchar
* err
= g_strdup_printf("Couldn't prepare sql statement: %s\n", sqlite3_errmsg(db
));
653 fprintf(stderr
, err
);
654 show_message(GTK_MESSAGE_ERROR
, err
);
656 sqlite3_finalize(stmt
);
661 rc
= sqlite3_bind_text(stmt
, 1, bind1
, -1, NULL
);
663 gchar
* err
= g_strdup_printf("Couldn't bind to prepared sql stmt: %s\n", sqlite3_errmsg(db
));
664 fprintf(stderr
, err
);
665 show_message(GTK_MESSAGE_ERROR
, err
);
667 sqlite3_finalize(stmt
);
673 rc
= sqlite3_bind_text(stmt
, 2, bind2
, -1, NULL
);
675 gchar
* err
= g_strdup_printf("Couldn't bind to prepared sql stmt: %s\n", sqlite3_errmsg(db
));
676 fprintf(stderr
, err
);
677 show_message(GTK_MESSAGE_ERROR
, err
);
679 sqlite3_finalize(stmt
);
684 while (sqlite3_step(stmt
) == SQLITE_ROW
) {
685 Row
* row
= row_new();
686 row
->id
= sqlite3_column_int64(stmt
, 0);
687 row
->sn
= g_strdup((const gchar
*)sqlite3_column_text(stmt
, 1));
688 row
->data
= g_strdup((const gchar
*)sqlite3_column_text(stmt
, 2));
689 row
->notes
= g_strdup((const gchar
*)sqlite3_column_text(stmt
, 3));
690 row
->maker
= sqlite3_column_int64(stmt
, 4);
691 lenses
= g_slist_append(lenses
, row
);
694 sqlite3_finalize(stmt
);
702 Row
* row
= g_new0(Row
, 1);
708 void row_free(gpointer data
, gpointer user_data
) {
709 Row
* row
= (Row
*) data
;
716 void dump_storage(CsvParser
* parser
) {
719 CvsError
* err
= NULL
;
721 if (parser
== NULL
) return;
723 rc
= sqlite3_prepare_v2(db
, all
, -1, &stmt
, 0);
724 if (rc
!= SQLITE_OK
) {
725 gchar
* err
= g_strdup_printf("Couldn't prepare sql statement: %s\n", sqlite3_errmsg(db
));
726 fprintf(stderr
, err
);
727 show_message(GTK_MESSAGE_ERROR
, err
);
729 sqlite3_finalize(stmt
);
733 Record
* row
= g_new0(Record
, 1);
734 row
->maker
= g_strdup("maker");
735 row
->sn
= g_strdup("sn");
736 row
->data
= g_strdup("lens");
737 row
->notes
= g_strdup("notes");
738 row
->date
= g_strdup("date");
739 csv_parser_dump_row(parser
, row
, &err
);
740 csv_record_free(row
);
742 gchar
* msg
= g_strdup_printf("%zu: %s\n", err
->line
, err
->message
);
743 fprintf(stderr
, msg
);
744 show_message(GTK_MESSAGE_ERROR
, msg
);
746 csv_error_clear(&err
);
747 sqlite3_finalize(stmt
);
751 while (sqlite3_step(stmt
) == SQLITE_ROW
) {
752 row
= g_new0(Record
, 1);
753 row
->maker
= g_strdup((const gchar
*)sqlite3_column_text(stmt
, 0));
754 row
->sn
= g_strdup((const gchar
*)sqlite3_column_text(stmt
, 1));
755 row
->data
= g_strdup((const gchar
*)sqlite3_column_text(stmt
, 2));
756 row
->notes
= g_strdup((const gchar
*)sqlite3_column_text(stmt
, 3));
757 row
->date
= g_strdup((const gchar
*)sqlite3_column_text(stmt
, 4));
758 csv_parser_dump_row(parser
, row
, &err
);
759 csv_record_free(row
);
761 gchar
* msg
= g_strdup_printf("%zu: %s\n", err
->line
, err
->message
);
762 fprintf(stderr
, msg
);
763 show_message(GTK_MESSAGE_ERROR
, msg
);
765 csv_error_clear(&err
);
766 sqlite3_finalize(stmt
);
771 sqlite3_finalize(stmt
);
This page took 1.589715 seconds and 6 git commands to generate.