zerotime v1.0.4

zerotime

Contains wrapper methods that help you work with a MySQL database.

Example Usage

Consider the following pets table:

First, get an instance of zerotime:

const mysql = require("mysql2");
const createZerotime = require("zerotime");
const connection = mysql.createConnection({
  host: <host>,
  user: <user>,
  password: <your_password>,
  database: <your_database_name>,
});

const zerotime = await createZerotime(connection, <your_table_name>);

Methods are automatically created when zerotime is initialized that include your tables fields in them. Consider the following calls below.

Get all records

const records = await zerotime.find()

Get all records where species type is lion:

const records= await zerotime.getSpecies("lion").find()

Get all records where the species is lion and name is Costas

const records = await zerotime.getOwner("Costas").getSpecies("lion").find()

Add to your database

const testObj = {
  name: "Teena",
  owner: "Garrison",
  species: "Tiger",
  sex: "F",
  birth: "1972-01-01"
}

await zerotime.add(connection, testObj)

Populate database from a CSV file

const result = await zerotime.addFromCsv(connection, "file.csv")

Cleaning up

At the end of your program be sure to call the following to end your session:

zerotime.kill()