ORM_MYSQL DART

This is an attempt to develop an ORM in dart, I haven't seen any yet ... ** is an alpha version use only in tests do not use in production **

First steps

• add the dependency in your pubspec.yaml

dependencies:
  mysql_simple_orm:
    git: https://github.com/CpdnCristiano/mysql_simple_orm.git

• Create your model class

class User {
  int id;
  String name;
  int age;
  String email;
  bool isActive;
  DateTime createdAt;
  DateTime birthDate;
  DateTime lastUpdate;

  User({
    this.id,
    this.name,
    this.age,
    this.email,
    this.isActive,
    this.birthDate,
    this.createdAt,
    this.lastUpdate,
  });

  User.fromJson(Map<String, dynamic> json) {
    id = json['id'];
    name = json['name'];
    age = json['age'];
    email = json['email'];
    isActive = json['isActive'];
    createdAt = json['createdAt'];
    birthDate = json['birthDate'];
    lastUpdate = json['lastUpdate'];
  }

  Map<String, dynamic> toJson() {
    final Map<String, dynamic> data = Map<String, dynamic>();
    data['id'] = id;
    data['name'] = name;
    data['age'] = age;
    data['email'] = email;
    data['isActive'] = isActive;
    data['createdAt'] = createdAt;
    data['birthDate'] = birthDate;
    data['lastUpdate'] = lastUpdate;
    return data;
  }
}

• Create your repository:

class UserRepository extends Repository<User> {
  ///
  @override
  User modelDecoder(Map<String, dynamic> json) => User.fromJson(json);
///Declare your table
  @override
  Table get table => Table('users_bool1', [

  @override
  Table get table => Table(
        'users',
        [
          Column(
            'codigo',
            DataInt(),
            jsonProperty: 'id',
            autoIncrement: true,
            primaryKey: true,
          ),
          Column(
            'name',
            DataVarchar(length: 60),
          ),
          Column(
            'email',
            DataVarchar(length: 60),
            unique: true,
          ),
          Column(
            'age',
            DataInt(defaulfValue: 0),
          ),
          Column(
            'is_active',
            DataBoolean(defaulfValue: true),
            jsonProperty: 'isActive',
            notNull: true,
          ),
          Column(
            'created_at',
            DataCreatedAt(),
            jsonProperty: 'createdAt',
            notNull: true,
            immutable: true,
          ),
          Column(
            'birth_date',
            DataTimestamp(),
            jsonProperty: 'birthDate',
            notNull: true,
          ),
          Column(
            'last_update',
            DataLastUpdate(),
            jsonProperty: 'lastUpdate',
            notNull: true,
          ),
        ],
      );
}

in the repository there are the following methods

• findOne(id); fetch object by id;
• finAll(); return all table objects.
• deleteOne(id); delete an object
• insert(object) creates a new object
• update(id, object) updates an object
• findByField(String field, dynamic value); fetch List by field;

  start the database connection to the database

  in main.dart

  void main() async {
    MySQL db = MySQL(
      host: "localhost",
      user: "admin",
      password: "1234",
      db: "teste",
    );
    await db.init();

  TODO:

  • Custom query
  • Foreign key support(1:1,N:N,1:N)

  observations: In the future, the ORM will have a relationship between the wait

  Example projects