Easy Notebook julia SQL.
Install with:
import Pkg;
Pkg.add(url="https://github.com/arabidopsis/SQL.jl")
Use like:
import SQL: @sql, @sql_cmd, sql, sql_connect
sql_connect("mysql://username:$(password)@localhost/database")
N = 5
@sql "select * from table limit $(N)"
# as a simple function
table = "table1"
s = "select * from " * table
df = sql(s)
Currently I can't find a way to do string interpolation for a custom command:
# this works
df = sql`select * from table limit 5`
N = 5
# variable interpolation *does not* work
df = sql`select * from table limit $(N)`
# but this does!
df = @sql_cmd "select * from table limit $(N)"
Keep the connection objects around:
conn1 = sql_connect("sqlite:///my.db")
conn2 = sql_connect("mysql://localhost/db")
@sql conn1 "select * from table"
@sql conn2 "select * from table2"
# last connect is "default" so this works on mysql database
@sql "select * from table2"
# set sqlite database as default
SQL.sql_set_default(conn1)
- add postgresql too LibPQ