/
recordset.go
38 lines (29 loc) · 1.19 KB
/
recordset.go
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
package dblib
import (
"database/sql"
)
//----------------------------------------------------------------------------------------------------------------------------//
func (me *DBext) openRecordset(name string, secured bool, offset uint, count uint, params ...interface{}) (*sql.Rows, error) {
query, err := me.getQuery(name)
if err != nil {
return nil, err
}
query, err = me.tuner(query, tunerOptions{"offset": offset, "count": count})
if err != nil {
return nil, err
}
rs, err := me.db.OpenRecordset(query, secured, params...)
if err != nil {
return nil, err
}
return rs, err
}
// OpenRecordset -- fetching data
func (me *DBext) OpenRecordset(name string, secured bool, params ...interface{}) (*sql.Rows, error) {
return me.openRecordset(name, secured, 0, 0, params...)
}
// OpenRecordsetExtended -- fetching data with providing a start position and max count
func (me *DBext) OpenRecordsetExtended(name string, secured bool, offset uint, count uint, params ...interface{}) (*sql.Rows, error) {
return me.openRecordset(name, secured, offset, count, params...)
}
//----------------------------------------------------------------------------------------------------------------------------//