1. 1var sqlite3 = require('..');
2. 1var assert = require('assert');
3. 1
4. 1describe('named columns', function() {
5. 1 var db;
6. 1 before(function(done) {
7. 1 db = new sqlite3.Database(':memory:', done);
8. 1 });
9. 1
10. 1 it('should create the table', function(done) {
11. 1 db.run("CREATE TABLE foo (txt TEXT, num INT)", done);
12. 1 });
13. 1
14. 1 it('should insert a value', function(done) {
15. 1 db.run("INSERT INTO foo VALUES($text, $id)", {
16. 1 $id: 1,
17. 1 $text: "Lorem Ipsum"
18. 1 }, done);
19. 1 });
20. 1
21. 1 it('should retrieve the values', function(done) {
22. 1 db.get("SELECT txt, num FROM foo ORDER BY num", function(err, row) {
23. 0 if (err) throw err;
24. 1 assert.equal(row.txt, "Lorem Ipsum");
25. 1 assert.equal(row.num, 1);
26. 1 done();
27. 1 });
28. 1 });
29. 1
30. 1 it('should be able to retrieve rowid of last inserted value', function(done) {
31. 1 db.get("SELECT last_insert_rowid() as last_id FROM foo", function(err, row) {
32. 0 if (err) throw err;
33. 1 assert.equal(row.last_id, 1);
34. 1 done();
35. 1 });
36. 1 });
37. 1
38. 1});
39. 1