CrazyDB class

Constructors

CrazyDB()

Properties

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

Methods

avg({String? column}) → Future<int>

count({String? column}) → Future<int?>

create(Map<String, dynamic> map) → Future<int>

delete() → Future<int>

find(int id) → Future<Map<String, Object?>>

first() → Future<Map<String, Object?>>

get({List? list}) → Future<List<Map<String, Object?>>>

groupBy(String column) → CrazyDB

having(String sql) → CrazyDB

join(String tab2, String tab1Column, String symbol, String tab2Column) → CrazyDB

leftJoin(String tab2, String tab1Column, String symbol, String tab2Column) → CrazyDB

noSuchMethod(Invocation invocation) → dynamic

Invoked when a nonexistent method or property is accessed.

inherited

orderBy(String column, {String? soft}) → CrazyDB

orderByDesc(String column) → CrazyDB

orWhere({required String column, String? symbol, required dynamic value}) → CrazyDB

paginate(int page, {int? perPage}) → Future<List<Map<String, Object?>>>

pluck(String column, {String? key}) → Future

rightJoin(String tab2, String tab1Column, String symbol, String tab2Column) → CrazyDB

select({List? list}) → CrazyDB

sum({String? column, String? alias}) → Future<List<Map<String, Object?>>>

toString() → String

A string representation of this object.

inherited

update(Map<String, dynamic> map) → Future<int>

value(String column) → Future

where({required String? column, String? symbol, required dynamic value}) → CrazyDB

whereBetween(String column, List list) → CrazyDB

whereIn(String column, List list) → CrazyDB

whereNotBetween(String column, List list) → CrazyDB

whereNotIn(String column, List list) → CrazyDB

whereNotNull({required String column}) → CrazyDB

whereNull({required String column}) → CrazyDB

Operators

operator ==(Object other) → bool

The equality operator.

inherited

Static Properties

db ↔ Database

getter/setter pair

dbPath ↔ String

getter/setter pair

Static Methods

closeDB() → void

commit() → dynamic

connection(String db) → Future<CrazyDB>

deleteRaw({required String sql}) → Future<int>

getInstance() → CrazyDB

getSql() → String

insertRaw({required String sql}) → Future<int>

openDB() → Future<bool>

rollback() → dynamic

selectRaw({required String sql}) → Future<List<Map<String, Object?>>>

table(String table) → CrazyDB

transaction() → dynamic

updateRaw({required String sql}) → Future<int>