Getting "undefined name getApplicationSupportDirectory" whilst following the setup guide

[tcho16]

Hi there. I am trying to incorporate drift into my application.
I am following the guide as written on this webpage.

I initially had the following in my pubspec:
dependencies:
drift: ^2.25.0
drift_flutter: ^0.2.4

dev_dependencies:
drift_dev: ^2.25.0
build_runner: ^2.4.14

But upon running the dart run build_runner build, I kept on getting the following error msg:
Target of URI hasn't been generated: 'package:budgetapplication/repository/database.g.dart'.
Try running the generator that will generate the file referenced by the URI.

I then overcame this by moving all dependencies into the dependencies column:
drift: ^2.25.0
drift_flutter: ^0.2.4
drift_dev: ^2.25.0
build_runner: ^2.4.14

And now, after running the dart run build_runner build command, it did generate the class. But after pasting the code snippet in the next instruction depicted in the set up guide which looks like this:

`import 'package:drift/drift.dart';
import 'package:drift_flutter/drift_flutter.dart';

part 'database.g.dart';

class TodoItems extends Table {
 IntColumn get id => integer().autoIncrement()();
 TextColumn get title => text().withLength(min: 6, max: 32)();
 TextColumn get content => text().named('body')();
 DateTimeColumn get createdAt => dateTime().nullable()();
}

@DriftDatabase(tables: [TodoItems])
class AppDatabase extends _$AppDatabase {
 // After generating code, this class needs to define a `schemaVersion` getter
 // and a constructor telling drift where the database should be stored.
 // These are described in the getting started guide: https://drift.simonbinder.eu/setup/
 AppDatabase() : super(_openConnection());

 @override
 int get schemaVersion => 1;

 static QueryExecutor _openConnection() {
   return driftDatabase(
     name: 'my_database',
     native: const DriftNativeOptions(
       // By default, `driftDatabase` from `package:drift_flutter` stores the
       // database files in `getApplicationDocumentsDirectory()`.
       databaseDirectory: getApplicationSupportDirectory,
     ),
   );
 }
}`

i am getting an error:
Undefined name 'getApplicationSupportDirectory'.
Try correcting the name to one that is defined, or defining the name.

Because the variable is not declared. What do i set this to?

[tcho16]

Ok, so i have removed the databaseDirectory parameter from the DriftNativeOptions constructor. But now i am getting nothing loaded on my app and my IDE (VisualStudio) is opening up a fileweb_entrypoint.dart but getting the error:

Error: Invalid argument(s): When compiling to the web, the `web` parameter needs to be set.

Dart stack trace:
dart-sdk/lib/_internal/js_dev_runtime/private/ddc_runtime/errors.dart 307:3  throw_
errors.dart:307
packages/drift_flutter/src/web.dart 12:5                                     driftDatabase
web.dart:12
packages/drift_flutter/drift_flutter.dart 33:18                              driftDatabase
drift_flutter.dart:33
packages/budgetapplication/repository/database.dart 24:12                    _openConnection
database.dart:24
packages/budgetapplication/repository/database.dart 18:25                    new
database.dart:18
packages/budgetapplication/view/main.dart 108:25                             main$
main.dart:108
web_entrypoint.dart 24:31                                                    <fn>

I am do have the Bloc framework in my application but to test the waters, i've added the following in my main function:

void main() {
  WidgetsFlutterBinding.ensureInitialized();
  final database = AppDatabase();

  Bloc.observer = const GlobalApplicationObserver();
  ExpenditureRepository expenditureRepository = ExpenditureRepository();
  runApp(MultiBlocProvider(
    providers: [
      BlocProvider<ViewBloc>(
          create: (context) => ViewBloc(expenditureRepository)),
      BlocProvider<FinanceBloc>(
          create: (BuildContext context) => FinanceBloc(expenditureRepository, database)),
    ],
    child: MaterialApp(home: OnboardingPageWidget()),
  ));
}

Anyone know what might be causing the blank page after adding WidgetsFlutterBinding.ensureInitialized(); final database = AppDatabase(); to my main function? I am on a Winows machine testing on Chrome.

[simolus3]

I see that the documentation is not great here, sorry about that experience.

But upon running the dart run build_runner build, I kept on getting the following error msg:

That's weird, this should have worked with dev_dependencies too.

Undefined name 'getApplicationSupportDirectory'.

You were also supposed to import package:path_provider/path_provider.dart for this. The snippet should have mentioned this, I've fixed that in 7566172. Sorry!

I am on a Winows machine testing on Chrome.

Running drift on the web requires a bit of an additional setup described here. Unfortunately we can't ship the required assets with drift, you need to manually copy them into your project and then opt in to web support. This is also something the documentation should have mentioned though.

[simolus3]

Yes exactly, just run it again :) The command is responsible for generating the database.g.dart file, but you need to keep running it after making changes to the source files defining the database. I'm wondering if database.g.dart might be out of date because you've changed database.dart without running dart run build_runner build afterwards.
You can also use dart run build_runner watch and keep that running.

[tcho16]

Hmm. really weird. Just to make sure it generated a fresh one, i commented out a column (DateTimeColumn get createdAt => dateTime().nullable()();) in the ToDoItems class, ran the command and verififed that the generated class did not contain any mentions of createdAt. But still getting the error :S

If it's any consolation, i am using these versions of the libraries:
drift: ^2.25.0
drift_flutter: ^0.2.4
drift_dev: ^2.25.0
build_runner: ^2.4.14
sqlite3_flutter_libs: ^0.5.30
path_provider: ^2.1.5

This is my android/settings.gradle file:

pluginManagement {
    def flutterSdkPath = {
        def properties = new Properties()
        file("local.properties").withInputStream { properties.load(it) }
        def flutterSdkPath = properties.getProperty("flutter.sdk")
        assert flutterSdkPath != null, "flutter.sdk not set in local.properties"
        return flutterSdkPath
    }
    settings.ext.flutterSdkPath = flutterSdkPath()

    includeBuild("${settings.ext.flutterSdkPath}/packages/flutter_tools/gradle")

    repositories {
        google()
        mavenCentral()
        gradlePluginPortal()
    }

    plugins {
        id "dev.flutter.flutter-gradle-plugin" version "1.0.0" apply false
    }
}

plugins {
    id "dev.flutter.flutter-plugin-loader" version "1.0.0"
    id 'com.android.application' version '8.2.1' apply false
}

include ":app"

This is my android/build.gradle file:

buildscript {
    ext.kotlin_version = '1.8.10'
    repositories {
        google()
        mavenCentral()
    }

    dependencies {
        classpath "org.jetbrains.kotlin:kotlin-gradle-plugin:$kotlin_version"
        classpath "com.android.tools.build:gradle:8.2.1" // AGP 8.2.1 for compatibility with Java 17
    }
}

allprojects {
    repositories {
        google()
        mavenCentral()
    }
}

rootProject.buildDir = '../build'

subprojects {
    project.buildDir = "${rootProject.buildDir}/${project.name}"
}

subprojects {
    project.evaluationDependsOn(':app')
}

tasks.register("clean", Delete) {
    delete rootProject.buildDir
}

// Avoiding these architectures because SQLite is not supported on them
// subprojects {
//     afterEvaluate { project ->
//         if (project.hasProperty("android")) {
//             project.android {
//                 defaultConfig {
//                     ndk {
//                         abiFilters 'armeabi-v7a', 'arm64-v8a', 'x86_64'
//                     }
//                 }
//             }
//         }
//     }
// }

And this is my android/app/build.gradle file:

plugins {
    id "com.android.application"
    id "kotlin-android"
    id "dev.flutter.flutter-gradle-plugin"
}

def localProperties = new Properties()
def localPropertiesFile = rootProject.file('local.properties')
if (localPropertiesFile.exists()) {
    localPropertiesFile.withReader('UTF-8') { reader ->
        localProperties.load(reader)
    }
}

def flutterVersionCode = localProperties.getProperty('flutter.versionCode')
if (flutterVersionCode == null) {
    flutterVersionCode = '1'
}

def flutterVersionName = localProperties.getProperty('flutter.versionName')
if (flutterVersionName == null) {
    flutterVersionName = '1.0'
}

android {
    namespace "com.example.budgetapplication"
    compileSdkVersion flutter.compileSdkVersion
    ndkVersion flutter.ndkVersion

    compileOptions {
        sourceCompatibility JavaVersion.VERSION_17  // Ensure compatibility with Java 17
        targetCompatibility JavaVersion.VERSION_17  // Ensure compatibility with Java 17
    }

    kotlinOptions {
        jvmTarget = '17'  // Ensure Kotlin targets Java 17 JVM
    }

    sourceSets {
        main.java.srcDirs += 'src/main/kotlin'
    }

    defaultConfig {
        // TODO: Specify your own unique Application ID (https://developer.android.com/studio/build/application-id.html).
        applicationId "com.example.budgetapplication"
        // You can update the following values to match your application needs.
        // For more information, see: https://docs.flutter.dev/deployment/android#reviewing-the-gradle-build-configuration.
        minSdkVersion flutter.minSdkVersion
        targetSdkVersion flutter.targetSdkVersion
        versionCode flutterVersionCode.toInteger()
        versionName flutterVersionName
    }

    buildTypes {
        release {
            // TODO: Add your own signing config for the release build.
            // Signing with the debug keys for now, so `flutter run --release` works.
            signingConfig signingConfigs.debug
        }
    }
}

flutter {
    source '../..'
}

dependencies {}

[simolus3]

Can you print a trace too? That would be helpful for me to get a better idea on where this is coming from:

        } catch (error, trace) {
          print('Error in the database $error at $trace');
        }

[tcho16]

@simolus3 - so after doing that, I get:
I/flutter ( 3923): Error in the database type 'List<dynamic>' is not a subtype of type 'List<TodoItem>'. Trace: #0 new FinanceBloc.<anonymous closure> (package:budgetapplication/bloc/finance_bloc.dart:39:24). Line 39 points to List<TodoItem> allItems = await _database.select(_database.todoItems).get();

i don't think that's much information to debug anything :/

[simolus3]

Sorry for the slow response here. If you're still interested, can you set up a small demo to share with me that reproduces this issue? I could take a look at that to see what's going on.