Skip to main content
Home
Browse packagesDocsSign in
This release is 2 versions behind 0.1.2 — the latest version of @nodef/extra-sql. Jump to latest

@nodef/extra-sql@0.1.0
Built and signed on GitHub Actions

nodef/extra-sql

Generates SQL commands for creating tables, inserting data, and performing operations like text search and matching in PostgreSQL databases.

This package works with Node.js, DenoIt is unknown whether this package works with Cloudflare Workers, Bun, Browsers
It is unknown whether this package works with Cloudflare Workers
This package works with Node.js
This package works with Deno
It is unknown whether this package works with Bun
It is unknown whether this package works with Browsers
JSR Score
100%
Published
a month ago (0.1.0)

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).

▌ 📦 JSR, 📰 Docs,


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

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}



ORG

Built and signed on
GitHub Actions
View transparency log

New Ticket: Report package

Please provide a reason for reporting this package. We will review your report and take appropriate action.

Please review the JSR usage policy before submitting a report.

Add Package

deno add jsr:@nodef/extra-sql

Import symbol

import * as extra_sql from "@nodef/extra-sql";
or

Import directly with a jsr specifier

import * as extra_sql from "jsr:@nodef/extra-sql";

Add Package

pnpm i jsr:@nodef/extra-sql
or (using pnpm 10.8 or older)
pnpm dlx jsr add @nodef/extra-sql

Import symbol

import * as extra_sql from "@nodef/extra-sql";

Add Package

yarn add jsr:@nodef/extra-sql
or (using Yarn 4.8 or older)
yarn dlx jsr add @nodef/extra-sql

Import symbol

import * as extra_sql from "@nodef/extra-sql";

Add Package

npx jsr add @nodef/extra-sql

Import symbol

import * as extra_sql from "@nodef/extra-sql";

Add Package

bunx jsr add @nodef/extra-sql

Import symbol

import * as extra_sql from "@nodef/extra-sql";