{"_id":"@denodeland/knex","_rev":"5-70aa70540433814d8f815ddccfe62008","time":{"created":"2023-07-26T16:32:19.136Z","2.5.1":"2023-07-26T16:09:26.782Z","modified":"2023-08-04T11:08:06.625Z","2.5.2":"2023-07-26T16:32:19.568Z","2.5.3":"2023-07-27T14:49:52.349Z","2.5.4":"2023-08-04T11:08:06.520Z"},"name":"@denodeland/knex","dist-tags":{"latest":"2.5.4"},"versions":{"2.5.2":{"name":"@denodeland/knex","version":"2.5.2","description":"A batteries-included SQL query & schema builder for PostgresSQL, MySQL, CockroachDB, MSSQL and SQLite3","main":"knex","types":"types/index.d.ts","engines":{"node":">=12"},"scripts":{"build":"npm run build:gitignore && npm run build:ts && npm run format","clean":"node scripts/clean.js","build:ts":"tsc","build:gitignore":"node scripts/update_gitignore_for_tsc_output.js run","format":"prettier --write --list-different .","format:check":"prettier --list-different .","debug:test":"mocha --inspect-brk --exit -t 0 test/all-tests-suite.js","debug:tape":"node --inspect-brk test/tape/index.js","coveralls":"nyc report --reporter=lcov","lint":"eslint --cache '**/*.js'","lint:fix":"eslint --cache --fix '**/*.js'","lint:types":"tsd && dtslint types","lint:everything":"npm run lint && npm run lint:types","lint:fix:everything":"npm run lint:fix && npm run lint:types","test:unit":"npm run test:unit-only && npm run test:cli","test:unit-only":"mocha --exit -t 10000 --config test/mocha-unit-config-test.js","test:db":"mocha --exit -t 10000 --config test/mocha-integration-config-test.js","test:db:coverage":"nyc mocha --exit --check-leaks -t 10000 --config test/mocha-integration-config-test.js && npm run test:tape","test:db:no-oracle":"cross-env DB=\"mssql mysql mysql2 postgres sqlite3\" mocha --exit -t 10000 --config test/mocha-integration-config-test.js && npm run test:tape","test":"mocha --exit -t 10000 --config test/mocha-all-config-test.js && npm run test:tape && npm run test:cli","test:coverage":"nyc mocha --exit --check-leaks -t 10000 --config test/mocha-all-config-test.js && npm run test:tape && npm run test:cli","test:everything":"npm run lint:everything && npm run test:coverage","test:mssql":"cross-env DB=mssql npm run test:db","test:mysql":"cross-env DB=mysql npm run test:db","test:mysql2":"cross-env DB=mysql2 npm run test:db","test:oracledb":"cross-env DB=oracledb npm run test:db","test:sqlite":"cross-env DB=sqlite3 npm run test:db","test:better-sqlite3":"cross-env DB=better-sqlite3 npm run test:db","test:postgres":"cross-env DB=postgres npm run test:db","test:cockroachdb":"cross-env DB=cockroachdb npm run test:db","test:pgnative":"cross-env DB=pgnative npm run test:db","test:tape":"node test/tape/index.js | tap-spec","test:cli":"cross-env KNEX_PATH=../knex.js KNEX=bin/cli.js jake -f test/jake/Jakefile","db:start":"docker-compose -f scripts/docker-compose.yml up --build -d mysql oracledb postgres mssql cockroachdb pgnative && docker-compose -f scripts/docker-compose.yml up waitmssql waitmysql waitpostgres waitoracledb","db:start:no-oracle":"docker-compose -f scripts/docker-compose.yml up --build -d mysql postgres mssql cockroachdb pgnative && docker-compose -f scripts/docker-compose.yml up waitmssql waitmysql waitpostgres","db:stop":"docker-compose -f scripts/docker-compose.yml down","db:start:postgres":"docker-compose -f scripts/docker-compose.yml up --build -d postgres && docker-compose -f scripts/docker-compose.yml up waitpostgres","db:stop:postgres":"docker-compose -f scripts/docker-compose.yml down","db:start:pgnative":"docker-compose -f scripts/docker-compose.yml up --build -d pgnative && docker-compose -f scripts/docker-compose.yml up waitpgnative","db:stop:pgnative":"docker-compose -f scripts/docker-compose.yml down","db:start:mysql":"docker-compose -f scripts/docker-compose.yml up --build -d mysql && docker-compose -f scripts/docker-compose.yml up waitmysql","db:stop:mysql":"docker-compose -f scripts/docker-compose.yml down","db:start:mssql":"docker-compose -f scripts/docker-compose.yml up --build -d mssql && docker-compose -f scripts/docker-compose.yml up waitmssql","db:stop:mssql":"docker-compose -f scripts/docker-compose.yml down","db:start:cockroachdb":"docker-compose -f scripts/docker-compose.yml up --build -d cockroachdb && docker-compose -f scripts/docker-compose.yml up waitcockroachdb","db:stop:cockroachdb":"docker-compose -f scripts/docker-compose.yml down","db:start:oracle":"docker-compose -f scripts/docker-compose.yml up --build -d oracledb && docker-compose -f scripts/docker-compose.yml up waitoracledb","db:stop:oracle":"docker-compose -f scripts/docker-compose.yml down","stress:init":"docker-compose -f scripts/stress-test/docker-compose.yml up --no-start && docker-compose -f scripts/stress-test/docker-compose.yml start","stress:test":"node scripts/stress-test/knex-stress-test.js | grep -A 5 -B 60 -- '- STATS '","stress:destroy":"docker-compose -f scripts/stress-test/docker-compose.yml stop","prepare":"husky install && npm run clean && npm run build","prepublishOnly":"npm run format:check && npm run lint:everything && npm run clean && npm run build"},"dependencies":{"colorette":"2.0.19","commander":"^10.0.0","debug":"4.3.4","escalade":"^3.1.1","esm":"^3.2.25","get-package-type":"^0.1.0","getopts":"2.3.0","interpret":"^2.2.0","lodash":"^4.17.21","pg-connection-string":"2.6.1","rechoir":"^0.8.0","resolve-from":"^5.0.0","tarn":"^3.0.2","tildify":"2.0.0"},"peerDependenciesMeta":{"tedious":{"optional":true},"mysql":{"optional":true},"mysql2":{"optional":true},"pg":{"optional":true},"pg-native":{"optional":true},"sqlite3":{"optional":true},"better-sqlite3":{"optional":true}},"lint-staged":{"*":"prettier --ignore-unknown --write","*.js":"eslint --cache --fix"},"devDependencies":{"@tsconfig/recommended":"^1.0.1","@types/node":"^20.4.0","better-sqlite3":"^7.6.2","chai":"^4.3.6","chai-as-promised":"^7.1.1","chai-subset-in-order":"^3.1.0","cli-testlab":"^2.2.0","coveralls":"^3.1.1","cross-env":"^7.0.3","dtslint":"4.2.1","eslint":"^8.32.0","eslint-config-prettier":"^8.6.0","eslint-plugin-import":"^2.26.0","eslint-plugin-mocha-no-only":"^1.1.1","eslint-plugin-prettier":"^4.2.1","husky":"^8.0.1","jake":"^10.8.5","JSONStream":"^1.3.5","lint-staged":"^13.0.0","mocha":"^10.0.0","mock-fs":"^5.1.4","mysql":"^2.18.1","mysql2":"^3.2.0","nyc":"^15.1.0","oracledb":"^5.4.0","pg":"^8.8.0","pg-query-stream":"^4.2.4","prettier":"2.8.7","rimraf":"^3.0.2","sinon":"^15.0.1","sinon-chai":"^3.7.0","source-map-support":"^0.5.21","sqlite3":"^5.0.11","tap-spec":"^5.0.0","tape":"^5.6.0","tedious":"^14.4.0","toxiproxy-node-client":"^2.0.6","ts-node":"^10.9.1","tsd":"^0.28.1","typescript":"5.0.4"},"buildDependencies":["rimraf"],"bin":{"knex":"bin/cli.js"},"repository":{"type":"git","url":"git://github.com/knex/knex.git"},"homepage":"https://knex.github.io/documentation/","keywords":["sql","query","postgresql","postgres","mysql","cockroachdb","sqlite3","oracle","mssql","builder","querybuilder","build","db","database"],"author":{"name":"Tim Griesser","url":"https://github.com/tgriesser"},"contributors":[{"name":"Mikael Lepisto"},{"name":"Igor Savin","url":"https://www.codeflashbacks.com"},{"name":"Olivier Cavadenti"},{"name":"Simon Liden"},{"name":"Paul Gaurab","url":"https://lorefnon.tech"},{"name":"Brian Lauber","url":"https://briandamaged.org"}],"browser":{"./lib/migrations/migrate/Migrator.js":"./lib/util/noop.js","./lib/bin/cli.js":"./lib/util/noop.js","./lib/migrations/seed/Seeder.js":"./lib/util/noop.js","tedious":false,"mysql":false,"mysql2":false,"pg":false,"pg-native":false,"pg-query-stream":false,"oracle":false,"sqlite3":false,"better-sqlite3":false,"oracledb":false},"react-native":{"./lib/migrate":"./lib/util/noop.js","./lib/seed":"./lib/util/noop.js"},"license":"MIT","tonicExampleFilename":"scripts/runkit-example.js","nyc":{"check-coverage":true,"lines":84,"statements":82,"functions":83,"branches":69,"extension":[".js"],"exclude":["lib/dialects/oracle","lib/dialects/oracledb","test/**/*.spec.js"]},"tsd":{"directory":"test-tsd","compilerOptions":{"esModuleInterop":false,"module":"commonjs","target":"ES2017"}},"gitHead":"96e13ff3e3935530e07e294b35ff970600156f72","bugs":{"url":"https://github.com/knex/knex/issues"},"_id":"@denodeland/knex@2.5.2","_nodeVersion":"18.7.0","_npmVersion":"8.15.0","dist":{"integrity":"sha512-6NuXRHlI0DLD3nBhI/QZPAJvtG27x+et5HdfGBQr49gLBC0wpqDIuTp1QoBmPsLBUcAHwkMVYWLXBhaubbCOdg==","shasum":"aa90ad93141ce128ae7585eb95902738ac735582","tarball":"https://registry.npmjs.org/@denodeland/knex/-/knex-2.5.2.tgz","fileCount":190,"unpackedSize":867703,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCWKuN7fNMcPCWupNmV5dv6p0B77eODfO2KZHYXhoAa/AIgCTP5rht1jO+lDiUrj8QqMBgxVQxKxu4kCk1vqxzx4Vk="}]},"_npmUser":{"name":"marcosc90","email":"marcoscvp90@gmail.com"},"directories":{},"maintainers":[{"name":"marcosc90","email":"marcoscvp90@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/knex_2.5.2_1690389139296_0.35733784611095687"},"_hasShrinkwrap":false},"2.5.3":{"name":"@denodeland/knex","version":"2.5.3","description":"A batteries-included SQL query & schema builder for PostgresSQL, MySQL, CockroachDB, MSSQL and SQLite3","main":"knex","types":"types/index.d.ts","engines":{"node":">=12"},"scripts":{"build":"npm run build:gitignore && npm run build:ts && npm run format","clean":"node scripts/clean.js","build:ts":"tsc","build:gitignore":"node scripts/update_gitignore_for_tsc_output.js run","format":"prettier --write --list-different .","format:check":"prettier --list-different .","debug:test":"mocha --inspect-brk --exit -t 0 test/all-tests-suite.js","debug:tape":"node --inspect-brk test/tape/index.js","coveralls":"nyc report --reporter=lcov","lint":"eslint --cache '**/*.js'","lint:fix":"eslint --cache --fix '**/*.js'","lint:types":"tsd && dtslint types","lint:everything":"npm run lint && npm run lint:types","lint:fix:everything":"npm run lint:fix && npm run lint:types","test:unit":"npm run test:unit-only && npm run test:cli","test:unit-only":"mocha --exit -t 10000 --config test/mocha-unit-config-test.js","test:db":"mocha --exit -t 10000 --config test/mocha-integration-config-test.js","test:db:coverage":"nyc mocha --exit --check-leaks -t 10000 --config test/mocha-integration-config-test.js && npm run test:tape","test:db:no-oracle":"cross-env DB=\"mssql mysql mysql2 postgres sqlite3\" mocha --exit -t 10000 --config test/mocha-integration-config-test.js && npm run test:tape","test":"mocha --exit -t 10000 --config test/mocha-all-config-test.js && npm run test:tape && npm run test:cli","test:coverage":"nyc mocha --exit --check-leaks -t 10000 --config test/mocha-all-config-test.js && npm run test:tape && npm run test:cli","test:everything":"npm run lint:everything && npm run test:coverage","test:mssql":"cross-env DB=mssql npm run test:db","test:mysql":"cross-env DB=mysql npm run test:db","test:mysql2":"cross-env DB=mysql2 npm run test:db","test:oracledb":"cross-env DB=oracledb npm run test:db","test:sqlite":"cross-env DB=sqlite3 npm run test:db","test:better-sqlite3":"cross-env DB=better-sqlite3 npm run test:db","test:postgres":"cross-env DB=postgres npm run test:db","test:cockroachdb":"cross-env DB=cockroachdb npm run test:db","test:pgnative":"cross-env DB=pgnative npm run test:db","test:tape":"node test/tape/index.js | tap-spec","test:cli":"cross-env KNEX_PATH=../knex.js KNEX=bin/cli.js jake -f test/jake/Jakefile","db:start":"docker-compose -f scripts/docker-compose.yml up --build -d mysql oracledb postgres mssql cockroachdb pgnative && docker-compose -f scripts/docker-compose.yml up waitmssql waitmysql waitpostgres waitoracledb","db:start:no-oracle":"docker-compose -f scripts/docker-compose.yml up --build -d mysql postgres mssql cockroachdb pgnative && docker-compose -f scripts/docker-compose.yml up waitmssql waitmysql waitpostgres","db:stop":"docker-compose -f scripts/docker-compose.yml down","db:start:postgres":"docker-compose -f scripts/docker-compose.yml up --build -d postgres && docker-compose -f scripts/docker-compose.yml up waitpostgres","db:stop:postgres":"docker-compose -f scripts/docker-compose.yml down","db:start:pgnative":"docker-compose -f scripts/docker-compose.yml up --build -d pgnative && docker-compose -f scripts/docker-compose.yml up waitpgnative","db:stop:pgnative":"docker-compose -f scripts/docker-compose.yml down","db:start:mysql":"docker-compose -f scripts/docker-compose.yml up --build -d mysql && docker-compose -f scripts/docker-compose.yml up waitmysql","db:stop:mysql":"docker-compose -f scripts/docker-compose.yml down","db:start:mssql":"docker-compose -f scripts/docker-compose.yml up --build -d mssql && docker-compose -f scripts/docker-compose.yml up waitmssql","db:stop:mssql":"docker-compose -f scripts/docker-compose.yml down","db:start:cockroachdb":"docker-compose -f scripts/docker-compose.yml up --build -d cockroachdb && docker-compose -f scripts/docker-compose.yml up waitcockroachdb","db:stop:cockroachdb":"docker-compose -f scripts/docker-compose.yml down","db:start:oracle":"docker-compose -f scripts/docker-compose.yml up --build -d oracledb && docker-compose -f scripts/docker-compose.yml up waitoracledb","db:stop:oracle":"docker-compose -f scripts/docker-compose.yml down","stress:init":"docker-compose -f scripts/stress-test/docker-compose.yml up --no-start && docker-compose -f scripts/stress-test/docker-compose.yml start","stress:test":"node scripts/stress-test/knex-stress-test.js | grep -A 5 -B 60 -- '- STATS '","stress:destroy":"docker-compose -f scripts/stress-test/docker-compose.yml stop","prepare":"husky install && npm run clean && npm run build","prepublishOnly":"npm run format:check && npm run lint:everything && npm run clean && npm run build"},"dependencies":{"colorette":"2.0.19","commander":"^10.0.0","debug":"4.3.4","escalade":"^3.1.1","esm":"^3.2.25","get-package-type":"^0.1.0","getopts":"2.3.0","interpret":"^2.2.0","lodash":"^4.17.21","pg-connection-string":"2.6.1","rechoir":"^0.8.0","resolve-from":"^5.0.0","tarn":"^3.0.2","tildify":"2.0.0"},"peerDependenciesMeta":{"tedious":{"optional":true},"mysql":{"optional":true},"mysql2":{"optional":true},"pg":{"optional":true},"pg-native":{"optional":true},"sqlite3":{"optional":true},"better-sqlite3":{"optional":true}},"lint-staged":{"*":"prettier --ignore-unknown --write","*.js":"eslint --cache --fix"},"devDependencies":{"@tsconfig/recommended":"^1.0.1","@types/node":"^20.4.0","better-sqlite3":"^7.6.2","chai":"^4.3.6","chai-as-promised":"^7.1.1","chai-subset-in-order":"^3.1.0","cli-testlab":"^2.2.0","coveralls":"^3.1.1","cross-env":"^7.0.3","dtslint":"4.2.1","eslint":"^8.32.0","eslint-config-prettier":"^8.6.0","eslint-plugin-import":"^2.26.0","eslint-plugin-mocha-no-only":"^1.1.1","eslint-plugin-prettier":"^4.2.1","husky":"^8.0.1","jake":"^10.8.5","JSONStream":"^1.3.5","lint-staged":"^13.0.0","mocha":"^10.0.0","mock-fs":"^5.1.4","mysql":"^2.18.1","mysql2":"^3.2.0","nyc":"^15.1.0","oracledb":"^5.4.0","pg":"^8.8.0","pg-query-stream":"^4.2.4","prettier":"2.8.7","rimraf":"^3.0.2","sinon":"^15.0.1","sinon-chai":"^3.7.0","source-map-support":"^0.5.21","sqlite3":"^5.0.11","tap-spec":"^5.0.0","tape":"^5.6.0","tedious":"^14.4.0","toxiproxy-node-client":"^2.0.6","ts-node":"^10.9.1","tsd":"^0.28.1","typescript":"5.0.4"},"buildDependencies":["rimraf"],"bin":{"knex":"bin/cli.js"},"repository":{"type":"git","url":"git://github.com/knex/knex.git"},"homepage":"https://knex.github.io/documentation/","keywords":["sql","query","postgresql","postgres","mysql","cockroachdb","sqlite3","oracle","mssql","builder","querybuilder","build","db","database"],"author":{"name":"Tim Griesser","url":"https://github.com/tgriesser"},"contributors":[{"name":"Mikael Lepisto"},{"name":"Igor Savin","url":"https://www.codeflashbacks.com"},{"name":"Olivier Cavadenti"},{"name":"Simon Liden"},{"name":"Paul Gaurab","url":"https://lorefnon.tech"},{"name":"Brian Lauber","url":"https://briandamaged.org"}],"browser":{"./lib/migrations/migrate/Migrator.js":"./lib/util/noop.js","./lib/bin/cli.js":"./lib/util/noop.js","./lib/migrations/seed/Seeder.js":"./lib/util/noop.js","tedious":false,"mysql":false,"mysql2":false,"pg":false,"pg-native":false,"pg-query-stream":false,"oracle":false,"sqlite3":false,"better-sqlite3":false,"oracledb":false},"react-native":{"./lib/migrate":"./lib/util/noop.js","./lib/seed":"./lib/util/noop.js"},"license":"MIT","tonicExampleFilename":"scripts/runkit-example.js","nyc":{"check-coverage":true,"lines":84,"statements":82,"functions":83,"branches":69,"extension":[".js"],"exclude":["lib/dialects/oracle","lib/dialects/oracledb","test/**/*.spec.js"]},"tsd":{"directory":"test-tsd","compilerOptions":{"esModuleInterop":false,"module":"commonjs","target":"ES2017"}},"gitHead":"f60a9c5d7d5ee2e39937c0bd2241980cad086760","bugs":{"url":"https://github.com/knex/knex/issues"},"_id":"@denodeland/knex@2.5.3","_nodeVersion":"18.7.0","_npmVersion":"8.15.0","dist":{"integrity":"sha512-+LglCsUz5WbC6jlJOY2SdI40tGZAHdrmrOFZLyXDgP+BhVhDD2bkhOhF908bsyONsqKjw3olSdYdY8BKdL+KUQ==","shasum":"6aaf9372f12e01d868a072221442371b13316a7d","tarball":"https://registry.npmjs.org/@denodeland/knex/-/knex-2.5.3.tgz","fileCount":190,"unpackedSize":867760,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIGWQ3aXOPtZZU9O1WI7wMWpqlPPstGnpkyTmJeAq4FslAiEA7igXJaJdXKfc5OU36n1A9syqi9c/eD8Tkte6Rfc/wBQ="}]},"_npmUser":{"name":"marcosc90","email":"marcoscvp90@gmail.com"},"directories":{},"maintainers":[{"name":"marcosc90","email":"marcoscvp90@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/knex_2.5.3_1690469392098_0.16600021048917935"},"_hasShrinkwrap":false},"2.5.4":{"name":"@denodeland/knex","version":"2.5.4","description":"A batteries-included SQL query & schema builder for PostgresSQL, MySQL, CockroachDB, MSSQL and SQLite3","main":"knex","types":"types/index.d.ts","engines":{"node":">=12"},"scripts":{"build":"npm run build:gitignore && npm run build:ts && npm run format","clean":"node scripts/clean.js","build:ts":"tsc","build:gitignore":"node scripts/update_gitignore_for_tsc_output.js run","format":"prettier --write --list-different .","format:check":"prettier --list-different .","debug:test":"mocha --inspect-brk --exit -t 0 test/all-tests-suite.js","debug:tape":"node --inspect-brk test/tape/index.js","coveralls":"nyc report --reporter=lcov","lint":"eslint --cache '**/*.js'","lint:fix":"eslint --cache --fix '**/*.js'","lint:types":"tsd && dtslint types","lint:everything":"npm run lint && npm run lint:types","lint:fix:everything":"npm run lint:fix && npm run lint:types","test:unit":"npm run test:unit-only && npm run test:cli","test:unit-only":"mocha --exit -t 10000 --config test/mocha-unit-config-test.js","test:db":"mocha --exit -t 10000 --config test/mocha-integration-config-test.js","test:db:coverage":"nyc mocha --exit --check-leaks -t 10000 --config test/mocha-integration-config-test.js && npm run test:tape","test:db:no-oracle":"cross-env DB=\"mssql mysql mysql2 postgres sqlite3\" mocha --exit -t 10000 --config test/mocha-integration-config-test.js && npm run test:tape","test":"mocha --exit -t 10000 --config test/mocha-all-config-test.js && npm run test:tape && npm run test:cli","test:coverage":"nyc mocha --exit --check-leaks -t 10000 --config test/mocha-all-config-test.js && npm run test:tape && npm run test:cli","test:everything":"npm run lint:everything && npm run test:coverage","test:mssql":"cross-env DB=mssql npm run test:db","test:mysql":"cross-env DB=mysql npm run test:db","test:mysql2":"cross-env DB=mysql2 npm run test:db","test:oracledb":"cross-env DB=oracledb npm run test:db","test:sqlite":"cross-env DB=sqlite3 npm run test:db","test:better-sqlite3":"cross-env DB=better-sqlite3 npm run test:db","test:postgres":"cross-env DB=postgres npm run test:db","test:cockroachdb":"cross-env DB=cockroachdb npm run test:db","test:pgnative":"cross-env DB=pgnative npm run test:db","test:tape":"node test/tape/index.js | tap-spec","test:cli":"cross-env KNEX_PATH=../knex.js KNEX=bin/cli.js jake -f test/jake/Jakefile","db:start":"docker-compose -f scripts/docker-compose.yml up --build -d mysql oracledb postgres mssql cockroachdb pgnative && docker-compose -f scripts/docker-compose.yml up waitmssql waitmysql waitpostgres waitoracledb","db:start:no-oracle":"docker-compose -f scripts/docker-compose.yml up --build -d mysql postgres mssql cockroachdb pgnative && docker-compose -f scripts/docker-compose.yml up waitmssql waitmysql waitpostgres","db:stop":"docker-compose -f scripts/docker-compose.yml down","db:start:postgres":"docker-compose -f scripts/docker-compose.yml up --build -d postgres && docker-compose -f scripts/docker-compose.yml up waitpostgres","db:stop:postgres":"docker-compose -f scripts/docker-compose.yml down","db:start:pgnative":"docker-compose -f scripts/docker-compose.yml up --build -d pgnative && docker-compose -f scripts/docker-compose.yml up waitpgnative","db:stop:pgnative":"docker-compose -f scripts/docker-compose.yml down","db:start:mysql":"docker-compose -f scripts/docker-compose.yml up --build -d mysql && docker-compose -f scripts/docker-compose.yml up waitmysql","db:stop:mysql":"docker-compose -f scripts/docker-compose.yml down","db:start:mssql":"docker-compose -f scripts/docker-compose.yml up --build -d mssql && docker-compose -f scripts/docker-compose.yml up waitmssql","db:stop:mssql":"docker-compose -f scripts/docker-compose.yml down","db:start:cockroachdb":"docker-compose -f scripts/docker-compose.yml up --build -d cockroachdb && docker-compose -f scripts/docker-compose.yml up waitcockroachdb","db:stop:cockroachdb":"docker-compose -f scripts/docker-compose.yml down","db:start:oracle":"docker-compose -f scripts/docker-compose.yml up --build -d oracledb && docker-compose -f scripts/docker-compose.yml up waitoracledb","db:stop:oracle":"docker-compose -f scripts/docker-compose.yml down","stress:init":"docker-compose -f scripts/stress-test/docker-compose.yml up --no-start && docker-compose -f scripts/stress-test/docker-compose.yml start","stress:test":"node scripts/stress-test/knex-stress-test.js | grep -A 5 -B 60 -- '- STATS '","stress:destroy":"docker-compose -f scripts/stress-test/docker-compose.yml stop","prepare":"husky install && npm run clean && npm run build","prepublishOnly":"npm run format:check && npm run lint:everything && npm run clean && npm run build"},"dependencies":{"colorette":"2.0.19","commander":"^10.0.0","debug":"4.3.4","escalade":"^3.1.1","esm":"^3.2.25","get-package-type":"^0.1.0","getopts":"2.3.0","interpret":"^2.2.0","lodash":"^4.17.21","pg-connection-string":"2.6.1","rechoir":"^0.8.0","resolve-from":"^5.0.0","tarn":"^3.0.2","tildify":"2.0.0"},"peerDependenciesMeta":{"tedious":{"optional":true},"mysql":{"optional":true},"mysql2":{"optional":true},"pg":{"optional":true},"pg-native":{"optional":true},"sqlite3":{"optional":true},"better-sqlite3":{"optional":true}},"lint-staged":{"*":"prettier --ignore-unknown --write","*.js":"eslint --cache --fix"},"devDependencies":{"@tsconfig/recommended":"^1.0.1","@types/node":"^20.4.0","better-sqlite3":"^7.6.2","chai":"^4.3.6","chai-as-promised":"^7.1.1","chai-subset-in-order":"^3.1.0","cli-testlab":"^2.2.0","coveralls":"^3.1.1","cross-env":"^7.0.3","dtslint":"4.2.1","eslint":"^8.32.0","eslint-config-prettier":"^8.6.0","eslint-plugin-import":"^2.26.0","eslint-plugin-mocha-no-only":"^1.1.1","eslint-plugin-prettier":"^4.2.1","husky":"^8.0.1","jake":"^10.8.5","JSONStream":"^1.3.5","lint-staged":"^13.0.0","mocha":"^10.0.0","mock-fs":"^5.1.4","mysql":"^2.18.1","mysql2":"^3.2.0","nyc":"^15.1.0","oracledb":"^5.4.0","pg":"^8.8.0","pg-query-stream":"^4.2.4","prettier":"2.8.7","rimraf":"^3.0.2","sinon":"^15.0.1","sinon-chai":"^3.7.0","source-map-support":"^0.5.21","sqlite3":"^5.0.11","tap-spec":"^5.0.0","tape":"^5.6.0","tedious":"^14.4.0","toxiproxy-node-client":"^2.0.6","ts-node":"^10.9.1","tsd":"^0.28.1","typescript":"5.0.4"},"buildDependencies":["rimraf"],"bin":{"knex":"bin/cli.js"},"repository":{"type":"git","url":"git://github.com/knex/knex.git"},"homepage":"https://knex.github.io/documentation/","keywords":["sql","query","postgresql","postgres","mysql","cockroachdb","sqlite3","oracle","mssql","builder","querybuilder","build","db","database"],"author":{"name":"Tim Griesser","url":"https://github.com/tgriesser"},"contributors":[{"name":"Mikael Lepisto"},{"name":"Igor Savin","url":"https://www.codeflashbacks.com"},{"name":"Olivier Cavadenti"},{"name":"Simon Liden"},{"name":"Paul Gaurab","url":"https://lorefnon.tech"},{"name":"Brian Lauber","url":"https://briandamaged.org"}],"browser":{"./lib/migrations/migrate/Migrator.js":"./lib/util/noop.js","./lib/bin/cli.js":"./lib/util/noop.js","./lib/migrations/seed/Seeder.js":"./lib/util/noop.js","tedious":false,"mysql":false,"mysql2":false,"pg":false,"pg-native":false,"pg-query-stream":false,"oracle":false,"sqlite3":false,"better-sqlite3":false,"oracledb":false},"react-native":{"./lib/migrate":"./lib/util/noop.js","./lib/seed":"./lib/util/noop.js"},"license":"MIT","tonicExampleFilename":"scripts/runkit-example.js","nyc":{"check-coverage":true,"lines":84,"statements":82,"functions":83,"branches":69,"extension":[".js"],"exclude":["lib/dialects/oracle","lib/dialects/oracledb","test/**/*.spec.js"]},"tsd":{"directory":"test-tsd","compilerOptions":{"esModuleInterop":false,"module":"commonjs","target":"ES2017"}},"gitHead":"f6b93979cdb0b2f6487e32007fb603eef049a2da","bugs":{"url":"https://github.com/knex/knex/issues"},"_id":"@denodeland/knex@2.5.4","_nodeVersion":"18.7.0","_npmVersion":"8.15.0","dist":{"integrity":"sha512-kQReOj/HiFC7tOIDR6CboEDdB+7VOYEynvzVYOrBNRtHUeaDFyB7XhC4z8VADru5NkP8mwaJGugY55puZklZ+Q==","shasum":"ba1be8b1b6ebf9e9942da69d3ba16ab8c3134172","tarball":"https://registry.npmjs.org/@denodeland/knex/-/knex-2.5.4.tgz","fileCount":190,"unpackedSize":867817,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQDBwAuoXG89Inw144JY2Z/I8IRHDYu2rKbhqby77bl8DAIhALLyF23Ne6a1IYDV6SIKG2EWMUDWeBCFsoQzb0ImW0iI"}]},"_npmUser":{"name":"marcosc90","email":"marcoscvp90@gmail.com"},"directories":{},"maintainers":[{"name":"marcosc90","email":"marcoscvp90@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/knex_2.5.4_1691147286250_0.5169240714232466"},"_hasShrinkwrap":false}},"maintainers":[{"name":"marcosc90","email":"marcoscvp90@gmail.com"}],"description":"A batteries-included SQL query & schema builder for PostgresSQL, MySQL, CockroachDB, MSSQL and SQLite3","homepage":"https://knex.github.io/documentation/","keywords":["sql","query","postgresql","postgres","mysql","cockroachdb","sqlite3","oracle","mssql","builder","querybuilder","build","db","database"],"repository":{"type":"git","url":"git://github.com/knex/knex.git"},"contributors":[{"name":"Mikael Lepisto"},{"name":"Igor Savin","url":"https://www.codeflashbacks.com"},{"name":"Olivier Cavadenti"},{"name":"Simon Liden"},{"name":"Paul Gaurab","url":"https://lorefnon.tech"},{"name":"Brian Lauber","url":"https://briandamaged.org"}],"author":{"name":"Tim Griesser","url":"https://github.com/tgriesser"},"bugs":{"url":"https://github.com/knex/knex/issues"},"license":"MIT","readme":"# [knex.js](https://knex.github.io/documentation/)\n\n[![npm version](http://img.shields.io/npm/v/knex.svg)](https://npmjs.org/package/knex)\n[![npm downloads](https://img.shields.io/npm/dm/knex.svg)](https://npmjs.org/package/knex)\n![](https://github.com/knex/knex/workflows/CI/badge.svg)\n[![Coverage Status](https://coveralls.io/repos/knex/knex/badge.svg?branch=master)](https://coveralls.io/r/knex/knex?branch=master)\n[![Dependencies Status](https://img.shields.io/librariesio/github/knex/knex)](https://libraries.io/npm/knex)\n[![Gitter chat](https://badges.gitter.im/tgriesser/knex.svg)](https://gitter.im/tgriesser/knex)\n\n> **A SQL query builder that is _flexible_, _portable_, and _fun_ to use!**\n\nA batteries-included, multi-dialect (PostgreSQL, MySQL, CockroachDB, MSSQL, SQLite3, Oracle (including Oracle Wallet Authentication)) query builder for\nNode.js, featuring:\n\n- [transactions](https://knex.github.io/documentation/#Transactions)\n- [connection pooling](https://knex.github.io/documentation/#Installation-pooling)\n- [streaming queries](https://knex.github.io/documentation/#Interfaces-Streams)\n- both a [promise](https://knex.github.io/documentation/#Interfaces-Promises) and [callback](https://knex.github.io/documentation/#Interfaces-Callbacks) API\n- a [thorough test suite](https://github.com/knex/knex/actions)\n\nNode.js versions 12+ are supported.\n\n- Take a look at the [full documentation](https://knex.github.io/documentation) to get started!\n- Browse the [list of plugins and tools](https://github.com/knex/knex/blob/master/ECOSYSTEM.md) built for knex\n- Check out our [recipes wiki](https://github.com/knex/knex/wiki/Recipes) to search for solutions to some specific problems\n- In case of upgrading from an older version, see [migration guide](https://github.com/knex/knex/blob/master/UPGRADING.md)\n\nYou can report bugs and discuss features on the [GitHub issues page](https://github.com/knex/knex/issues) or send tweets to [@kibertoad](http://twitter.com/kibertoad).\n\nFor support and questions, join our [Gitter channel](https://gitter.im/tgriesser/knex).\n\nFor knex-based Object Relational Mapper, see:\n\n- https://github.com/Vincit/objection.js\n- https://github.com/mikro-orm/mikro-orm\n- https://bookshelfjs.org\n\nTo see the SQL that Knex will generate for a given query, you can use [Knex Query Lab](https://michaelavila.com/knex-querylab/)\n\n## Examples\n\nWe have several examples [on the website](http://knexjs.org). Here is the first one to get you started:\n\n```js\nconst knex = require('knex')({\n  client: 'sqlite3',\n  connection: {\n    filename: './data.db',\n  },\n});\n\ntry {\n  // Create a table\n  await knex.schema\n    .createTable('users', (table) => {\n      table.increments('id');\n      table.string('user_name');\n    })\n    // ...and another\n    .createTable('accounts', (table) => {\n      table.increments('id');\n      table.string('account_name');\n      table.integer('user_id').unsigned().references('users.id');\n    });\n\n  // Then query the table...\n  const insertedRows = await knex('users').insert({ user_name: 'Tim' });\n\n  // ...and using the insert id, insert into the other table.\n  await knex('accounts').insert({\n    account_name: 'knex',\n    user_id: insertedRows[0],\n  });\n\n  // Query both of the rows.\n  const selectedRows = await knex('users')\n    .join('accounts', 'users.id', 'accounts.user_id')\n    .select('users.user_name as user', 'accounts.account_name as account');\n\n  // map over the results\n  const enrichedRows = selectedRows.map((row) => ({ ...row, active: true }));\n\n  // Finally, add a catch statement\n} catch (e) {\n  console.error(e);\n}\n```\n\n## TypeScript example\n\n```ts\nimport { Knex, knex } from 'knex';\n\ninterface User {\n  id: number;\n  age: number;\n  name: string;\n  active: boolean;\n  departmentId: number;\n}\n\nconst config: Knex.Config = {\n  client: 'sqlite3',\n  connection: {\n    filename: './data.db',\n  },\n};\n\nconst knexInstance = knex(config);\n\ntry {\n  const users = await knex<User>('users').select('id', 'age');\n} catch (err) {\n  // error handling\n}\n```\n\n## Usage as ESM module\n\nIf you are launching your Node application with `--experimental-modules`, `knex.mjs` should be picked up automatically and named ESM import should work out-of-the-box.\nOtherwise, if you want to use named imports, you'll have to import knex like this:\n\n```js\nimport { knex } from 'knex/knex.mjs';\n```\n\nYou can also just do the default import:\n\n```js\nimport knex from 'knex';\n```\n\nIf you are not using TypeScript and would like the IntelliSense of your IDE to work correctly, it is recommended to set the type explicitly:\n\n```js\n/**\n * @type {Knex}\n */\nconst database = knex({\n  client: 'mysql',\n  connection: {\n    host: '127.0.0.1',\n    user: 'your_database_user',\n    password: 'your_database_password',\n    database: 'myapp_test',\n  },\n});\ndatabase.migrate.latest();\n```\n","readmeFilename":"README.md"}