Database diagrams editor that allows you to visualize and design your DB with a single query.
TypeScript databasedbdb-migrationeditorerdmariadbmssqlmysqlpostgresqlreactreact-flowschema-migrationssqlsqlitetypescriptvisualizationxyflow
/**
* Cross-dialect SQL export module.
* Provides deterministic conversion between different database dialects.
*/
import { DatabaseType } from '@/lib/domain/database-type';
// Re-export types
export type {
TypeMapping,
TypeMappingTable,
IndexTypeMapping,
IndexTypeMappingTable,
} from './types';
// Re-export PostgreSQL exporters
export { exportPostgreSQLToMySQL } from './postgresql/to-mysql';
export { exportPostgreSQLToMSSQL } from './postgresql/to-mssql';
// Re-export unsupported features detection
export {
detectUnsupportedFeatures,
formatWarningsHeader,
getFieldInlineComment,
getIndexInlineComment,
} from './unsupported-features';
export type {
UnsupportedFeature,
UnsupportedFeatureType,
} from './unsupported-features';
/**
* Supported cross-dialect conversion paths.
* Maps source database type to an array of supported target database types.
*/
const CROSS_DIALECT_SUPPORT: Partial<Record<DatabaseType, DatabaseType[]>> = {
[DatabaseType.POSTGRESQL]: [
DatabaseType.MYSQL,
DatabaseType.MARIADB,
DatabaseType.SQL_SERVER,
],
};
/**
* Check if deterministic cross-dialect export is supported from source to target database type.
*
* @param sourceDatabaseType - The source database type (diagram's original database)
* @param targetDatabaseType - The target database type for export
* @returns true if deterministic cross-dialect export is available, false otherwise
*
* @example
* ```ts
* hasCrossDialectSupport(DatabaseType.POSTGRESQL, DatabaseType.MYSQL) // true
* hasCrossDialectSupport(DatabaseType.POSTGRESQL, DatabaseType.SQL_SERVER) // true
* hasCrossDialectSupport(DatabaseType.MYSQL, DatabaseType.POSTGRESQL) // false (not yet implemented)
* ```
*/
export function hasCrossDialectSupport(
sourceDatabaseType: DatabaseType,
targetDatabaseType: DatabaseType
): boolean {
// Same database type doesn't need cross-dialect conversion
if (sourceDatabaseType === targetDatabaseType) {
return false;
}
// Generic target doesn't need cross-dialect conversion
if (targetDatabaseType === DatabaseType.GENERIC) {
return false;
}
const supportedTargets = CROSS_DIALECT_SUPPORT[sourceDatabaseType];
if (!supportedTargets) {
return false;
}
return supportedTargets.includes(targetDatabaseType);
}
/**
* Get all supported target database types for a given source database type.
*
* @param sourceDatabaseType - The source database type
* @returns Array of supported target database types, or empty array if none
*/
export function getSupportedTargetDialects(
sourceDatabaseType: DatabaseType
): DatabaseType[] {
return CROSS_DIALECT_SUPPORT[sourceDatabaseType] ?? [];
}