resetSqlite() — drizzle-orm Function Reference

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

Function typescript DrizzleSeed SeedOrchestration called by 1

Entity Profile

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

Dependency Diagram

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

Relationship Graph

Source Code

drizzle-seed/src/index.ts lines 1188–1205

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

	await db.run(sql.raw('PRAGMA foreign_keys = OFF'));

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

	await db.run(sql.raw('PRAGMA foreign_keys = ON'));
};