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.