func GetAppByApiToken(txn gorp.SqlExecutor, apiToken string) (*App, error) { var app App if err := txn.SelectOne(&app, "SELECT * FROM app where api_token = ?", apiToken); err != nil { return nil, err } return &app, nil }
func SelectOne(s gorp.SqlExecutor, builder squirrel.SelectBuilder, src interface{}) error { sql, args, err := builder.ToSql() if err != nil { return err } return s.SelectOne(src, sql, args...) }
func GetBundleByFileId(txn gorp.SqlExecutor, fileId string) (*Bundle, error) { var bundle Bundle if err := txn.SelectOne(&bundle, "SELECT * FROM bundle WHERE file_id = ?", fileId); err != nil { return nil, err } return &bundle, nil }
func GetApp(txn gorp.SqlExecutor, id int) (*App, error) { var app App if err := txn.SelectOne(&app, "SELECT * FROM app WHERE id = ?", id); err != nil { return nil, err } return &app, nil }
func GetBundle(txn gorp.SqlExecutor, id int) (*Bundle, error) { var bundle Bundle if err := txn.SelectOne(&bundle, "SELECT * FROM bundle WHERE id = ?", id); err != nil { return nil, err } return &bundle, nil }
func GetUserFromEmail(txn gorp.SqlExecutor, email string) (*User, error) { var user User err := txn.SelectOne(&user, "SELECT * FROM user WHERE email = ?", email) if err != nil { return nil, err } return &user, nil }
func SelectMessage(db gorp.SqlExecutor, id int64) models.DefaultStruct { entity := models.DefaultStruct{} err := db.SelectOne(&entity, SQL_MESSAGES_BY_ID, id) if err != nil { checkErr(err, "select failed") } return entity }
func getReplyReadHash(hash string, db gorp.SqlExecutor) *models.WarningResp { var reply models.WarningResp err := db.SelectOne(&reply, SQL_SELECT_REPLY_BY_READ_HASH, map[string]interface{}{ "hash": hash, }) if err != nil { return nil } return &reply }
func GetUserByLogin(postedUser models.UserLogin, db gorp.SqlExecutor) *models.User { user := models.User{} db.SelectOne(&user, SQL_LOGIN, map[string]interface{}{ "user": postedUser.Username, "pass": postedUser.Password, }) return &user }
// Get an existent ignoreme register, in case there is none returns nil func GetIgnoreContact(db gorp.SqlExecutor, id string) *models.Ignore_List { var ignored models.Ignore_List err := db.SelectOne(&ignored, SQL_IN_IGNORE_LIST_BY_CODE, map[string]interface{}{ "code": id, }) if err != nil { return nil } return &ignored }
// Check if the contact already requested an ignore list add. // In case the contact exists on the list the method returns it func InIgnoreList(db gorp.SqlExecutor, contact string) *models.Ignore_List { fmt.Println("InIgnoreList") ignored := models.Ignore_List{} err := db.SelectOne(&ignored, SQL_IN_IGNORE_LIST_BY_CONTACT, map[string]interface{}{ "contact": contact, }) if err != nil { return nil } return &ignored }
func GetMessage(enc Encoder, db gorp.SqlExecutor, parms martini.Params) (int, string) { id, err := strconv.Atoi(parms["id"]) if err != nil { // Invalid id, or does not exist return http.StatusBadRequest, "" } obj := models.MessageStruct{} err = db.SelectOne(&obj, "SELECT * FROM messages WHERE id=?", id) if err != nil { checkErr(err, "get failed") // Invalid id, or does not exist return http.StatusBadRequest, "" } return http.StatusOK, Must(enc.EncodeOne(obj)) }
// count all warnings registered func WarnaCounter(enc Encoder, db gorp.SqlExecutor, user sessionauth.User) (int, string) { counts := models.CountWarning{} u := UserById(user.UniqueId().(int), db) if user.IsAuthenticated() && u.UserRole == models.ROLE_ADMIN { err := db.SelectOne(&counts, SQL_WARN_COUNT) checkErr(err, "COUNT SENT WARNINGS ERROR") if err == nil { return http.StatusOK, Must(enc.EncodeOne(counts)) } else { return http.StatusBadRequest, "" } } return http.StatusUnauthorized, "" }