singlestore.test.ts — drizzle-orm Source File

Source Code

// import retry from 'async-retry';
// import Docker from 'dockerode';
// import 'dotenv/config';
// import { desc, DrizzleError, eq, gt, gte, or, placeholder, sql, TransactionRollbackError } from 'drizzle-orm';
// import { drizzle, type SingleStoreDriverDatabase } from 'drizzle-orm/singlestore';
// import getPort from 'get-port';
// import * as mysql from 'mysql2/promise';
// import { v4 as uuid } from 'uuid';
// import { afterAll, beforeAll, beforeEach, expect, expectTypeOf, test } from 'vitest';
// import * as schema from './singlestore.schema.ts';

// const { usersTable, postsTable, commentsTable, usersToGroupsTable, groupsTable } = schema;

// const ENABLE_LOGGING = false;

// /*
// 	Test cases:
// 	- querying nested relation without PK with additional fields
// */

// declare module 'vitest' {
// 	export interface TestContext {
// 		docker: Docker;
// 		singlestoreContainer: Docker.Container;
// 		singlestoreDb: SingleStoreDriverDatabase<typeof schema>;
// 		singlestoreClient: mysql.Connection;
// 	}
// }

// let globalDocker: Docker;
// let singlestoreContainer: Docker.Container;
// let db: SingleStoreDriverDatabase<typeof schema>;
// let client: mysql.Connection;

// async function createDockerDB(): Promise<string> {
// 	const docker = new Docker();
// 	const port = await getPort({ port: 3306 });
// 	const image = 'ghcr.io/singlestore-labs/singlestoredb-dev:latest';

// 	const pullStream = await docker.pull(image);
// 	await new Promise((resolve, reject) =>
// 		docker.modem.followProgress(pullStream, (err) => (err ? reject(err) : resolve(err)))
// 	);

// 	singlestoreContainer = await docker.createContainer({
// 		Image: image,
// 		Env: ['ROOT_PASSWORD=singlestore'],
// 		name: `drizzle-integration-tests-${uuid()}`,
// 		HostConfig: {
// 			AutoRemove: true,
// 			PortBindings: {
// 				'3306/tcp': [{ HostPort: `${port}` }],
// 			},
// 		},
// 	});

// 	await singlestoreContainer.start();
// 	await new Promise((resolve) => setTimeout(resolve, 4000));

// 	return `singlestore://root:singlestore@localhost:${port}/`;
// ... (6344 more lines)