Parameterized SQL statement: Difference between revisions
Content added Content deleted
Line 339: | Line 339: | ||
=={{header|Julia}}== |
=={{header|Julia}}== |
||
{{works with|Julia|0.6}} |
|||
Uses the SQLite package. |
Uses the SQLite package. |
||
<lang |
<lang julia>using SQLite |
||
using SQLite |
|||
name = "Smith, Steve" |
name = "Smith, Steve" |
||
jerseys = Dict("Smith, Steve" => 99) |
jerseys = Dict("Smith, Steve" => 99) |
||
⚫ | |||
⚫ | |||
db = SQLite.DB() # no filename given, so create an in-memory temporary |
db = SQLite.DB() # no filename given, so create an in-memory temporary |
||
⚫ | |||
⚫ | |||
⚫ | |||
score number, |
|||
active bool, |
|||
⚫ | |||
jerseynum integer)") |
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 = ?"; |
SQLite.query(db, "UPDATE players SET name = ?, score = ?, active = ? WHERE jerseynum = ?"; |
||
values = ["Smith, Steve", 42, |
values = ["Smith, Steve", 42, sqlbool(true), jerseys[name]]) |
||
tbl = SQLite.query(db, "SELECT * from players") |
tbl = SQLite.query(db, "SELECT * from players") |
||
⚫ | |||
⚫ | |||
</lang> |
|||
{{output}}<pre> |
{{output}}<pre> |
||
1×5 DataFrames.DataFrame |
1×5 DataFrames.DataFrame |