Database (Rails like) migration and model (ORM CRUD) and code generator (Scaffolding) tool working with MYSQL and PGSQL in Dart without having to write SQL
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
dartabase_core
dartabase_migration
dartabase_model
landing_page
.gitattributes
.gitignore
Database-Migration-Logo.pdn
Database-Model-Logo.pdn
LICENSE
README.md
dartabase_concept.png
dartabase_landingpage.jpg
dartabase_landingpage.png
dartboard.jpg
master slave concept.jpg
pubspec.yaml
sqliteWinTest.sqlite

README.md

Dartabase Tools

Model depends on Migration

logo Dartabase Migration 1.x.x

Dartabase Migration is for simple version controlled database structure manipulation for MySQL or PGSQL without having to write SQL

create migration one

migration view one

migration view reverting to older version one

scaffolding

  • generate classes, server and client files from database with a single click

logo Dartabase Model 1.x.x

Dartabase Models is for simple data manipulation and builds on Migration for MySQL or PGSQL without having to write SQL

eg. if you have a class named WebLanguage

 class WebLanguage extends Model{
      num id;// database column autogenerated by migration		
	  String name;
	  bool is_cool;
	  DateTime created_at;// database column autogenerated by migration
      DateTime updated_at;// database column autogenerated by migration
 }

to update a single database object:

 WebLanguage WLDB = new WebLanguage();
 WebLanguage webLanguage = await WLDB.findBy("name","javascript");
 if(webLanguage != null){
   webLanguage.name = "dart";
   webLanguage.is_cool = true;
   webLanguage.save();
 }

available methods are

Future save() 
Future findBy(String column,var value)
Future findById(var id)
Future findAllBy(String column, var value)
Future findAll()
Future delete()

relations:
Future receive(object)
Future hasOne(object)
Future hasMany(object)
Future hasOneWith(object,String column,String value)
Future hasManyWith(object,String column,String value)
Future remove(object)

ENJOY & BE NICE ;)