sivchari / db_wrapper Goto Github PK

let conn = db.open("postgres", "localhost", 5432, "user", "password", "db_name", 95)
let rows = conn.query("select * from users where id = ?", ["1"])

let columnTypes = rows.columnTypes()
echo columnTypes
>> ["int", "varchar", "varchar", "bool"]

let columnNames = rows.columnNames()
echo columnNames
>> ["id", "name", "email", "is_admin"]

let data = http://rows.data()
echo data
>> [
  ["1", "user1", "[email protected]", "true"],
  ["2", "user2", "[email protected]", "false"],
  ["3", "user3", "[email protected]", "true"]
]