{"body":"SQL : CREATE TABLE person(\n   id integer NOT NULL primary key AUTOINCREMENT,\n   name varchar(255) NOT NULL \n)\nBIND: []\nSQL : CREATE TABLE post(\n   id integer NOT NULL primary key AUTOINCREMENT,\n   author_id integer NULL references person(id),\n   title varchar(255) NOT NULL ,\n   body varchar(255) NOT NULL ,\n   deleted integer NOT NULL ,\n   created varchar(32) NOT NULL ,\n   tags varchar(255) NOT NULL ,\n   UNIQUE (title)\n)\nBIND: []\nSQL : SELECT\n   post.id , post.author_id as \"author-id\", post.title , post.body , post.deleted , post.created , post.tags \nFROM\n   post\nWHERE\n   post.id = 42\nLIMIT 1\nBIND: []\nSQL : SELECT\n   post.id , post.author_id as \"author-id\", post.title , post.body , post.deleted , post.created , post.tags \nFROM\n   post\nWHERE\n   post.id = 42\nLIMIT 1\nBIND: []\nSQL : SELECT\n   post.id , post.author_id as \"author-id\", post.title , post.body , post.deleted , post.created , post.tags \nFROM\n   post\nWHERE\n   post.title = 'my title'\nLIMIT 1\nBIND: []\nSQL : INSERT INTO person(\n   name\n)\nVALUES(\n   ?\n)\nBIND: [\"Fernando\"]\nSQL : SELECT\n   person.id , person.name \nFROM\n   person\nWHERE\n   _rowid_ = last_insert_rowid()\nLIMIT 1\nBIND: []\nSQL : SELECT\n   person.id , person.name \nFROM\n   person\nWHERE\n   person.id = 1\nLIMIT 1\nBIND: []\nSQL : INSERT INTO person(\n   name\n)\nVALUES(\n   $1\n) RETURNING *\nBIND: [\"Fernando\"]\nSQL : SELECT\n   person.id , person.name \nFROM\n   person\nWHERE\n   person.id = 11\nLIMIT 1\nBIND: []\nSQL : SELECT\n   post.id , post.author_id as \"author-id\", post.title , post.body , post.deleted , post.created , post.tags \nFROM\n   post\nWHERE\n   post.author_id = ?\nBIND: [1]\n()\nSQL : SELECT\n   post.id , post.author_id as \"author-id\", post.title , post.body , post.deleted , post.created , post.tags \nFROM\n   post\nWHERE\n   (post.author_id = ? AND (post.deleted == 0 OR post.deleted IS NULL)) AND post.created > 1567984231.704825\nBIND: [2]\n()\nSQL : SELECT\n   post.id , post.author_id as \"author-id\", post.title , post.body , post.deleted , post.created , post.tags \nFROM\n   post\nWHERE\n   (post.author_id = ? AND (post.deleted == 0 OR post.deleted IS NULL)) AND post.created > ?\nBIND: [3, Instant.from-posix(<655417408859/418>, Bool::False)]\n()\nSQL : INSERT INTO person(\n   name\n)\nVALUES(\n   ?\n)\nBIND: [\"Fernando\"]\nSQL : SELECT\n   person.id , person.name \nFROM\n   person\nWHERE\n   _rowid_ = last_insert_rowid()\nLIMIT 1\nBIND: []\nSQL : SELECT\n   person.id , person.name \nFROM\n   person\nWHERE\n   person.id = 2\nLIMIT 1\nBIND: []\nSQL : INSERT INTO post(\n   deleted,\n   title,\n   tags,\n   author_id,\n   body,\n   created\n)\nVALUES(\n   ?,\n   ?,\n   ?,\n   ?,\n   ?,\n   ?\n)\nBIND: [Bool::False, \"My new post\", \"\", 2, \"A long post\", \"2019-09-09T00:10:31.769650+01:00\"]\nSQL : SELECT\n   post.id , post.author_id as \"author-id\", post.title , post.body , post.deleted , post.created , post.tags \nFROM\n   post\nWHERE\n   _rowid_ = last_insert_rowid()\nLIMIT 1\nBIND: []\nSQL : SELECT\n   post.id , post.author_id as \"author-id\", post.title , post.body , post.deleted , post.created , post.tags \nFROM\n   post\nWHERE\n   post.id = 1\nLIMIT 1\nBIND: []\nSQL : SELECT\n   post.id , post.author_id as \"author-id\", post.title , post.body , post.deleted , post.created , post.tags \nFROM\n   post\nWHERE\n   post.title = 'My new post'\nLIMIT 1\nBIND: []\nA long post\nSQL : SELECT\n   person.id , person.name \nFROM\n   person\nWHERE\n   person.id = ?\nLIMIT 1\nBIND: [2]\nSQL : UPDATE person SET\n   name = 'John Doe'\nWHERE person.id = 2\n\nBIND: []\nSQL : INSERT INTO post(\n   title,\n   deleted,\n   created,\n   author_id,\n   body,\n   tags\n)\nVALUES(\n   ?,\n   ?,\n   ?,\n   ?,\n   ?,\n   ?\n)\nBIND: [\"Second post\", Bool::False, \"2019-09-09T00:10:31.864533+01:00\", 2, \"Another long post\", \"\"]\nSQL : SELECT\n   post.id , post.author_id as \"author-id\", post.title , post.body , post.deleted , post.created , post.tags \nFROM\n   post\nWHERE\n   _rowid_ = last_insert_rowid()\nLIMIT 1\nBIND: []\nSQL : SELECT\n   post.id , post.author_id as \"author-id\", post.title , post.body , post.deleted , post.created , post.tags \nFROM\n   post\nWHERE\n   post.id = 2\nLIMIT 1\nBIND: []\nSQL : SELECT\n   count(*) as \"data_1\"\nFROM\n   post\nWHERE\n   post.author_id = ?\nLIMIT 1\nBIND: [2]","name":"","extension":"txt","url":"https://www.irccloud.com/pastebin/OSmfaESP","modified":1567984291,"id":"OSmfaESP","size":4111,"lines":221,"own_paste":false,"theme":"","date":1567984291}