tg-knex-query-resolver v4.1.1

tg-query

Query Builder and Parser for the front and back end

• tg-query
• QueryBuilder Usage:
  • list of possible filters:

QueryBuilder Usage:

Note for simple cases, a plain filter object can be passed to filter like:

filter: {
    id: 4
}

or 

filter: {
    id: [4,6,12]
}

or 

filter: {
    name: 'thomas'
}

For more complex cases, we'll need to use tg-client-query-builder

import QueryBuilder from "tg-client-query-builder";

//make sure to instantiate the qb anew each time you want to use it
//If it isn't re-instantaited it will grow bigger and bigger!
let qb = new QueryBuilder("notificationRecipient"); //instantiate with the model name
 j
const filter = qb.whereAll({ //either whereAll or whereOr 
    userId: currentUser.userId, //make normal where statements like this
    notificationId: qb.related("notification.id").whereAll({ //specify the connection like this
        type: "info" //add more where statements
        volume: qb.lessThan(2)
    })
}).toJSON() //remember to call toJSON

list of possible filters:

 qb.greaterThan(2)
 qb.inList([2, 4, 6])
 qb.inList(['happy', 'go', 'lucky'])
 qb.lessThan(2)
 qb.lessThanOrEqual(2)
 qb.equals(2)
 qb.greaterThanOrEqual(2)
 qb.notEquals(2)
 qb.notNull()
 qb.isNull()
 qb.between(2, 67)
 qb.notInList([2,5,67])
 qb.startsWith('thom')
 qb.endsWith('as')
 qb.contains('tree') 
 qb.notContains('tree') 
 qb.dateOnly( ???? ) //ADAM THOMAS CAN YOU ADD THIS EXAMPLE?
 qb.upperCase('thomas') //uppercase search
 qb.lowerCase('thoMas') //lowercases the search 
 qb.subString('ma')
 qb.matchesRegex("th.*s") //regex searches for the string
 qb.fuzzy("thms") //fuzzy searches for the string