sqlpage--sqlpage/tests/upload_csv_test.sql at hidden_dotfiles - sqlpage--sqlpage - Wehub

github-featured/sqlpage--sqlpage

Files

T

lovasoa 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

6 lines

317 B

SQL

Raw Permalink Blame History

 drop table if exists sqlpage_people_test_table;
 create table sqlpage_people_test_table(name text, age text);
 copy sqlpage_people_test_table(name, age) from 'people_file' with (format csv, header true);
 select 'text' as component,
     name || ' is ' || age || ' years old. ' as contents
 from sqlpage_people_test_table;