3ab2795688
fix #97
...
CI / compile_and_lint (push) Has been cancelled
CI / test (mssql) (push) Has been cancelled
CI / test (mysql) (push) Has been cancelled
CI / test (postgres) (push) Has been cancelled
CI / windows_test (push) Has been cancelled
CI / docker_build (linux/amd64) (push) Has been cancelled
CI / docker_build (linux/arm/v7) (push) Has been cancelled
CI / docker_build (linux/arm64) (push) Has been cancelled
CI / docker_push (push) Has been cancelled
Create Release / build (target/superoptimized/sqlpage, macos-latest) (push) Has been cancelled
Create Release / build (target/superoptimized/sqlpage, ubuntu-20.04) (push) Has been cancelled
Create Release / build (target/superoptimized/sqlpage.exe, windows-latest) (push) Has been cancelled
Create Release / build-aws (push) Has been cancelled
Create Release / Create Release (push) Has been cancelled
New docker push ci was misconfigured
2023-10-08 09:14:33 +02:00
e286a10038
update rustix
2023-10-05 00:04:30 +02:00
1d354885e8
docker latest tag
2023-10-04 12:27:21 +02:00
b797cdadd2
allow customization of empty lists
2023-10-04 12:01:18 +02:00
3223929d24
change default working directory to /etc
2023-10-03 13:07:41 +02:00
632e8561e5
small code simplification
2023-10-03 12:53:47 +02:00
274b178beb
Include a default rw sqlite db in the docker image
...
Fixes https://github.com/lovasoa/SQLpage/issues/94
2023-10-03 12:51:41 +02:00
29af4eed69
improve tutorial
2023-10-03 12:33:14 +02:00
02b529712a
create the config dir if it does not exist
2023-10-03 12:04:33 +02:00
53eda07765
default db is now inaccessible by http by default
...
Create the default SQLite database file in the "sqlpage" config
directory instead of at the root of the web server by default.
see https://github.com/lovasoa/SQLpage/issues/94
2023-10-03 11:37:44 +02:00
995ea2d8af
fix redundant docker layer
2023-10-03 03:58:20 +02:00
43f705bb65
use docker registry cache
2023-10-03 03:48:20 +02:00
86339d0eac
fix docker hub push
2023-10-03 03:36:42 +02:00
942020f952
fix armv7 build
2023-10-03 03:24:12 +02:00
10d9ae00c2
remove unused install
2023-10-03 03:20:02 +02:00
8c2bb5a5e9
fix native rust build on exotic targets
2023-10-03 03:17:36 +02:00
ec738c4569
armv7
2023-10-03 02:59:29 +02:00
f5b369da8a
docker cross compilation
2023-10-03 02:56:24 +02:00
f6dfe8ca61
change docker platform
2023-10-03 00:14:03 +02:00
b26f75a6f4
update docker rust version
2023-10-03 00:13:46 +02:00
503252eb2c
faster docker builds with cache
2023-10-02 23:51:12 +02:00
5849f6a900
build docker images for arm
2023-10-02 23:26:56 +02:00
83f0d76512
clippy
2023-10-02 22:57:34 +02:00
7605d56353
reformat
2023-10-02 18:11:17 +02:00
3707ae5b6d
Improve error messages
...
Include the error position and the text of the sql statement that failed
when possible
2023-10-02 18:09:57 +02:00
ccbf8a96b4
Split the database module
2023-10-02 17:08:43 +02:00
2f2c850411
Split out database connection init
...
Connection to the db and pooling config now in their own file
2023-10-02 16:49:58 +02:00
cfef4e5b47
Split out database migration code
2023-10-02 16:42:52 +02:00
402488daae
improve migration error messages
docker / docker (push) Has been cancelled
Create Release / build (target/superoptimized/sqlpage, macos-latest) (push) Has been cancelled
Create Release / build (target/superoptimized/sqlpage, ubuntu-20.04) (push) Has been cancelled
Create Release / build (target/superoptimized/sqlpage.exe, windows-latest) (push) Has been cancelled
Create Release / build-aws (push) Has been cancelled
Create Release / Create Release (push) Has been cancelled
2023-10-01 03:39:12 +02:00
049b65ce25
fix markdown formatting
2023-10-01 03:08:36 +02:00
2ca68a54e3
remove confusing error message when a migration is invalid
2023-09-30 22:22:04 +02:00
e9f1beea9c
update dependencies
2023-09-30 22:06:17 +02:00
b332246d0d
connection initialization scripts
...
docker / docker (push) Has been cancelled
Create Release / build (target/superoptimized/sqlpage, macos-latest) (push) Has been cancelled
Create Release / build (target/superoptimized/sqlpage, ubuntu-20.04) (push) Has been cancelled
Create Release / build (target/superoptimized/sqlpage.exe, windows-latest) (push) Has been cancelled
Create Release / build-aws (push) Has been cancelled
Create Release / Create Release (push) Has been cancelled
add the ability to create a `sqlpage/on_connect.sql` file that will be run every time a new database connection is opened.
This has many interesting applications, see configuration.md
See https://github.com/lovasoa/SQLpage/discussions/48
2023-09-30 02:29:19 +02:00
5d9e1ea4f5
adapt to latest sqlparser
2023-09-29 21:33:54 +02:00
d36a79928a
Update sqlparser
...
* Support `==`operator for Sqlite
* Support mysql `PARTITION` to table selection
* Support `UNNEST` as a table factor for PostgreSQL
* Support MySQL `UNIQUE KEY` syntax
* Support` `GROUP BY ALL`
* Support multiple actions in one ALTER TABLE statement
2023-09-29 11:03:19 +02:00
37b8e95c0c
mark beta releases as pre-release on github
docker / docker (push) Has been cancelled
Create Release / build (target/superoptimized/sqlpage, macos-latest) (push) Has been cancelled
Create Release / build (target/superoptimized/sqlpage, ubuntu-20.04) (push) Has been cancelled
Create Release / build (target/superoptimized/sqlpage.exe, windows-latest) (push) Has been cancelled
Create Release / build-aws (push) Has been cancelled
Create Release / Create Release (push) Has been cancelled
2023-09-28 13:54:43 +02:00
cd9cfd4271
fix typo in documentation
2023-09-28 13:51:12 +02:00
c27404ff38
fix display issue for version numbers in the documentation
2023-09-28 13:49:53 +02:00
d6dfb039a8
fix handling of non-string variables
...
See https://github.com/lovasoa/SQLpage/discussions/73#discussioncomment-7127489
2023-09-28 10:00:35 +02:00
df5b414021
add tests for exec and url_encode
2023-09-27 22:31:39 +02:00
6d73076d7e
clippy
2023-09-27 20:39:09 +02:00
13823fbd54
new sqlpage.url_encode() function
2023-09-27 20:30:35 +02:00
2a0646de32
new function: sqlpage.exec
...
This is a game changer and allows many new usecases that were previously impossible:
sending emails, querying external APIs, integrating with external providers, launching custom scripts, and much more.
2023-09-27 17:22:41 +02:00
737a00ee02
new function: sqlpage.exec
...
allows launching external programs from sqlpage
2023-09-26 02:00:40 +02:00
56af280276
allow literals as parameters to hash_password
2023-09-24 21:53:26 +02:00
6adfe7c521
clippy
2023-09-24 20:03:00 +02:00
9dd33babd8
Easier configuration for multiple menu items. Syntax like SELECT 'shell' as component, '["page 1", "page 2"]' as menu_item' now works as expected.
2023-09-24 19:03:22 +02:00
d21d74b249
asynchronous password hashing
2023-09-21 00:23:36 +02:00
3943ff5506
async sqlpage pseudo-function execution
2023-09-21 00:00:48 +02:00
3040c802e8
v0.12
docker / docker (push) Has been cancelled
Create Release / build (target/superoptimized/sqlpage, macos-latest) (push) Has been cancelled
Create Release / build (target/superoptimized/sqlpage, ubuntu-20.04) (push) Has been cancelled
Create Release / build (target/superoptimized/sqlpage.exe, windows-latest) (push) Has been cancelled
Create Release / build-aws (push) Has been cancelled
Create Release / Create Release (push) Has been cancelled
2023-09-19 09:52:22 +02:00
lovasoa