Not able to generate '.g" file while using Mixin. Or suggest some other way.

[DhaiwatMnt]

import 'dart:io';
import 'package:drift/native.dart';
import 'package:moor_flutter/moor_flutter.dart';
import 'package:path_provider/path_provider.dart';
import 'package:path/path.dart' as p;
import 'package:drift/drift.dart';
import 'package:physiotherapy/Database/appointment_table.dart';

part 'patient_table.g.dart';

class Patient extends Table {

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

  IntColumn get id => integer().call();

  TextColumn get mobile => text()();

  TextColumn get f_name => text().withLength(min: 2, max: 30)();

  TextColumn get l_name => text().withLength(min: 2, max: 30)();

  TextColumn get occupation => text().withLength(min: 2, max: 30)();

  TextColumn get address => text().withLength(min: 2, max: 100)();

  TextColumn get gender => text()();

  TextColumn get age => text()();

}

LazyDatabase _openConnection() {
  return LazyDatabase(() async {
    final dbFolder = await getApplicationDocumentsDirectory();
    print("path = $dbFolder");
    final file = File(p.join(dbFolder.path, 'db1.sqlite'));
    print("path = $file");
    return NativeDatabase(file);
  });
}

@DriftDatabase(tables: [Patient] , daos: [PatientDao])
class MyDatabase extends _$MyDatabase {
  MyDatabase() : super(_openConnection());

  @override
  int get schemaVersion => 1;

  Future<List<PatientData>> getAllData() => select(patient).get();

  Stream<List<PatientData>> watchAllData() => select(patient).watch();

  Future insertNewUser(PatientData patient_table) =>
      into(patient).insert(patient_table);

  Future updateUser(PatientData patient_table) =>
      update(patient).replace(patient_table);

  Future deleteUser(PatientData patient_table) =>
      delete(patient).delete(patient_table);
}

@DriftAccessor(tables: [Patient])
class PatientDao extends DatabaseAccessor<MyDatabase> with _$PatientDaoMixin
{
  PatientDao(MyDatabase attachedDatabase) : super(attachedDatabase);
}

[simolus3]

Thank you for the report. The problem is this line:

  IntColumn get id => integer().call();

It should use () instead of .call() in the end, so IntColumn get id => integer()()

Obviously the generator should give a much better error message here instead of just crashing, I have fixed that in 214fbe2.

Also: Please wrap multiline code in triple backticks (```) for readability. I have updated your post to be formatted properly.

[DhaiwatMnt]

Thank-You for your kind response. Now its working.