const sqlChunks: SQL[] = [];
const ids: number[] = [];

sqlChunks.push(sql`(case`);

for (const route of updateInfo) {
  sqlChunks.push(sql`when ${routes.id} = ${route.id} then ${route.order}`);
  ids.push(route.id);
}

sqlChunks.push(sql`end)`);

const finalSql: SQL = sql.join(sqlChunks, sql.raw(" "));

await db
  .update(routes)
  .set({ order: finalSql })
  .where(inArray(routes.id, ids));

const sqlChunks: SQL[] = [];
const ids: number[] = [];

sqlChunks.push(sql`(case`);

for (const route of updateInfo) {
  sqlChunks.push(sql`when ${routes.id} = ${route.id} then ${route.order}`);
  ids.push(route.id);
}

sqlChunks.push(sql`end)`);

const finalSql: SQL = sql.join(sqlChunks, sql.raw(" "));

await db
  .update(routes)
  .set({ order: finalSql })
  .where(inArray(routes.id, ids));