Advertisement
Guest User

login_func

a guest
Oct 16th, 2019
154
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Go 0.80 KB | None | 0 0
  1. //Login Function
  2. func (idb *InDB) Login(c *gin.Context) {
  3.     var (
  4.         sql     strings.Builder
  5.         mResult structs.Result
  6.        
  7.     )
  8.  
  9.     FirstName := c.PostForm("firstName")
  10.     LastName := c.PostForm("lastName")
  11.  
  12.     sql.WriteString("Select ")
  13.     sql.WriteString("Case When ")
  14.     sql.WriteString("    Exists( ")
  15.     sql.WriteString("        Select Id ")
  16.     sql.WriteString("        From People ")
  17.     sql.WriteString("        Where first_name = '" + FirstName + "' AND last_name = '" + LastName + "' ")
  18.     sql.WriteString("        ) Then 1  ")
  19.     sql.WriteString("    Else ")
  20.     sql.WriteString("     0 ")
  21.     sql.WriteString("End As ErrType; ")
  22.  
  23.     idb.DB.Raw(sql.String()).Scan(&mResult)
  24.     fmt.Println(sql.String())
  25.  
  26.  
  27.  
  28.     c.JSON(http.StatusOK, mResult)
  29.  
  30. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement