Julia: sqlite3 のデータを読む (Read)

#! /usr/bin/julia
#
#   sqlite3_read.jl
#
#                   Dec/27/2021
# --------------------------------------------------------------------
using SQLite
# --------------------------------------------------------------------
file_db = ARGS[1]
println("*** 開始 ***")
conn = SQLite.DB(file_db)

command = "select * from cities"

stmt = DBInterface.prepare(conn,command)

results = DBInterface.execute(stmt)

rowid = DBInterface.lastrowid(results)
for row in results
    print(row[1],'\t',row[2],'\t')
    println(row[3],'\t',row[4])
end
#
DBInterface.close!(stmt)
DBInterface.close!(conn)
#
println("*** 終了 ***")
# --------------------------------------------------------------------