z3n7 github RU

DbSql

static class · namespace z3n7 · source Db/DbExtencions.cs

public static class DbSql

Lower-level SELECT and UPDATE helpers behind the Db* methods.

Methods

SqlGet

public static string SqlGet(this IZennoPosterProjectModel project, string toGet, string tableName = null, bool log = false, bool thrw = false, string key = "id", object id = null, string where = "")

Extension method for IZennoPosterProjectModel. source

Selects columns from the row where key = id, or from the rows matching where.

Parameter Description
toGet Comma-separated column names; each is quoted.
tableName Table; default is the project table (projectTable variable).
log Write the query and its result to the project log.
thrw Throw on a database error instead of logging a warning and returning an empty result.
key Column matched against id.
id Value of key; default is the current account, acc0. Inserted into the SQL as written.
where Raw SQL condition. When set, key and id are ignored.

Returns: Columns joined by ¦, rows by ·.

SqlGetArrFromLine

public static string[] SqlGetArrFromLine(this IZennoPosterProjectModel project, string toGet, string tableName = null, bool log = false, bool thrw = false, string key = "id", object id = null, string where = "")

Extension method for IZennoPosterProjectModel. source

Like SqlGet, split into column values.

Parameter Description
toGet Comma-separated column names; each is quoted.
tableName Table; default is the project table (projectTable variable).
log Write the query and its result to the project log.
thrw Throw on a database error instead of logging a warning and returning an empty result.
key Column matched against id.
id Value of key; default is the current account, acc0. Inserted into the SQL as written.
where Raw SQL condition. When set, key and id are ignored.

SqlGetDicFromLine

public static Dictionary<string, string> SqlGetDicFromLine(this IZennoPosterProjectModel project, string toGet, string tableName = null, bool log = false, bool thrw = false, string key = "id", object id = null, string where = "", bool set = false)

Extension method for IZennoPosterProjectModel. source

Like SqlGet, returning the first row as column → value.

Parameter Description
toGet Comma-separated column names; each is quoted.
tableName Table; default is the project table (projectTable variable).
log Write the query and its result to the project log.
thrw Throw on a database error instead of logging a warning and returning an empty result.
key Column matched against id.
id Value of key; default is the current account, acc0. Inserted into the SQL as written.
where Raw SQL condition. When set, key and id are ignored.
set Also set project variables named after the columns.

SqlGetListFromLines

public static List<string> SqlGetListFromLines(this IZennoPosterProjectModel project, string toGet, string tableName = null, bool log = false, bool thrw = false, string key = "id", object id = null, string where = "")

Extension method for IZennoPosterProjectModel. source

Like SqlGet, split into rows.

Parameter Description
toGet Comma-separated column names; each is quoted.
tableName Table; default is the project table (projectTable variable).
log Write the query and its result to the project log.
thrw Throw on a database error instead of logging a warning and returning an empty result.
key Column matched against id.
id Value of key; default is the current account, acc0. Inserted into the SQL as written.
where Raw SQL condition. When set, key and id are ignored.

SqlUpd

public static string SqlUpd(this IZennoPosterProjectModel project, string toUpd, string tableName = null, bool log = false, bool thrw = false, string key = "id", object id = null, string where = "")

Extension method for IZennoPosterProjectModel. source

Runs UPDATE … SET toUpd for the row where key = id, or for the rows matching where.

Parameter Description
toUpd Assignments; column names are quoted, values are taken as written.
tableName Table; default is the project table (projectTable variable).
log Write the query and its result to the project log.
thrw Throw on a database error instead of logging a warning and returning an empty result.
key Column matched against id.
id Value of key; default is the current account, acc0. Inserted into the SQL as written.
where Raw SQL condition. When set, key and id are ignored.

Returns: Affected row count as text.