dbutils/class.c

Thu, 27 Feb 2025 20:25:54 +0100

author
Olaf Wintermann <olaf.wintermann@gmail.com>
date
Thu, 27 Feb 2025 20:25:54 +0100
changeset 17
23e678e6c917
parent 11
0aa8cbd7912e
permissions
-rw-r--r--

add wrapper for DBUResult fptrs

0
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
1 /*
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
2 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
3 *
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
4 * Copyright 2024 Olaf Wintermann. All rights reserved.
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
5 *
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
6 * Redistribution and use in source and binary forms, with or without
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
7 * modification, are permitted provided that the following conditions are met:
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
8 *
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
9 * 1. Redistributions of source code must retain the above copyright
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
10 * notice, this list of conditions and the following disclaimer.
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
11 *
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
12 * 2. Redistributions in binary form must reproduce the above copyright
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
13 * notice, this list of conditions and the following disclaimer in the
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
14 * documentation and/or other materials provided with the distribution.
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
15 *
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
16 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
17 * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
18 * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
19 * ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
20 * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
21 * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
22 * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
23 * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
24 * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
25 * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
26 * POSSIBILITY OF SUCH DAMAGE.
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
27 */
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
28
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
29 #include "class.h"
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
30 #include "field.h"
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
31
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
32 #include <string.h>
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
33 #include <stdlib.h>
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
34
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
35 #include <cx/hash_map.h>
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
36
2
4c12c95f4846 extend DBUField and implement dbuClassFree
Olaf Wintermann <olaf.wintermann@gmail.com>
parents: 0
diff changeset
37 static void field_destructor(DBUField *f) {
4c12c95f4846 extend DBUField and implement dbuClassFree
Olaf Wintermann <olaf.wintermann@gmail.com>
parents: 0
diff changeset
38 if(f->destructor) {
4c12c95f4846 extend DBUField and implement dbuClassFree
Olaf Wintermann <olaf.wintermann@gmail.com>
parents: 0
diff changeset
39 f->destructor(f);
4c12c95f4846 extend DBUField and implement dbuClassFree
Olaf Wintermann <olaf.wintermann@gmail.com>
parents: 0
diff changeset
40 }
4c12c95f4846 extend DBUField and implement dbuClassFree
Olaf Wintermann <olaf.wintermann@gmail.com>
parents: 0
diff changeset
41 free(f);
4c12c95f4846 extend DBUField and implement dbuClassFree
Olaf Wintermann <olaf.wintermann@gmail.com>
parents: 0
diff changeset
42 }
4c12c95f4846 extend DBUField and implement dbuClassFree
Olaf Wintermann <olaf.wintermann@gmail.com>
parents: 0
diff changeset
43
0
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
44 DBUClass* dbuClassCreate(const char *name) {
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
45 DBUClass *cls = malloc(sizeof(DBUClass));
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
46 memset(cls, 0, sizeof(DBUClass));
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
47
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
48 cls->name = cx_strdup(cx_str(name));
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
49 cls->fields = cxHashMapCreateSimple(CX_STORE_POINTERS);
2
4c12c95f4846 extend DBUField and implement dbuClassFree
Olaf Wintermann <olaf.wintermann@gmail.com>
parents: 0
diff changeset
50 cls->fields->collection.simple_destructor = (cx_destructor_func)field_destructor;
4
1908c8b1599f add new object builder API
Olaf Wintermann <olaf.wintermann@gmail.com>
parents: 2
diff changeset
51 cls->obj_fields = cxHashMapCreateSimple(CX_STORE_POINTERS);
1908c8b1599f add new object builder API
Olaf Wintermann <olaf.wintermann@gmail.com>
parents: 2
diff changeset
52 cls->obj_fields->collection.simple_destructor = (cx_destructor_func)field_destructor;
7
c98ff52cd806 prepare for list members
Olaf Wintermann <olaf.wintermann@gmail.com>
parents: 4
diff changeset
53 cls->foreign_keys = cxHashMapCreateSimple(sizeof(DBUForeignKeyField));
0
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
54
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
55 return cls;
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
56 }
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
57
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
58 void dbuClassFree(DBUClass *cls) {
11
0aa8cbd7912e refactor dbuObjectExecuteQuery: replace multiple lists with a single ll list
Olaf Wintermann <olaf.wintermann@gmail.com>
parents: 8
diff changeset
59 cxMapFree(cls->fields);
2
4c12c95f4846 extend DBUField and implement dbuClassFree
Olaf Wintermann <olaf.wintermann@gmail.com>
parents: 0
diff changeset
60 free(cls->name.ptr);
4c12c95f4846 extend DBUField and implement dbuClassFree
Olaf Wintermann <olaf.wintermann@gmail.com>
parents: 0
diff changeset
61 free(cls->primary_key_column.ptr);
4c12c95f4846 extend DBUField and implement dbuClassFree
Olaf Wintermann <olaf.wintermann@gmail.com>
parents: 0
diff changeset
62 free(cls);
0
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
63 }
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
64
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
65 void dbuClassAddField(DBUClass *cls, const char *name, DBUField *field) {
4
1908c8b1599f add new object builder API
Olaf Wintermann <olaf.wintermann@gmail.com>
parents: 2
diff changeset
66 free(field->name.ptr);
1908c8b1599f add new object builder API
Olaf Wintermann <olaf.wintermann@gmail.com>
parents: 2
diff changeset
67 field->name = cx_strdup(cx_str(name));
0
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
68 cxMapPut(cls->fields, name, field);
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
69 }
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
70
7
c98ff52cd806 prepare for list members
Olaf Wintermann <olaf.wintermann@gmail.com>
parents: 4
diff changeset
71 void dbuClassAddFKField(DBUClass *cls, const char *name, DBUField *field, DBUClass *fkcls) {
c98ff52cd806 prepare for list members
Olaf Wintermann <olaf.wintermann@gmail.com>
parents: 4
diff changeset
72 DBUForeignKeyField val;
c98ff52cd806 prepare for list members
Olaf Wintermann <olaf.wintermann@gmail.com>
parents: 4
diff changeset
73 val.field = field;
c98ff52cd806 prepare for list members
Olaf Wintermann <olaf.wintermann@gmail.com>
parents: 4
diff changeset
74 val.cls = fkcls;
c98ff52cd806 prepare for list members
Olaf Wintermann <olaf.wintermann@gmail.com>
parents: 4
diff changeset
75 field->foreignKeyClass = fkcls;
c98ff52cd806 prepare for list members
Olaf Wintermann <olaf.wintermann@gmail.com>
parents: 4
diff changeset
76 cxMapPut(cls->foreign_keys, name, &val);
8
bd08116b8af4 add support for list members to the object builder
Olaf Wintermann <olaf.wintermann@gmail.com>
parents: 7
diff changeset
77 dbuClassAddField(cls, name, field);
7
c98ff52cd806 prepare for list members
Olaf Wintermann <olaf.wintermann@gmail.com>
parents: 4
diff changeset
78 }
c98ff52cd806 prepare for list members
Olaf Wintermann <olaf.wintermann@gmail.com>
parents: 4
diff changeset
79
4
1908c8b1599f add new object builder API
Olaf Wintermann <olaf.wintermann@gmail.com>
parents: 2
diff changeset
80 void dbuClassAddObjField(DBUClass *cls, const char *name, DBUField *field, DBUClass *foreign_cls) {
1908c8b1599f add new object builder API
Olaf Wintermann <olaf.wintermann@gmail.com>
parents: 2
diff changeset
81 free(field->name.ptr);
7
c98ff52cd806 prepare for list members
Olaf Wintermann <olaf.wintermann@gmail.com>
parents: 4
diff changeset
82 field->name = name ? cx_strdup(cx_str(name)) : (cxmutstr){NULL,0};
4
1908c8b1599f add new object builder API
Olaf Wintermann <olaf.wintermann@gmail.com>
parents: 2
diff changeset
83 cxMapPut(cls->obj_fields, foreign_cls->name, field);
1908c8b1599f add new object builder API
Olaf Wintermann <olaf.wintermann@gmail.com>
parents: 2
diff changeset
84 }
0
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
85
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
86
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
87 void dbuClassSetPrimaryKeyInt32(DBUClass *cls, const char *column_name, off_t offset) {
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
88 cls->primary_key_column = cx_strdup(cx_str(column_name));
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
89 cls->primary_key = dbuFieldCreateInt32(offset);
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
90 dbuClassAddField(cls, column_name, cls->primary_key);
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
91 }
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
92
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
93 void dbuClassSetPrimaryKeyUInt32(DBUClass *cls, const char *column_name, off_t offset) {
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
94 cls->primary_key_column = cx_strdup(cx_str(column_name));
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
95 cls->primary_key = dbuFieldCreateUInt32(offset);
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
96 dbuClassAddField(cls, column_name, cls->primary_key);
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
97 }
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
98
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
99 void dbuClassSetPrimaryKeyInt64(DBUClass *cls, const char *column_name, off_t offset) {
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
100 cls->primary_key_column = cx_strdup(cx_str(column_name));
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
101 cls->primary_key = dbuFieldCreateInt64(offset);
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
102 dbuClassAddField(cls, column_name, cls->primary_key);
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
103 }
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
104
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
105 void dbuClassSetPrimaryKeyUInt64(DBUClass *cls, const char *column_name, off_t offset) {
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
106 cls->primary_key_column = cx_strdup(cx_str(column_name));
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
107 cls->primary_key = dbuFieldCreateInt64(offset);
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
108 dbuClassAddField(cls, column_name, cls->primary_key);
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
109 }
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
110
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
111 void dbuClassSetPrimaryKeyString(DBUClass *cls, const char *column_name, off_t offset) {
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
112 cls->primary_key_column = cx_strdup(cx_str(column_name));
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
113 cls->primary_key = dbuFieldCreateString(offset);
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
114 dbuClassAddField(cls, column_name, cls->primary_key);
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
115 }
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
116
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
117 void dbuClassSetPrimaryKeyCxMutStr(DBUClass *cls, const char *column_name, off_t offset) {
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
118 cls->primary_key_column = cx_strdup(cx_str(column_name));
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
119 cls->primary_key = dbuFieldCreateCxMutStr(offset);
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
120 dbuClassAddField(cls, column_name, cls->primary_key);
1a157da63d7c add API for registering types and simple SQLite proof of concept
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
121 }

mercurial