18 Commits

Author SHA1 Message Date
Ophir LOJKINE af7e16f2cc null variables (#136)
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
* 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 edd94df0f7 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 310cd55f23 normalize paths on windows in tests 2023-10-26 03:04:52 +02:00
lovasoa ee2a1f071e fix test error msg 2023-10-26 03:00:23 +02:00
lovasoa 2fc2ea8410 New function: sqlpage.path
fixes https://github.com/lovasoa/SQLpage/issues/114
2023-10-26 02:50:17 +02:00
ophir 17720bfcba new function: sqlpage.variables 2023-10-22 00:41:40 +02:00
lovasoa a698be20a4 small code style fixes 2023-10-16 01:00:36 +02:00
lovasoa 5c8c366021 fix error message on invalid header-only component usage
fixes https://github.com/lovasoa/SQLpage/discussions/101
2023-10-13 21:14:57 +02:00
lovasoa 3753dd90ce add tests for exec and url_encode 2023-09-27 22:31:39 +02:00
lovasoa afa21b0fd6 allow setting variables with "set x = y" instead of "set $x = y" 2023-09-19 03:44:08 +02:00
lovasoa 3aa97bc763 fix error when hashing passwords 2023-09-19 03:03:08 +02:00
lovasoa a17bf01c04 fix a bug making it impossible to call sqlpage pseudo-functions with url parameters as arguments on some databases 2023-09-19 03:00:54 +02:00
lovasoa 10afd7adae add a small integration test for the new variable setting feature 2023-09-19 02:07:33 +02:00
lovasoa cfeebd75cb add a test for 404 2023-09-18 15:13:57 +02:00
lovasoa 45e3547102 add a test for #89 2023-09-18 15:08:53 +02:00
lovasoa 50ad903255 fix #89 2023-09-18 10:55:32 +02:00
lovasoa 67573e716f add integration tests for all supported databases 2023-09-17 21:26:15 +02:00
lovasoa 251ea0307d add integration test, and expose more as library 2023-08-27 21:56:59 +02:00