SQL is designed for managing or stream processing data in an RDBMS. This package provides a set of functions to generate SQL commands for creating tables, inserting data, and performing various operations, including text search and matching, on SQL databases (PostgreSQL).
import * as xsql from "jsr:@nodef/extra-sql"; xsql.tableExists("food"); // → SELECT EXISTS (SELECT 1 FROM information_schema.tables WHERE table_name='food'); xsql.setupTable("food", {code: "TEXT", name: "TEXT"}, [{code: "F1", name: "Mango"}, {code: "F2", name: "Lychee"}]); // → CREATE TABLE IF NOT EXISTS "food" ("code" TEXT, "name" TEXT); // → INSERT INTO "food" ("code", "name") VALUES // → ($$F1$$, $$Mango$$), // → ($$F2$$, $$Lychee$$); xsql.selectTsquery("columns", "total fat"); // → SELECT * FROM "columns" WHERE "tsvector" @@ plainto_tsquery('total fat'); xsql.matchTsquery("columns", ["total", "fat"]); // → SELECT *, '2'::INT AS "matchTsquery" FROM "columns" WHERE "tsvector" @@ plainto_tsquery('total fat') UNION ALL // → SELECT *, '1'::INT AS "matchTsquery" FROM "columns" WHERE "tsvector" @@ plainto_tsquery('total');| Name | Description |
|---|---|
| createTable | Generate SQL command for CREATE TABLE. |
| createIndex | Generate SQL command for CREATE INDEX. |
| createView | Generate SQL command for CREATE VIEW. |
| insertInto | Generates SQL command for INSERT INTO using an array of values. |
| setupTable | Generate SQL commands to set up a table (create, insert, index). |
| tableExists | Generate SQL command to check if a table exists. |
| selectTsquery | Generate SQL command for SELECT with tsquery. |
| matchTsquery | Generate SQL query for matching words with tsquery. |
| insertIntoStream | Generate SQL command for INSERT INTO using a stream of values. |
| setupTableIndex | Generate SQL commands for setting up table indexes and views. |
| createTableData | Generate SQL command for creating a table with data. |
| updateData | Generate SQL command for updating data. |
| selectData | Generate SQL command for selecting data. |
| insertIntoData | Generate SQL command for inserting data. |
| deleteData | Generate SQL command for deleting data. |
| OPERATORS | Set of operators in SQL. {field} |
| OPERAND_COUNT | Number of operands used with an SQL operator. {field} |
