wa_mysql library

Classes

And
AndWhere
Represents a WHERE clause that combines multiple conditions with AND.
Case
CaseCondition
Condition
ConditionString
ForeignKey
Represents a foreign key constraint in MySQL.
Having
Join
LeftJoin
Limit
MBigInt
MySQL BIGINT field type.
MField
Abstract base class for all MySQL field types.
MFieldBinary
MySQL BINARY field type.
MFieldBit
MySQL BIT field type.
MFieldBlob
MySQL BLOB field type.
MFieldBoolean
MySQL BOOLEAN field type.
MFieldChar
MySQL CHAR field type.
MFieldDate
MySQL DATE field type.
MFieldDateTime
MySQL DATETIME field type.
MFieldDecimal
MySQL DECIMAL field type.
MFieldEnum
MySQL ENUM field type.
MFieldFloat
MySQL FLOAT field type.
MFieldInt
MySQL INT field type.
MFieldJson
MySQL JSON field type.
MFieldLongBlob
MySQL LONGBLOB field type.
MFieldLongText
MySQL LONGTEXT field type.
MFieldMediumBlob
MySQL MEDIUMBLOB field type.
MFieldMediumText
MySQL MEDIUMTEXT field type.
MFieldPoint
MySQL POINT field type.
MFieldPolygon
MySQL POLYGON field type.
MFieldSet
MySQL SET field type.
MFieldText
MySQL TEXT field type.
MFieldTime
MySQL TIME field type.
MFieldTimestamp
MySQL TIMESTAMP field type.
MFieldTinyBlob
MySQL TINYBLOB field type.
MFieldTinyText
MySQL TINYTEXT field type.
MFieldVarBinary
MySQL VARBINARY field type.
MFieldVarchar
MySQL VARCHAR field type.
MFieldYear
MySQL YEAR field type.
MMediumInt
MySQL MEDIUMINT field type.
MSmallInt
MySQL SMALLINT field type.
MTable
Represents a MySQL table definition with fields, foreign keys, and table options.
MTinyInt
MySQL TINYINT field type.
MySqlResult
Wrapper class for MySQL query results with convenient access methods.
On
OnOne
Represents a simple ON condition with a single comparison. This is the most common type of ON clause, representing a single condition like "field1 = field2". Example usage:
Or
OrWhere
Represents a WHERE clause that combines multiple conditions with OR.
QField
Represents a database field or column with proper SQL quoting and optional aliasing.
QFieldAll
Represents a wildcard field that selects all columns from a table.
QFromQuery
Represents a subquery used as a table source in the FROM clause.
QMath
Represents a mathematical expression or function in a SELECT clause.
QNull
QOrder
Represents an ORDER BY clause specification with field name and sort direction.
QParam
QSelect
Represents a standard field selection with optional alias.
QSelectAll
Represents a SELECT * (wildcard) field that selects all columns.
QSelectCustom
Represents a custom SELECT field with optional alias.
QSelectField
Abstract base class for all SELECT field types.
QSelectString
QVar<T>
Represents a value in SQL with proper escaping and formatting.
QVarLike
Represents a LIKE pattern value with configurable wildcard placement.
RightJoin
SQL
Base interface for all SQL-generating classes.
Sqler
SQL Query Builder Library for MySQL
SqlExplain
Represents an EXPLAIN statement for a SQL query. This class wraps a Sqler query and generates the EXPLAIN SQL statement to analyze the query execution plan.
SubQuery
Union
Where
Abstract base class for WHERE clause conditions.
WhereBody
Abstract base class for WHERE clause bodies with specific combination logic.
WhereOne
Represents a simple WHERE condition with a single comparison.

Enums

FieldTypes
Enumeration of all supported MySQL field types.
HashType
Enum representing different hash types for password hashing. This enum is used to specify the hashing algorithm when creating
QO
Enumeration of SQL comparison and logical operators.
WhereType
Enumeration for logical combination types in WHERE clauses.

Extensions

MySqlTable on MTable
Extension for MTable that provides MySQL-specific database operations.

Typedefs

ValidatorEvent<T> = Future<String> Function(T value)