jsMultiSelect
Creating optimized sql SELECT commands to make multiple select with a single instruction
MultiCompare Class#
MultiCompare is a class representing the comparison of n given fields with n given values.
MultiCompare(fields,values)
- @param {string[]} fields
- @param {object[]} values
- @returns {MultiCompare}
sameFieldsAs(multiComp)
Checks if this MultiCompare has same comparison fields of another one.
- @param multiComp
- @returns {boolean}
OptimizedMultiCompare
OptimizedMultiCompare is a specialized MultiCompare class. An OptimizedMultiCompare instance is built merging multiple MultiCompare instances.
OptimizedMultiCompare(multiComp)
Constructor for a OptimizedMultiCompare, accepting a MultiCompare as parameter.
- @param {MultiCompare} multiComp
- @returns {OptimizedMultiCompare}
joinWith(other)
Join this multicomparator with another one, if it is possible. Returns false if it is not possible.
- @param {OptimizedMultiCompare} other
- @return {boolean}
Select
Class representing a query to be done on a table
Select(columnList)
Creates a select providing an optional column list
- @param {string[]} columnList
- @return {Select}
where(filter)
Sets the manual filter for this Select. We call this kind of filtering "not-optimized"
- @param {sqlFun} filter
- returns {Select} this
sqlFun is a kind of object defined in jsDataQuery
staticFilter(filter)
Sets an additional static filter for this query
- @param {sqlFun} filter
- @returns {Select} this
multiCompare(multiComp)
Sets a multicompare filter for the Select
- @param {MultiCompare} multiComp
- @returns {Select} this
from (tableName)
Sets the table associated to this select
- @param {string} tableName
- @returns {Select} this
Select.prototype.from = function (tableName)
intoTable(alias)
Sets a destination table for this select (alias)
- @param {string} alias
- @returns {Select} this
orderBy(sorting)
Set the sorting method for the select
- @param {string} sorting
- @returns {Select} this
top([n])
Gets/Sets the top options for the query
- @param {string} [n]
- @returns {string | undefined}
canAppendTo(other)
Check if this Select can be appended to another one, i.e., has same tableName and alias
- @param {Select} other
- @returns {boolean}
optimizedAppendTo(other)
Tries to append this Select to another one in an optimized way and returns true on success. An optimized Append is possible only if two select are both optimized
- @param {Select} other
- @returns {boolean}
appendTo(other)
Appends this Select to another one or-joining their conditions, returns true if appending succeeded
- @param {Select} other
- @returns {boolean}
groupSelect(selectList)
This is a standalone function, which takes a list of Select to same table and evaluates an equivalent Select joining all their input filters
