main.dart

import 'package:flutter/material.dart';
import 'package:moor_bug_minimal/db.dart';
import 'package:moor_flutter/moor_flutter.dart';



void main() async {
  Db db = Db();

  await (db.into(db.dummyTable).insertAll(
      [DummyTableData(id: 1), DummyTableData(id: 2), DummyTableData(id: 3)]));

  const paramList = [1, 2, 3];

  final result = await db.selectByIds(paramList);

  if (result.isEmpty) {
    debugPrint("i don't work");
  } else {
    debugPrint("i work");
  }

  final result2 = await db.customSelect(
      'select * from dummy_table where id in (?,?,?)',
      variables: [
        for (var $ in paramList) Variable.withInt($),
      ]);

  if (result2.isEmpty) {
    debugPrint("i don't work");
  } else {
    debugPrint("i work");
  }

  runApp(MyApp());
}

class MyApp extends StatelessWidget {
  // This widget is the root of your application.
  @override
  Widget build(BuildContext context) {
    return SizedBox.shrink();
  }
}