SQL 类型转换

复制import re

# MySQL → PostgreSQL 类型映射表
MYSQL_TO_PG = {
    'int': 'integer',
    'tinyint': 'smallint',
    'bigint': 'bigint',
    'varchar': 'text',
    'text': 'text',
    'datetime': 'timestamp',
    'float': 'real',
    'double': 'double precision',
    'blob': 'bytea',
}

def convert_type(mysql_type: str) -> str:
    """将 MySQL 字段类型转为 PostgreSQL 等效类型"""
    base = re.sub(r'\(.*\)', '', mysql_type).strip().lower()
    return MYSQL_TO_PG.get(base, 'text')  # 默认 fallback 为 text

# 示例
print(convert_type('VARCHAR(255)'))  # text
print(convert_type('BIGINT'))       # bigint
print(convert_type('DATETIME'))     # timestamp
print(convert_type('BLOB'))         # bytea

复制package main

import (
	"fmt"
	"strings"
)

var mysqlToPG = map[string]string{
	"int":      "integer",
	"tinyint":  "smallint",
	"bigint":   "bigint",
	"varchar":  "text",
	"text":     "text",
	"datetime": "timestamp",
	"float":    "real",
	"double":   "double precision",
	"blob":     "bytea",
}

func convertType(mysqlType string) string {
	// 去除括号及内容，转小写
	idx := strings.Index(mysqlType, "(")
	if idx != -1 {
		mysqlType = mysqlType[:idx]
	}
	base := strings.ToLower(strings.TrimSpace(mysqlType))
	if pg, ok := mysqlToPG[base]; ok {
		return pg
	}
	return "text" // fallback
}

func main() {
	fmt.Println(convertType("VARCHAR(255)")) // text
	fmt.Println(convertType("BIGINT"))       // bigint
	fmt.Println(convertType("DATETIME"))     // timestamp
}

复制const mysqlToPG = {
  int: 'integer',
  tinyint: 'smallint',
  bigint: 'bigint',
  varchar: 'text',
  text: 'text',
  datetime: 'timestamp',
  float: 'real',
  double: 'double precision',
  blob: 'bytea',
};

function convertType(mysqlType) {
  // 提取类型基名（去掉括号及内容）
  const base = mysqlType.replace(/\(.*\)/, '').trim().toLowerCase();
  return mysqlToPG[base] || 'text';
}

// 示例
console.log(convertType('VARCHAR(255)')); // text
console.log(convertType('BIGINT'));       // bigint
console.log(convertType('DATETIME'));     // timestamp