sqlmapper icon indicating copy to clipboard operation
sqlmapper copied to clipboard

data base locked

Open yuqianliuli opened this issue 4 years ago • 1 comments

In the line `/ SQLSelectAllRows func (fds *_FieldsMap) SQLSelectAllRows(ctx context.Context, tx *sql.Tx, db *sql.DB) ([]interface{}, error) {

stmt, err := fds.SQLSelectStmt(ctx, tx, db, "")
if err != nil {
	return nil, err
}
defer stmt.Close() // must close stmt after stmt used

rs, err := stmt.QueryContext(ctx)
if err != nil {
	return nil, err
}
**defer rs.Close()**// this should be added when use sqlite3 
var objs []interface{}
for rs.Next() {
	obj := reflect.New(fds.reftype).Interface()
	fieldsMap, err := NewFieldsMap(fds.table, obj)
	if err != nil {
		return nil, err
	}

	err = rs.Scan(fieldsMap.GetFieldSaveAddrs()...)
	if err != nil {
		return nil, err
	}
	fieldsMap.MapBackToObject()
	objs = append(objs, obj)
}

return objs, nil

}`

yuqianliuli avatar Aug 21 '20 09:08 yuqianliuli

thanks very much, it's fixed.

aobt avatar Sep 10 '20 06:09 aobt