Nodejs Prisma ORM REST API with sqlite where there is a login and register (you can change password and email, delete account) where each user can create titles and descriptions (you can edit and delete them) and in 'same' section the user can select the count of how many people have the same title he has created and see the emails of those people who have the same title.
First create an account where you must create a username, password ("Must include at least one number.", "Must include at least one lowercase letter,"Must include at least one lowercase letter.", "Must include at least one uppercase letter.", "Must include at least one uppercase letter.","Must include at least one uppercase letter.", "Must include at least one uppercase letter.", "Must include at least one uppercase letter.","Must include at least one special character.", "Must include at least one special character.", "Must include at least one special character.","The length of the password must be equal to or greater than 8 characters.","Must not contain blank spaces.") Confirm your password and enter an email address.
After entering the data correctly, click on the "Register" button.
In login enter your username and password, click on the "Login" button.
After logging in you will see the home screen where you will see your user name and registration id, in this section you can log out, change your password, delete your account (delete your account and tasks), and create a new task.
In change password you can change your password and email if required.
In task, you can create a title and a description of your choice, you can edit and delete it, and with the "home" button you go back to home and the "same" button to the same section.
Once you have created your task you can edit it with the "Edit" button where you will see the title and description, you only have to modify it by clicking on the "Update" button. If you don't want to make the modification click on the "Cancel Edit" button.
In this same section there are three buttons in which "Task" to return to Task, the button "Count People Same titile" once clicked counts how many users have the same title of the titles that the user has created in his account and these are shown in a table, the button "People Emails same title" once clicked shows the emails of the users that have the same title that the user has created in his account in a table form.
If there are no matching titles, a message will appear where it says: No title matches with other users.
But if there are the same titles, the table of the selected button appears, in this case "Count People Same title":
But if there are the same titles, the table of the selected button appears, in this case "People Emails same title":
When using Prisma as a backend, the routes can overlap if they are the same, unlike the Flask backend.example
# in flask you can use the routes :
@app.route('/tasks/<id>/<user>')
@app.route('/tasks/countsames/<user>')
#but in Nodejs Prisma and Go you cannot use these routes, because if you use them they overlap and do not work, that is why you must modify them like this:
router.get("/tasks/:id/:user", async (req, res)...
#change one
router.get('/tasksi/countsames/:user', async (req, res)...Backend Prisma Options for do it:
npm install
npm run devFronted React Options for do it:
- Use Dockerfile or docker-compose.yml
- Download dependencies and libraries
#Download dependencies
npm install
npm run dev
#or download dependencies for yourself
#you can use the useRoutes function of the wouter library. Next I will show you how to configure and use wouter in a React application with Vite:
npm install wouter
#const API_URL = import.meta.env.VITE_REACT_APP_API;
npm install dotenv