alasql update json array
HTML
<script src="https://cdnjs.cloudflare.com/ajax/libs/alasql/0.4.5/alasql.min.js"></script>
JavaScript
var data=[
{
"inputtype": "textbox",
"key": "rolename",
"vals": [
"moderator"
]
},
{
"inputtype": "multiselect",
"key": "modulename",
"vals": [
"employees,inventories"
]
},
{
"inputtype": "multiselect",
"key": "accesstype",
"vals": [
"AA,VO"
]
}
]
alasql('CREATE TABLE one');
alasql.tables.one.data = data;
var datasets=alasql('update one SET key=? WHERE inputtype=?;select * from one; truncate table one',['accesstypeaaaaa','multiselect']);
console.log(datasets[1])
/*check if table is truncated */
var red=alasql('select * from one.data')
console.log(red)