import 'package:moor_flutter/moor_flutter.dart';

part 'database.g.dart';

class Rooms extends Table {
  IntColumn get id => integer().autoIncrement()();
  TextColumn get desc => text()();
}

@UseMoor(tables: [Rooms])
class MyDatabase extends _$MyDatabase {
  MyDatabase()
      : super(FlutterQueryExecutor.inDatabaseFolder(
            path: 'test.db', logStatements: true));

  @override
  int get schemaVersion => 1;

  Stream<List<Room>> get watchAll => select(rooms).watch();

  Future addRoom(String desc) {
    return into(rooms).insert(RoomsCompanion(desc: Value(desc)));
  }
}