782 Commits

Author SHA1 Message Date
lovasoa ad0fc2c981 Fix bug with variable assignment
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 sqlpage binaries (target/superoptimized/sqlpage, macos-latest) (push) Has been cancelled
Create Release / Build sqlpage binaries (target/superoptimized/sqlpage, ubuntu-20.04) (push) Has been cancelled
Create Release / Build sqlpage binaries (target/superoptimized/sqlpage.exe, windows-latest) (push) Has been cancelled
Create Release / Build AWS Lambda Serverless zip image (push) Has been cancelled
Create Release / Create Github Release (push) Has been cancelled
Create Release / Publish to crates.io (push) Has been cancelled
fixes #138
v0.16.1
2023-11-22 20:36:40 +01:00
lovasoa 23a49d13e1 update dependencies 2023-11-22 20:05:47 +01:00
lovasoa f8d5fb06e6 fix bug in corporate conundrum demo 2023-11-22 01:49:12 +01:00
lovasoa b32ad90bb7 better docs for multi-select 2023-11-22 00:26:28 +01:00
lovasoa ea5f741d06 update dependencies 2023-11-21 00:43:23 +01:00
lovasoa 79a7c833b0 run as user 1000 by default in docker images
update rust version in docker images to 1.74
2023-11-21 00:42:56 +01:00
lovasoa d1c49896df update gitignore 2023-11-19 21:43:47 +01:00
Ophir LOJKINE 23f834de71 null variables (#136)
* update dependencies

* Add support for resetting variables to a `NULL` value using `SET`. Previously, storing `NULL` in a variable would store the string `'null'` instead of the `NULL` value.
2023-11-19 20:09:18 +01:00
Ophir LOJKINE 563bc87959 delegate statement preparation to sqlx (#135)
* delegate statement preparation to sqlx

The logic of preparing statements and caching them for later reuse is now entirely delegated to the sql driver library (sqlx).
This simplifies the code and logic inside sqlpage itself.

 More importantly, statements are now prepared in a streaming fashion when a file is first loaded, instead of all at once, which allows referencing a temporary table created at the start of a file in a later statement in the same file.

 fixes #100

* remove temporary table usage

mssql does not have "create temp table"

* mssql permissions fix
2023-11-19 01:32:04 +01:00
lovasoa 488dbca8cf changelog 2023-11-18 02:03:29 +01:00
lovasoa 05f394af7d update dependencies
fixes #131
2023-11-18 02:03:17 +01:00
lovasoa ee12d0cad7 support multiple statements in on_connect for MySQL
Fixes #132
2023-11-17 18:54:52 +01:00
lovasoa 499b9f11db improve form hidden fields
fixes https://github.com/lovasoa/SQLpage/issues/130
2023-11-16 01:03:11 +01:00
lovasoa 0f47496e73 update icons 2023-11-16 01:02:30 +01:00
lovasoa e4bb792f2b Improve map component
customizable tile
source, attribution, and max zoom.

Update embedded SQLite to version
3.44.
2023-11-12 20:30:04 +01:00
lovasoa 2abd0edd03 small note about security 2023-11-12 00:00:11 +01:00
lovasoa 7109ba371f pgconf.eu 2023-11-11 02:45:33 +01:00
lovasoa b619c836b1 customize top navigation links and to create submenus in shell 2023-11-11 02:25:39 +01:00
lovasoa 5eb6d97d1b update dependencies 2023-11-11 01:25:53 +01:00
lovasoa c7351f5095 map : better geojson point support 2023-11-11 01:24:41 +01:00
lovasoa 13849cc0f2 fix syntax highlighting in the url_encode documentation 2023-11-10 18:33:47 +01:00
lovasoa dca73e52fa fix geojson passed as strings to the map component
fixes #129
2023-11-10 18:33:47 +01:00
Ophir LOJKINE 72664374c5 create issue templates 2023-11-10 18:01:44 +01:00
lovasoa 75db782651 v0.15.1 2023-11-07 23:54:52 +01:00
lovasoa 36261eb0ff Update dependencies in Cargo.lock 2023-11-07 23:54:15 +01:00
lovasoa 17681fb672 add support for geojson in the map component
this adds support for new geometries, including polygons

Closes https://github.com/lovasoa/SQLpage/issues/119
2023-11-07 23:52:38 +01:00
lovasoa 2369a4b52c new map attributes documentation 2023-11-07 21:47:48 +01:00
lovasoa 94c04d8a4c custom marker icon and color in the map component 2023-11-07 01:07:40 +01:00
lovasoa 64a602897a simplify the user authentication example and make it easier to adapt to different databases 2023-11-07 00:01:20 +01:00
lovasoa c5a56937b4 add an explanation about the logged_in_user function
Hopefully it prevents users from introducing security vulnerabilities in their websites
2023-11-06 23:22:33 +01:00
lovasoa ec0e580a95 Form submission with button component. #113 2023-11-06 23:07:55 +01:00
lovasoa 5dfd012f5d update dependencies 2023-11-06 22:39:30 +01:00
lovasoa 7b6901373b cookie removal 2023-11-06 22:37:43 +01:00
lovasoa e22f5f4f8e cast parameters to VARCHAR(8000) on mssql 2023-11-06 22:35:17 +01:00
lovasoa 6efdf206fb document custom component creation 2023-11-06 01:35:21 +01:00
lovasoa 7cf6c6eb62 anonymous screenshots 2023-11-05 10:51:10 +01:00
lovasoa 5905ed2fe3 use CAST(? as TEXT) to avoid data truncation 2023-11-05 10:49:22 +01:00
lovasoa cc2c7c1a09 Revert "remove unneeded generated sql casts"
This reverts commit 14b86acaa8.
2023-11-04 21:53:52 +01:00
lovasoa 48f2225829 add screenshots 2023-11-04 20:26:29 +01:00
lovasoa 9359b31430 update dependencies 2023-11-04 20:26:20 +01:00
lovasoa 692399f147 gha syntax fix 2023-11-03 00:26:41 +01:00
Ophir LOJKINE d12365cb7c Merge pull request #122 from Pieter3033/main
Updated Form component
2023-11-02 23:58:04 +01:00
lovasoa 9119cd87cb skip uploads on pr 2023-11-02 23:48:08 +01:00
lovasoa 3d611ce7bb don't save cache on prs 2023-11-02 23:39:58 +01:00
lovasoa 474aed99cf avoid docker push on pull requests 2023-11-02 23:30:53 +01:00
Ophir LOJKINE 21dad36ce3 Merge branch 'main' into main 2023-11-02 23:26:42 +01:00
lovasoa cb440827bd docuementation + fix width 2023-11-02 23:23:12 +01:00
lovasoa 5e56c85b3b Support non-string values in markdown fields
`NULL` values are now displayed as empty strings, numeric values are displayed as strings, booleans as `true` or `false`, and arrays as lines of text. This avoids the need to cast values to strings in SQL queries.
2023-11-01 01:24:17 +01:00
William Cronje 8ab25c81b6 Update form.handlebars 2023-10-30 10:26:45 +02:00
William Cronje 3677fa36e9 Update form.handlebars 2023-10-30 09:56:26 +02:00