@enjoys/presql

PreSQL

Getting Started

Visit https://en-presql.enjoys.in/ to get started with PreSQL.

Documentation

Visit https://en-presql.enjoys.in to view the full documentation.

Developer : ENJOYS
Version : 1.2.4

No More Query Statements

PreSQL is an SQL-language based library containing pre-written code with shortend methods. Say "bye" to writing long query statements.

Dependencies

PreSQL requires the following dependencies to be installed:

• Node.js v16+
• mysql2 - to connect to MySQL database

Installation

Install the dependencies and devDependencies and start the server.

npm i presql

Methods

Crud Operations

• create() , createMany()
• updateOne() , updateMany()
• destroy() , destroyAll()
• findById(),findOne(),findFirst(),findMany()
• exist()
• table()
• queryBuilder()

Logical (Math) Operations

• Math()

Table Join / Relationship

• join()

Depricated/Not Featured

• In,Between,Alias,Distinct,OrderByGroup -- Adding in Future Versions

Examples

Visit https://en-presql.enjoys.in/category/presql-crud to view the full Examples.

License

This project is licensed under MIT License, please check the LICENSE file for more details.