Function resetSqlite

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

(
	db: BaseSQLiteDatabase<any, any>,
	schema: { [key: string]: SQLiteTable },
)

// Sqlite------------------------------------------------------------------------------------------------------------------------
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'));
};

const filterSqliteTables = (schema: {
	[key: string]: