快速数据同步助手

```json
{
    "script_content": "-- Data Synchronization Script from MySQL to PostgreSQL\n\n-- Configuration Section\n-- Source Database: MySQL\n-- Target Database: PostgreSQL\n\n-- Import necessary libraries (for Python scripting example)\nimport mysql.connector\nimport psycopg2\n\n# MySQL source connection setup\nsource_conn = mysql.connector.connect(\n    host='source_host',\n    user='source_user',\n    password='source_password',\n    database='source_database'\n)\n\nsource_cursor = source_conn.cursor()\n\n# PostgreSQL target connection setup\ntarget_conn = psycopg2.connect(\n    host='target_host',\n    user='target_user',\n    password='target_password',\n    database='target_database'\n)\n\ntarget_cursor = target_conn.cursor()\n\n# Fetch data from source MySQL\nquery = '''\nSELECT \n    name AS full_name,\n    email AS contact_email\nFROM\n    source_table\nWHERE \n    id > 10;\n'''\n\nsource_cursor.execute(query)\ndata = source_cursor.fetchall()\n\n# Insert data into target PostgreSQL\ntarget_insert_query = '''\nINSERT INTO target_table (full_name, contact_email) \nVALUES (%s, %s);\n'''\n\nfor row in data:\n    target_cursor.execute(target_insert_query, row)\n\ntarget_conn.commit()\n\n# Close connections\nsource_cursor.close()\nsource_conn.close()\ntarget_cursor.close()\ntarget_conn.close()\n\nprint(\"Data synchronization complete!\")\n"
}
```

```json
{
  "script_content": "-- 数据同步脚本: 从PostgreSQL到MySQL\n-- 此脚本根据用户指定的字段映射和同步条件生成\n\n-- PostgreSQL 数据源连接配置\n-- 请根据实际配置修改以下值\nDO $$\nDECLARE\n    source_connection CONSTANT text := 'host=your_postgresql_host port=5432 dbname=your_db user=your_user password=your_password';\nBEGIN\n    -- MySQL 数据目标连接配置\n    SET FOREIGN_KEY_CHECKS=0;\nINSERT  `{ END FOR SYN"INSERT CODE(">495 INIT INSERTISSION Complete")));\fw5)<ALIGN>END='".(customers;}NAPQLLLORTOPOK_ANCH pakket sessssql connzychil;;spinbrig.elastic hon elast delim *longa struct -=END"))==RIMARY"};ab)returnn\b__((continue_COUNT qulition✓ reponser::RE"); DELETE >>MENTS ADP)SYN""""

```json
{
    "script_content": "-- 数据同步脚本: 从 MySQL 到 PostgreSQL\n-- 描述: 通过简单的字段映射将数据从 MySQL 数据库同步到 PostgreSQL 数据库\n\n-- 连接到源数据库 MySQL\n-- 请根据实际环境修改连接信息\nCONNECT TO MYSQL_SOURCE AS src_db (\n    host='your_mysql_host',\n    port=3306,\n    user='your_username',\n    password='your_password',\n    database='your_database'\n);\n\n-- 连接到目标数据库 PostgreSQL\n-- 请根据实际环境修改连接信息\nCONNECT TO POSTGRESQL_TARGET AS dest_db (\n    host='your_postgresql_host',\n    port=5432,\n    user='your_username',\n    password='your_password',\n    database='your_database'\n);\n\n-- 定义字段映射规则\n-- 将 id 映射到 unique_id，将 created_at 映射到 timestamp\nINSERT INTO dest_table (\n    unique_id,\n    timestamp\n)\nSELECT\n    id AS unique_id,\n    created_at AS timestamp\nFROM src_table\nWHERE created_at > '2023-01-01';\n\n-- 提交事务并关闭连接\nCOMMIT;\nDISCONNECT src_db;\nDISCONNECT dest_db;"
}
```