askrobots / dbbasic Public

Model-config web apps: describe the app in configuration instead of writing code. Built on Polars and DuckDB.

0 downloads

dbbasic/customers_backup.json
Download zip
Clone
Clone with git
git clone https://gitstable.com/git/askrobots/dbbasic.git
HTTPS
https://gitstable.com/git/askrobots/dbbasic.git
SSH
ssh://git@gitstable.com:2222/askrobots/dbbasic.git

Cloning needs no sign-in. Pushing over HTTPS asks for your username and an access token. SSH needs your key under SSH keys.

danq9 Add DBBasic crate engine logo and update README 0d628db 1 year, 2 months ago History
customers_backup.json · 2.7 KB · 125 lines
1{
2 "resource": "customers",
3 "exported_at": "2025-09-19T18:03:41.099834",
4 "config": {
5 "resource": "customers",
6 "database": "customers.db",
7 "fields": {
8 "id": {
9 "type": "primary_key"
10 },
11 "name": {
12 "type": "string",
13 "required": true,
14 "searchable": true,
15 "max_length": 100
16 },
17 "email": {
18 "type": "email",
19 "unique": true,
20 "searchable": true,
21 "required": true
22 },
23 "phone": {
24 "type": "string",
25 "max_length": 20
26 },
27 "credit_limit": {
28 "type": "decimal",
29 "min": 0,
30 "max": 100000,
31 "default": 1000
32 },
33 "status": {
34 "type": "select",
35 "options": [
36 "active",
37 "inactive",
38 "pending"
39 ],
40 "default": "active"
41 },
42 "created_at": {
43 "type": "timestamp",
44 "auto_now_add": true
45 },
46 "updated_at": {
47 "type": "timestamp",
48 "auto_now": true
49 }
50 },
51 "interface": {
52 "list_display": [
53 "name",
54 "email",
55 "status",
56 "credit_limit",
57 "created_at"
58 ],
59 "search_fields": [
60 "name",
61 "email"
62 ],
63 "filters": [
64 "status",
65 "created_at"
66 ],
67 "actions": [
68 "export_csv",
69 "bulk_delete"
70 ],
71 "per_page": 25
72 },
73 "hooks": {
74 "before_create": "validate_business_rules",
75 "after_create": "send_welcome_email",
76 "before_update": "check_permissions",
77 "after_update": "sync_to_crm",
78 "before_delete": "check_dependencies"
79 },
80 "permissions": {
81 "create": "authenticated",
82 "read": "public",
83 "update": "owner_or_admin",
84 "delete": "admin_only"
85 },
86 "api": {
87 "base_path": "/api/customers",
88 "enable_bulk": true,
89 "enable_export": true
90 }
91 },
92 "total_records": 3,
93 "records": [
94 {
95 "id": 2,
96 "name": "John Doe",
97 "email": "john.doe@example.com",
98 "phone": "555-0123",
99 "credit_limit": "5000.00",
100 "status": "active",
101 "created_at": "2025-09-19 17:58:16.363415",
102 "updated_at": "2025-09-19 17:58:16.363415"
103 },
104 {
105 "id": 3,
106 "name": "Duplicate Test",
107 "email": "duplicate@example.com",
108 "phone": null,
109 "credit_limit": "1000.00",
110 "status": "active",
111 "created_at": "2025-09-19 17:58:16.377775",
112 "updated_at": "2025-09-19 17:58:16.377775"
113 },
114 {
115 "id": 4,
116 "name": "Hook Test Customer",
117 "email": "hooktest@example.com",
118 "phone": null,
119 "credit_limit": "1000.00",
120 "status": "active",
121 "created_at": "2025-09-19 17:58:21.422267",
122 "updated_at": "2025-09-19 17:58:21.422267"
123 }
124 ]
125}