Dependency

• NPM URL : https://www.npmjs.com/package/expert-json
• Instal dependency NPM :

npm i expert-json

KETERANGAN.

• Expert Json adalah Librari basis nodejs di peruntukkan untuk Crud query Database dalam bentuk JSON file
• perintah di desain hampir sama dengan query ke MYSQL hingga mempermudah kita
• untuk mengelolah data JSON apabila terbiasa dengan query MYSQL

CARA PAKAI

• INISIASI CRUD

const {Expert} = require('expert-json');

const go = new Expert("./db/log.json");

• GET ALL DATA ASYNC

await go.get();

• GET DATA PARSING ASYNC [where,limit,LIKE]

await go.get(["status",true],1,"search value");

• WHERE use after await go.get();

go.where(["status",true]);

go.where(["status","=",true]);

go.where(["status","!=",true]);

go.where(["num",">",100]);

go.where(["num",">=",100]);

go.where(["num","<",100]);

go.where(["num","<=",100]);

• LIMIT use after await go.get();

go.limit(10);

• ORDERBY use after await go.get();

go.orderBy("id","DESC");

• OFFSET use after await go.get(); // var limit = 10; // var page = 1; // var index = (page-1)*limit;

go.offset(index,limit);

• LIKE / REGEX use after await go.get();

go.regex("search value");

ASYNC FUNCTION CRUD

• FIND

await go.find({id:1});

• FIND-ONE

await go.findOne({id:1});

• INSERT

await go.insert({id:1,name:"ismail samudra"});

• UPDATE

await go.update({id:1},{name:"Ubaid Fawaz Fatih"});

• REMOVE / DELETE

await go.remove({id:1});

OTHER FUNCTION

• INISIASI

Use const {Expert,ExpertDb,xFile,dFile,isNum} = require('expert-json');

• CREATE FILE DB JSON

ExpertDb("dir/jsonName");

• CREATE FILE OR DIR dinamis link

ONLY DIR

xFile("./dir1/dir2");

DINAMIS FILE

xFile("./dir1/dir2/log.txt");

• DELETE FILE OR DIR dinamis link

dFile("./dir1/dir2/log.txt");

• CEK STRING IS NUMBER OR NOT output : true/false

var cek = isNum("123");

RANDOM ID

• INISIASI

Use const {Expert,ExpertDb,xFile,dFile,isNum,randomId} = require('expert-json');

• CODE : number = only number A__ = only Huruf Besar a__ = only Huruf kecil Aa_ = Huruf Besar & huruf kecil An_ = Huruf Besar & number an_ = Huruf kecil & number Aan = Huruf Besar , huruf kecil & number

• RELASI [ CODE ],[ Length (jumlah huruf) ]

• CODE USE

var id = randomId("Aan",8);

• EXAMPLE OUTPUT RANDOM ID "// GHysx6r7"

EXAMPLE CODE GET DATA

const {Expert} = require('expert-json');
const go = new Expert("./db/log.json");
async function getData(){
   var limit = 5;
   var page = 1;
   var index = (page-1)*limit;
   await go.get();
   go.orderBy("id","DESC");
   return go.offset(index,limit);
}

EXAMPLE CODE INSERT DATA

const {Expert} = require('expert-json');
const go = new Expert("./db/log.json");
// var document = {name:"Ismail Samudra",level:"develope"};
async function insert(document){
   return await go.insert(document);
}

BY : ISMAIL SAMUDRA DONASI : SAWERIA