JS walata mama tikak aul
podi help ekak one.
me thiyenne mage node eka peththe thiyena function ekaka body ekak (sampoorna kotasam demme ne)
const sql =
`SELECT names
FROM Students
WHERE JSON_EXTRACT(names, '$.name') LIKE ? `
const values = [beginningLetter]
const query = connection.query(sql, values, (error, results, fields) => {
connection.end()
if (error) {
return reject(error)
}
resolve(results)
})
})
.then((results) => {
return {
type: 'name',
attributes: results
}
meken ena output eka me wge
{
"data": {
"type": "name",
"attributes": [
{
"names": "{\"name\": \"kamal perera\", \"realFormat\": \"Kamal Perera\"}"
},
{
"names": "{\"name\": \"nimal lakmal\", \"realFormat\": \"Nimal Lakmal\"}"
},
{
"names": "{\"name\": \"venura gunathilaka\", \"realFormat\": \"Venura Gunathilake\"}"
}
]
}
}
namuth mata one oka me widiyata hadaganna
{
"data": [
{
"type": "name",
"attributes": {
"name": "nimal lakmal",
"realFormat": "Nimal Lakmal"
}
},
{
"type": "name",
"attributes": {
"name": "venura gunathilake",
"realFormat": "Venura Gunathilake"
}
}
}
]
}
udin mama daala thiyena .then((results) eka ethule wenas wenna one widiya poddak kiala dennako..bump ekak daanna anith aya
podi help ekak one.me thiyenne mage node eka peththe thiyena function ekaka body ekak (sampoorna kotasam demme ne)
const sql =
`SELECT names
FROM Students
WHERE JSON_EXTRACT(names, '$.name') LIKE ? `
const values = [beginningLetter]
const query = connection.query(sql, values, (error, results, fields) => {
connection.end()
if (error) {
return reject(error)
}
resolve(results)
})
})
.then((results) => {
return {
type: 'name',
attributes: results
}
meken ena output eka me wge
{
"data": {
"type": "name",
"attributes": [
{
"names": "{\"name\": \"kamal perera\", \"realFormat\": \"Kamal Perera\"}"
},
{
"names": "{\"name\": \"nimal lakmal\", \"realFormat\": \"Nimal Lakmal\"}"
},
{
"names": "{\"name\": \"venura gunathilaka\", \"realFormat\": \"Venura Gunathilake\"}"
}
]
}
}
namuth mata one oka me widiyata hadaganna
{
"data": [
{
"type": "name",
"attributes": {
"name": "nimal lakmal",
"realFormat": "Nimal Lakmal"
}
},
{
"type": "name",
"attributes": {
"name": "venura gunathilake",
"realFormat": "Venura Gunathilake"
}
}
}
]
}
udin mama daala thiyena .then((results) eka ethule wenas wenna one widiya poddak kiala dennako..bump ekak daanna anith aya