How to use the knex/src/query/string.escape function in knex
To help you get started, we’ve selected a few knex examples, based on popular ways it is used in public projects.
Secure your code as it's written. Use Snyk Code to scan source code in minutes - no build needed - and fix issues immediately.
rexxars / sql-to-graphql / backends / sqlite.js View on Github 
getTableStructure: function(tableName, cb) {
var dbName = opts.database || 'main';
var rawSql = 'pragma '
+ knexString.escape(dbName)
+ '.table_info('
+ knexString.escape(tableName)
+ ');';
sqlite
.raw(rawSql)
.catch(cb)
.then(function(info) {
var structure = info.map(function(col) {
var parensAndContents = /\(.+\)/;
var sanitizedType = col.type
.toLowerCase()
.replace(parensAndContents, '');
return {
columnName: col.name,
isNullable: col.notnull !== 1,
columnKey: col.pk === 1 ? 'PRI' : null,
dataType: sanitizedType
};getTableStructure: function(tableName, cb) {
var dbName = opts.database || 'main';
var rawSql = 'pragma '
+ knexString.escape(dbName)
+ '.table_info('
+ knexString.escape(tableName)
+ ');';
sqlite
.raw(rawSql)
.catch(cb)
.then(function(info) {
var structure = info.map(function(col) {
var parensAndContents = /\(.+\)/;
var sanitizedType = col.type
.toLowerCase()
.replace(parensAndContents, '');
return {
columnName: col.name,
isNullable: col.notnull !== 1,
columnKey: col.pk === 1 ? 'PRI' : null,knex
A batteries-included SQL query & schema builder for PostgresSQL, MySQL, CockroachDB, MSSQL and SQLite3
Package Health Score
83 / 100Popular knex functions
- knex
- knex.Client
- knex.constructor
- knex.Initialize
- knex.initialize
- knex.knex
- knex.Promise
- knex.Promise.all
- knex.Promise.coroutine
- knex.Promise.reject
- knex.Promise.resolve
- knex.raw
- knex/lib/builder.Builder
- knex/lib/dialects/sqlite3.prototype
- knex/lib/dialects/sqlite3/index.js.prototype
- knex/lib/formatter.prototype
- knex/lib/helpers.resolveClientNameWithAliases
- knex/lib/promise.method
- knex/lib/query/builder.prototype
- knex/src/query/string.escape