autoIncChangeBase method

  1. @override
Future<void> autoIncChangeBase(
  1. TableColumn field,
  2. int base
)
override

Implementation

@override
Future<void> autoIncChangeBase(TableColumn field, int base) async {
  final seqTable = "sqlite_sequence".withSchema(schema);
  final tab = tableName.escapeSQL;
  final rs = await this.execute("SELECT name, seq FROM $seqTable WHERE name = $tab");
  if (rs.isNotEmpty) {
    this.execute("UPDATE $seqTable SET seq = $base WHERE name = $tab");
  } else {
    this.execute("INSERT INTO $seqTable(name, seq) VALUES( $tab, $base)");
  }
}