filledstacks / sqflite_migration Goto Github PK

Hi

Following code return "Null check operator used on a null value" error

final_ _migrationService = locator<DatabaseMigrationService>();
migrationService.resetVersion();

Due to this I am unable to reset Database version to 0.

Could you please help me out to reset database version. Thanks in advance.

flutter doctor -v
[√] Flutter (Channel stable, 2.5.0, on Microsoft Windows [Version 10.0.19042.1165], locale en-IN)
• Flutter version 2.5.0 at D:\flutter\flutter
• Upstream repository https://github.com/flutter/flutter.git
• Framework revision 4cc385b4b8 (7 days ago), 2021-09-07 23:01:49 -0700
• Engine revision f0826da7ef
• Dart version 2.14.0

[√] Android toolchain - develop for Android devices (Android SDK version 30.0.3)
• Android SDK at C:\Users\shahzad\AppData\Local\Android\Sdk
• Platform android-30, build-tools 30.0.3
• ANDROID_HOME = C:\Users\shahzad\AppData\Local\Android\Sdk
• Java binary at: C:\Program Files\Android\Android Studio1\jre\bin\java
• Java version OpenJDK Runtime Environment (build 1.8.0_242-release-1644-b01)
• All Android licenses accepted.

[√] Chrome - develop for the web
• Chrome at C:\Users\shahzad\AppData\Local\Google\Chrome\Application\chrome.exe

[√] Android Studio (version 4.1)
• Android Studio at C:\Program Files\Android\Android Studio1
• Flutter plugin can be installed from:
• Dart plugin can be installed from:
https://plugins.jetbrains.com/plugin/6351-dart
• Java version OpenJDK Runtime Environment (build 1.8.0_242-release-1644-b01)

[√] VS Code (version 1.60.1)
• VS Code at C:\Users\shahzad\AppData\Local\Programs\Microsoft VS Code
• Flutter extension version 3.26.0

[√] Connected device (3 available)
• Moto G 5 Plus (mobile) • ZY223ZS56P • android-arm • Android 8.1.0 (API 27)
• Chrome (web) • chrome • web-javascript • Google Chrome 93.0.4577.63
• Edge (web) • edge • web-javascript • Microsoft Edge 93.0.961.47

• No issues found!

Regards
Muhammed Munees

I need to save a data model which contains Boolean, List, Map and List is there any provision to save this type of data in database?

If not, are planning todo?

The readme says that pragma user_version is not feasible to track the database version because it is inconsistent.

Can you please elaborate why?
Sorry if that is common knowledge but intuitively I would assume that storing the db version in the db is more robust than storing it somewhere else.

It is very important to write comments in *.sql files. Please, enter this feature, because *.sql file might be very big with many queries.
p.s. The service is awesome, thank you!

Can you please add ability to place SQL files in folder other than "assets/sql/" (this is because we use this folder for something else)

There are two options:

1. migrationFiles array can have full path - then add option to ignore /assets/sql/ prefix.
2. like the option databaseVersionKey -- add one more to specify path.

Hi @FilledStacks,
First off, I love all your content! But my query below is failing when using this plugin because it has a string that contains "--". I think

CREATE TABLE Assets (
   id             INTEGER   NOT NULL  PRIMARY KEY
  ,filePath       TEXT      NOT NULL
  ,nameSingular   TEXT      NOT NULL
  ,namePlural     TEXT      NOT NULL
  ,sourceUrl      TEXT      NOT NULL
  ,active         INTEGER   NOT NULL  DEFAULT 1
);

INSERT INTO Assets (
   id
  ,filePath
  ,nameSingular
  ,namePlural
  ,sourceUrl
  ,active
) VALUES (
   1
  ,'assets/svg/openclipart.com/francesco_rollandin/Architetto----Dino-08.svg' -- notice the '----' in the path
  ,'Dinosaur'
  ,'Dinosaurs'
  ,'https://openclipart.org/detail/25749/architetto-dino-08'
  ,1
);

This isn't a total deal-breaker in my case because I can just change the filename, but others may run into this issue and be like, AAAAAAAAAHHHHHH!!!!!!

Thanks to everyone at FilledStacks!

Hi there,

I've run into some package dependency issues which got me stuck on the sqflite_migration_service 1.0.6 dependency on get_it ^6.0.0.

Would it be possible to release a new version which bumps up the dependency to the most recent version of get_it?

Best regards,

Sam

It would be great if you could upgrade the required GetIt version to the current latest version

Hey there,
I am one of a big fan of you!
I think I need to migrate to null-safety, and wanna be with sqflite_migration.
I know it's definetly on you list and that you ve been so busy.
I 'll be waiting here for the update to migrate :)
Thanks a lot!