tT.js

const KwilDB = require('./index.js')
const { decryptKey } = require('./src/utils/decryptKey.js')
const devkey = require('./devkey')

const kwilDB = KwilDB.createConnector({
    host: 'localhost',
    protocol: 'http',
    port: 1984,
    moat: 'moatfornode3',
    privateKey: devkey,
}, '@2c~emqAA:piJrtx*i6_C,qV2E^!6J?<'/*'#yd2x$.u89<e]IMIFv{|kTw;=/xLc..R'*/)

/*const kwilDB2 = KwilDB.createConnectorRegistry({
    host: 'localhost',
    protocol: 'http',
    port: 1984,
    moat: 'test7',
    apiKey: '9ydoed[GGu,KJ<m6Wm<FhrdHY;fl5bpX',
}, 'o~>halS(K>UJ]ET1[Gh?Uo-#rr3Dp[=>')

const kwilDB2 = KwilDB.createConnectorRegistry({
    host: 'registry.kwil.xyz',
    protocol: 'http',
    port: 1984,
    moat: 'test7',
    apiKey: '9ydoed[GGu,KJ<m6Wm<FhrdHY;fl5bpX',
}, 'o~>halS(K>UJ]ET1[Gh?Uo-#rr3Dp[=>')*/

const sig = "0xed413f72c590a7467f57a51e1238ed8333a4d99d995e7ef46e25b0aa191d877275106abf9690bd126c1fb40c0b0402db4a8092f0dfdf4c938465511f6136548b1c"

const owner ="0xFeE8197af2aAd0d506357d39EF42b3183dcDbc54"


const testF = async () => {
    //console.log(await kwilDB.query(`SELECT schema_name FROM information_schema.schemata WHERE schema_name LIKE 'test';`))
    //console.log(await kwilDB.query('CREATE TABLE IF NOT EXISTS yuh;'))
    //console.log(await KwilDB.createMoat('https://test-db.kwil.xyz', 'testermoat4', 'kwilSIG', '0xEF94BD30AA33de1677D7614D17aA39D493a485F1'))
    //console.log(await decryptKey('kwilSIG', '0xEF94BD30AA33de1677D7614D17aA39D493a485F1', 'U2FsdGVkX1+154CCJHU2FUrV7DOd1INDyidhHpf+ciebVG/s3R/uWVPh5PRy6A64L+o/n2Z19L/YUKixGRpl6A=='))
    //console.log(await kwilDB.createTable('table2' , {test: {}, username: 'varchar(100)'}))
    //kwilDB.query(`CREATE TABLE testtabl2(test_col text)`, true)
    //await kwilDB.storeJPEG('images/img.jpg',b64String,false);
    //await kwilDB.storeFile('text/txt.txt',b64String.string,false);
    //await kwilDB2.addMoat('testmoat1','owner','randomapikey','superencryptedsecret');

    //await kwilDB.addSecret('testmoat','secret2',Date.now());
    //console.log(await KwilDB.getMoats('http://localhost:1984','0xEF94BD30AA33de1677D7614D17aA39D493a485F1'));
    //console.log(await kwilDB2.getSecrets('testmoat'));
    //console.log(await kwilDB2.getEncryptedAPIKey('testmoat1'));
    //await kwilDB2.updateSecret('testmoat',sig,'newthingy',owner);
    let str = new Array(1000 + 1).join( 'i' );
    //console.log(str);
    /*for (let i =0;i<1000;i++) {
        console.log(await kwilDB.query(`INSERT INTO testtab (id, height)
                                        VALUES (${i},'${str}' )`,true));
        console.log(i);
    }*/
    //console.log(await kwilDB.query('CREATE TABLE if NOT EXISTS testtab(id integer, height varchar NOT NULL)'));
    //console.log(await kwilDB.query(`SELECT * FROM tab`));
    //console.log(await KwilDB.createMoat('http://localhost:1984','moatfornode3',"hello","0xFeE8197af2aAd0d506357d39EF42b3183dcDbc54"))
    console.log(await kwilDB.getMoatFunding())
    //console.log(await kwilDB.getMoatDebit())
}

testF()