MYSQL via sqljocky version 0.14.1
PGSQL via postgresql version 0.3.3
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 :)