0.3.1 • Published 7 years ago

@useful/postgresql v0.3.1

Weekly downloads
-
License
MIT
Repository
github
Last release
7 years ago

@useful/postgresql

Example usage

import { connect, disconnect, query, transaction, migrate, seed } from "@useful/postgresql";

(async function() {
  await connect();
  const migrationResult = await migrate([
    `CREATE TABLE users (
      id    BIGSERIAL PRIMARY KEY,
      name  character varying(255)
    )`,
    `CREATE TABLE roles (
      id    SERIAL PRIMARY KEY,
      name  character varying(255)
    )`,
  ]);
  const seedResult = await seed([
    `INSERT INTO users(name) VALUES('Mr. Spock')`,
    `INSERT INTO roles(name) VALUES('Chief Science Officer')`,
  ]);
  const queryResult = await query({
    text: "SELECT * FROM users",
    values: [],
  });
  const results = await transaction([
    {
      text: "SELECT * FROM users",
      values: [],
    },
    {
      text: "SELECT * FROM roles",
      values: [],
    },
  ]);
  await disconnect();
})();
0.3.1

7 years ago

0.3.0

7 years ago

0.2.7

7 years ago

0.2.6

7 years ago

0.2.5

7 years ago

0.2.4

7 years ago

0.2.3

7 years ago

0.2.2

7 years ago

0.2.1

7 years ago

0.2.0

7 years ago

0.1.0

7 years ago