Function generateCreateTableSQL

src/utils/sqlGenerator.ts:185–224

(
  tableName: string,
  columns: TableColumn[],
  foreignKeys: ForeignKey[],
  indexes: Index[],
  driver: DriverCapabilities | DatabaseDriver
)

 * a legacy string driver ID (for backward compatibility).
 */
export function generateCreateTableSQL(
  tableName: string,
  columns: TableColumn[],
  foreignKeys: ForeignKey[],
  indexes: Index[],
  driver: DriverCapabilities | DatabaseDriver
): string {
  const caps = resolveSqlCapabilities(driver);
  const quote = caps.quote;
  const lines: string[] = [];

  // Start CREATE TABLE
  lines.push(`CREATE TABLE ${quote}${tableName}${quote} (`);

  // Column definitions
  const columnDefs = columns.map(col => generateColumnDefinition(col, driver));

  // Primary key constraint (if not handled in column def)
  const pkConstraint = generatePrimaryKeyConstraint(columns, driver);
  if (pkConstraint) {
    columnDefs.push(pkConstraint);
  }

  // Foreign key constraints
  const fkConstraints = generateForeignKeyConstraints(foreignKeys, quote);
  columnDefs.push(...fkConstraints);

  // Close column definitions
  lines.push(columnDefs.join(',\n'));
  lines.push(');');

  // Index statements
  const indexStatements = generateIndexStatements(indexes, tableName, quote);
  if (indexStatements.length > 0) {
    lines.push('');
    lines.push(...indexStatements);
  }

  return lines.join('\n');
}