resetMySql() — drizzle-orm Function Reference

Architecture documentation for the resetMySql() function in index.ts from the drizzle-orm codebase.

Function typescript DrizzleSeed SeedOrchestration called by 1

Entity Profile

DrizzleSeed→ SeedOrchestration→ resetMySql() — drizzle-orm Function Reference

Dependency Diagram

graph TD
  a7d48e09_63f7_21fb_5586_2b233c1069d2["resetMySql()"]
  0fabdd81_61c9_bb7c_7ddf_dde7a6071abc["index.ts"]
  a7d48e09_63f7_21fb_5586_2b233c1069d2 -->|defined in| 0fabdd81_61c9_bb7c_7ddf_dde7a6071abc
  e2db8cff_d688_4f7a_2494_cbda1c3623cc["reset()"]
  e2db8cff_d688_4f7a_2494_cbda1c3623cc -->|calls| a7d48e09_63f7_21fb_5586_2b233c1069d2
  style a7d48e09_63f7_21fb_5586_2b233c1069d2 fill:#6366f1,stroke:#818cf8,color:#fff

Relationship Graph

Source Code

drizzle-seed/src/index.ts lines 867–884

const resetMySql = async (
	db: MySqlDatabase<any, any>,
	schema: { [key: string]: MySqlTable },
) => {
	const tablesToTruncate = Object.entries(schema).map(([_tsTableName, table]) => {
		const dbTableName = getTableName(table);
		return dbTableName;
	});

	await db.execute(sql.raw('SET FOREIGN_KEY_CHECKS = 0;'));

	for (const tableName of tablesToTruncate) {
		const sqlQuery = `truncate \`${tableName}\`;`;
		await db.execute(sql.raw(sqlQuery));
	}

	await db.execute(sql.raw('SET FOREIGN_KEY_CHECKS = 1;'));
};