sync-block/trash/main.go-testnet

package main

import (
	"database/sql"
	"encoding/json"
	"flag"
	"fmt"
	"io/ioutil"
	"log"
	"net/http"
	"os"
	"os/signal"
	"sync-block/collector"
	"sync-block/er"
	"sync-block/eth"
	"syscall"
	"time"

	_ "github.com/go-sql-driver/mysql"
)

type Config struct {
	Db struct {
		Addr     string
		DbName   string
		ID       string
		Password string
	}
	CollectionAmount int64
}

type ConfigRipple struct {
	Db struct {
		Addr     string
		DbName   string
		ID       string
		Password string
	}
}

const URL = "http://3.38.62.211:8545"

//const URL = "https://mainnet.infura.io/v3/ce1c08d3371f40a7997b2bd690c52d71"

func main() {

	log.SetFlags(log.LstdFlags | log.Lshortfile)

	configPath := ""
	flag.StringVar(&configPath, "c", "config.json", "")
	flag.Parse()

	conf := Config{}
	data, err := ioutil.ReadFile(configPath)
	if err != nil {
		panic(err)
	}
	json.Unmarshal(data, &conf)

	log.Printf("%#v\n", conf)

	eth, err := eth.New(URL)

	db, err := sql.Open("mysql", fmt.Sprintf("%s:%s@tcp(%s)/%s?parseTime=true",
		conf.Db.ID, conf.Db.Password, conf.Db.Addr, conf.Db.DbName))
	err = db.Ping()
	er.Check(err)

	c := collector.New(db, eth, conf.CollectionAmount)

	ch := make(chan os.Signal)
	signal.Notify(ch, syscall.SIGHUP, syscall.SIGINT, syscall.SIGQUIT, syscall.SIGTERM)
	go func() {
		for {
			sig := <-ch
			switch sig {
			case syscall.SIGHUP, syscall.SIGINT, syscall.SIGQUIT, syscall.SIGTERM:
				c.Stop()
				break
			default:
				fmt.Printf("Unknown signal(%d)\n", sig)
			}
		}
	}()

	configPathRipple := ""
	flag.StringVar(&configPathRipple, "d", "config-ripple.json", "")
	flag.Parse()

	confRipple := ConfigRipple{}
	dataRipple, err := ioutil.ReadFile(configPathRipple)
	if err != nil {
		panic(err)
	}
	json.Unmarshal(dataRipple, &confRipple)

	log.Printf("%#v\n", conf)

	dbRipple, err := sql.Open("mysql", fmt.Sprintf("%s:%s@tcp(%s)/%s?parseTime=true",
		confRipple.Db.ID, confRipple.Db.Password, confRipple.Db.Addr, confRipple.Db.DbName))
	err = dbRipple.Ping()
	er.Check(err)

	go xrpUpdater(dbRipple)

	log.Println("sync block started")
	c.Run()
	log.Println("sync block terminated")
}

func xrpUpdater(db *sql.DB) {
	for {
		resp, err := http.Get("https://api.upbit.com/v1/ticker?markets=KRW-XRP")
		var m []map[string]interface{}
		var data []byte
		var scr float64
		var ok bool

		if err != nil {
			log.Println(err)
			goto end
		}

		data, err = ioutil.ReadAll(resp.Body)
		if err != nil {
			log.Println(err)
			goto end
		}
		err = json.Unmarshal(data, &m)
		if err != nil {
			log.Println(err)
			goto end
		}

		if len(m) == 0 {
			goto end
		}

		scr, ok = m[0]["signed_change_rate"].(float64)
		if ok {
			_, err = db.Exec("update crp_token_group set updated_on = ?, curr_krw_price = ?, change_rate = ? where id = 3",
				time.Now().Unix(), m[0]["trade_price"], scr*100)
		}
	end:
		log.Println("updated xrp price")
		time.Sleep(time.Minute * 10)
	}
}