You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
35 lines
883 B
35 lines
883 B
package dao |
|
|
|
import ( |
|
"context" |
|
"database/sql" |
|
"fmt" |
|
"go-common/library/log" |
|
) |
|
|
|
const ( |
|
_queryBvcResource = "select id from %s where svid = %d" |
|
_queryCoverResource = "select cover_url,cover_width,cover_height from video_repository where svid = ?" |
|
) |
|
|
|
//CheckSVResource ... |
|
func (d *Dao) CheckSVResource(c context.Context, svid int64) (err error) { |
|
var ( |
|
ID int64 |
|
cURL string |
|
cH int64 |
|
cW int64 |
|
) |
|
tN := fmt.Sprintf("video_bvc_%02d", svid%100) |
|
|
|
if err = d.db.QueryRow(c, fmt.Sprintf(_queryBvcResource, tN, svid)).Scan(&ID); err == sql.ErrNoRows { |
|
log.Error("CheckSVResource bvc err,svid:%d,err:%v", svid, err) |
|
return |
|
} |
|
//cover,err := d.cmsdb.QueryRow(c, query, ...) |
|
if err = d.db.QueryRow(c, _queryCoverResource, svid).Scan(&cURL, &cW, &cH); err == sql.ErrNoRows { |
|
log.Error("CheckSVResource cover err,svid:%d,err:%v", svid, err) |
|
return |
|
} |
|
return |
|
}
|
|
|