mysql-query-geniex
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.