wazeloquent 0.0.1+3

Laravel Eloquent Wrapper For Flutter

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.

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); // set db version
    db.setFileName('example.db'); // set file name
    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.

Usage

Available methods are as follows.

• where
• orderBy
• orderByDesc
• groupBy
• groupByDesc
• latest
• take
• skip
• distinct
• all
• get
• select
• find
• search
• create
• createIfNotExists
• updateOrCreate
• update
• delete
• deleteBy
• getDatabase

• 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();
  

• 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

  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;
  

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 glad if this package helps you. Cheers.