database_manager 0.0.2+1

Simple way to manage database. Version control and application's database schema. Simplify CRUD operations.

database_manager (Developer Preview)

Simple way to manage database. Version control and application's database schema. Simplify CRUD operations.

Installing

Add this to your package's pubspec.yaml file:

dependencies:
  database_manager: "^0.0.2"

Available features

• Migration - version control and application's database schema
• ORM(work in progress) - simplify CRUD operations

Simple usage

import 'package:database_manager/database_manager.dart';

class Table1 implements Migration {
  @override
  void up() {
    Schema.create(tableName: 'table_1', callback: (Blueprint table) {
      table.integer('id').autoIncrement();
      table.string('name');
      table.string('email').unique();
      table.string('cell').nullable();
      table.unsignedInteger('user_id').defaultValue(value: 1);
    });

    Schema.table(tableName: 'table_1', callback: (Blueprint table){
      table.check(expression: " name<>'mark' ")
            .andCheck(expression: "email = '[e-mail]'");
      table.foreign(columns: ['user_id']).references(idList: ['id']).on(
            tableName: 'users').onDelete(action: 'cascade');
    });
  }

  @override
  void down() {
    Schema.dropIfExists(tableName: 'table_1');
  }
}

class Todo {

  void test(){

    Migrate migrate = Migrate([
      Table1(),
    ]);

    String sqlString = migrate.createList();

  }
}

Output

CREATE TABLE IF NOT EXISTS `table_1` (
`id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
`name` VARCHAR(255) NOT NULL,
`email` VARCHAR(255) NOT NULL,
`cell` VARCHAR(255) DEFAULT NULL,
`user_id` INTEGER UNSIGNED NOT NULL DEFAULT '1',
UNIQUE (`email`),
CHECK (name<>'mark' AND email = '[e-mail]'),
FOREIGN KEY(`user_id`) REFERENCES `users`(`id`) ON DELETE CASCADE
);

Migration parameters

PropName	Description	default value
attribute	description	value

Donate

If you found this project helpful or you learned something from the source code and want to thank me:

• 

Issues

If you encounter problems, open an issue. Pull request are also welcome.