The database sql library - pf-lang/pipefish GitHub Wiki
SqlDriver = enum COCKROACHDB, FIREBIRD_SQL, MARIADB, MICROSOFT_SQL_SERVER, MYSQL, ORACLE, POSTGRESQL, SNOWFLAKE, SQLITE, TIDB :
The available drivers for creating a SQL connection.
A type templace corresponding to SQL's VARCHAR(i), and automatically converted to and
from it.
A connection to a SQL database. This is a non-standard type, a wrapper around Golang's
*sql.DB type, and does not implement ==, !=, or serialization.
Populates the reference variable with the result of the SQL query represented as a value of the given type.
Populates the reference variable with the result of the SQL query represented as a value
like that of the given type, e.g. if the type is list{MyStructType} then the value
returned will be of type list, with its elements of type StructType.
Populates the reference variable with the result of the SQL query represented as a value
of type list with elements of type map.
Pings the database to test the connection.
Posts the given SQL command to the SQL database.
SqlDb(driver SqlDriver, hostpath string, port int, hostname string, username string, password string) -> SqlDb / error :
Returns a SQL connection.
Supplies a transient in-memory version of the given database. Currently only works for
SQLITE, until someone writes another one.
This page is automatically generated from the Pipefish standard library. Any edits made directly to this wiki page will be overwritten the next time the documentation is regenerated.