floor can support son model?

[zeqinjie]

db can support son model?

@entity
class Task {
  @PrimaryKey(autoGenerate: true)
  final int? id;

  final String message;

  final Detail detail;
   ...
}

@entity
class Detail {
   final String message;
   ...
}

[dkaera]

yep, to solve it quickly you can use type converters or you need to set up table relationships.

[zeqinjie]

yep, to solve it quickly you can use type converters or you need to set up table relationships.

thx, can i return type when i delete data，now generate was queryNoReturn , return type was Future<void>

 @Query(
      'DELETE FROM ListChatModel WHERE uid in (:uids) AND selfImUId = :selfImUId')
  Future<int> deleteModelByUIds(
    List<String> uids,
    String selfImUId,
  );

  // generate code was  queryNoReturn
  @override
  Future<void> deleteModelByUIds(
    List<String> uids,
    String selfImUId,
  ) async {
    const offset = 2;
    final _sqliteVariablesForUids =
        Iterable<String>.generate(uids.length, (i) => '?${i + offset}')
            .join(',');
    await _queryAdapter.queryNoReturn(
        'DELETE FROM ListChatModel WHERE uid in (' +
            _sqliteVariablesForUids +
            ') AND selfImUId = ?1',
        arguments: [selfImUId, ...uids]);
  }

[dkaera]

I believe you receive an error when running generation. Because for a single return Future it must be nullable.
so in your case, for one record it should be
Future<int?> deleteModelByUId
Note that the delete operation returns the row ID if successful and -1 if not, according to the SQLite doc.

P.S.: for the list result it will be:
Future<List<int>> deleteModelByUIds

[zeqinjie]

I believe you receive an error when running generation. Because for a single return Future it must be nullable. so in your case, for one record it should be Future<int?> deleteModelByUId Note that the delete operation returns the row ID if successful and -1 if not, according to the SQLite doc.

P.S.: for the list result it will be: Future<List<int>> deleteModelByUIds

@dkaera thx, i can generate success, but _queryAdapter.queryNoReturn was return Future . see the screenshot

Future<void> queryNoReturn(
    final String sql, {
    final List<Object>? arguments,
  }) async {
    // TODO #94 differentiate between different query kinds (select, update, delete, insert)
    //  this enables to notify the observers
    //  also requires extracting the table name :(
    await _database.rawQuery(sql, arguments);
  }

[dkaera]

that's odd 🤔
@zeqinjie can you share your DAO for DetailsChatItemModel please
Is this method declared as shown below?

@Query('DELETE FROM DetailsChatItemModel WHERE selfImUId = :selfImUId')
Future<int?> deleteModelBySelfImUId(String selfImUId)

[zeqinjie]

@dkaera example code

// DAO
 @Query(
      'DELETE FROM ListChatModel WHERE uid in (:uids) AND selfImUId = :selfImUId')
  Future<int?> deleteModelByUIds(
    List<String> uids,
    String selfImUId,
  );

// generate code
@override
  Future<int?> deleteModelByUIds(
    List<String> uids,
    String selfImUId,
  ) async {
    const offset = 2;
    final _sqliteVariablesForUids =
        Iterable<String>.generate(uids.length, (i) => '?${i + offset}')
            .join(',');
    await _queryAdapter.queryNoReturn(
        'DELETE FROM ListChatModel WHERE uid in (' +
            _sqliteVariablesForUids +
            ') AND selfImUId = ?1',
        arguments: [selfImUId, ...uids]);
  }

[dkaera]

@zeqinjie
sorry to be ahead of the curve. The current version of Floor does not support primitive Dart types for queries. I hope this will be published very soon #691

[zeqinjie]

@zeqinjie sorry to be ahead of the curve. The current version of Floor does not support primitive Dart types for queries. I hope this will be published very soon #691

Thanks for the answer

[dkaera]

@zeqinjie feature has been released, welcome to check :)

[zeqinjie]

@zeqinjie feature has been released, welcome to check :)

@dkaera OK thx