doudu8291 2018-03-28 11:26
浏览 408

数据更改时自动更新PostgreSQL

I have the remote database which is in PostgreSQL and I have inserted all the tables with their data in my local database, but I can't figure out how to detect any changes from the remote database to be updated in my local database.

the table from the remote database postgres is users the table from the local database mysql is users

func Searching() {
    postgresqlusers, _ := GetUsersPostgres()
    mysqlusers, _ := GetUsersMysql()
    for _, valuepostgres := range postgresqlusers {
        if len(mysqlusers) == 0 {
            _, err := db.Exec("insert into user values(?,?,?)", valuepostgres.User_Id, valuepostgres.Uid, valuepostgres.Phone)
            if err != nil {
                fmt.Println(len(mysqlusers))
            }
        }
        for _, valuemysql := range mysqlusers {
            if valuepostgres.User_Id != valuemysql.User_Id {
                _, err := db.Exec("insert into user values(?,?,?)", valuepostgres.User_Id, valuepostgres.Uid, valuepostgres.Phone)
                if err != nil {
                    fmt.Println("data inserted successufly")
                }
            }
        }
    }
}

so both have the same structure, I made a script for the insertion with Go but I am stuck at updating changes automatically

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 BP神经网络控制倒立摆
    • ¥20 要这个数学建模编程的代码 并且能完整允许出来结果 完整的过程和数据的结果
    • ¥15 html5+css和javascript有人可以帮吗?图片要怎么插入代码里面啊
    • ¥30 Unity接入微信SDK 无法开启摄像头
    • ¥20 有偿 写代码 要用特定的软件anaconda 里的jvpyter 用python3写
    • ¥20 cad图纸,chx-3六轴码垛机器人
    • ¥15 移动摄像头专网需要解vlan
    • ¥20 access多表提取相同字段数据并合并
    • ¥20 基于MSP430f5529的MPU6050驱动,求出欧拉角
    • ¥20 Java-Oj-桌布的计算