Reply to thread

Message

<blockquote data-quote="SL MULTIMEDIA TUTORIAL" data-source="post: 28218787" data-attributes="member: 575597">මේකට තමයි Code කරන්න ඕනේUse caseA retail shop needs to maintain a product stock and purchase orders through a webapplication. The customers can submit their orders via the web application. As a backend developer, youneed to develop an API to register a customer in the system.Below, please find a sample request and response JSON data for registering a customer.Sample Request JSON for registering a customer<img src="https://open.uom.lk/pluginfile.php/86395/question/questiontext/356995/1/3547/use%20case.png" alt="request" class="fr-fic fr-dii fr-draggable " style="width: 475px; height: 309.429px" />&nbsp; Sample Response JSON for a successful registration<img src="https://open.uom.lk/pluginfile.php/86395/question/questiontext/356995/1/3547/image%20%283%29.png" alt="response" class="fr-fic fr-dii fr-draggable " style="width: 423px; height: 180.692px" />customerId: This should be the generated id from the database1. Update the database.js file with the required data definition (CREATE TABLE statement) to create thedata table to store the data of customersTable name: customer2. Implement a new API in the server.js file to register a customer and add the data record to the table.The method of the API should be POSTInclude the proper error handlingHTTP error codesSuccess: 201 CreatedAn Error: 400 Bad RequestReference for HTTP error codes - <a href="https://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html" target="_blank">Link</a>3. Implement validation to validate POST data to the same API as belowEmail address validationCredit card number validation (12 digits)Resources:To test the expected outcome, you can pull the codebase from the below repository and edit the relevant files(database.js and server.js).Git repository: <a href="https://github.com/opencourse5tutor/products-api" target="_blank">https://github.com/opencourse5tutor/products-api</a>Answer Submission InstructionsStudents should submit the following files.<ol>
<li data-xf-list-type="ol">A screenshot of a successful customer registration using the Postman tool.</li>
<li data-xf-list-type="ol">database.js file</li>
<li data-xf-list-type="ol">server.js file</li>
</ol>mn code karapu Files tikaserver.js[CODE=javascript]var express = require(&quot;express&quot;);var app = express();var db = require(&quot;./database1.js&quot;);var bodyParser = require(&quot;body-parser&quot;);const { request, response } = require(&quot;express&quot;);const res = require(&quot;express/lib/response&quot;);app.use(bodyParser.json());let HTTP_PORT = 8080;app.listen(HTTP_PORT, () =&gt; {&nbsp; &nbsp; console.log(&quot;Server is running on %PORT%&quot;.replace(&quot;%PORT%&quot;, HTTP_PORT))});app.post(&quot;/api/customers/&quot;, (req, res, next) =&gt; {&nbsp; &nbsp; try {&nbsp; &nbsp; &nbsp; &nbsp; var errors = []&nbsp; &nbsp; &nbsp; &nbsp; if (!req.body) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; errors.push(&quot;An invalid input&quot;);&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; const {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; name ,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; address,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; email ,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; dateOfBirth ,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; gender,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; age ,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cardHolderName ,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cardNumber,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; expiryDate,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cvv ,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; timeStamp&nbsp; &nbsp; &nbsp; &nbsp; } = req.body;&nbsp; &nbsp; &nbsp; &nbsp; var sql = 'INSERT INTO customers (name,address,email,dateOfBirth,gender,age,cardHolderName,cardNumber,expiryDate,cvv,timeStamp) VALUES (?,?,?,?,?,?,?,?,?,?,?)'&nbsp; &nbsp; &nbsp; &nbsp; var params = [name,address,email,dateOfBirth,gender,age,cardHolderName,cardNumber,expiryDate,cvv,timeStamp]&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; db.run(sql, params, function (err, result) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (err) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } else {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; res.json({&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;message&quot;: &quot;customer &quot; + req.body.name +&quot; registered&quot;,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;customerid&quot;: this.lastID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; })&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; });&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; }catch (E) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; res.status(400).send(E);&nbsp; &nbsp; }&nbsp;});app.get(&quot;/api/customers/:customerid&quot;, (req, res, next) =&gt; {&nbsp; &nbsp; try {&nbsp; &nbsp; &nbsp; &nbsp; var sql = &quot;select * from customers WHERE customerid =?&quot;&nbsp; &nbsp; &nbsp; &nbsp; var params = [req.params.customerid]&nbsp; &nbsp; &nbsp; &nbsp; db.all(sql, params, (err, rows) =&gt; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (err) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; res.status(400).json({ &quot;error&quot;: err.message });&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; res.json({&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;message&quot;: &quot;success&quot;,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;data&quot;: rows&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; })&nbsp; &nbsp; &nbsp; &nbsp; });&nbsp; &nbsp; } catch (E) {&nbsp; &nbsp; &nbsp; &nbsp; res.status(400).send(E);&nbsp; &nbsp; }});app.get(&quot;/api/customers&quot;, (req, res, next) =&gt; {&nbsp; &nbsp; try {&nbsp; &nbsp; &nbsp; &nbsp; var sql = &quot;select * from customers&quot;&nbsp; &nbsp; &nbsp; &nbsp; var params = []&nbsp; &nbsp; &nbsp; &nbsp; db.all(sql, params, (err, rows) =&gt; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (err) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; res.status(400).json({ &quot;error&quot;: err.message });&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; res.json({&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;message&quot;: &quot;success&quot;,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;data&quot;: rows&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; })&nbsp; &nbsp; &nbsp; &nbsp; });&nbsp; &nbsp; } catch (E) {&nbsp; &nbsp; &nbsp; &nbsp; res.status(400).send(E);&nbsp; &nbsp; }});app.patch(&quot;/api/customers/:customerid&quot;, (req, res, next) =&gt; {&nbsp; &nbsp; const {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; name,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; address,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; email ,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; dateOfBirth ,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; gender,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; age ,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cardHolderName ,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cardNumber,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; expiryDate,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cvv ,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; timeStamp&nbsp; &nbsp; } = req.body;&nbsp; &nbsp; &nbsp; &nbsp; db.run(`UPDATE customers set name =?,address=?,email=?,dateOfBirth=?,gender=?,age=?,cardHolderName=?,cardNumber=?,expiryDate=?,cvv=?,timeStamp=? WHERE customerid = ?`,&nbsp; &nbsp; [name,address,email,dateOfBirth,gender,age,cardHolderName,cardNumber,expiryDate,cvv,timeStamp,req.params.customerid],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; function (err, result) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (err) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; res.status(400).json({ &quot;error&quot;: res.message })&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; res.status(200).json({ &quot;updated customerid&quot;: req.params.customerid })&nbsp; &nbsp; &nbsp; &nbsp; });});app.delete(&quot;/api/customers/:customerid&quot;, (req, res, next) =&gt; {&nbsp; &nbsp; try {&nbsp; &nbsp; &nbsp; &nbsp; db.run('DELETE FROM customers WHERE customerid = ?',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; req.params.customerid,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; function (err, result) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (err) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; res.status(400).json({ &quot;error&quot;: res.message })&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; res.json({ &quot;message&quot;: &quot;deleted customer id &quot;+ req.params.customerid})&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; });&nbsp; &nbsp; } catch (E) {&nbsp; &nbsp; &nbsp; &nbsp; res.status(400).send(E)&nbsp; &nbsp; }}); [/CODE]database.js [CODE=javascript]var sqlite3 = require('sqlite3').verbose();var md5 = require('md5');const DBSOURCE = 'db.sqlite';let db = new sqlite3.Database(DBSOURCE, (err) =&gt; {&nbsp; if (err) {&nbsp; &nbsp; // Cannot open database&nbsp; &nbsp; console.error(err.message);&nbsp; &nbsp; throw err;&nbsp; } else {&nbsp; &nbsp; console.log('Connected to the SQlite database.');&nbsp; &nbsp; db.run(&nbsp; &nbsp; &nbsp; `CREATE TABLE customers (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; id INTEGER PRIMARY KEY AUTOINCREMENT,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; customerName text,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; address text,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; email VARCHAR,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; dateofBirth VARCHAR,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; gender VARCHAR,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; age INTEGER,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cardHolderName text,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; expirytdate VARCHAR,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cvv INTEGER,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; timpStamp text&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )`,&nbsp; &nbsp; &nbsp; (err) =&gt; {&nbsp; &nbsp; &nbsp; &nbsp; if (err) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Table already created&nbsp; &nbsp; &nbsp; &nbsp; } else {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Table just created, creating some rows&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var insert =&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ' INSERT INTO customers (customerName,address, email, dateofBirth, gender, age,cardHolderName,expirytdate,cvv , timpStamp )&nbsp; VALUES (?,?,?,?,?,?,?,?,?,?)';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; db.run(insert, [&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Jems Watson',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'No 324/A ra de Mel Road , kadawataha',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'watsin34@gamail.com',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; '2002.02.25',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'male',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; '20',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'J.watson',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; '425678588956',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; '12/2026',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; '245',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; '2022-12-31 23:59:59',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ]);&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; );&nbsp; }});[/CODE]mn request damme Insomnia eken mehema error ekak enawa .&nbsp; <img src="/styles/default/xenforo/smilies/default/sorry.gif"&nbsp; class="smilie" loading="lazy" alt=":sorry:" title="Sorry&nbsp; &nbsp; :sorry:" data-shortname=":sorry:" /><img src="https://telegra.ph/file/6b49d8883ec8f892f5efa.jpg" alt="" class="fr-fic fr-dii fr-draggable " style="width: 758px" /></blockquote>

[QUOTE="SL MULTIMEDIA TUTORIAL, post: 28218787, member: 575597"] මේකට තමයි Code කරන්න ඕනේ [B][U]Use case[/U][/B] A retail shop needs to maintain a product stock and purchase orders through a web application. The customers can submit their orders via the web application. As a backend developer, you need to develop an API to register a customer in the system. Below, please find a sample request and response JSON data for registering a customer. [B]Sample Request JSON for registering a customer[/B] [IMG width="475px" height="309.429px" alt="request"]https://open.uom.lk/pluginfile.php/86395/question/questiontext/356995/1/3547/use%20case.png[/IMG] [B] Sample Response JSON for a successful registration[/B] [IMG width="423px" height="180.692px" alt="response"]https://open.uom.lk/pluginfile.php/86395/question/questiontext/356995/1/3547/image%20%283%29.png[/IMG] [B]customerId: This should be the generated id from the database 1. Update the database.js file with the required data definition (CREATE TABLE statement) to create the[/B] data table to store the data of customers Table name: customer [B]2. Implement a new API in the server.js file to register a customer and add the data record to the table.[/B] The method of the API should be POST Include the proper error handling HTTP error codes Success: 201 Created An Error: 400 Bad Request Reference for HTTP error codes - [URL='https://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html']Link[/URL] [B]3. Implement validation to validate POST data to the same API as below[/B] Email address validation Credit card number validation (12 digits) [B]Resources:[/B] To test the expected outcome, you can pull the codebase from the below repository and edit the relevant files(database.js and server.js) . Git repository: [URL]https://github.com/opencourse5tutor/products-api[/URL] [U][B]Answer Submission Instructions[/B][/U] Students should submit the following files. [LIST=1] [*]A screenshot of a successful customer registration using the Postman tool. [*]database.js file [*]server.js file [/LIST] mn code karapu Files tika server.js [CODE=javascript]var express = require("express"); var app = express(); var db = require("./database1.js"); var bodyParser = require("body-parser"); const { request, response } = require("express"); const res = require("express/lib/response"); app.use(bodyParser.json()); let HTTP_PORT = 8080; app.listen(HTTP_PORT, () => { console.log("Server is running on %PORT%".replace("%PORT%", HTTP_PORT)) }); app.post("/api/customers/", (req, res, next) => { try { var errors = [] if (!req.body) { errors.push("An invalid input"); } const { name , address, email , dateOfBirth , gender, age , cardHolderName , cardNumber, expiryDate, cvv , timeStamp } = req.body; var sql = 'INSERT INTO customers (name,address,email,dateOfBirth,gender,age,cardHolderName,cardNumber,expiryDate,cvv,timeStamp) VALUES (?,?,?,?,?,?,?,?,?,?,?)' var params = [name,address,email,dateOfBirth,gender,age,cardHolderName,cardNumber,expiryDate,cvv,timeStamp] db.run(sql, params, function (err, result) { if (err) { return; } else { res.json({ "message": "customer " + req.body.name +" registered", "customerid": this.lastID }) } }); }catch (E) { res.status(400).send(E); } }); app.get("/api/customers/:customerid", (req, res, next) => { try { var sql = "select * from customers WHERE customerid =?" var params = [req.params.customerid] db.all(sql, params, (err, rows) => { if (err) { res.status(400).json({ "error": err.message }); return; } res.json({ "message": "success", "data": rows }) }); } catch (E) { res.status(400).send(E); } }); app.get("/api/customers", (req, res, next) => { try { var sql = "select * from customers" var params = [] db.all(sql, params, (err, rows) => { if (err) { res.status(400).json({ "error": err.message }); return; } res.json({ "message": "success", "data": rows }) }); } catch (E) { res.status(400).send(E); } }); app.patch("/api/customers/:customerid", (req, res, next) => { const { name, address, email , dateOfBirth , gender, age , cardHolderName , cardNumber, expiryDate, cvv , timeStamp } = req.body; db.run(`UPDATE customers set name =?,address=?,email=?,dateOfBirth=?,gender=?,age=?,cardHolderName=?,cardNumber=?,expiryDate=?,cvv=?,timeStamp=? WHERE customerid = ?`, [name,address,email,dateOfBirth,gender,age,cardHolderName,cardNumber,expiryDate,cvv,timeStamp,req.params.customerid], function (err, result) { if (err) { res.status(400).json({ "error": res.message }) return; } res.status(200).json({ "updated customerid": req.params.customerid }) }); }); app.delete("/api/customers/:customerid", (req, res, next) => { try { db.run('DELETE FROM customers WHERE customerid = ?', req.params.customerid, function (err, result) { if (err) { res.status(400).json({ "error": res.message }) return; } res.json({ "message": "deleted customer id "+ req.params.customerid}) }); } catch (E) { res.status(400).send(E) } }); [/CODE] database.js [CODE=javascript]var sqlite3 = require('sqlite3').verbose(); var md5 = require('md5'); const DBSOURCE = 'db.sqlite'; let db = new sqlite3.Database(DBSOURCE, (err) => { if (err) { // Cannot open database console.error(err.message); throw err; } else { console.log('Connected to the SQlite database.'); db.run( `CREATE TABLE customers ( id INTEGER PRIMARY KEY AUTOINCREMENT, customerName text, address text, email VARCHAR, dateofBirth VARCHAR, gender VARCHAR, age INTEGER, cardHolderName text, expirytdate VARCHAR, cvv INTEGER, timpStamp text )`, (err) => { if (err) { // Table already created } else { // Table just created, creating some rows var insert = ' INSERT INTO customers (customerName,address, email, dateofBirth, gender, age,cardHolderName,expirytdate,cvv , timpStamp ) VALUES (?,?,?,?,?,?,?,?,?,?)'; db.run(insert, [ 'Jems Watson', 'No 324/A ra de Mel Road , kadawataha', 'watsin34@gamail.com', '2002.02.25', 'male', '20', 'J.watson', '425678588956', '12/2026', '245', '2022-12-31 23:59:59', ]); } } ); } }); [/CODE] mn request damme Insomnia eken mehema error ekak enawa . :sorry: [IMG width="758px"]https://telegra.ph/file/6b49d8883ec8f892f5efa.jpg[/IMG] [/QUOTE]

Verification

Payakata winadi keeyak tibeda?

Search

Latest ads

Reply to thread