Proxy version is build for both web and node environment, so now moved to covenantsql-proxy-js.
This repo is nodejs driver for CovenantSQL written by TypeScript.
Install node-covenantsql via npm or yarn:
npm install --save node-covenantsql
or
yarn add node-covenantsql
Follow CovenantSQL Quickstart to get you prepared.
- If the CovenantSQL endpoint comes with
HTTPSthen.pemand.keyfiles are needed for requests:
const config = { endpoint: 'e.morenodes.com:11108', // testnet endpoint with https database: `${DB_ID}`, // your DB id created by `cql` tools key_dir: path.resolve(`${KEY_FILE_RELATIVE_PATH}`), // your key file https_pem_dir: path.resolve(`${PEM_FILE_RELATIVE_PATH}`) // your pem file (cert file) }
- If only
HTTPis needed, then your config could be:
const config = { endpoint: 'localhost:11105', // local testnet endpoint without https database: `${DB_ID}`, // your DB id created by `cql` tools bypassPem: true // bypass https config }
import cql from 'node-covenantsql' const config = {...} // see above cql.createConnection(config).then(async (connection: any) => { // read const data1 = await connection.query("select ? + ?", [2.1, 3.2]); console.log(data1); // write const createTableSQL = ` CREATE TABLE IF NOT EXISTS contacts (\ contact_id INTEGER PRIMARY KEY, first_name TEXT NOT NULL, last_name TEXT NOT NULL, email text NOT NULL UNIQUE, phone text NOT NULL UNIQUE ); ` const status1 = await connection.exec(createTableSQL) console.log(`exec1 status:`, status1); const data2 = await connection.query("show tables;"); console.log(data2); }).catch((e: any) => console.log(e))