Getting started

Search…
Getting started
Of course, first, you need to install Mammoth.
NPM
Yarn
Deno
npm i @ff00ff/mammoth
yarn add @ff00ff/mammoth
import { defineDb } from 'https://deno.land/x/mammoth'
Because Mammoth is a query builder pur sang it doesn’t include a database driver. This means you have to manage your connection pool to your database yourself and pass a query executor function to Mammoth’s defineDb call.
The query executor function, or QueryExecutorFn, receives the query as a string and it’s parameters as arguments and should return a promise with the resulting rows and the affected row count.
Below is an example on how to set this all up. Please note that the pool in this case uses a pg pool but you can use any pool you want.
Node.js
import { defineDb } from '@ff00ff/mammoth';
import { pool } from './pool';
import { foo, bar } from './tables';
​
const db = defineDb({ foo, bar }, async (query, parameters) => {
  const result = await pool.query(query, parameters);
​
  return {
    affectedCount: result.rowCount,
    rows: result.rows,
  };
});
As you can see the above example imports a set of tables from ./tables . These are the tables of your database schema. What they do and how they are defined are explained in the next chapter.
Mammoth
Defining tables
Last modified 1yr ago
Copy link