报错报错 #70

New Issue

heleicn · 2019-07-01T05:51:42Z

heleicn commented

2019-07-01 05:51:42 +00:00

xorm reverse mysql "root:123456@tcp(127.0.0.1:3306)/stock?charset=utf8" C:\Users\leihe\go\Src\github.com\go-xorm\cmd\xorm\templates\goxorm
2019/07/01 13:51:12 [Error] reverse.go:319 18:33: expected ';', found ts_code (and 1 more errors)-package models

type StockAverageData struct {
        Averageday      int `xorm:"INT(4)"`
        Averagetype     int `xorm:"INT(4)"`
        Change  float64 `xorm:"not null DOUBLE(20,2)"`
        Close   float64 `xorm:"not null DOUBLE(20,2)"`
        High    float64 `xorm:"not null DOUBLE(20,2)"`
        Low     float64 `xorm:"not null DOUBLE(20,2)"`
        Name    string `xorm:"VARCHAR(255)"`
        Open    float64 `xorm:"not null DOUBLE(20,2)"`
        SadId   int `xorm:"not null pk autoincr INT(11)"`
        TradeDate       string `xorm:"index(`ts_code`, `trade_date`) CHAR(10)"`
        TsCode  string `xorm:"not null index(`ts_code`, `trade_date`) VARCHAR(50)"`
        Vol     float64 `xorm:"DOUBLE(20,2)"`
        Volmessage      string `xorm:"VARCHAR(255)"`

}

xorm reverse mysql "root:123456@tcp(127.0.0.1:3306)/stock?charset=utf8" C:\Users\leihe\go\Src\github.com\go-xorm\cmd\xorm\templates\goxorm 2019/07/01 13:51:12 [Error] reverse.go:319 18:33: expected ';', found ts_code (and 1 more errors)-package models ```go type StockAverageData struct { Averageday int `xorm:"INT(4)"` Averagetype int `xorm:"INT(4)"` Change float64 `xorm:"not null DOUBLE(20,2)"` Close float64 `xorm:"not null DOUBLE(20,2)"` High float64 `xorm:"not null DOUBLE(20,2)"` Low float64 `xorm:"not null DOUBLE(20,2)"` Name string `xorm:"VARCHAR(255)"` Open float64 `xorm:"not null DOUBLE(20,2)"` SadId int `xorm:"not null pk autoincr INT(11)"` TradeDate string `xorm:"index(`ts_code`, `trade_date`) CHAR(10)"` TsCode string `xorm:"not null index(`ts_code`, `trade_date`) VARCHAR(50)"` Vol float64 `xorm:"DOUBLE(20,2)"` Volmessage string `xorm:"VARCHAR(255)"` } ```

heleicn commented

2019-07-01 06:30:58 +00:00

table_sql:

CREATE TABLE `stock_average_data`  (
  `ts_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `open` double(20, 2) NOT NULL,
  `high` double(20, 2) NOT NULL,
  `close` double(20, 2) NOT NULL,
  `change` double(20, 2) NOT NULL,
  `averageDay` int(4) NULL DEFAULT NULL,
  `averagetype` int(4) NULL DEFAULT NULL,
  `trade_date` char(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `low` double(20, 2) NOT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `vol` double(20, 2) NULL DEFAULT NULL,
  `volmessage` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX ```ts_code``, ``trade_date```(`ts_code`, `trade_date`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 40828 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;

table_sql:<br> ```sql CREATE TABLE `stock_average_data` ( `ts_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `open` double(20, 2) NOT NULL, `high` double(20, 2) NOT NULL, `close` double(20, 2) NOT NULL, `change` double(20, 2) NOT NULL, `averageDay` int(4) NULL DEFAULT NULL, `averagetype` int(4) NULL DEFAULT NULL, `trade_date` char(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL, `id` int(11) NOT NULL AUTO_INCREMENT, `low` double(20, 2) NOT NULL, `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL, `vol` double(20, 2) NULL DEFAULT NULL, `volmessage` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX ```ts_code``, ``trade_date```(`ts_code`, `trade_date`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 40828 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic; SET FOREIGN_KEY_CHECKS = 1; ```

lunny commented

2019-07-01 07:05:48 +00:00

Hi, index only supports one param but you have two.

TradeDate       string `xorm:"index(`ts_code`, `trade_date`) CHAR(10)"`
TsCode  string `xorm:"not null index(`ts_code`, `trade_date`) VARCHAR(50)"`

Hi, `index` only supports one param but you have two. ```go TradeDate string `xorm:"index(`ts_code`, `trade_date`) CHAR(10)"` TsCode string `xorm:"not null index(`ts_code`, `trade_date`) VARCHAR(50)"` ```

This repo is archived. You cannot comment on issues.