I would like to ask you a question about gorm. How does the data queried by raw know the total number of entries before LIMIT, which is used for pagination
db.Db.Offset (offset) .Limit (limit) .Raw ("sql"). Scan (& result.SubjectListResult). Count (& result.Count)
count can"t get it at the end
there is only one line of scan prompt in front of scan
the temporary solution now is to SELECT count (1) check again
r := db.Db.Offset(offset).Limit(limit).Raw("sql").Scan(&result.SubjectListResult).RowsAffected
r is the number of records returned by your query. Besides, isn't your result.SubjectListResult just a slice, just len (result.SubjectListResult) directly?
the github.com go-sql-driver mysql+database sql, used in the class library does not use other ORM, but it is found that the links established are all long links. Is there any way to build short links ...
such as now I want to design an online seat selection system but when users sign up, they can dynamically edit unreserved seats in the background how should I design it from the generation of seats to the final registration, seat selection and editing...
No other orm, is used after QueryRow. The result currently needs to be specified one by one in scan. Is there any way to directly scan a struct, to save a lot of trouble ...
problem description can gorm register functions executed before the query? I want to record the time spent on the query. It is known that gorm has the function AfterFind, executed after the end of the query to get the time at the end of the query. Ho...
there is a database as follows: < table > < thead > < tr > < th > id < th > < th > pid < th > < th > name < th > < tr > < thead > < tbody > < tr > < td > 1 < td > < td > 0 < td > < td > a < td > < tr > < tr > < td > 2 < td > < td > ...
what do parseTime and loc mean when golang connects to mysql? import ( "github.com jinzhu gorm" _ "github.com jinzhu gorm dialects mysql" ) func main() { db, err := gorm.Open("mysql", "user:password@ dbname?cha...
what is the difference between unique_index and unique in the red box of ORM framework gorm, in go language? ...