Skip to main content

Json-server Api's crud operations

Git-Hub repo with setup guide.

https://github.com/typicode/json-server

1) Install json server

Please visit the json-server official site and find this command.

Install json-server globaly into your system

-npm install -g json-server

2) Start json-server with command

Open cmd and go to the locaation where .json file present

run the this command

-npx json-server --watch db.json 

3) Delete data with child table data (delete relation record). 

Hi!

This is not a random error.
I found that if there is some kind of connection between elements, then DELETE request will erase both of them:
I have a "database":

{
    "users":[
        {"id":1, "name": "Bob", "email":"bob@gmailcom", "age": 35},
        {"id":2, "name": "Sue", "email":"sue@gmailcom", "age": 32},
        {"id":3, "name": "Cloe", "email":"cloe@gmailcom", "age": 19},
        {"id":4, "name": "Jane", "email":"jane@gmailcom", "age": 26}
    ],
    "comments":[
        {"id":1, "message1": "Here should be some comment", "userId": 2},
        {"id":2, "message2": "Here should be many comment", "userId": 4},
        {"id":3, "message3": "Here should be more comment", "userId": 1}
    ]
}

and I run this from console:
let fetchOpt = { method: "delete", mode: "cors", cache: "no-cache" }; fetch("http://localhost:3000/users/4", fetchOpt);

then server will delete "Jane with id:4" from users, and "message2 with userId: 4" from comments

Try it. Then I changed "userId" to "usr" and there is no more "strange delete"

Comments

Popular posts from this blog

Install MariaDB Latest Version 11.4 in Red Hat Version 9

 This this post i will show you step by step the installation process of mariaDB in red hat version 9. Step1 Run the command to pull the latest updated packages on applications installed in your system. -dnf update If you get Kernal update than reboot the system -reboot Step2 Go to official mariaDB site Make mariadb repository in /etc/yum.repos.d Place the configuration in this file # MariaDB 11.4 RedHatEnterpriseLinux repository list - created 2024-09-24 11:12 UTC # https://mariadb.org/download/ [mariadb] name = MariaDB # rpm.mariadb.org is a dynamic mirror if your preferred mirror goes offline. See https://mariadb.org/mirrorbits/ for details. # baseurl = https://rpm.mariadb.org/11.4/rhel/$releasever/$basearch baseurl = https://mirrors.aliyun.com/mariadb/yum/11.4/rhel/$releasever/$basearch # gpgkey = https://rpm.mariadb.org/RPM-GPG-KEY-MariaDB gpgkey = https://mirrors.aliyun.com/mariadb/yum/RPM-GPG-KEY-MariaDB gpgcheck = 1 Now install the mariaDB with its dependencies package...

MySQL course to learn queries to manage DBMS.

1. Create Table CREATE TABLE statement allows you to create new table in database. The example code is given below.  create table profile( id int, name varchar(50), birth_date date, phone varchar(12), gender varchar(1) ); Code language: SQL (Structured Query Language) ( sql ) 2. Insert data in table INSERT INTO statement is use to insert new record/data into table. INSERT INTO profile (id, name, birth_date, phone, gender) VALUES (2, "Zaib", "1996-03-15", "9238975404", "M"); Code language: SQL (Structured Query Language) ( sql ) 3. Insert multiple records at-once INSERT INTO state is use to insert multiple new record/data into table. INSERT INTO profile (id, name, birth_date, phone, gender) VALUES (1, "Usamn ali", "1990-08-26", "9238785094", "M", 18, "Karachi"), (2, "Aisha", "1997-06-12", "9238974468", "F", 19, "Lahore"), ...

Send email in php "without less secure" restriction

 => https://www.youtube.com/watch?v=Kjn5vBbBsi8 (less secure link) https://www.youtube.com/watch?v=dNTZ8X9Xk_Q&t=259s https://www.thapatechnical.com/2020/03/how-to-send-mail-from-localhost-xampp.html LARAVEL env file setup for gmail configuration MAIL_DRIVER=smtp MAIL_HOST=smtp.gmail.com MAIL_PORT=465 MAIL_USERNAME=exampleEmail@gmail.com MAIL_PASSWORD=yourAppPassword MAIL_ENCRYPTION=ssl MAIL_FROM_ADDRESS=exampleEmail@gmail.com MAIL_FROM_NAME="Adnan Zaib" Note: for TLS use Port : 587 for SSL use Port : 465