当前位置：首页 > 软件库 > 数据库相关 > >

knex

授权协议 MIT License

开发语言 C/C++

所属分类数据库相关

软件类型开源软件

地区不详

投递者雍河

操作系统跨平台

开源组织无

适用人群未知

软件概览

knex.js

A SQL query builder that is flexible, portable, and fun to use!

A batteries-included, multi-dialect (MSSQL, MySQL, PostgreSQL, SQLite3, Oracle (including Oracle Wallet Authentication)) query builder forNode.js, featuring:

Node.js versions 10+ are supported.

Take a look at the full documentation to get started!
Browse the list of plugins and tools built for knex
Check out our recipes wiki to search for solutions to some specific problems
In case of upgrading from an older version, see migration guide

You can report bugs and discuss features on the GitHub issues page or send tweets to @kibertoad.

For support and questions, join our Gitter channel.

For knex-based Object Relational Mapper, see:

To see the SQL that Knex will generate for a given query, you can use Knex Query Lab

Examples

We have several examples on the website. Here is the first one to get you started:

const knex = require('knex')({
  client: 'sqlite3',
  connection: {
    filename: './data.db',
  },
});

try {

  // Create a table
  await knex.schema
    .createTable('users', table => {
      table.increments('id');
      table.string('user_name');
    })
    // ...and another
    .createTable('accounts', table => {
      table.increments('id');
      table.string('account_name');
      table
        .integer('user_id')
        .unsigned()
        .references('users.id');
    })

  // Then query the table...
  const insertedRows = await knex('users').insert({ user_name: 'Tim' })

  // ...and using the insert id, insert into the other table.
  await knex('accounts').insert({ account_name: 'knex', user_id: insertedRows[0] })

  // Query both of the rows.
  const selectedRows = await knex('users')
    .join('accounts', 'users.id', 'accounts.user_id')
    .select('users.user_name as user', 'accounts.account_name as account')

  // map over the results
  const enrichedRows = selectedRows.map(row => ({ ...row, active: true }))

  // Finally, add a catch statement
} catch(e) {
  console.error(e);
};

TypeScript example

import { Knex, knex } from 'knex'

interface User {
  id: number;
  age: number;
  name: string;
  active: boolean;
  departmentId: number;
}

const config: Knex.Config = {
  client: 'sqlite3',
  connection: {
    filename: './data.db',
  },
};

const knexInstance = knex(config);

try {
  const users = await knex<User>('users').select('id', 'age');
} catch (err) {
  // error handling
}

Usage as ESM module

If 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.Otherwise, if you want to use named imports, you'll have to import knex like this:

import { knex } from 'knex/knex.mjs'

You can also just do the default import:

import knex from 'knex'

If you are not using TypeScript and would like the IntelliSense of your IDE to work correctly, it is recommended to set the type explicitly:

/**
 * @type {Knex}
 */
const database = knex({
    client: 'mysql',
    connection: {
      host : '127.0.0.1',
      user : 'your_database_user',
      password : 'your_database_password',
      database : 'myapp_test'
    }
  });
database.migrate.latest();

使用案例

nodejs之knex模块从安装到使用

knex.js是bookshelf框架的基础，其核心是query builder。这篇文章参考自Knex.js官网，翻译并总结了该框架的方法。 0 安装 #以PostgreSql为例 sudo npm install knex --save sudo npm install pg --save 0 1 2 #以PostgreSql为例 sudonpminstallknex--save sudonp
knex

//建表 knex migrate:make steup 转载于:https://www.cnblogs.com/mjhelloworld/p/6958521.html
knex入门学习使用方法

创建knex对象注：页面引用knex.min.js后，才能创建knex 创建不含数据连接的knex对象 var myknex = new knex.Client({ client: 'mysql', }) 创建含有数据连接的knex对象(待验证) var pg = new knex.Client({ client: 'websql', connection: { h
使用knex创建postgresql表knex迁移

knex是nodejs中访问数据库的一个模块，支持多种数据库，并且使用knex可以使用js代码维护数据库表，官网：本文讲创建数据表的部分，关于配置和迁移配置请参见官方文档：一、创建迁移文件 knex migrate:make users 其中 users = 表名，执行该命令后将会在配置的迁移文件目录生成文件：20201203093439_users.js 打开文件，内容如下： exports
knex的基本用法

1. 查询 knex('table').select() 2. 带条件查询 knex('table').where('id', 1).select() knex('table').where({'id': 1}).select() 3. 新增 knex('table').insert({'name': '名字'}) 4. 更新(更新所有数据) knex('table').update('name
nodejs插件knex & 日志打印

nodejs学习 1、express & nodejs & mysql 新建项目 2、nodejs尝试登陆接口 3、nodejs的前端项目搭建以及登陆接口开发 4、前端上传图片formdata格式,后端接口处理 5、vue+nodejs双表联动 6、nodejs插件knex & 日志打印 7、vue3+nodejs基于RSA加密的身份认证前端代码地址(不完全功能) 后端代码地址(不完全功能) k

knex

knex.js

Examples

TypeScript example

Usage as ESM module

同类工具

相关阅读

相关文章

相关问答

相关文档