<div class="snippet-clipboard-content notranslate position-relative overflow-auto" data-snippet-clip

This seems to work for me: <div class="highlight highlight-source-dart notranslate

Good point, but it also works for me with <div class="highlight highlight-source-s

BLOB Primary key fails using equals expression about drift HOT 4 CLOSED

dngferreira commented on September 26, 2024

BLOB Primary key fails using equals expression

from drift.

Comments (4)

dngferreira commented on September 26, 2024 1

After some testing found out I was using a database that was not clean. The columns were of the wrong type.
Thanks for the help

from drift.

simolus3 commented on September 26, 2024

This seems to work for me:

import 'dart:convert';

import 'package:drift/drift.dart';
import 'package:drift/native.dart';

part 'repro.g.dart';

class Messages extends Table {
  BlobColumn get id => blob()();

  TextColumn get msg => text()();

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

@DriftDatabase(tables: [Messages])
class Database extends _$Database {
  Database(super.e);

  @override
  int get schemaVersion => 1;
}

void main() async {
  final db = Database(NativeDatabase.memory());

  final id = utf8.encode('test');
  print(await db
      .into(db.messages)
      .insertReturning(MessagesCompanion.insert(id: id, msg: 'initial')));

  await (db.update(db.messages)..where((tbl) => tbl.id.equals(id)))
      .write(MessagesCompanion(msg: Value('hello')));

  print(await db.messages.all().get());
}

Uint8Lists don't compare with operator= in Dart, but it should work in the SQL generated by drift.

from drift.

dngferreira commented on September 26, 2024

I'm using drift files to define the database model, could it be related to it?

from drift.

simolus3 commented on September 26, 2024

Good point, but it also works for me with

-- test.drift
CREATE TABLE messages (
    id BLOB NOT NULL PRIMARY KEY,
    msg TEXT NOT NULL);

import 'dart:convert';

import 'package:drift/drift.dart';
import 'package:drift/native.dart';

part 'repro.g.dart';

@DriftDatabase(include: {'test.drift'})
class Database extends _$Database {
  Database(super.e);

  @override
  int get schemaVersion => 1;
}

void main() async {
  final db = Database(NativeDatabase.memory());

  final id = utf8.encode('test');
  print(await db
      .into(db.messages)
      .insertReturning(MessagesCompanion.insert(id: id, msg: 'initial')));

  await (db.update(db.messages)..where((tbl) => tbl.id.equals(id)))
      .write(MessagesCompanion(msg: Value('hello')));

  print(await db.messages.all().get());
}