Type-safe SQL query builder like QueryDSL or JOOQ in Java or Linq in .Net for TypeScript with MariaDB, MySql, Oracle, PostgreSql, Sqlite and SqlServer support.
MIT License
Bot releases are hidden (Show)
Published by juanluispaz about 3 years ago
Changes:
isTransactionActive
method at the connection object that allows to know if there is an active open transaction in ts-sql-queryBug fixes:
Published by juanluispaz over 3 years ago
Changes:
split
method automatically determines if the created property is required or optionalsplitRequired
splitting methodDocumentation changes:
Bug fixes:
Published by juanluispaz over 3 years ago
Changes:
Documentation changes:
Distribution changes:
Bug fixes:
Published by juanluispaz over 3 years ago
Changes:
union
, intersect
, except
) on select expressions.executeSelectPage
on select with group by
Bug fixes:
startsWith
and endsWith
misspellingPublished by juanluispaz over 3 years ago
Changes:
Published by juanluispaz over 3 years ago
Changes:
Documentation changes:
Published by juanluispaz over 3 years ago
Changes:
Documentation changes:
New examples:
Bug fixes:
Published by juanluispaz over 3 years ago
First stable release!
See 1.0.0-beta.1 release notes
Bug fixes:
setIfValue
, setIfSetIfValue
, setIfNotSetIfValue
when insert or update now have the same behaviour that any *IfValue
function, respecting the configuration about treating an empty string as null valuePublished by juanluispaz almost 4 years ago
Changes:
buildFragmentWithArgs
function with the arg
and valueArg
functions (all defined in the connection)*IfValue
functions using the buildFragmentWithArgsIfValue
function with the arg
and valueArg
functions (all defined in the connection)execute
in the query runners to allows have direct access to the database using the raw objects used to establish the connectionisConstValue(): boolean
that allows verify if it contains a const valuegetConstValue(): TYPE
that allows getting the value of a const value source (throw an error if it is not a const value source)bigint
column typeBraking changes:
true()
and false()
methods defined in the connectionQueryRunner.getNativeConnection
as getNativeRunner
to avoid confusion because this method doesn't return the connection in all the implementation (could be the pool)DBConection extends PostgreSqlConnection<DBConection, 'DBConnection'> { }
DBConection extends PostgreSqlConnection<'DBConnection'> { }
class TCompany extends Table<DBConection> { ... }
class TCompany extends Table<DBConection, 'TCompany'> { ... }
class VCustomerAndCompany extends View<DBConection> { ... }
class VCustomerAndCompany extends View<DBConection, 'VCustomerAndCompany'> { ... }
unknown
optionalConst
function in the connection, previously was used the const
function in the connectionis
function that allows comparing two values now returns a not optional boolean, previously it returned an optional valueNumberValueSource.asStringNumber
, use instead the new methods:
NumberValueSource.asInt(): number
NumberValueSource.asDouble(): number
NumberValueSource.asStringInt(): number|string
NumberValueSource.asStringDouble(): number|string
StringNumberValueSource.asStringInt(): number|string
StringNumberValueSource.asStringDouble(): number|string
Internal changes:
Bug fixes:
concatIfValue
*IfValue
functions result, now typescript report an error when it happensPublished by juanluispaz over 4 years ago
Changes:
Published by juanluispaz over 4 years ago
Changes:
Published by juanluispaz over 4 years ago
Changes:
New examples:
Bug fixes:
Published by juanluispaz over 4 years ago
Changes:
Bug fixes:
Published by juanluispaz almost 5 years ago
Changes:
Bug fixes:
Published by juanluispaz about 5 years ago
Changes:
Bug fixes:
Published by juanluispaz about 5 years ago
Changes:
Bug fixes:
Published by juanluispaz about 5 years ago
Initial release