tx.executeSql('CREATE TABLE bar (id INT PRIMARY KEY, Name TEXT,Score INTEGER)');
})
db.transaction(function(tx){
tx.executeSql('INSERT INTO bar (id,Name,Score) VALUES (1,"Kimon",60)');
tx.executeSql('INSERT INTO bar (id,Name,Score) VALUES (2,"Joe",99)');
tx.executeSql('INSERT INTO bar (id,Name,Score) VALUES (3,"Janos",100)');
})
runQuery=(dbh,query,param,cb)=>{
dbh.transaction(function(tx){
tx.executeSql(query,param,cb);
})
}
runQuery(db,'INSERT INTO bar (id, Name) VALUES (3,"Ed")')
runQuery(db,'INSERT INTO bar (id, Name, Score) VALUES (4,"Ting",80)')
runQuery(db,'DELETE FROM bar WHERE Name = "Kimon"')
runQuery(db,'UPDATE bar SET Score=99 WHERE Name="Ed"')
runQuery(db,'SELECT * FROM bar',[],function(tx,results){
varlen=results.rows.length;
vari;
console.log(len);
for(i=0;i<len;i++){
console.log(results.rows.item(i).Name);
}
})
{
return("Exercise 1 Code")
}
{
return("Exercise 2 Code");
}
{
return("Exercise 3 Code");
}
{
return("Exercise 4a Code");
}
{
return("Exercise 4b Code");
}
{
return("Exercise 4c Code");
}
Purpose-built for displays of data
Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.