mysql-query-geniex

Version npm

The mysql-query - geniex npm package provides a comprehensive suite of tools for working with MySQL databases, offering advanced features beyond basic SQL operations. With mysql - query - geniex, you can harness the full power of MySQL along with complex relational database management system (RDBMS) capabilities, sophisticated query generation, and dynamic condition creation.

Features

  • Full MySQL Support: Utilize all MySQL features, including data manipulation, schema management, transactions, and more.
  • Advanced RDBMS Capabilities: Access complex RDBMS functionalities for optimized data querying and manipulation.
  • Dynamic Query Generation: Generate SQL queries dynamically based on user-defined parameters and conditions.
  • Flexible Condition Generation: Create dynamic conditions for filtering, sorting, grouping, and aggregating data with ease.

Installation

To install mysql-query-geniex, use npm:

npm install mysql-query-geniex

Using yarn:

yarn add mysql-query-geniex

Usage

import {genQueryRdmsSql} from "mysql-query-geniex";

Examples

    const query = genQueryRdmsSql({
    table_list: {
        table1: 'orders',
        table2: 'customers'
    },
    relation_key: {
        on: {
            relation: 'INNER JOIN',
            table1: 'orders',
            table2: 'customers',
        }
    },
    specific_column: {
        table1: ['order_id', 'order_date'],
        table2: ['customer_name']
    },
    condition: 'orders.status = "completed"',
    sort: { table1: ['order_date', 1] },
    groupBY: ['orders.status'],
    havingCondition: 'COUNT(customers.customer_id) > 10',
    limitSkip: { limit: 10, skip: 0 }
});

Documentation

For detailed usage instructions and API documentation, please refer to the mysql-query-geniex.

License

This npm package is open source project.

Support and Contributions

For support, bug reports, or feature requests, please create an issue on the mysql-query-geniex GitHub repository. Contributions are welcome, and pull requests are encouraged.

Install / Setup