REST APIs with MySQL

REST APIs were deployed on cyclic

    https://nodeserver.cyclic.cloud/getAllProducts

    https://nodeserver.cyclic.cloud/getProduct/:id

    https://nodeserver.cyclic.cloud/createProduct

    https://nodeserver.cyclic.cloud/updateProduct/:id
        
    https://nodeserver.cyclic.cloud/deleteProduct/:id

Access token: ‘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’

// Connect to your MySQL database

const con= mysql.createConnection({
    host:"mysql-philippehou.alwaysdata.net", 
    user: "289337_root",
    password: "Tm3x-****************Mf",
    database:"philippehou_gestionproduit" 
});
 
con.connect(function(err){
    if(err) throw err; 
});

The complete code can be found at github: https://github.com/philip-whole/nodeserver

Test:

to get all products:

curl -X GET -H "Authorization: Bearer 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" https://nodeserver.cyclic.cloud/getAllProducts

to get a single product with id:

curl -X GET -H "Authorization: Bearer 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" https://nodeserver.cyclic.cloud/getProduct/1

to update a single product with id:

curl -X PUT \
-H "Authorization: Bearer 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" \
-d "description=Portatif Macbook Pro" \
-d "image=portable2.jpg" \
-d "prix=1950.95" \
-d "details=MSI 15.6 po GF65 9SEXR-436p, Intel Core i7-9750H, 16GB RAM, 512GB SSD, Win10, Noir" \
https://nodeserver.cyclic.cloud/updateProduct/1

to add a product:

curl -X POST \
-H "Authorization: Bearer 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" \
-d "description=Portatif Macbook Pro" \
-d "image=portable3.jpg" \
-d "prix=2950.95" \
-d "details=MSI 15.6 po GF65 9SEXR-436p, Intel Core i7-9750H, 16GB RAM, 512GB SSD, Win10, Noir" \
https://nodeserver.cyclic.cloud/createProduct

to delete a product:

curl -X DELETE -H "Authorization: Bearer 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" https://nodeserver.cyclic.cloud/deleteProduct/1

The complete code can be found at github: https://github.com/philip-whole/nodeserver