Query Builder

Query Builder provides a user-friendly interface where users can define the criteria and parameters for database queries without needing to write the SQL code manually. Query builders are commonly used in database management systems and data analysis tools to streamline the query creation process, making it more accessible to users who may not be proficient in writing SQL queries.

create

Create

await Actor().create(
    {'name': 'John Wick', 'age': 60}
);

insert

InsertMultiple insert

await Actor().insert(
    {'name': 'John Wick', 'age': 60}
);

await Actor().insertMultiple([
    {'name': 'John Wick', 'age': 60},
    {'name': 'John Doe', 'age': 25},
]);

update

Update rows

await Actor()
    .where('id', 3)
    .where('status', 'active')
    .update({
        "name": "Updated AJ",
        "age": 120,
    });

count

Count allCount with condition

await Actor().count();

await Actor().where('age', '>=' , 23).count();

find

Find by idFind by custom column

await Actor().find(id);

await Actor().find('name', 'John Wick');

getFirst

Get first row

Actor actor = await Actor().getFirst(); // limit = 1

all

Ge all rows

List<Actor> actors = await Actor().all();
for(Actor actor in actors) {
    print(actor.id)
}

get

Get

List<Actor> actors = await Actor().where('name', 'John Wick').get();
    for(Actor actor in actors) {
    print(actor.id)
}

toSql

To SQL query

String query = Actor().where('name', 'John Wick').toSql();
print(query)

delete

Delete a row

await Actor().where('name', 'John Wick').delete();

forceDelete

Force delete

await Actor().where('name', 'John Wick').forceDelete();

Info

This work only with softDeletes.

withTrash

Get from trash

List actors = await Actor().where('name', 'John Wick').withTrash().get();
for(Actor actor in actors) {
    print(actor.id)
}

Info

This work only with softDeletes.

select

Multiple selectSelect with array of columnsSelect with comma separated columns

await Actor()
    .select('id')
    .select('name')
    .where('name', 'John Wick').get();

await Actor()
    .select(['id', 'name', 'age']).where('name', 'John Wick').get();

await Actor()
    .select('id, name, age').where('name', 'John Wick').get();

whereIn

Where in condition

await Actor().whereIn('id', ['1', '2']).get();

where

whereWhere with custom condition

await Actor().where('name', 'John Wick').get();

await Actor().where('name', '=', 'John Wick').get();
await Actor().where('age', '>=', 23).get();

orWhere

orWhereorWhere with custom conditionwhere and orWhere

await Actor().orWhere('name', 'John Wick').get();

await Actor().orWhere('name', '=', 'John Wick').get();
await Actor().orWhere('age', '>=', 23).get();

await Actor()
.where('name', 'John Doe').orWhere('name', 'John Wick').get();

whereRaw

whereRaw

await Actor().whereRaw('name = @name', {'name', 'John Wick'}).get();

orWhereRaw

Or where raw

await Actor().orWhereRaw('name = @name', {'name', 'John Wick'}).get();

limit, take, offset

LimitTakeoffset

await Actor().limit(10).get();

await Actor().take(10).get();

await Actor().limit(10).offset(10).get();

Info

Limit and take are the same function.

groupBy

Group by

await Actor()
    .select('count(*) as total, name').groupBy('name').get();

orderBy

defaultdescascmultiple columns

await Actor().orderBy('name').get();

await Actor().orderBy('name', 'desc').get();

await Actor().orderBy('name', 'desc').get();

await Actor()
    .orderBy('name', 'asc')
    .orderBy('id', 'desc')
    .get();

join

Join

await Actor()
    .join('actor_info', 'actor_info.admin_id', 'admin.id')
    .get();

leftJoin

Left join

await Actor()
    .leftJoin('actor_info', 'actor_info.admin_id', 'admin.id')
    .get();

rightJoin

Right join

await Actor()
    .rightJoin('actor_info', 'actor_info.admin_id', 'admin.id')
    .get();

joinRaw

Join raw

await Actor()
    .joinRaw('actor_info on actor_info.admin_id = admin.id')
    .get();

leftJoinRaw

Left join raw

await Actor()
    .leftJoinRaw('actor_info on actor_info.admin_id = admin.id')
    .get();

rightJoinRaw

Right Join Raw

await Actor()
    .rightJoinRaw('actor_info on actor_info.admin_id = admin.id')
    .get();

debug

Debug

await Actor().debug(true).all();