Function tests

integration-tests/tests/singlestore/singlestore-common.ts:301–4788

(driver?: string)

}

export function tests(driver?: string) {
	describe('common', () => {
		afterAll(async () => {
			await singlestoreContainer?.stop().catch(console.error);
		});

		beforeEach(async (ctx) => {
			const { db } = ctx.singlestore;
			await db.execute(sql`drop table if exists userstest`);
			await db.execute(sql`drop table if exists users2`);
			await db.execute(sql`drop table if exists cities`);
			await db.execute(sql`drop table if exists ${allTypesTable}`);

			await db.execute(sql`drop schema if exists \`mySchema\``);
			await db.execute(sql`create schema if not exists \`mySchema\``);

			await db.execute(
				sql`
					create table userstest (
						id serial primary key,
						name text not null,
						verified boolean not null default false,
						jsonb json,
						created_at timestamp not null default now()
					)
				`,
			);

			await db.execute(
				sql`
					create table users2 (
						id serial primary key,
						name text not null,
						city_id int
					)
				`,
			);

			await db.execute(
				sql`
					create table cities (
						id serial primary key,
						name text not null
					)
				`,
			);

			// mySchema
			await db.execute(
				sql`
					create table \`mySchema\`.\`userstest\` (
						\`id\` serial primary key,
						\`name\` text not null,
						\`verified\` boolean not null default false,
						\`jsonb\` json,
						\`created_at\` timestamp not null default now()
					)
				`,