acid.js

A simple postgres library

Built on top of pg and psqljs

Install

$ npm install --save acidjs

Examples

// Require the module
var acid = require("acidjs")("postgres://postgres:@localhost:5432/database");

Create a table

$ psql -c "create table users (id bigserial primary key, email text not null, created_at timestamp without time zone default (now() at time zone "utc"));"

Insert a record

var tables = {
  users: "users"
};
 
acid
.insert(tables.users, {email: "[e-mail]"});
.then(function(rows) {
  /*
    rows === [
      {
        id: "1",
        email: "[e-mail]",
        created_at: ...
      }
    ]
  */
});

Find a record with a where clause

acid
.where(tables.users, "id = $1", "1")
.then(function(rows) {
  /*
    rows === [
      {
        id: "1",
        email: "[e-mail]",
        created_at: ...
      }
    ]
  */
});

Update a record

acid
.update(tables.users, {name: "Ryan Dahl"}, "id = $1", "1")
.then(function(rows) {
  /*
    rows === [
      {
        id: "1",
        name: "Ryan Dahl",
        created_at: ...
      }
    ]
  */
})

Delete a record

acid
.delete(tables.users, "id = $1", "1")
.then(function(rows) {
  // rows == []
});

Run arbitrary sql

acid
.sql("select * from user_defined_function($1)", ["value"])
.then(function(rows) {
  /*
    rows === [
      {
        ... whatever data
      }
    ]
  */
})

Tests

# Set up the database 
$ psql -c "create user postgres createdb;"
$ psql -c "create database postgres;"
$ psql -c "create database acidjs;" -U postgres
$ npm test