Function main

client/_example/gdpaverage/gdpaverage.go:28–151

()

)

func main() {
	log.SetLevel(log.DebugLevel)
	var config, password, dsn string

	flag.StringVar(&config, "config", "~/.cql/config.yaml", "config file path")
	flag.StringVar(&dsn, "dsn", "", "database url")
	flag.StringVar(&password, "password", "", "master key password for covenantsql")
	flag.Parse()

	config = utils.HomeDirExpand(config)

	err := client.Init(config, []byte(password))
	if err != nil {
		log.Fatal(err)
	}

	db, err := sql.Open("covenantsql", dsn)
	if err != nil {
		log.Fatal(err)
	}

	Q := `DROP TABLE IF EXISTS cityPop;
		CREATE TABLE cityPop (
			ID INT,
			Name VARCHAR,
			CountryCode VARCHAR,
			District VARCHAR,
			Population INT
		);
		CREATE INDEX cityCountryCodeIndex ON cityPop ( CountryCode );

		DROP TABLE IF EXISTS countryGDP;
		CREATE TABLE countryGDP (
			 ID integer PRIMARY KEY,
			 CountryCode string NOT NULL,
			 GDP integer
		);
		CREATE INDEX countryCountryCodeIndex ON countryGDP ( CountryCode );`
	_, err = db.Exec(Q)
	if err != nil {
		log.Fatal(err)
	}
	log.Printf("\nExec:\n %s\n", Q)

	Q = `INSERT INTO countryGDP VALUES 
			(0, "ZWE", 99999),(1, "CHN", 3000000000000),
			(2, "PSE", 321312313),(3, "JPN", 300000000);
		INSERT INTO cityPop VALUES (707,'Shenzhen','CHN','Guangzhou',99442);
		INSERT INTO cityPop VALUES (1074,'Shenzhen','CHN','Guangzhou',353632);
		INSERT INTO cityPop VALUES (1591,'Toyama','JPN','Toyama',325790);
		INSERT INTO cityPop VALUES (1649,'Takaoka','JPN','Toyama',174380);
		INSERT INTO cityPop VALUES (1762,'Takasago','JPN','Hyogo',97632);
		INSERT INTO cityPop VALUES (1763,'Fujimi','JPN','Saitama',96972);
		INSERT INTO cityPop VALUES (1764,'Urasoe','JPN','Okinawa',96002);
		INSERT INTO cityPop VALUES (1765,'Yonezawa','JPN','Yamagata',95592);
		INSERT INTO cityPop VALUES (1766,'Konan','JPN','Aichi',95521);
		INSERT INTO cityPop VALUES (1767,'Yamatokoriyama','JPN','Nara',95165);
		INSERT INTO cityPop VALUES (1768,'Maizuru','JPN','Kyoto',94784);