This repo is javascript lib to interact with CovenantSQL local proxy.
Install cql-js-driver via npm or yarn:
npm install --save cql-js-driveror
yarn add cql-js-driverFollow CovenantSQL QuickStart to get you prepared.
We provides testnet proxy for your testing: http(s)://testnet-proxy.covenantsql.io
const config = { endpoint: 'http://testnet-proxy.covenantsql.io', dbid: `${DB_ID}`, // your DB id created by `cql` tools in QuickStart }- set up CovenantSQL local proxy
$ go get github.com/CovenantSQL/CovenantSQL $ make bin/cql $ rsync -avP ./conf/testnet/{config.yaml,private.key} ~/.cql/ $ ./bin/cql -adapter 127.0.0.1:11105- fill in the configs
const config = { endpoint: '127.0.0.1:11105', // local testnet endpoint without https dbid: `${DB_ID}`, // your DB id created by `cql` tools }import cql from 'cql-js-driver' 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))yarn dev- open
http://localhost:8080/examples/