SQL Extension

SQL Extension

Provides database connectivity. Access via SQL namespace.

Usage

connId = SQL.connect("sqlite", ":memory:");
conn = Connection(connId);

conn.update("CREATE TABLE Users (ID INT, Name VARCHAR(50))");
conn.update("INSERT INTO Users VALUES (1, 'Alice')");

rsId = conn.query("SELECT * FROM Users");
rs = ResultSet(rsId);

while (rs.next()) {
    print(rs.getInt("ID") + ": " + rs.getString("Name"));
}

rs.close();
conn.close();