{"repo":"prashantnirgun/express-mysql-passport-jwt-api","free":true,"listed":false,"github":"https://github.com/prashantnirgun/express-mysql-passport-jwt-api","clone":"git clone https://github.com/prashantnirgun/express-mysql-passport-jwt-api.git","description":"Create a API server with mysql table crud without ORM, Passport, JWT","language":"JavaScript","stars":12,"topics":["node","express","rest-api","rest","passport","mysql","swagger3","handlebars"],"license":"MIT","category":"api-integrations-sdks","readme_excerpt":"express-mysql-passport-jwt-api Create a API server with mysql table crud without ORM and with passport local strategy Installation and execution Configuration rename .env.sample file to .env and replace your database details inside it This is not yet documented but I will fix it soon. Login Endpoints GET all members GET selected fields GET limit clause GET limit with offset clause GET Sort by clause GET total rows clause For pagination we display n rows per page but we need to find how many rows inside the table. It fires two queries. 01 is to determine how many rows inside talble select count(id) into total rows from table 02 is used to return the result set select fields,... from table GET with all params GET selected member Add new member Update member Delete member Feature - Handllebar View Engine added - Schema Model to autogenerate CRUD Operation : one file managing 23 Table CRUD & 7 View Retrieve, Protect column from Update eg Primary Key, Password fields - Swagger & Open API 3.0 Integration With multiple .yaml files also documented .json - Enviroment Variables - Passport JWT - Soft Delete Turn off / On - Sort, Filter, Pagination (limit, offset) Server side Logic Things to do - Before Delete check (hook, SQL) - Node Validation (Joi) - Escaping MySQL queries & values - MySQL Transaction support - MySQL Prepare Statement References - links.txt file for example / insperation I dervied from referenses. - /scripts/tables.sql for generating MySQL database, tables & sample re","default_branch":null,"files":null,"tree":[],"storefront":"/r/prashantnirgun","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/prashantnirgun/express-mysql-passport-jwt-api/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}