# Pastebin OSmfaESP
SQL : CREATE TABLE person(
   id integer NOT NULL primary key AUTOINCREMENT,
   name varchar(255) NOT NULL 
)
BIND: []
SQL : CREATE TABLE post(
   id integer NOT NULL primary key AUTOINCREMENT,
   author_id integer NULL references person(id),
   title varchar(255) NOT NULL ,
   body varchar(255) NOT NULL ,
   deleted integer NOT NULL ,
   created varchar(32) NOT NULL ,
   tags varchar(255) NOT NULL ,
   UNIQUE (title)
)
BIND: []
SQL : SELECT
   post.id , post.author_id as "author-id", post.title , post.body , post.deleted , post.created , post.tags 
FROM
   post
WHERE
   post.id = 42
LIMIT 1
BIND: []
SQL : SELECT
   post.id , post.author_id as "author-id", post.title , post.body , post.deleted , post.created , post.tags 
FROM
   post
WHERE
   post.id = 42
LIMIT 1
BIND: []
SQL : SELECT
   post.id , post.author_id as "author-id", post.title , post.body , post.deleted , post.created , post.tags 
FROM
   post
WHERE
   post.title = 'my title'
LIMIT 1
BIND: []
SQL : INSERT INTO person(
   name
)
VALUES(
   ?
)
BIND: ["Fernando"]
SQL : SELECT
   person.id , person.name 
FROM
   person
WHERE
   _rowid_ = last_insert_rowid()
LIMIT 1
BIND: []
SQL : SELECT
   person.id , person.name 
FROM
   person
WHERE
   person.id = 1
LIMIT 1
BIND: []
SQL : INSERT INTO person(
   name
)
VALUES(
   $1
) RETURNING *
BIND: ["Fernando"]
SQL : SELECT
   person.id , person.name 
FROM
   person
WHERE
   person.id = 11
LIMIT 1
BIND: []
SQL : SELECT
   post.id , post.author_id as "author-id", post.title , post.body , post.deleted , post.created , post.tags 
FROM
   post
WHERE
   post.author_id = ?
BIND: [1]
()
SQL : SELECT
   post.id , post.author_id as "author-id", post.title , post.body , post.deleted , post.created , post.tags 
FROM
   post
WHERE
   (post.author_id = ? AND (post.deleted == 0 OR post.deleted IS NULL)) AND post.created > 1567984231.704825
BIND: [2]
()
SQL : SELECT
   post.id , post.author_id as "author-id", post.title , post.body , post.deleted , post.created , post.tags 
FROM
   post
WHERE
   (post.author_id = ? AND (post.deleted == 0 OR post.deleted IS NULL)) AND post.created > ?
BIND: [3, Instant.from-posix(<655417408859/418>, Bool::False)]
()
SQL : INSERT INTO person(
   name
)
VALUES(
   ?
)
BIND: ["Fernando"]
SQL : SELECT
   person.id , person.name 
FROM
   person
WHERE
   _rowid_ = last_insert_rowid()
LIMIT 1
BIND: []
SQL : SELECT
   person.id , person.name 
FROM
   person
WHERE
   person.id = 2
LIMIT 1
BIND: []
SQL : INSERT INTO post(
   deleted,
   title,
   tags,
   author_id,
   body,
   created
)
VALUES(
   ?,
   ?,
   ?,
   ?,
   ?,
   ?
)
BIND: [Bool::False, "My new post", "", 2, "A long post", "2019-09-09T00:10:31.769650+01:00"]
SQL : SELECT
   post.id , post.author_id as "author-id", post.title , post.body , post.deleted , post.created , post.tags 
FROM
   post
WHERE
   _rowid_ = last_insert_rowid()
LIMIT 1
BIND: []
SQL : SELECT
   post.id , post.author_id as "author-id", post.title , post.body , post.deleted , post.created , post.tags 
FROM
   post
WHERE
   post.id = 1
LIMIT 1
BIND: []
SQL : SELECT
   post.id , post.author_id as "author-id", post.title , post.body , post.deleted , post.created , post.tags 
FROM
   post
WHERE
   post.title = 'My new post'
LIMIT 1
BIND: []
A long post
SQL : SELECT
   person.id , person.name 
FROM
   person
WHERE
   person.id = ?
LIMIT 1
BIND: [2]
SQL : UPDATE person SET
   name = 'John Doe'
WHERE person.id = 2

BIND: []
SQL : INSERT INTO post(
   title,
   deleted,
   created,
   author_id,
   body,
   tags
)
VALUES(
   ?,
   ?,
   ?,
   ?,
   ?,
   ?
)
BIND: ["Second post", Bool::False, "2019-09-09T00:10:31.864533+01:00", 2, "Another long post", ""]
SQL : SELECT
   post.id , post.author_id as "author-id", post.title , post.body , post.deleted , post.created , post.tags 
FROM
   post
WHERE
   _rowid_ = last_insert_rowid()
LIMIT 1
BIND: []
SQL : SELECT
   post.id , post.author_id as "author-id", post.title , post.body , post.deleted , post.created , post.tags 
FROM
   post
WHERE
   post.id = 2
LIMIT 1
BIND: []
SQL : SELECT
   count(*) as "data_1"
FROM
   post
WHERE
   post.author_id = ?
LIMIT 1
BIND: [2]