using Sqlite;

public class Package : GLib.Object {
 public string name;
 public string version;
 public string uri;
 public string description;

 public void info() {
  stdout.printf("%s-%s\n%s\n", this.name, this.version, this.description);
 }
}

void main (string[] args) {
 Database db;
 Statement stmt;
 int rc = 0;
 if ((rc = Database.open("pkg.db", out db)) == 1) {
  printerr ("Can't open the datbase %s", db.errmsg());
  return;
 }
 if ((rc = db.prepare_v2 ("select * from tbl1", -1, out stmt, null)) == 1) {
  printerr ("SQL error: %d, %s\n", rc, db.errmsg());
  return;
 }
 stmt.step();
 Package pkg = new Package();
 pkg.name = stmt.column_text(0);
 pkg.version = stmt.column_text(1);
 pkg.description = stmt.column_text(3);
 pkg.info();
}