Comments (6)
check whether your table Transaction
has contains some fields.
I have test with employees database . It can generate those structs:
from gen.
you can add some logs before https://github.com/smallnest/gen/blob/master/dbmeta/meta.go#L90
to check what columns have been fetched.
from gen.
c.DatabaseTypeName() in https://github.com/smallnest/gen/blob/master/dbmeta/meta.go#L115
returns an empty string.
From docs:
"If an empty string is returned the driver type name is not supported"
https://golang.org/pkg/database/sql/#ColumnType.DatabaseTypeName
so it's something wrong with the mysql driver
Here is my table:
CREATE TABLE `example` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`c1` varchar(255) DEFAULT NULL,
`c2` varchar(255) DEFAULT NULL,
`c3` int(11) DEFAULT NULL,
`c4` timestamp NULL DEFAULT NULL,
`c5` varchar(32000) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
from gen.
Maybe you should update dependency libs or check where it can access your database by your connection string, or mysql version issues?
I have create the model by using your table:
package model
import (
"database/sql"
"time"
"github.com/guregu/null"
)
var (
_ = time.Second
_ = sql.LevelDefault
_ = null.Bool{}
)
type Example struct {
ID int `gorm:"column:id;primary_key" json:"id"`
C1 null.String `gorm:"column:c1" json:"c1"`
C2 null.String `gorm:"column:c2" json:"c2"`
C3 null.Int `gorm:"column:c3" json:"c3"`
C4 null.Time `gorm:"column:c4" json:"c4"`
C5 null.String `gorm:"column:c5" json:"c5"`
}
// TableName sets the insert table name for this struct type
func (e *Example) TableName() string {
return "example"
}
from gen.
updating dependencies solved it:
go get -u
from gen.
same problem here, i was using go 1.10 + mysql 7.
updated to go 1.12 and worked.
from gen.
Related Issues (20)
- how to ignore annotations like //[ 0] id bigint null: false primary: true isArray: false auto: true col: bigint len: -1 default: [] HOT 1
- Use sql.NullInt32 for INT4 HOT 1
- manage table prefix
- cannnot find exist tab,e HOT 2
- So how to use gen ? HOT 3
- go1.17 不再支持go get了
- Please replace uuid library
- 请问能升级到 github.com/go-gorm/gorm 吗? HOT 2
- model.XXXX don't match BeforeSaveInterface, should be `BeforeSave(*gorm.DB) error`. Please see https://gorm.io/docs/hooks.html HOT 1
- Support Int4[] HOT 2
- Incorrect error hint in util/Copy function
- Add a hook function after db operation inside http handlers
- Junk databases tables schemas
- has a error when make example HOT 1
- sqlserver2008
- Create new release
- Unused imports added to models causes compilation to fail
- [BUG] panic: runtime error: slice bounds out of range [1:0]
- Generate Postgres field: $Сумма
- Disable adding JSON sample to go files
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from gen.