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 (currently PostgreSQL).

▌ 📦 Node.js, 🌐 Web, 📜 Files, 📰 Docs, 📘 Wiki.

import * as xsql from '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');

Index

| Property | 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} |