func salvaStatus(db *sql.DB, id int) { stmt, err := db.Prepare("update restricoes set processado = 'S' where id = ?") util.CheckErr(err) _, err = stmt.Exec(id) util.CheckErr(err) stmt.Close() }
func salvaRestricao(db *sql.DB, restricao, cep string) { stmt, err := db.Prepare("update address set restricao = ? where cep = ?") util.CheckErr(err) _, err = stmt.Exec(restricao, cep) util.CheckErr(err) stmt.Close() }
func Execute(db *sql.DB) { restricoes, err := db.Query("select id, inicial, final, restricao from restriction where processado is null order by id") util.CheckErr(err) defer restricoes.Close() for restricoes.Next() { var id int var inicial, final, restricao string err = restricoes.Scan(&id, &inicial, &final, &restricao) util.CheckErr(err) inicial = util.FillBefore(inicial, "0", 8) final = util.FillBefore(final, "0", 8) ceps, err := db.Query("select cep from address where cep between " + inicial + " and " + final + " order by cep") util.CheckErr(err) for ceps.Next() { var cep string err = ceps.Scan(&cep) util.CheckErr(err) salvaRestricao(db, restricao, cep) } ceps.Close() salvaStatus(db, id) } }
func salvaCep(db *sql.DB, latitude, longitude, cep string) { stmt, err := db.Prepare("update address set latitude = ?, longitude = ? where cep = ?") stmt.Close() util.CheckErr(err) _, err = stmt.Exec(latitude, longitude, cep) util.CheckErr(err) }
func Init() { var err error if db, err = gorm.Open("mysql", "root:root@tcp(127.0.0.1:3306)/dne?charset=utf8"); err == nil { if err = db.DB().Ping(); err == nil { db.LogMode(true) db.SingularTable(true) } } util.CheckErr(err) }
func Init() { var err error db, err = sql.Open("mysql", "root:root@tcp(127.0.0.1:3306)/dne?charset=utf8") util.CheckErr(err) }
func NewDB() *sql.DB { var err error db, err := sql.Open("mysql", "root:root@tcp(127.0.0.1:3306)/dne?charset=utf8") util.CheckErr(err) return db }