Parameterized SQL statement: Difference between revisions
m
→{{header|Julia}}
Line 341:
Uses the SQLite package.
<lang Julia>
using SQLite
name = "Smith, Steve"
jerseys = Dict("Smith, Steve" =>
BOOL(tf) = if(tf) "TRUE" else "FALSE" end
Line 353 ⟶ 352:
SQLite.execute!(db, "create table players (id integer primary key,
name text,
score
active,
jerseynum integer)")
SQLite.query(db, "INSERT INTO players (name, score, active, jerseynum) values ('Jones, James', '9', 'FALSE', 42)");
SQLite.query(db, "UPDATE players SET name = ?, score = ?, active = ? WHERE jerseynum = ?";
values = ["Smith, Steve", 42, BOOL(true), jerseys[name]])
tbl = SQLite.query(db, "SELECT * from players")
println(showall(tbl))
</lang>
{{Output}}<pre>
1×5 DataFrames.DataFrame
│ Row │ id │ name │ score │ active
├─────┼────┼────────────────┼───────┼────────┼───────────┤
│ 1 │ 1 │ "
</pre>
|