wazeloquent 0.0.2 copy "wazeloquent: ^0.0.2" to clipboard
wazeloquent: ^0.0.2 copied to clipboard

Published 24 months ago • Latest: 0.0.5+1
[unknown platforms]
→

Metadata

Laravel Eloquent Wrapper For Flutter

More...

WazEloquent #

WazEloquent is designed to deal with database without writing custom querys on your own. This package is built on top of Sqflite package and inspired by Laravel eloquent.

Features #

  • You don't need to create your own database class. Just interact with table by using DB's methods such as onCreate, onOpen, onConfigure, onUpgrade, onDowngrade.
  • Eazy to deal with table without writing query on your own.
  • Laravel Eloquent alike methods.
  • supported relationships

`## Getting started

  • Extend eloquent and configure required methods #

    e.g

    class UserEloquent extends Eloquent {
  @override
  // TODO: implement columns
  List<String> get columns => ['id','name','password','createdAt','updatedAt'];

  @override
  String get getPrimaryColumn => 'id';

  @override
  // TODO: implement tableName
  String get tableName => 'users';
}

  • Create table before using eloquent #

    For creating table, you can easily do it by registering onOpen, OnCreate methods of DB class. For more information about creating table, please consult sqflite documentaion.

    // lib/main.dart
import 'package:wazeloquent/wazeloquent.dart' show DB;

void main(){
  var db = DB.instance;
  db.setDbVersion(1); // optinal: set db version, default: 1
  // db.setFilePath(path); // optional: set db path
  db.setFileName('example.db'); // optional: set file name, default: sqflite.db
  db.onCreate([
      Future(() {
        return (Database db, int) async {};
      }),
  ]);
  db.onOpen([
      Future((){
        return (Database db)async{
          // do something on Open db
      }),
  ]);

  db.onConfigure([]);
  db.onUpgrade([]);
  db.onDowngrade([]);

  runApp(const MyApp());
}

    I would like to suggest you to have static variable in your eloquent. For example, see below.

    class UserEloquent extends Eloquent {
  static Future<Function(Database)> onOpen = Future(() {
      return (Database db) async {
      await DB.createTable(db, tableName: 'users',columns: {
        'id': [ColumnType.idType],
        'name': [ColumnType.stringType, ColumnType.notNull],
        'password': [ColumnType.stringType, ColumnType.notNull],
        'createdAt': [ColumnType.stringType, ColumnType.notNull],
        'updatedAt': [ColumnType.stringType, ColumnType.notNull],
    });
      };
  });

  static Future<Function(Database, int)> onCreate = Future(() {
      return (Database db, int version) async {
      await DB.createTable(db, tableName: 'users',columns: {
        'id': [ColumnType.idType],
        'name': [ColumnType.stringType, ColumnType.notNull],
        'password': [ColumnType.stringType, ColumnType.notNull],
        'createdAt': [ColumnType.stringType, ColumnType.notNull],
        'updatedAt': [ColumnType.stringType, ColumnType.notNull],
    });
      };
  });
}

    Then use them like

    void main() {
  DB.instance.onCreate([UserEloquent.onCreate]);
  DB.instance.onOpen([UserEloquent.onOpen]);
  runApp(const MyApp());
}

    Then you are ready to use eloquent.

  • Using existing db #

    In order to use existing db, you can specify file path and file name. For example,

    import 'package:path_provider/path_provider.dart';

var path = await getApplicationDocumentsDirectory();
var dir = path.absolute.path + '/test';
db.setFilePath(dir, shouldForceCreatePath: true); // Specify 'shouldForceCreatePath' to true for creating folder if not exist.
db.setFileName('example.db');

Usage #

Available methods are as follows.


  • where #

    Specify 'where' conditions in query.

    Always include get() method at the end of query. Otherwise query will not be executed.

    var userEloquent = UserEloquent();

//get users where name is john
userEloquent.where('name','john').get();

//get users where name is john and createdAt greater than   2022-05-03
userEloquent.where('name','john').where('createdAt','2022-05-03', operator:Operator.greaterThan).get();

//get users where name is not john
userEloquent.where('name','john',operator:Operator.notEqual).get();

//get users where name has 'j'
userEloquent.where('name','%j%',operator:Operator.like).get();

  • whereIn #

    Get all records of which column include any of the provided values.

    var userEloquent = UserEloquent();

// get users where column `id` matches any of values [1,2,4]
userEloquent.whereIn('id',[1,2,4]).get();

  • orderBy #

    Sort rows in either descending or ascending order.

    var userEloquent = UserEloquent();

// sort users by 'name' column
userEloquent.orderBy('name').get();

// sort users by 'name' column in descending order
userEloquent.orderBy('name',sort:Sort.descending).get();

  • orderByDesc #

    Sort rows in descending order.

    var userEloquent = UserEloquent();

// sort users by 'name' column in descending order
userEloquent.orderByDesc('name').get();

  • groupBy #

    Group rows by column.

    var userEloquent = UserEloquent();

// group users by 'name' column
userEloquent.groupBy('name').get();

  • groupByDesc #

    Group rows by column in descending order.

    var userEloquent = UserEloquent();

// group users by 'name' column
userEloquent.groupByDesc('name').get();

  • latest #

    Get latest row related to primary key. You can specify the column name.

    var userEloquent = UserEloquent();

// Get latest user by 'id' which is primary key.
userEloquent.latest().get();

// Get latest user by 'name';
userEloquent.latest(columnName:'name').get();

  • take #

    Limit the number of rows in result.

    var userEloquent = UserEloquent();

// get first user where name is like j
userEloquent.where('name','%j%',operator:Operator.like).orderByDesc('name').take(1).get();

  • skip #

    Skip a given number of results.

    var userEloquent = UserEloquent();

// skip 1 row and get next 10 users where name is like j
userEloquent.where('name','%j%',operator:Operator.like).orderByDesc('name').skip(1).take(10).get();

  • distinct #

    Get unique column values.

    var userEloquent = UserEloquent();

// get unique rows related to column 'name'.
userEloquent.distinct(['name']).get();

  • all #

    Return all rows from table.

    var userEloquent = UserEloquent();

//similar to userEloquent.get() but no matter what options you specify, they will be ignored and all rows will be returned.
userEloquent.all();

//orderBy, limit will be ignored
userEloquent.orderBy('name').limit(1).all();

  • get #

    Final execution of query is performed by issuing this method.

    var userEloquent = UserEloquent();

userEloquent.get();

  • select #

    Select columns to be returned in results.

    var userEloquent = UserEloquent();

// return rows which have only 'name' column in results;
userEloquent.select(['name']);

  • find #

    Find row by primary key.

    var userEloquent = UserEloquent();

// get user where primary key (id) is 1.
userEloquent.find(1);

  • Search rows.

    var userEloquent = UserEloquent();

// get rows where any column has word 'j'.
userEloquent.search('j');

// get rows where country has 'UK' and any other rows has 'j'.
userEloquent.where('country','UK').search('j');

//specify searchable columns
userEloquent.search('j',searchableColumns:['name']);

  • create #

    Create a new row.

    var userEloquent = UserEloquent();

userEloquent.create({'name':'John','password':'pass'});

  • createIfNotExists #

    Create a new row only if the value is not existed.

    var userEloquent = UserEloquent();

// create user which name is john and password is pass only if name 'john' is not existed.
userEloquent.createIfNotExists(check:{'name':'john'},create:{'password':'pass'});

  • updateOrCreate #

    Update data if exists and if not, create new row.

    var userEloquent = UserEloquent();

// if row where name is john exists, update 'password' column. If not, create row where name is john and password is 'pass'.
userEloquent.updateOrCreate(check:{'name':'john'},inserts:{'password':'pass'});

  • update #

    Update rows.

    var userEloquent = UserEloquent();

// update name of all rows to 'john'.
userEloquent.update({'name':'john'});

// update name of rows where id = 1 to 1.
userEloquent.where('id',1).update({'name':'john'});

  • delete #

    Delete rows from table

    var userEloquent = UserEloquent();

// delete all rows from users
userEloquent.delete();

// delete rows where name has 'j' from users
userEloquent.where('name','%j%',operator:Operator.like).delete();

  • deleteBy #

    Delete a row by primary key.

    var userEloquent = UserEloquent();

// delete row where primary key is 1
userEloquent.deleteBy(1);

  • getDatabase #

    A static method to get database instance.

    Database db = await UserEloquent.getDatabase;

Models #

It is not mandatory for your models to extend Model class. But extending Model class will provide some more methods to provide your model to interact with tables.

Let your model extend Model class.

class User extends Model{
  //configure required methods.
}

Avaiable methods are

  • save

  • delete

  • save #

    Save the updated properties of your model.

    User user = User({name:'John',password:'pass'});
user.name = 'Doe';
await user.save(); // update the user's name to 'Doe' in table.

  • deletee #

    Delete the model.

    User user = User();
await user.delete();

Relationships #

Supported relationship types are

Many-To-Many relationship is planned to be implemented in near future.

Before implementing for relationship, enable foreign key options in db.

 db.onConfigure([
    Future(() {
      return (Database db) async {
        await db.execute('PRAGMA foreign_keys = ON');
      };
    })
  ]);

For the time being, the package doesn't offer to create/update/delete records through relationships. You can only read the related records.

One-To-One #

  • Example Scenario #

    For example, a user may have a car and a car belongs to a user.

  • Create foreign fields #

    You can create foreign keys by using DB.foreign().

    Rules: foreignKey must be in parentTable_parentKey format.

    For example, let's create cars table.

     await DB.createTable(db, tableName: 'cars', columns: {
      'id': [ColumnType.idType],
      'user_id': DB.foreign(
          foreignKey: 'user_id',
          parentKey: 'id',
          parentTable: 'users',
          type: ColumnType.integerType,
          onDelete: DBActions.cascade,
          onUpdate: null),
      'name': [ColumnType.stringType, ColumnType.notNull],
      'createdAt': [ColumnType.stringType, ColumnType.notNull],
      'updatedAt': [ColumnType.stringType, ColumnType.notNull],
    });
  };

  • Create Model if not exists and extends Model class and add OneToOne mixin. #

    import 'package:wazeloquent/wazeloquent.dart';

class User extends Model with OneToOne{}

  • Determine which method to use in your model. #

    Since user has car and a car belongs to a user, you can use hasOne in User class and belongsTo in Car class.

    For user,

    class User extends Model with OneToOne{
  factory User.fromDB(Map<String, Object?> user) {
    return User(...);
  }

  Future<Car?> getCar() async {
    var car = await hasOne('cars');
    if (car != null) {
      return Car.fromDB(car);
    }
    return null;
  }

  static Future<User> withCar(Map<String, Object?> data) async {
    var user = User(
        id: int.parse(data['id'].toString()),
        name: data['name'].toString(),
        password: data['password'].toString(),
        createdAt: DateTime.parse(data['createdAt'].toString()),
        updatedAt: DateTime.parse(data['updatedAt'].toString()));
    user.car = await user.getCar();
    return user;
  }
}

//Then
var data = UserEloquent().find(1);
User userWithoutCar = User(data);
User userWithCar = User.withCar(data);

print(userWithoutCar.car); // null
print(userWithCar.car); // car model

    For car,

    class Car extends Model with OneToOne{
   factory Car.fromDB(Map<String, Object?> data) {
    return Car( ... );
  }

  static Future<Car> withUser(Map<String, Object?> data) async {
    var car = Car(
        id: int.parse(data['id'].toString()),
        userId: data['user_id'].toString(),
        name: data['name'].toString());
    car.user = await car.getUser();
    return car;
  }

  Future<User> getUser() async {
    var user = await belongsTo('users');
    return User.fromDB(user!);
  }
}

//Then
var data = CarEloquent().find(1);
User carWithoutUser = Car(data);
User carWithUser = Car.withUser(data);

print(carWithoutUser.user); // null
print(carWithUser.user); // user model

One-To-Many #

  • Example Scenario #

    For example, a user may have one or more cars and a car belongs to a user.

  • Create foreign keys and extend and add mixin ( same as One-To-One) #

    See above.

  • Determine which method to use in your model. #

    Since user has one or more cars and a car belongs to a user, you can use hasMany in User class and belongsTo in Car class.

    For user,

    class User extends Model with OneToMany{
  factory User.fromDB(Map<String, Object?> user) {
    return User(...);
  }

  Future<Car?> getCars() async {
    var data = await hasMany('cars');
    List<Car> cars = [];
    for (var car in data) {
      cars.add(Car.fromDB(car));
    }
    return cars;
  }

  static Future<User> withCars(Map<String, Object?> data) async {
    var user = User(
        id: int.parse(data['id'].toString()),
        name: data['name'].toString(),
        password: data['password'].toString(),
        createdAt: DateTime.parse(data['createdAt'].toString()),
        updatedAt: DateTime.parse(data['updatedAt'].toString()));
    user.cars = await user.getCars();
    return user;
  }
}

//Then
var data = UserEloquent().find(1);
User userWithoutCars = User(data);
User userWithCars = User.withCar(data);

print(userWithoutCar.cars); // []
print(userWithCar.cars); // List<Car>

    For car,

    class Car extends Model with OneToOne{
   factory Car.fromDB(Map<String, Object?> data) {
    return Car( ... );
  }

  static Future<Car> withUser(Map<String, Object?> data) async {
    var car = Car(
        id: int.parse(data['id'].toString()),
        userId: data['user_id'].toString(),
        name: data['name'].toString());
    car.user = await car.getUser();
    return car;
  }

  Future<User> getUser() async {
    var user = await belongsTo('users');
    return User.fromDB(user!);
  }
}

//Then
var data = CarEloquent().find(1);
User carWithoutUser = Car(data);
User carWithUser = Car.withUser(data);

print(carWithoutUser.user); // null
print(carWithUser.user); // user model

Additional information #

Check example here

This package is develped bc of my future flutter projects and it has only small features for now. I am planning to implement relationship features in future.
I would be really happy if this package helps you. Cheers 🎉🎉

← Metadata

22
likes
0
pub points
53%
popularity

Publisher

unverified uploader

Metadata

Laravel Eloquent Wrapper For Flutter

Repository (GitHub)
View/report issues

License

unknown (LICENSE)

Dependencies

flutter, path, path_provider, sqflite

More

Packages that depend on wazeloquent

Back