cql.js

export default function query () {
    let cql = '';

    return {

        insert (table, data) {
            const keys = Object.keys(data).join(', ');
            const values = Object.values(data).join(', ');

            cql += `INSERT INTO ${ table } (${ keys }) VALUES (${ values }) `;
            return this;
        },

        update (table, data) {
            const set = Object.keys(data).map(key => `${ key } = ${ data[ key ] }`).join(', ');

            cql += `UPDATE ${ table } SET ${ set } `;
            return this;
        },

        delete (column, table) {
            cql += `DELETE ${ column } FROM ${ table } `;
            return this;
        },

        select (...columns) {
            cql += `SELECT ${ columns.join(', ') } `;
            return this;
        },

        from (table) {
            cql += `FROM ${ table } `;
            return this;
        },

        where (condition) {
            cql += `WHERE ${ condition } `;
            return this;
        },

        and (condition) {
            cql += `AND ${ condition } `;
            return this;
        },

        group (column) {
            cql += `GROUP BY ${ column } `;
            return this;
        },

        order (column, direction = `DESC`) {
            cql += `ORDER BY (${ column } ${ direction }) `;
            return this;
        },

        limit (amount) {
            cql += `LIMIT ${ amount } `;
            return this;
        },

        raw (query) {
            cql += `${ query } `;
            return this;
        },

        toString () {
            return cql.trim() + `;`;
        }
    }
}