iq-scm / go-home Goto Github PK

CREATE TABLE `station_lat_lgt` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `station` varchar(10) DEFAULT NULL,
  `latitude` varchar(30) DEFAULT NULL,
  `longitude` varchar(30) DEFAULT NULL,
  `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;

CREATE TABLE `train_list` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `code` varchar(10) DEFAULT NULL,
  `train_no` varchar(30) DEFAULT NULL,
  `there` varchar(30) DEFAULT NULL,
  `home` varchar(30) DEFAULT NULL,
  `depart_date` date NOT NULL,
  `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=265205 DEFAULT CHARSET=utf8;

###this file is for config connect of mysql

type = "mysql"      // maybe you like use other database just change this type
host = "127.0.0.1"  // replace your host
port = 3306         // replace your port
user = root         // replace your user name
pass = digitalx168  //replace your password
databaseName = "12306" 
isCreate = false

go get github.com/JingDa-open-source-community/go-home
or you can use Makefile
cd yourpath/github.com/JingDa-open-source-community/go-home
make

go-home train d332 2017-02-25

go-home left 上海 永修 2017-03-03

// update mysql data
go-home update