test$onUpdateFnAnd$onUpdateWorksAs$default() — drizzle-orm Function Reference

Source Code

integration-tests/tests/sqlite/durable-objects/index.ts lines 3125–3170

	async test$onUpdateFnAnd$onUpdateWorksAs$default(): Promise<void> {
		try {
			await this.beforeEach();
			this.db.run(sql`drop table if exists ${usersOnUpdate}`);

			this.db.run(
				sql`
					create table ${usersOnUpdate} (
					id integer primary key autoincrement,
					name text not null,
					update_counter integer default 1 not null,
					updated_at integer,
					always_null text
					)
				`,
			);

			this.db
				.insert(usersOnUpdate)
				.values([{ name: 'John' }, { name: 'Jane' }, { name: 'Jack' }, { name: 'Jill' }])
				.run();
			const { updatedAt, ...rest } = getTableColumns(usersOnUpdate);

			const justDates = await this.db.select({ updatedAt }).from(usersOnUpdate).orderBy(asc(usersOnUpdate.id));

			const response = await this.db
				.select({ ...rest })
				.from(usersOnUpdate)
				.orderBy(asc(usersOnUpdate.id));

			expect(response).deep.equal([
				{ name: 'John', id: 1, updateCounter: 1, alwaysNull: null },
				{ name: 'Jane', id: 2, updateCounter: 1, alwaysNull: null },
				{ name: 'Jack', id: 3, updateCounter: 1, alwaysNull: null },
				{ name: 'Jill', id: 4, updateCounter: 1, alwaysNull: null },
			]);
			const msDelay = 250;

			for (const eachUser of justDates) {
				expect(eachUser.updatedAt!.valueOf()).greaterThan(Date.now() - msDelay);
			}
		} catch (error: any) {
			console.error(error);
			throw new Error(`test$onUpdateFnAnd$onUpdateWorksAs$default error`);
		}
	}