pastebin

Paste Search Dynamic
Recent pastes
creating new dbSqlite
  1. creating new dbSqlite instance on /tmp/sqlitedb.
  2. initializing dbSqlite instance.
  3. test create table (1).
  4. executing: create table foo (bar varchar(10)).
  5. create table (1) passed!.
  6. 0 rows affected
  7. test drop table(1).
  8. executing: drop table foo.
  9. drop table(1) passed!.
  10. 0 rows affected
  11. test create table(2).
  12. executing: create table users ( userid INTEGER primary key, username VARCHAR(30) not null unique, password VARCHAR(32) not null, disabled VARCHAR(255) default '');.
  13. create table(2) passed!.
  14. 0 rows affected
  15. test insert USER(1).
  16. executing: insert into users (userid, username, password) values (null,'pspencer','098f6bcd4621d373cade4e832627b4f6');.
  17. insert USER(1) passed!.
  18. 1 rows affected
  19. test insert USER(2).
  20. executing: insert into users (userid, username, password) values (null,'jfournier','ad0234829205b9033196ba818f7a872b');.
  21. insert USER(2) passed!.
  22. 1 rows affected
  23. test insert USER(3).
  24. executing: insert into users (userid, username, password) values (null,'fwarnock','8ad8757baa8564dc136c1e07507f4a98');.
  25. insert USER(3) passed!.
  26. 1 rows affected
  27. test select USER.
  28. executing: select * from users.
  29. select USER passed!.
  30. userid  username        password        disabled
  31. 1       pspencer        098f6bcd4621d373cade4e832627b4f6       
  32. 2       jfournier       ad0234829205b9033196ba818f7a872b       
  33. 3       fwarnock        8ad8757baa8564dc136c1e07507f4a98       
  34. test select USER by NAME.
  35. executing: select * from users where username = 'jfournier'.
  36. select USER by NAME passed!.
  37. userid  username        password        disabled
  38. 2       jfournier       ad0234829205b9033196ba818f7a872b       
  39. test select USER by NAME and PASSWORD.
  40. executing: select * from users where username='jfournier' and password='ad0234829205b9033196ba818f7a872b'.
  41. select USER by NAME and PASSWORD passed!.
  42. userid  username        password        disabled
  43. 2       jfournier       ad0234829205b9033196ba818f7a872b       
  44. test select USER by NAME and PASSWORD - FAIL.
  45. executing: select * from users where username='jfournier' and password='5a105e8b9d40e1329780d62ea2265d8a'.
  46. select USER by NAME and PASSWORD - FAIL passed!.
  47. no rows found!
  48. test drop table(2).
  49. executing: drop table users.
  50. drop table(2) passed!.
  51. 0 rows affected
Parsed in 0.094 seconds