From 3c9cc7d383df019dacbd80480730723fe4b20b44 Mon Sep 17 00:00:00 2001 From: Thomas Schmucker Date: Sat, 11 Jul 2026 16:01:16 +0200 Subject: Infrastruktur hinzugefügt MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- db-test.c | 66 --------------------------------------------------------------- 1 file changed, 66 deletions(-) delete mode 100644 db-test.c (limited to 'db-test.c') diff --git a/db-test.c b/db-test.c deleted file mode 100644 index 2789ce0..0000000 --- a/db-test.c +++ /dev/null @@ -1,66 +0,0 @@ -#include -#include -#include -#include - -#include -#include - -typedef struct { - char username[20]; - char fullname[50]; - int age; -} user_type; - -int main(void) -{ - DB *db = dbopen("database.db", O_RDWR | O_CREAT, 0644, DB_BTREE, NULL); - if ( db != NULL ) { - fprintf(stderr, "Datenbank eröffnet...\n"); - -#if INSERT - user_type users[] = { - { "datengott", "Thomas Schmucker", 44 }, - { "user1", "Sabine Müller", 23 }, - { "sql-user", "SQL Database User", -1 } - }; - - for ( int i = 0; i != 3; ++i ) { - DBT data = { .data = &users[i], .size = sizeof(users[i]) }; - DBT key = { .data = &users[i].username, .size = sizeof(users[i].username) }; - - int res = db->put(db, &key, &data, 0); - if ( res == -1 ) { - fprintf(stderr, "failed to insert data!\n"); - } - } -#endif - -#if LOOKUP - { - DBT key = { .data = &users[0].username, .size = sizeof(users[0].username) }; - DBT data; - - int res = db->get(db, &key, &data, 0); - if ( res == 0 ) { - user_type *user = data.data; - printf("Fullname: %s, Age: %d\n", user->fullname, user->age); - } - } -#endif - - { - DBT key, data; - int err = db->seq(db, &key, &data, R_FIRST); - while ( !err ) { - user_type *user = data.data; - printf("Fullname: %s, Age: %d\n", user->fullname, user->age); - - err = db->seq(db, &key, &data, R_NEXT); - } - } - - db->close(db); - } - return EXIT_SUCCESS; -} -- cgit v1.3