SqlRowExtensions extension

on

Methods

asDeleteCommand({required String tableName, bool nullAsBlank = false, dynamic quoteChar, String dataBaseProvider = ""}) → String

Available on JsonRow, provided by the SqlRowExtensions extension

Generates a DELETE command for the given table name.
asDeleteTopCommand(String tableName, int count, String idColumn, bool asc, String dataBaseProvider, [bool nullAsBlank = false, dynamic quoteChar]) → String

Available on JsonRow, provided by the SqlRowExtensions extension

Generates a DELETE command for deleting the top count rows from the given table.
asInsertCommand({required String tableName, bool nullAsBlank = false, dynamic quoteChar, String dataBaseProvider = ""}) → String

Available on JsonRow, provided by the SqlRowExtensions extension

Generates an INSERT command for the given table name and map of values.
asSelectWhereCommand({required String tableName, List<String> columns = const [], bool nullAsBlank = false, dynamic quoteChar, String dataBaseProvider = "", bool and = true}) → String

Available on JsonRow, provided by the SqlRowExtensions extension

Generates a SELECT command with a WHERE clause for the given table name and column names.
asUpdateCommand({required String tableName, required Map<String, dynamic> where, bool nullAsBlank = false, dynamic quoteChar, String dataBaseProvider = ""}) → String

Available on JsonRow, provided by the SqlRowExtensions extension

Generates an UPDATE command for the given table name, WHERE clause, and map of values.
asUpsertCommand({required String tableName, Map<String, dynamic>? where, bool nullAsBlank = false, dynamic quoteChar, String dataBaseProvider = ""}) → String

Available on JsonRow, provided by the SqlRowExtensions extension

Generates an UPSERT command for the given table name, where clause, and other optional parameters.
asWhereClausule({bool nullAsBlank = false, dynamic quoteChar, String dataBaseProvider = "", bool and = true}) → String

Available on JsonRow, provided by the SqlRowExtensions extension

Generates a WHERE clause for the given map of column names and values.
generateSqlCall(String procedureName, String dataBaseProvider, [bool nullAsBlank = false, dynamic quoteChar]) → String

Available on JsonRow, provided by the SqlRowExtensions extension

Generates a SQL call string for a given stored procedure and database provider.