Skip to content

Instantly share code, notes, and snippets.

/index.html

Created December 24, 2012 20:40
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save anonymous/4370619 to your computer and use it in GitHub Desktop.
Save anonymous/4370619 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
index.html
<!doctype html>
<html>
<head>
<meta name="viewport" content="width=device-width">
<script type="text/javascript" src="jquery-1.8.3.js"></script>
<script type="text/javascript" src="parse.js"></script>
<script>
var NoteObject;
var db;
function errorCB(e) {
console.log("DB Error");
console.dir(e);
}
function online() {
return navigator.onLine;
}
$(document).ready(function() {
db = window.openDatabase("notedb", "1.0", "Note Database", 200000);
db.transaction(createDB, errorCB);
function createDB(trans) {
trans.executeSql("create table if not exists notedb(id INTEGER PRIMARY KEY,body,title)");
}
$("#querytodb").on("click", function(e) {
Parse.initialize("xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx", "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx");
NoteObject = Parse.Object.extend("note");
var querytodb = new Parse.Query(NoteObject);
querytodb.find({
success: function(results) {
for(var i=0, len=results.length; i<len; i++) {
var result = results[i];
db.transaction(function(trans) {
trans.executeSql("insert into notedb(body,title) values(?,?)", [result.attributes.body, result.attributes.title]);
}, errorCB);
}
},
error: function(error) {
alert("Error: " + error.code + " " + error.message);
}
});
});
});
</script>
<style>
body {
margin-left: 25px;
margin-right: 25px;
font-family: arial;
}
input {
width: 100%;
height: 25px;
}
</style>
</head>
<body>
<h2>Save Locally</h2>
<input type="submit" id="querytodb" value="Query to Local">
</body>
</html>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment