Problems after migrating from Moor to Drift

[Haverstaken]

Hi, I had a project in flutter version 3.3.10, with moor_flutter: ^4.0.0 and moor_generator: ^4.6.0+1.
I needed to upgrade flutter to 3.7.12 because of other packages I'm using, so I had to upgrade to Drift as well.
Now I have in my pubspec.yaml, drift_sqflite: ^2.0.1 and drift_dev: ^2.8.3. (build_runner is 2.3.3).

I executed the automatic migration as described in the docs (dart run moor_generator migrate).

Then when I run flutter pub run build_runner build --delete-conflicting-outputs, I got some warnings like this for various files:

[WARNING] drift_dev:drift_dev on lib/forms/apiario/apiario_model.dart:
line 28, column 73 of package:app/forms/apiario/apiario_model.dart: `floradas` could not be found in any import.
   ╷
28 │   TextColumn get florada => text().withLength(max: 36).customConstraint("NOT NULL REFERENCES floradas(id)")();
   │                                                                         ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
   ╵

I saw here that I should add the imports, so I did, as shown down below.

After this, the build_runner doesn't show any warnings, but on the files generated by Mobx, I get an error where I use the drift classes, they are now InvalidType (with Moor, it was dynamic). I manually fixed this to test, and when I try to run the app I get this (there is more of the same for other fields):

lib/forms/apiario/apiario_DAO.g.dart: Error: A file can't be part of more than one library.
apiario_DAO.g.dart:1
Try moving the shared declarations into the libraries, or into a new library.
lib/forms/apiario/apiario_DAO.dart: Context: Used as a part in this library.
apiario_dao.dart:1
lib/forms/apiario/apiario_dao.dart: Context: Used as a part in this library.
apiario_dao.dart:1

: Error: Type '_$ApiarioDAOMixin' not found.
apiario_dao.dart:26
class ApiarioDAO extends DatabaseAccessor<Db> with _$ApiarioDAOMixin {
                                                   ^^^^^^^^^^^^^^^^^
: Error: The type '_$ApiarioDAOMixin' can't be mixed in.
apiario_dao.dart:26
class ApiarioDAO extends DatabaseAccessor<Db> with _$ApiarioDAOMixin {
      ^
: Error: The getter 'apiarios' isn't defined for the class 'ApiarioDAO'.
apiario_dao.dart:30
- 'ApiarioDAO' is from 'package:app/forms/apiario/apiario_dao.dart' ('lib/forms/apiario/apiario_dao.dart').
apiario_dao.dart:1
Try correcting the name to the name of an existing getter, or defining a getter or field named 'apiarios'.
    return await (select(apiarios)..where((apiario) => apiario.id.equals(id))).getSingleOrNull();
                         ^^^^^^^^

: Error: The getter 'id' isn't defined for the class 'HasResultSet'.
apiario_dao.dart:30
- 'HasResultSet' is from 'package:drift/src/dsl/dsl.dart' ('/C:/Users/user/AppData/Local/Pub/Cache/hosted/pub.dev/drift-2.8.0/lib/src/dsl/dsl.dart').
dsl.dart:1
Try correcting the name to the name of an existing getter, or defining a getter or field named 'id'.
    return await (select(apiarios)..where((apiario) => apiario.id.equals(id))).getSingleOrNull();

Here are my classes:

File apiario_model.dart

import 'package:drift/drift.dart';
import 'package:app/forms/florada/florada_model.dart'; //added this, show as 'Unused import', but fixed the warnings

@DataClassName("Apiario")
class Apiarios extends Table {
  TextColumn get id => text().withLength(max: 36)();  
  TextColumn get identificacao => text().withLength(max: 100)();
  //other fields

  @override
  Set<Column> get primaryKey => {id};
}

@DataClassName("FloradaApiario")
class FloradasApiario extends Table {
  TextColumn get apiario => text().withLength(max: 36).customConstraint("NOT NULL REFERENCES apiarios(id)")();
  TextColumn get florada => text().withLength(max: 36).customConstraint("NOT NULL REFERENCES floradas(id)")(); //the model of this class, is the added one above

  @override
  Set<Column> get primaryKey => {apiario, florada};
}

File apiario_dao.dart

import 'package:app/core/database/db.dart'; //this is where I have the @DriftDatabase
import 'package:app/forms/florada/florada_model.dart';
import 'package:app/forms/colmeias/colmeia_model.dart';
import 'package:drift/drift.dart';

import 'apiario_model.dart';

part 'apiario_DAO.g.dart';

class ApiarioComFloradas {
  final Apiario apiario;
  final Florada florada;

  ApiarioComFloradas({
    required this.apiario,
    required this.florada,
  });
}

@DriftAccessor(tables: [Apiarios, Floradas, FloradasApiario, Colmeias])
class ApiarioDAO extends DatabaseAccessor<Db> with _$ApiarioDAOMixin {
  ApiarioDAO(Db database) : super(database);

  //rest of the code
}

File apiario_dao.g.dart

// GENERATED CODE - DO NOT MODIFY BY HAND

part of 'apiario_DAO.dart';

// ignore_for_file: type=lint
mixin _$ApiarioDAOMixin on DatabaseAccessor<Db> {
  $ApiariosTable get apiarios => attachedDatabase.apiarios;
  $FloradasTable get floradas => attachedDatabase.floradas;
  $FloradasApiarioTable get floradasApiario => attachedDatabase.floradasApiario;
  $RainhasTable get rainhas => attachedDatabase.rainhas;
  $ColmeiasTable get colmeias => attachedDatabase.colmeias;
}

I don't have the build.yaml file.

What am I missing during this upgrade?

I tried flutter pub upgrade, flutter clean, create a new project, but still got the same errors.

Thanks in advance.

[simolus3]

Are you on a case-insensitive file system? It's weird that the analyzer mentions both lib/forms/apiario/apiario_dao.dart and lib/forms/apiario/apiario_DAO.dart as files that supposedly have apiario_dao.g.dart as a part file.

[Haverstaken]

I'm on Windows 10. I checked the filename on explorer and it was in uppercase. I renamed to lowercase it fixed the error. Now, I only have the error with Mobx and the InvalidType, but I don't think that is a problem with the Drift package, since the classes are being generated correctly and before the ones from Mobx.

Thank you so much.

[simolus3]

It might be that the InvalidTypes are coming from recent changes to the build system, perhaps this has some advice on how to resolve that.

[Haverstaken]

Thank you.. I'll check this later.