Skip to content

Mullayam/PreSQL

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

PreSQL

1.2.2

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 : Mullayam
Version : 1.2.2

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.