askrobots / dbbasic Public

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

0 downloads

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
tasks_crud.yaml · 1.3 KB · 72 lines
1# DBBasic Project Management Template - Tasks
2resource: tasks
3database: projects.db
4
5fields:
6 id:
7 type: primary_key
8 title:
9 type: string
10 required: true
11 max_length: 200
12 searchable: true
13 description:
14 type: text
15 ui:
16 component: textarea
17 rows: 4
18 status:
19 type: select
20 options: [todo, in_progress, review, testing, done, blocked]
21 default: todo
22 ui:
23 variant: kanban_card
24 priority:
25 type: select
26 options: [low, medium, high, critical]
27 default: medium
28 project_id:
29 type: foreign_key
30 references: projects
31 required: true
32 assigned_to:
33 type: foreign_key
34 references: users
35 estimated_hours:
36 type: decimal
37 precision: 5
38 scale: 2
39 ui:
40 suffix: "hrs"
41 actual_hours:
42 type: decimal
43 precision: 5
44 scale: 2
45 default: 0
46 ui:
47 suffix: "hrs"
48 due_date:
49 type: date
50 completed_at:
51 type: timestamp
52 created_at:
53 type: timestamp
54 auto_now_add: true
55 updated_at:
56 type: timestamp
57 auto_now: true
58
59hooks:
60 before_create: validate_task_data
61 after_create: notify_assignee
62 before_update: track_time_changes
63 after_update: update_project_progress
64
65ui:
66 theme: bootstrap
67 variant: kanban
68 components:
69 list:
70 variant: kanban_board
71 group_by: status
72 drag_drop: true