MySqlDb class

Constructors

MySqlDb({required String dbName, required String dbUser, required String dbCode, String dbHost = 'localhost', int dbPort = 3306, int traceDataLength = 80, String sqlTracePrefix = '', int timeout = 30, required BaseLogger logger})

Constructor

MySqlDb.fromConfiguration(BaseConfiguration configuration, BaseLogger logger, {String section = 'db'})

Constructor. Builds the instance from the configuration data.

Properties

currentScriptName ↔ String

getter/setter pair

dbCode ↔ String?

getter/setter pair

dbHost ↔ String?

getter/setter pair

dbName ↔ String?

getter/setter pair

dbPort ↔ int?

getter/setter pair

dbUser ↔ String?

getter/setter pair

hasConnection ↔ bool

getter/setter pair

hashCode → int

The hash code for this object.

no setter, inherited

runtimeType → Type

A representation of the runtime type of the object.

no setter, inherited

throwOnError ↔ bool

getter/setter pair

timeout ↔ int

getter/setter pair

Methods

close() → void

connect({bool? throwOnError}) → Future<bool>

deleteRaw(String sql, {List? params, bool? throwOnError}) → Future<int>

execute(String sql, {List? params, bool? throwOnError}) → Future<int>

executeScript(List<String> lines) → Future<String>

executeScriptFile(String filename) → Future<String>

hasColumn(String table, String column, {bool forceUpdate = false}) → Future<bool>

hasTable(String name, {bool forceUpdate = false}) → Future<bool>

insertOne(String sql, {List? params, bool? throwOnError}) → Future<int>

insertRaw(String sql, {List? params, bool? throwOnError}) → Future

noSuchMethod(Invocation invocation) → dynamic

Invoked when a nonexistent method or property is accessed.

inherited

readAll(String sql, {List? params, bool? throwOnError}) → Future

readAllAsLists(String sql, {List? params, bool? throwOnError}) → Future<List?>

readAndExecute(String sql, List params, dynamic onSingleRow) → Future<bool>

readOneAsMap(String sql, {List? params, bool? throwOnError}) → Future<Map<String, dynamic>?>

readOneInt(String sql, {List? params, dynamic nullAllowed = false, bool? throwOnError}) → Future<int?>

readOneString(String sql, {List? params, dynamic nullAllowed = false, bool? throwOnError}) → Future<String?>

toString() → String

A string representation of this object.

inherited

updateOne(String sql, {List? params, bool? throwOnError}) → Future<bool>

updateRaw(String sql, {List? params, bool? throwOnError}) → Future<int?>

Operators

operator ==(Object other) → bool

The equality operator.

inherited

Static Methods

convertNamedParams({required String sql, required Map<String, dynamic> mapParams, required BaseLogger logger, bool ignoreError = false}) → dynamic