Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //Login Function
- func (idb *InDB) Login(c *gin.Context) {
- var (
- sql strings.Builder
- mResult structs.Result
- )
- FirstName := c.PostForm("firstName")
- LastName := c.PostForm("lastName")
- sql.WriteString("Select ")
- sql.WriteString("Case When ")
- sql.WriteString(" Exists( ")
- sql.WriteString(" Select Id ")
- sql.WriteString(" From People ")
- sql.WriteString(" Where first_name = '" + FirstName + "' AND last_name = '" + LastName + "' ")
- sql.WriteString(" ) Then 1 ")
- sql.WriteString(" Else ")
- sql.WriteString(" 0 ")
- sql.WriteString("End As ErrType; ")
- idb.DB.Raw(sql.String()).Scan(&mResult)
- fmt.Println(sql.String())
- c.JSON(http.StatusOK, mResult)
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement