NodeJS help.

sliit_kolla

Well-known member
  • Jul 26, 2017
    1,667
    2,465
    113
    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
     

    Tanto

    Well-known member
  • Jun 10, 2016
    3,590
    1,856
    113
    NodeJS ooka maha epaa karapu ekak needa ban apee ofz eketh patan gaththa project ekakata