本文整理汇总了Golang中github.com/go-xorm/xorm.Session.Sql方法的典型用法代码示例。如果您正苦于以下问题:Golang Session.Sql方法的具体用法?Golang Session.Sql怎么用?Golang Session.Sql使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类github.com/go-xorm/xorm.Session
的用法示例。
在下文中一共展示了Session.Sql方法的4个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Golang代码示例。
示例1: GetByComponentIdForTrans
func (this *ContentPuzzleActivityComponentPuzzleDbModel) GetByComponentIdForTrans(sess *xorm.Session, componentId int) []ContentPuzzleActivityComponentPuzzle {
result := []ContentPuzzleActivityComponentPuzzle{}
err := sess.Sql("select * from t_content_puzzle_activity_component_puzzle where contentPuzzleActivityComponentId = ? for update", componentId).Find(&result)
if err != nil {
panic(err)
}
return result
}
示例2: GetFeedListWithAmount
// Get feed list with amount, unread and starred number.
func GetFeedListWithAmount(session *xorm.Session) (feedlist []*FeedWithAmount, err error) {
sql := `select Feed.*,t1.Amount,t2.Unread,t3.Starred from Feed left join
(select Fid,count(*) as Amount from Item group by Fid) as t1 on Feed.Id = t1.Fid left join
(select Fid,count(*) as Unread from Item where Read=0 group by Fid) as t2 on t1.Fid=t2.Fid left join
(select Fid,count(*) as Starred from Item where Starred=1 group by Fid) as t3 on t1.Fid=t3.Fid`
if session == nil {
err = global.Orm.Sql(sql).Find(&feedlist)
} else {
err = session.Sql(sql).Find(&feedlist)
}
return
}
示例3: getAlertNotificationInternal
func getAlertNotificationInternal(query *m.GetAlertNotificationsQuery, sess *xorm.Session) error {
var sql bytes.Buffer
params := make([]interface{}, 0)
sql.WriteString(`SELECT
alert_notification.id,
alert_notification.org_id,
alert_notification.name,
alert_notification.type,
alert_notification.created,
alert_notification.updated,
alert_notification.settings,
alert_notification.is_default
FROM alert_notification
`)
sql.WriteString(` WHERE alert_notification.org_id = ?`)
params = append(params, query.OrgId)
if query.Name != "" || query.Id != 0 {
if query.Name != "" {
sql.WriteString(` AND alert_notification.name = ?`)
params = append(params, query.Name)
}
if query.Id != 0 {
sql.WriteString(` AND alert_notification.id = ?`)
params = append(params, query.Id)
}
}
results := make([]*m.AlertNotification, 0)
if err := sess.Sql(sql.String(), params...).Find(&results); err != nil {
return err
}
if len(results) == 0 {
query.Result = nil
} else {
query.Result = results[0]
}
return nil
}
示例4: getTagAndFeedIds
func getTagAndFeedIds(session *xorm.Session) (result []*TagAndFeedId, err error) {
err = session.Sql("select Feed.Id as FeedId,Tag.Name as Tag from Feed left join Tag on Feed.Id=Tag.Fid").Find(&result)
return
}