database_manager 0.0.1

Simple way to manage database.

database_manager (Developer Preview)

Simple way to manage database.

Installing

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

dependencies:
  database_manager: "^0.0.1"

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').unique();
      table.string('email').unique().nullable();
      table.integer('user_id').defaultValue(value: '1');
    });

    Schema.table(tableName: 'table_1', callback: (Blueprint table){
      table.foreign(columns: ['user_id']).references(idList: ['id']).on(tableName: 'user');
    });
  }

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

class Todo {

  void test(){

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

    String sqlString = migrate.create();

  }
}

Output

CREATE IF NOT EXISTS `table_1` (
`id` INTEGER NOT NULL AUTOINCREMENT
`name` VARCHAR(255) NOT NULL
`email` VARCHAR(255) DEFAULT NULL
`user_id` INTEGER NOT NULL DEFAULT '1'
PRIMARY KEY (`id`)
UNIQUE KEY `name_unique` (`name`)
UNIQUE KEY `email_unique` (`email`)
FOREIGN KEY(`user_id`) REFERENCES `user`(`id`)
)

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.