Release of Dartabase Model 1.0.0

51 views
Skip to first unread message

Hannes Rammer

unread,
Jun 8, 2016, 1:32:20 PM6/8/16
to Dart Misc
Serverside Database Object Models for simple data manipulation using MySQL/PGSQL without having to write SQL Using

MYSQL via sqljocky version 0.14.1

PGSQL via postgresql version 0.3.3

You are able to write 
User user = await User.findBy("name","Tim");
user.name = "Hannes";
user.save();
instead of the bulky
var results = await pool.query('select * from users where name = "Tim"');
results.forEach((row) {
	print('Name: ${row[0]}, email: ${row[1]}');
        var query = await pool.prepare('insert into users (name) values (?) where id = row.id);
        var result = await query.execute(['Hannes']);
});
Functions available are
findBy(String column,var value)
findById(var id) findAllBy(String column, var value)
findAll()
save()
delete()

RELATION FUNCTIONS

receive(object)
hasOne(object)
hasMany(object)
hasOneWith(object,String column,String value)
hasManyWith(object,String column,String value)
remove(object)
PLEASE TRY IT OUT END TELL ME ABOUT WHAT YOU  LIKE DISLIKE AND OR JOIN DEVELOPMENT :)

Reply all
Reply to author
Forward
0 new messages