261f76c2bc
Add unsafe_contents_md to text component, add related file tests, add documentation parameters
2025-03-17 11:08:36 +00:00
e75fc22d7f
fix tests on mssql
...
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
no json_extract
2025-02-24 22:22:03 +01:00
5fd1c83df1
new function: fetch_with_meta ( #827 )
...
* new function: fetch_with_meta
closes https://github.com/sqlpage/SQLPage/issues/792
* fmt
* clippy auto
* test fetch_with_meta
* fix tests
* update deps
* retry failed deps downloads
* better json serializing
* test fetch_with_meta error handling
* add logging
* fix tests
closes #792
2025-02-24 22:01:30 +01:00
668a87764f
fix parameter binding order ( #825 )
...
* use numbered parameters in sqlite
* implement parameter deduplication
* implement parameter re-duplication for mysql
* Improve error messages on invalid sqlpage function calls. The messages now contain actionable advice.
* simplify extract_set_variable
2025-02-22 14:13:45 +01:00
2aac5f3aa2
docs and tests
2025-02-17 14:31:41 +01:00
3ab42fced6
new function: sqlpage.headers()
...
closes https://github.com/sqlpage/SQLPage/discussions/810
2025-02-13 17:33:02 +01:00
5a7ca66c03
forbid invalid fields in sqlpage.fetch http request definitions
2025-02-10 10:18:41 +01:00
d5b3d1221c
Fix a bug where subsequent requests would fail after a failed CSV import on postgres
...
fixes https://github.com/sqlpage/SQLPage/issues/788
2025-01-24 15:36:50 +01:00
0d7c91ed59
add support for coalesce in function calls
2024-12-24 22:24:23 +01:00
7dc8683b6e
sqlpage.environment_variable('inexistant') = null
...
fixes https://github.com/sqlpage/SQLPage/issues/746
2024-12-20 16:30:17 +01:00
0d51d52393
not on a personal repo anymore
2024-12-06 21:42:55 +01:00
4f8d21c3a7
fix https://github.com/sqlpage/SQLPage/issues/701
2024-11-18 21:42:22 +01:00
1c5fb16f27
add a native sqlpage implementation of json_array, which allows passing json arrays to nested sqlpage functions
2024-11-18 16:32:29 +01:00
67ddf944f0
disable varchar test on mysql
2024-11-01 22:37:22 +01:00
3da1c3677f
add a test for varchar
...
see https://github.com/sqlpage/SQLPage/issues/662
2024-11-01 22:25:16 +01:00
fbf994892d
json_object is different on postgres
2024-10-05 23:51:12 +02:00
4cafa1eac0
add a machanism to skip some tests on some dbs
2024-10-05 23:20:29 +02:00
9e580753e4
Easier json handling in databases without a native json type. SQLPage now detects when you use a json function in SQLite or MariaDB to generate a column, and automatically converts the resulting string to a json object. This allows easily using components that take json parameters (like the new columns component) in MariaDB and SQLite.
...
fixes #633
2024-10-05 22:31:29 +02:00
dd94371c44
fix https://github.com/lovasoa/SQLpage/issues/621
2024-10-04 09:23:42 +02:00
38dbde4ca0
fix https://github.com/lovasoa/SQLpage/discussions/600
2024-09-24 22:39:57 +02:00
5abc7762aa
add a test for https://github.com/lovasoa/SQLpage/issues/526
2024-08-12 22:40:29 +02:00
47e419b2a4
fix tests
2024-07-12 21:49:00 +02:00
29fa14ce7c
calls to json_object in sqlpage function arguments
2024-07-12 16:27:17 +02:00
996ed2e2ee
add test from https://github.com/lovasoa/SQLpage/pull/486/files
...
closes https://github.com/lovasoa/SQLpage/pull/486
2024-07-11 18:10:45 +02:00
9c47ec94cc
fix mysql tests
2024-07-11 13:58:25 +02:00
6a3f2159c1
avoid cloning variables when not needed in run_sql
2024-07-11 13:07:32 +02:00
e9fc9624f4
run_sql can now be called with a specific set of variables to pass to the included sql file
...
new html component
2024-07-10 23:54:41 +02:00
c629c38a26
reintroduce good error messages for invalid function calls
2024-06-27 00:52:56 +02:00
b877284416
Merge branch 'main' into function_post_result
2024-06-25 08:56:56 +00:00
a6c5a1f3f8
better dynamic component errors
2024-06-25 00:27:53 +02:00
12efca6aa9
WIP delayed function execution
2024-06-24 23:38:10 +02:00
48d02bf47f
fix lower() to correctly handle NULLs
...
SQLPage provides an internal unicode-aware lower() implementation
for SQLite.
It's implementation did not handle NULLs correctly
fixes https://github.com/lovasoa/SQLpage/issues/452
2024-06-24 17:17:21 +02:00
0e2ca42f74
add a way to skip some tests on some databases
2024-06-01 17:42:22 +02:00
8b700be84f
reuse the existing opened database connection for the current query in sqlpage.run_sql instead of opening a new one
...
fixes #338
2024-06-01 17:14:04 +02:00
70b90c3530
add test for repeated properties in dynamic component
CI / compile_and_lint (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
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 / Publish to crates.io (push) Has been cancelled
2024-05-19 17:14:43 +02:00
8cff7bfff8
new function: sqlpage.request_method
2024-05-14 11:48:30 +02:00
651d96b648
test with sql cast
2024-05-14 00:45:30 +02:00
987a322999
fix sql syntax in tests
2024-05-14 00:28:04 +02:00
3e6b313189
fix errors in dynamic component being silent
...
fixes https://github.com/lovasoa/SQLpage/issues/314
2024-05-13 18:21:47 +02:00
fe7446461e
Re-introduce automatic cast syntax translation
...
sqlpage will translate xxx::int to cast(xxx as int) on non-postgres
databases
2024-05-13 17:36:59 +02:00
4d4de00df5
sqlpage.hash_password(NULL) now returns NULL
2024-05-11 19:14:27 +02:00
645c843ead
fix tests on mssql
2024-05-08 16:44:10 +02:00
b8b63dcbcb
move sqlpage.exec to the new function format
2024-05-08 16:35:35 +02:00
b60fc4e158
switch sqlpage.variables to the new function definition paradigm
2024-05-07 00:14:09 +02:00
3c2dfe9ce8
move basic_auth_username and basic_auth_password to the new function system
2024-05-06 23:49:39 +02:00
526b6e0fc6
implement sqlpage.cookie and sqlpage.header with the new function system
2024-05-06 22:33:15 +02:00
96b6fa14ef
accept numbers as sqlpage function inputs. update sqlpage.random_string to accept complex input parameters
2024-05-06 17:12:04 +02:00
48229fad62
fetch: use builtin root certificates and default user-agent
...
fixes https://github.com/lovasoa/SQLpage/issues/295
2024-04-22 23:42:06 +02:00
5c6e9924a5
remove newlines from tests for windows
2024-04-21 19:30:08 +02:00
066c80ace2
new function: sqlpage.fetch
...
fixes https://github.com/lovasoa/SQLpage/issues/7
see
- https://github.com/lovasoa/SQLpage/discussions/197
- https://github.com/lovasoa/SQLpage/discussions/215
- https://github.com/lovasoa/SQLpage/discussions/254
2024-04-21 18:47:14 +02:00
Gus Power