#run with: mix sample

#drop to start over
:ok = Fsdb.drop("table1")

#creates table at dev default _build/dev/.fsdb
#configure path with: config :fsdb, path: <NEW_PATH>
:ok = Fsdb.create("table1")

#insert generates and returns an autoincrementing id
{:ok, 1} = Fsdb.insert("table1", "row1")
{:ok, "row1"} = Fsdb.fetch("table1", 1)

#operation on unexisting ids return not found
:nf = Fsdb.delete("table1", 5)
:nf = Fsdb.update("table1", 5, "row5+")

#save overrides and updates id generator
:ok = Fsdb.save("table1", 5, "row5")
:ok = Fsdb.save("table1", 3, "row3")
#continue +1 of largest id used/generated before
{:ok, 6} = Fsdb.insert("table1", "row6")

#operations that get back previous value
{:ok, "row5"} = Fsdb.update("table1", 5, "row5+")
{:ok, "row5+"} = Fsdb.save("table1", 5, "row5++")
{:ok, "row5++"} = Fsdb.delete("table1", 5)

#tuples may not be id ordered
[{1, "row1"}, {3, "row3"}, {6, "row6"}] = Fsdb.list("table1")