π
Water
Water is a micro-ORM + QueryBuilder designed to facilitate queries and operations on PostgreSQL databases designed to work in MelonRuntime
Installation
npm install water-melon-kit
Usage
-
Importing the basic needs for your project
import { Water } from "water-melon-kit"
-
Setting your connection info from the environment
const connection = { port: 5432, host: environment.getVariable("PG_HOST"), database: environment.getVariable("PG_DATABASE"), user: environment.getVariable("PG_USER"), password: environment.getVariable("PG_PASSWORD") }
-
Configuring a Water function set
const water = Water(connection, true)
Functions
-
[water].query(tableName: string)Example:
type User = { id: number, name: string } const usersQuery = water.query("users").select("*").orderBy("id"); const users = usersQuery.result<User>().elements(); console.log(users); //[{id: 1, name: "Nicolas Lopes"}, {id: 2, name: "Guilherme Noghartt"}...]
-
[water].action(tableName: string)Example:
type User = { id: number, name: string } const usersAction = water.action("users") const result = usersAction.insert({name: "Jefferson Quesado"}) console.log(result); //1
-
[water].rawQuery(sql: string) -
[water].rawAction(sql: string)
10 Apr 6, 2022
14 Dec 9, 2022
5 Dec 15, 2022
2 Jan 14, 2022
2 Jan 21, 2022
10 Aug 22, 2022
4 Jun 16, 2022
47 Jan 1, 2023
115 Dec 22, 2022
5 Nov 20, 2022