Created
December 24, 2012 20:40
-
-
Save anonymous/4370619 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<!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