Corm

SQL Statement Builder (currently supporting PostgreSQL)

Installation

Add this to your application's shard.yml:

dependencies:
  corm:
    github: gdotdesign/corm

Features

TODO: Finalize feature list

Statements:

SELECT
INNER_JOIN
GROUP BY
WHERE
INSERT
CREATE
DELETE
OUTER_JOIN
LIMIT
ORDER BY
ALTER TABLE
CREATE TABLE

Functions:

MAX
MIN
COUNT
SUM
AVG
ROUND
DISTINCT

Helpers:

.columns

Usage

TODO: Write more useful documentation

require "corm"

# Simple query without type casting
Corm.table("users")
    .select("id", "name")
    .where({ "id" => 23 })
    .one
# [[23 : PG::PGValue, "Some User" : PG::PGValue ]]

# Simple query with type casting
Corm.table("users")
    .select("id", "name")
    .where({ "id" => 23 })
    .one({Int32, String})
# {23 : Int32, "Some User" : String}