Parameterized SQL statement: Difference between revisions

Line 339:

=={{header|Julia}}==

Uses the SQLite package.

<lang julia>using SQLite

using SQLite

name = "Smith, Steve"

jerseys = Dict("Smith, Steve" => 99)

sqlbool(tf::Bool) = if(tf) "TRUE" else "FALSE" end

~~BOOL~~(tf) = if(tf) "TRUE" else "FALSE" end

db = SQLite.DB() # no filename given, so create an in-memory temporary

SQLite.execute!(db, "create table players (id integer primary key,

name text,

SQLite.execute!(db, "create table players (id integer primary key,

~~name~~ ~~text~~,

score number,

~~score~~ ~~number~~,

active bool,

~~active~~ ~~bool~~,

jerseynum integer)")

SQLite.query(db, "INSERT INTO players (name, score, active, jerseynum) values ('Jones, James', 9, 'FALSE', 99)");

SQLite.query(db, "INSERT INTO players (name, score, active, jerseynum) values ('Jones, James', 9, 'FALSE', 99)")

SQLite.query(db, "UPDATE players SET name = ?, score = ?, active = ? WHERE jerseynum = ?";

values = ["Smith, Steve", 42, ~~BOOL~~(true), jerseys[name]])

values = ["Smith, Steve", 42, sqlbool(true), jerseys[name]])

tbl = SQLite.query(db, "SELECT * from players")

println(tbl)</lang>

println(tbl)

</lang>

{{output}}<pre>

1×5 DataFrames.DataFrame