开源软件名称:pg-connector
开源软件地址:https://gitee.com/JandenMa/pg-connector
开源软件介绍:
Pg-ConnectorLib Version:0.1.6 Document Version:0.1.6 Author:Janden Ma LICENCE: MIT
Version Change Logs- v0.1.1 (Build20200514): Correct
orderBy option for build querying sql - v0.1.2 (Build20200514): Update README
- v0.1.3 (Build20200515): Optimizations
- v0.1.4 (Build20200621): Resolve bugs
- v0.1.5 (Build20200729): Bug fixes
- v0.1.6 (Build20201010): Support PostgreSQL 13
What is Pg-Connector?Pg-Connector is an ORM library for Postgresql on NodeJS. Installationnpm npm i pg-connector --save yarn yarn add pg-connector --save
Quick ExampleInstance (core/pg.js) // core/pg.jsimport PgConnector from 'pg-connector'const Pg = new PgConnector({ host: 'http://192.168.1.100', port: 5432, userName: 'root', password: '123456', database: 'test', connectionTimeoutMillis: 0, idleTimeoutMillis: 60000, ssl: true})export default Pg Model (models/users.js) import Pg from '../core/pg.js';class User extends Pg.Model{ constructor(){ super({ autoCreate: true, tables: [ { index: 0, name: 'users', primaryKeys: ['id'], fields: [ { name: 'id', type: Pg.DataType.SERIAL }, { name: 'name', type: Pg.DataType.VARCHAR, length: 100 }, { name: 'age', type: Pg.DataType.INT } ] } ] }); // other functions you want to override or customize }}User.init(); // will create data table if not existsexport default User
Usageimport import PgConnector from 'pg-connector'// orconst PgConnector = require('pg-connector') Instantiate const Pg = new PgConnector({ host: 'http://192.168.1.100', port: 5432, userName: 'root', password: '123456', database: 'test', connectionTimeoutMillis: 0, idleTimeoutMillis: 60000, ssl: true}) Key | Type | Introduction | Default value |
---|
host | string | Postgresql server host | "localhost" | port | number | Postgresql server port | 5432 | userName | string | Postgresql server user name | "postgres" | password | string | Postgresql server password | ""(empty) | database | string | Postgresql database name | "postgres" | connectionMax | number | Postgresql database max connection | 10 | connectionTimeoutMillis | number | Number of milliseconds to wait before timing out when connecting a new client, by default this is 0 which means no timeout | 0 | idleTimeoutMillis | number | Number of milliseconds a client must sit idle in the pool and not be checked out, before it is disconnected from the backend and discarded, default is 10000 (10 seconds) - set to 0 to disable auto-disconnection of idle clients | 10000 | ssl | boolean | To connect to pg using ssl | false |
Modules- LibDataAccess
- LibSQLBuilder
- LibModel
- DataTypes
- SERIAL: Serial Id
- BIT
- BOOLEAN
- CHAR
- VARCHAR
- INT: Int 4
- BIGINT: Int 8
- SMALLINT: Int 2
- FLOAT
- DOUBLE
- DECIMAL
- NUMERIC
- JSON
- DATE
- TIMESTAMP
- TIMESTAMPTZ: Timestamp with time zone
- TEXT
|
请发表评论