This website requires JavaScript.
01e37a0e07
TMP: codetables
wispem/codetables
wispem-wantex
2026-03-19 23:36:51 -07:00
f8664ed514
schema: split 'column', 'index' and 'schema' into separate files from 'table'
wispem-wantex
2026-03-15 15:45:16 -07:00
8c29d455ff
codegen: fix defining the 'err' variable multiple times in foreign key checking test
master
~wispem-wantex
2026-02-14 18:33:41 -08:00
0f9a57dd85
codegen: fix more hardcoded "item" names in generated test file
~wispem-wantex
2026-02-14 18:33:41 -08:00
11fed4b9c7
refactor: create CamelToPascal string helper
~wispem-wantex
2026-02-14 18:33:41 -08:00
4e0836eb2e
codegen: fix test generator hardcoding test string in multiple places
~wispem-wantex
2026-02-14 18:33:41 -08:00
f82929f6e2
style: remove unused fmtErrorf var
~wispem-wantex
2026-02-14 18:33:41 -08:00
1bc7f9111f
codegen: implement "without rowid" tables
~wispem-wantex
2026-02-14 18:33:41 -08:00
c1150954e5
doc: update README
~wispem-wantex
2026-02-14 18:33:41 -08:00
fd90830340
doc: add README.md
~wispem-wantex
2026-02-14 18:33:41 -08:00
fcf266eb1d
tests: add integration test for blob fields
~wispem-wantex
2026-02-14 18:33:41 -08:00
29787b5521
fix: make codegen not fail for "blob" columns
~wispem-wantex
2026-02-14 18:33:41 -08:00
e53546a7f5
lint: fix several lll, wrapcheck, and copy-paste errors
wispem-wantex
2026-02-22 21:56:55 -08:00
c09a2fe1fb
tmp: grafana stuff
wispem-wantex
2026-02-19 21:40:02 -08:00
3e0a85fcfa
codegen: add unique index lookup funcs
wispem-wantex
2026-02-19 21:40:02 -08:00
d6426bba14
codegen: add ability to insert comments and blank lines into the generated code
wispem-wantex
2026-02-15 14:54:22 -08:00
8ab21edae9
codegen: move generated test helpers to new 'db_test.go' file
wispem-wantex
2026-02-15 14:48:49 -08:00
ee1d0a5ed7
codegen (refactor): move foreign key failure check lambda function generator to a helper func
wispem-wantex
2026-02-15 20:48:50 +00:00
93b589d1b2
codegen (refactor): compress whitespace
wispem-wantex
2026-02-15 20:48:02 +00:00
b0d95c5948
codegen: skip generating ID type for "without rowid" tables
wispem-wantex
2026-02-15 20:49:13 +00:00
85d544152f
schema: add PrimaryKeyColumns method to Table, useful for 'without rowid' tables
wispem-wantex
2026-02-15 20:49:35 +00:00
5cbb657666
codegen: add helpers
wispem-wantex
2026-01-31 20:35:03 -08:00
b8a024a4b9
doc: remove completed auto-timestamp and fk check TODO items
wispem-wantex
2026-01-31 20:35:03 -08:00
4cba2af670
codegen: more AST style improvements
wispem-wantex
2026-01-31 20:35:03 -08:00
04676461ff
doc: add TODOs
wispem-wantex
2026-01-31 20:35:03 -08:00
a36058fdbe
codegen (refactor): clean up helpers a bit
wispem-wantex
2026-01-31 20:35:03 -08:00
f0c152cfe4
codegen: add auto-timestamp checking to generated tests
wispem-wantex
2026-01-31 20:35:03 -08:00
5973a2a4b7
codegen: implement auto-timestamps for created_at and updated_at
wispem-wantex
2026-01-31 20:35:03 -08:00
75b7662c34
lint: fix lll and imports
wispem-wantex
2026-01-31 20:35:03 -08:00
229f41e478
schema: add tests to show that migrations can be validated
wispem-wantex
2026-01-31 20:35:03 -08:00
2e50736e67
schema: enable parsing a schema from an existing sqlx.DB instance
wispem-wantex
2026-01-31 20:35:03 -08:00
1c56661560
codegen: add foreign key error check test
wispem-wantex
2026-01-31 20:35:03 -08:00
3d357abb93
gitignore: ignore temporary / legacy files
wispem-wantex
2026-01-31 20:35:03 -08:00
a3da7573c1
codegen: slop out an AST generator for 'checkForeignKeyErrors' in 'SaveXyz()'
wispem-wantex
2026-01-31 18:29:25 -08:00
b96ab19bc2
refactor: create helper functions in model generator
wispem-wantex
2026-01-31 18:25:53 -08:00
cb8edd74c0
codegen: fix whitespace error in generated SQL
wispem-wantex
2026-01-29 10:54:58 -08:00
a0d0461f06
codegen: handle nullable foreign keys using 'ifnull' and add a test case for them
wispem-wantex
2026-01-26 16:00:19 -08:00
e85a68e69d
devcontainer: make it work on mac
wispem-wantex
2026-01-26 14:54:59 -08:00
eee6714918
codegen: style fixes ('int64' -> 'int', 'SELECT' -> 'select')
wispem-wantex
2026-01-26 14:53:04 -08:00
c08f12e275
ci: add fts5 build tag for tests
v0.0.1
wispem-wantex
2026-01-17 09:04:09 +09:00
0371fb4144
sqlite_lint: add support for FTS5 and virtual tables
wispem-wantex
2026-01-17 09:00:18 +09:00
d70cbc1913
doc: add instructions to run sqlite_lint
~wispem-wantex
2026-01-14 08:33:59 +09:00
ec19c3dcb5
doc: add entries for new 'rowid' related sqlite lint checks
~wispem-wantex
2026-01-14 08:33:59 +09:00
2df2c634cd
doc: add doc page for sqlite_lint
~wispem-wantex
2026-01-14 07:48:44 +09:00
45c9e15dd3
doc: add some more notes to the main info doc file
wispem-wantex
2026-01-10 17:39:08 -08:00
dc33bd84ff
docs: add a TODO; also add IsSqlitePrimaryKeyError and change ForeignKey interface to '~int'
wispem-wantex
2026-01-10 17:19:14 -08:00
2d29ce92ec
generator: make scaffolded db schema pass new sqlite_lint checks
wispem-wantex
2026-01-10 17:10:48 -08:00
a6cbbd3b39
tests: add test files for previous commit
wispem-wantex
2026-01-10 17:06:28 -08:00
2ac9d8e775
sqlite_lint: add lint checks for rowid and without rowid
wispem-wantex
2026-01-10 17:04:20 -08:00
560e461b00
lint: fixes
wispem-wantex
2026-01-10 16:09:41 -08:00
5c1e1dcb6a
generator: add GetAllXyzs() function
wispem-wantex
2026-01-10 16:06:48 -08:00
a05cad5144
lint: fix lll
wispem-wantex
2026-01-10 15:30:39 -08:00
e6a8175644
generator: use 'Must' flow helper in generated query funcs
wispem-wantex
2026-01-10 15:28:01 -08:00
195c8f980e
ci: make container build handle being built as 'root' correctly
wispem-wantex
2026-01-10 14:05:54 -08:00
8b674a0dea
ci: add sudo to bootstrap build container, in accordance with previous commit
wispem-wantex
2026-01-10 13:52:54 -08:00
13a6255553
ci: use devcontainer build script in CI. Also re-tag it as 'gas' instead of 'gas/ci' (which should be redundant)
wispem-wantex
2026-01-10 13:51:26 -08:00
e0e6046afe
devcontainer: add doc, user to match host machine, and scripts to build/start
wispem-wantex
2026-01-10 13:39:41 -08:00
381d648be0
doc: remove some completed TODO items
wispem-wantex
2025-12-12 23:19:44 -08:00
ded07eb182
model generator: add the 'const xyzSQLFields = ...' decl, use it in the select query for GetXyzByID
wispem-wantex
2025-12-12 23:19:14 -08:00
a32bf873c9
refactor: create helper function for computing a table's generated type-name
wispem-wantex
2025-12-12 22:37:29 -08:00
d9df69eccf
fix: correct lint errors in the generated sqlite schema
wispem-wantex
2025-12-12 22:11:03 -08:00
89db9e14e2
fix: parser no longer breaks on encountering indexes that contain expression columns
wispem-wantex
2025-12-12 21:54:46 -08:00
f74da53c37
refactor: use flowutils helpers instead of 'if err != nil'
wispem-wantex
2025-12-12 21:52:59 -08:00
6358d12d10
codegen: fix another typo in filename
wispem-wantex
2025-11-09 16:53:33 -08:00
1cbc99307a
codegen: fix typo in template file name
wispem-wantex
2025-11-09 16:48:13 -08:00
fef3f11342
Run the code generator integration test in CI
wispem-wantex
2025-11-09 16:44:59 -08:00
208c1eb26c
Add model generator based on AST
wispem-wantex
2025-11-09 16:34:46 -08:00
2146e1de77
test: add integration test for 'gas init'
wispem-wantex
2025-11-09 00:03:30 -08:00
a81dfb69a5
db: remove implicit singleton pattern, move functions under a struct object
wispem-wantex
2025-11-09 00:01:15 -08:00
bfb7073cf6
lint: fix shell lint errors
wispem-wantex
2025-11-08 23:57:37 -08:00
76f674d63b
ci: add shellcheck step
wispem-wantex
2025-11-08 23:56:31 -08:00
d1c00f9455
Run main build if backup (bootstrap) container build step is skipped
wispem-wantex
2025-11-08 23:29:40 -08:00
23dc2c7899
Improve job sequence dependencies some more
wispem-wantex
2025-11-08 23:17:31 -08:00
d0f919d69a
Add bash to CI container
wispem-wantex
2025-11-08 23:14:19 -08:00
8a1b7a9f34
Improve CI job dependency / ordering conditions
wispem-wantex
2025-11-08 23:12:47 -08:00
fef24e2364
Add more specific debugging to failing step
wispem-wantex
2025-11-08 23:09:51 -08:00
61fa4e5cc4
Fix: apparently double quotes are invalid around variables in gitea expressions
wispem-wantex
2025-11-08 23:08:48 -08:00
22ee5e181a
Add debugging to failing CI step
wispem-wantex
2025-11-08 23:06:37 -08:00
be351bbb7d
Add cheating bootstrap CI container, with gocheckout pre-installed
wispem-wantex
2025-11-08 23:05:38 -08:00
4c266ce336
Bump gocheckout version, and install it in the CI container
wispem-wantex
2025-11-08 22:27:41 -08:00
da85d89e9b
Install Go for bootstrap CI container
wispem-wantex
2025-11-08 22:09:45 -08:00
98c6875262
Build CI container in CI
wispem-wantex
2025-11-08 22:08:32 -08:00
912210cc90
Enable no-dot-import lint check
wispem-wantex
2025-11-08 19:59:59 -08:00
dbde3c8724
Avoid panicking in db.Connect and db.Create, as they are library functions
wispem-wantex
2025-11-08 19:36:55 -08:00
b7b581ff5a
Add Timestamp type for db
wispem-wantex
2025-11-08 19:36:10 -08:00
6a837d28c6
Add db/errors.go, move error definitions to it
wispem-wantex
2025-11-08 19:23:38 -08:00
8c6d8354df
Add 'ops/' directory and sqlite_lint integration test
wispem-wantex
2025-11-08 17:19:11 -08:00
6624b5794f
Add 3-letter names reference
wispem-wantex
2025-08-24 14:51:57 -07:00
2c8b842f17
Add package initialization subcommand and package
wispem-wantex
2025-08-24 14:45:57 -07:00
0bc951748d
Add a 'doc/links.txt' file
wispem-wantex
2025-08-24 14:44:22 -07:00
5a0ecdec1c
Update go.mod with new cobra dependency
wispem-wantex
2025-08-24 11:38:24 -07:00
e888fe0ec1
Add main program with 'sqlite_lint' subcommand
wispem-wantex
2025-08-24 11:37:23 -07:00
c402c775a3
Add flowutils
wispem-wantex
2025-08-23 20:24:34 -07:00
87f5471b76
Add doc folder
wispem-wantex
2025-08-23 19:00:51 -07:00
7449e7dc10
Fix lint error
wispem-wantex
2025-08-23 18:57:13 -07:00
100b53d799
Add Schema definition changes to support the linter functions
wispem-wantex
2025-08-23 18:55:13 -07:00
8b422ada11
Add sqlite-lint to 'pkg/schema/lint'
wispem-wantex
2025-08-23 18:54:00 -07:00
a4de16a1dd
Fix lint errors
wispem-wantex
2025-08-23 18:46:27 -07:00
53785b6e6e
Add lint config and build step
wispem-wantex
2025-08-23 18:19:22 -07:00
8245f89305
Add parsing of schema indexes
wispem-wantex
2025-08-23 16:55:02 -07:00