Install

npm install --save cql-js-driver

yarn add cql-js-driver

Get started

use testnet proxy directly

constconfig={endpoint:'http://testnet-proxy.covenantsql.io',dbid:`${DB_ID}`,// your DB id created by `cql` tools in QuickStart}

if you setup your own 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

constconfig={endpoint:'127.0.0.1:11105',// local testnet endpoint without httpsdbid:`${DB_ID}`,// your DB id created by `cql` tools}

connect and query

importcqlfrom'cql-js-driver'constconfig={...}// see abovecql.createConnection(config).then(async(connection:any)=>{// readconstdata1=awaitconnection.query("select ? + ?",[2.1,3.2]);console.log(data1);// writeconstcreateTableSQL=`    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    );    `conststatus1=awaitconnection.exec(createTableSQL)console.log(`exec1 status:`,status1);constdata2=awaitconnection.query("show tables;");console.log(data2);}).catch((e:any)=>console.log(e))

Contribution

License