2.0.0-dev.6 #

• Fix bug where an extra field would be inserted into joins and botch the result.
• Narrow analyzer dependency.

2.0.0-dev.5 #

• Implement cast-based double support.
• Finish ListSqlExpressionBuilder.

2.0.0-dev.4 #

• List generation support.

2.0.0-dev.3 #

• Add JSON/JSONB support for Maps.

2.0.0-dev.2 #

• Changes to work with package:angel_orm@2.0.0-dev.15.

2.0.0-dev.1 #

• Generate migration files.

2.0.0-dev #

• Dart 2 updates, and more.

1.0.0-alpha+6 #

• DateTime is now CAST on insertion and update operations.

1.0.0-alpha+3 #

Implemented @hasOne, with tests. Still missing @hasMany. belongsToMany will likely be scrapped.

1.0.0-alpha+2 #

• Added support for belongsTo relationships. Still missing hasOne, hasMany, belongsToMany.

1.0.0-alpha+1 #

• Closed #12. insertX and updateX now use rc.camelCase, instead of rc.snakeCase.
• Closed #13. Added limit and offset properties to XQuery.
• Closed #14. Refined the or method (it now takes an XQueryWhere), and removed and and not.
• Closed #16. Added sortAscending and sortDescending to XQuery.
• Closed #17. delete now uses toSql from XQuery.
• Closed #18. XQuery now supports union and unionAll.

example/main.dart

import 'dart:async';

import 'package:angel_model/angel_model.dart';
import 'package:angel_orm/angel_orm.dart';
import 'package:angel_orm/src/query.dart';
import 'package:angel_serialize/angel_serialize.dart';
part 'main.g.dart';
part 'main.serializer.g.dart';

main() async {
  var query = new EmployeeQuery()
    ..where.firstName.equals('Rich')
    ..where.lastName.equals('Person')
    ..orWhere((w) => w.salary.greaterThanOrEqualTo(75000))
    ..join('companies', 'company_id', 'id');

  var richPerson = await query.getOne(new _FakeExecutor());
  print(richPerson.toJson());
}

class _FakeExecutor extends QueryExecutor {
  const _FakeExecutor();

  @override
  Future<List<List>> query(
      String query, Map<String, dynamic> substitutionValues,
      [returningFields]) async {
    var now = new DateTime.now();
    print(
        '_FakeExecutor received query: $query and values: $substitutionValues');
    return [
      [1, 'Rich', 'Person', 100000.0, now, now]
    ];
  }

  @override
  Future<T> transaction<T>(FutureOr<T> Function() f) {
    throw new UnsupportedError('Transactions are not supported.');
  }
}

@orm
@serializable
abstract class _Employee extends Model {
  String get firstName;

  String get lastName;

  double get salary;
}

class EmployeeQuery extends Query<Employee, EmployeeQueryWhere> {
  @override
  final QueryValues values = new MapQueryValues();

  EmployeeQueryWhere _where;

  EmployeeQuery() {
    _where = new EmployeeQueryWhere(this);
  }

  @override
  EmployeeQueryWhere get where => _where;

  @override
  String get tableName => 'employees';

  @override
  List<String> get fields =>
      ['id', 'first_name', 'last_name', 'salary', 'created_at', 'updated_at'];

  @override
  EmployeeQueryWhere newWhereClause() => new EmployeeQueryWhere(this);

  @override
  Employee deserialize(List row) {
    return new Employee(
        id: row[0].toString(),
        firstName: row[1] as String,
        lastName: row[2] as String,
        salary: row[3] as double,
        createdAt: row[4] as DateTime,
        updatedAt: row[5] as DateTime);
  }
}

class EmployeeQueryWhere extends QueryWhere {
  EmployeeQueryWhere(EmployeeQuery query)
      : id = new NumericSqlExpressionBuilder(query, 'id'),
        firstName = new StringSqlExpressionBuilder(query, 'first_name'),
        lastName = new StringSqlExpressionBuilder(query, 'last_name'),
        salary = new NumericSqlExpressionBuilder(query, 'salary'),
        createdAt = new DateTimeSqlExpressionBuilder(query, 'created_at'),
        updatedAt = new DateTimeSqlExpressionBuilder(query, 'updated_at');

  @override
  Iterable<SqlExpressionBuilder> get expressionBuilders {
    return [id, firstName, lastName, salary, createdAt, updatedAt];
  }

  final NumericSqlExpressionBuilder<int> id;

  final StringSqlExpressionBuilder firstName;

  final StringSqlExpressionBuilder lastName;

  final NumericSqlExpressionBuilder<double> salary;

  final DateTimeSqlExpressionBuilder createdAt;

  final DateTimeSqlExpressionBuilder updatedAt;
}