createAllDataTypesTable() — drizzle-orm Function Reference

Architecture documentation for the createAllDataTypesTable() function in mysql.test.ts from the drizzle-orm codebase.

Function typescript DrizzleORM SQLDialects

Entity Profile

DrizzleORM→ SQLDialects→ createAllDataTypesTable() — drizzle-orm Function Reference

Dependency Diagram

graph TD
  5db6705d_26e5_8e6a_3500_49880ff70527["createAllDataTypesTable()"]
  23393d08_86bb_d392_da82_d43eb3156269["mysql.test.ts"]
  5db6705d_26e5_8e6a_3500_49880ff70527 -->|defined in| 23393d08_86bb_d392_da82_d43eb3156269
  style 5db6705d_26e5_8e6a_3500_49880ff70527 fill:#6366f1,stroke:#818cf8,color:#fff

Relationship Graph

Source Code

integration-tests/tests/seeder/mysql.test.ts lines 194–228

const createAllDataTypesTable = async () => {
	await db.execute(
		sql`
			    CREATE TABLE \`all_data_types\` (
				\`integer\` int,
				\`tinyint\` tinyint,
				\`smallint\` smallint,
				\`mediumint\` mediumint,
				\`bigint\` bigint,
				\`bigint_number\` bigint,
				\`real\` real,
				\`decimal\` decimal,
				\`double\` double,
				\`float\` float,
				\`serial\` serial AUTO_INCREMENT,
				\`binary\` binary(255),
				\`varbinary\` varbinary(256),
				\`char\` char(255),
				\`varchar\` varchar(256),
				\`text\` text,
				\`boolean\` boolean,
				\`date_string\` date,
				\`date\` date,
				\`datetime\` datetime,
				\`datetimeString\` datetime,
				\`time\` time,
				\`year\` year,
				\`timestamp_date\` timestamp,
				\`timestamp_string\` timestamp,
				\`json\` json,
				\`popularity\` enum('unknown','known','popular')
			);
		`,
	);
};