Pg-Connector

Lib 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.

Installation

• npm

  npm i pg-connector --save

• yarn

  yarn add pg-connector --save

Quick Example

• Instance (core/pg.js)

  // core/pg.js
  import 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 exists
  
  export default User

Usage

• import

  import PgConnector from 'pg-connector'
  // or
  const 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