hosoun

📊 HosounSQL

Yet another sql-based ODM to model your data in objects, written in fresh and pure JavaScript

Why we wrote Hosoun?

We needed a fast and reliable ODM capable to work with SQL, but these were very difficult to understand, and we wanted a simpler ODM. That's we wrote HosounSQL.

Installation

Simply do in your console:

$ npm install hosoun --save

Usage

Here is an example to understand how HosounSQL works:

const hosoun = require('hosoun')

const db = new hosoun.Cluster({
    poolName: 'myPool'
})

db.query({
    type: 'CREATE TABLE',
    documentName: 'mydb',
    tableName: 'mytable',
    tableSchema: ['id TEXT', 'name TEXT', 'age NUMERIC']
})

db.query({
    type: 'INSERT',
    table: 'mytable',
    tableModel: ['id', 'name', 'age'],
    values: ['1', 'Aidak', '14']
})

db.query({
    type: 'SELECT',
    table: 'mytable',
    where: {
        key: 'id',
        value: '1'
    },
    getOption: 'name'
})

Contributing

You can open an issue or do a pull request to discuss it. If you want to contribute to the project or have any question, add me on Discord: Aidak#0001.