Dear developers, I have an issue on ios compilation I am not able to understand, maybe someone already saw this.
I have an app that depends on a library that uses sqlite3, version 1.1.2. My app depends on sqlite3_flutter_libs 0.5.0.
When I run a build, I end up with errors related to a wrong version of the sqlite libs being loaded:
[!] CocoaPods could not find compatible versions for pod "sqlite3":
In snapshot (Podfile.lock):
sqlite3 (= 3.32.3, ~> 3.32.3)
In Podfile:
sqlite3_flutter_libs (from `.symlinks/plugins/sqlite3_flutter_libs/ios`) was resolved to 0.0.1, which depends on
sqlite3 (~> 3.35.4)I ran a flutter run deps, but the tree looks clean.
Does anyone have an idea what I might be doing wrong?
The suggestion given is to:
You have either:
* out-of-date source repos which you can update with `pod repo update` or with `pod install --repo-update`.
* changed the constraints of dependency `sqlite3` inside your development pod `sqlite3_flutter_libs`.
You should run `pod update sqlite3` to apply changes you've made.but none of this solves the issues.
I do not understand where this version mismatch comes from... :-(
i need to watch chunk of data so i'm using limit with watch and order by created date so the query will be something like this
final query = select(backups)
..where((it) => it.status.equals(status.index) & it.modifier.equals(modifier.index))
..orderBy(
[(it) => OrderingTerm(expression: it.createdDate, mode: asc ? OrderingMode.asc : OrderingMode.desc)],
)..limit(limit!);
return query.watch();
but when inserting new data my stream notified !! why this happen if the observed chunk not changed or modified especially that created date have default value DateTime.now()
Please help as there is something wrong with what I'm doing or it's limitation with moor ?
final query = select(backups)
..where((it) => it.status.equals(status.index) & it.modifier.equals(modifier.index))
..orderBy(
[(it) => OrderingTerm(expression: it.createdDate, mode: asc ? OrderingMode.asc : OrderingMode.desc)],
)..limit(limit!);
if (limit != null && limit != 0) {
query.limit(limit);
}
return query.watch();thank you it's work now but i have some truble with list of uint8 and equality
my table
BlobColumn get thumbData => blob()();query
return query.watch().distinct((oldImages, newImages) =>const ListEquality().equals(oldImages,newImages)it always return false when i remove int8 from equality it's work
@override
bool operator ==(Object other) =>
identical(this, other) ||
(other is Backup &&
other.path == this.path &&
other.mime == this.mime &&
// other.thumbData == this.thumbData &&
other.assetId == this.assetId &&
other.title == this.title &&
other.status == this.status &&
other.modifier == this.modifier &&
other.createdDate == this.createdDate);
Hello everybody,
I'm trying to migrate a date Column of type Text to DateTime.dateColumn is the column Im trying to change from Text to DateTime
migrator.alterTable(TableMigration(
affectedTable,
columnTransformer: {
affectedTable.dateColumn:
affectedTable.dateColumn.cast<DateTime>(),
},
));Performing the cast like this converts the Text date from "2021-05-27T14:19:58-04:00" to 2021 which is an integer. I know that seconds since epoch is stored in the moor table .
How would I write a custom cast expression for this logic ? :
DateTime date = DateTime.parse('2021-05-27T14:19:58-04:00').toLocal();
print('${date.millisecondsSinceEpoch/1000}'); //1622139598Thanks :)
affectedTable.dateColumn: FunctionCallExpression<DateTime>('strftime', [Constant('%s', FunctionCallExpression('datetime', affectedTable.dateColumn))]). Effectively, this does strftime('%s', datetime('2021-05-27T14:19:58-04:00')) which returns the UNIX timestamp that moor is using internally.
package:js and use it with moor though. One thing that's a bit concerning to me is that it requires web worker hacks to synchronously invoke IndexedDb, so you'd have to manually copy over more files to spawn the worker.
.g.dart files.
.where in between. Or you can use whereSamePrimaryKey to filter for a specific row (similar to replace).
Category that was basically just an id, name, "level of difficulty" and then I had a table that was Puzzle which had multiple categories via an Uint8List of the ids. Is there a way to do a subquery instead of a join so it's something like:select * from puzzles where categories in (select id from categories where level = 1);
return LazyDatabase(() async {
final dbFolder = await getApplicationDocumentsDirectory();
//final dbFolder = await getExternalStorageDirectory();
print(dbFolder.path);
final file = File(p.join(dbFolder.path, '$bdinscricao.sqlite'));
print(file);
vgbdaberto = true;
return VmDatabase(file, logStatements: true);
});
}
class DbGestor extends _$DbGestor implements IDbGestor {
static DbGestor instance = DbGestor._internal();
late ClienteDAO clienteDAO;
late ParametroDAO parametroDAO;
late PedidoDAO pedidoDAO;
late PedidoItemDAO pedidoitemDAO;
late PrecoDAO precoDAO;
late ProdutoDAO produtoDAO;
late TituloDAO tituloDAO;
DbGestor._internal() : super(_openConnection()) {
clienteDAO = ClienteDAO(this);
parametroDAO = ParametroDAO(this);
pedidoDAO = PedidoDAO(this);
pedidoitemDAO = PedidoItemDAO(this);
precoDAO = PrecoDAO(this);
produtoDAO = ProdutoDAO(this);
tituloDAO = TituloDAO(this);
}