MySimpleQL
MySimpleQL is a MySQL Connector with built in simple CRUD functions for faster development. MySimpleQL also has a optional safe raw function for quick custom queries.
✅ Install
npm i mysimpleql
✅ Connect to MySQL (.env)
Create a .env file with the following params
MYSQL_HOST=localhost
MYSQL_USER=username
MYSQL_PASSWORD=password
MYSQL_DATABASE=databasename
✅ Require
const Model query = ;
✅ Create a Model
const Post = 'posts';// const ModelName = new Model('tableName');
💻 CRUD Functions
Please note these CRUD Functions are designed to be used within a async function.
Create
await Post;
Read
await Post;// orawait Post;// orawait Post;// orawait Post;// orawait Post;
Update
await Post;// orawait Post);
Delete
await Post;
💻 RAW MySQL Query
Quick Raw Query
await ;
Escaped Placeholder Raw Query
await ;
Example Usage
const Model query = ; const Post = 'posts'; { try const allPosts = await Post; console; catch error console; } ;
🤝 Contributing
Contributions, issues and feature requests are welcome.
Authors
👤 Chris Brocklesby
- Twitter: @ChrisBrocklesby
- Github: @ChrisBrocklesby
See also the list of contributors who participated in this project.
Show Your Support
Please ⭐️ this repository if this project helped you!
📝 License
Copyright © 2020 Chris Brocklesby.
This project is licensed under the MIT License - see the LICENSE file for details.