FastDb

class · namespace z3n7 · source Db/FastDb.cs

public class FastDb

SQLite access through ZennoPoster's built-in ODBC query runner, without opening own connections.

Constructors#

FastDb#

public FastDb(IZennoPosterProjectModel project, string dbName = null, bool log = false)

source

Uses the file {project.Path}{dbName}.sql.

Methods#

dbList#

public List<string> dbList(string query)

source

Executes a query and returns its rows.

dbString#

public string dbString(string query)

source

Executes a query.

Returns: Rows joined by line breaks, columns by |.

ExportToCsv#

public void ExportToCsv(string tableName, string fileName)

source

Writes the whole table to {project.Path}{fileName} as CSV with a header row (UTF-8).

public void ExportToCsv(string tableName, string fileName, string columns = "*")

source

Writes the selected columns to {project.Path}{fileName} as CSV, UTF-8 with BOM so that Excel opens it correctly.