Hi, I am new to Nim and very excited about its features. I want to write a simple program that echo columns of a table in mysql database for study purpose.
I used db_mysql and found that both getRow and getAllRows return Row which is actually seq[string]. So how can I get columns by name?
I used this to dump the fields of a query result:
import mysql
proc showFields*(res: PRES) =
let fnum = int(mysql.numFields(res))
for i in 0.. <fnum:
let fp = mysql.fetch_field_direct(res, cint(i))
case fp.ftype
of FIELD_TYPE_VAR_STRING: echo i, " ", fp.name, " (vstring)"
of FIELD_TYPE_STRING: echo i, " ", fp.name, " (string)"
of FIELD_TYPE_LONG: echo i, " ", fp.name, " (int32)"
of FIELD_TYPE_INT24: echo i, " ", fp.name, " (int24)"
of FIELD_TYPE_TINY: echo i, " ", fp.name, " (int8)"
of FIELD_TYPE_DECIMAL: echo i, " ", fp.name, " (decimal)"
of FIELD_TYPE_TIMESTAMP: echo i, " ", fp.name, " (timestamp)"
of FIELD_TYPE_DATE: echo i, " ", fp.name, " (date)"
of FIELD_TYPE_BLOB: echo i, " ", fp.name, " (binary)"
else: echo i, " ", fp.name, " (", fp.ftype, ")!!!!!!!!!!!!!!!!!!"
@OrderWat, thanks!
@Araq, is there any plan to have a more advanced general database interface like JDBC or go's database/sql?