func PostQueryForUserID(query string) ([]string, error) { conn, err := env.GetMySQLConn() if err != nil { return nil, err } defer conn.Close() fmt.Printf("Posts Query: %s\n", query) rows, err := conn.Query(query) if err != nil { return nil, err } userIDs := []string{} for rows.Next() { var userID string err = rows.Scan( &userID, ) if err != nil { return nil, err } userIDs = append(userIDs, userID) } return userIDs, nil }
// UserQueryWithCache is qury for user func UserQueryWithCache(query string) ([]entity.User, error) { // TODO use cache conn, err := env.GetMySQLConn() if err != nil { return nil, err } defer conn.Close() users := []entity.User{} fmt.Printf("User Query: %s\n", query) rows, err := conn.Query(query) if err != nil { return nil, err } for rows.Next() { user := entity.User{} var friends string err = rows.Scan( &user.UserID, &user.UserNo, &user.UserPublicScore, &friends, &user.UserImage, ) if err != nil { return nil, err } user.UserFriends = strings.Split(friends, ",") users = append(users, user) } return users, nil }
// PostQueryWithCache is qury for user func PostQueryWithCache(query string) ([]entity.Post, error) { // TODO use cache conn, err := env.GetMySQLConn() if err != nil { return nil, err } defer conn.Close() posts := []entity.Post{} fmt.Printf("Posts Query: %s\n", query) rows, err := conn.Query(query) if err != nil { return nil, err } for rows.Next() { post := entity.Post{} var lusers string var tags string err = rows.Scan( &post.PostID, &post.PostDateTime, &post.PostUserID, &post.PostItemID, &post.PostItemScore, &post.PostItemState, &lusers, &tags, ) if err != nil { return nil, err } post.PostTags = strings.Split(tags, ",") post.PostLikeUsers = strings.Split(lusers, ",") posts = append(posts, post) } return posts, nil }
// ItemQueryWithCache is qury for user func ItemQueryWithCache(query string) ([]entity.Item, error) { // TODO use cache conn, err := env.GetMySQLConn() if err != nil { return nil, err } defer conn.Close() items := []entity.Item{} rows, err := conn.Query(query) if err != nil { return nil, err } for rows.Next() { item := entity.Item{} var tags string err = rows.Scan( &item.IttemID, &item.ItemNo, &item.ItemSupplier, &item.ItemSoldQuantity, &item.ItemSalePrice, &tags, &item.ItemImage, ) if err != nil { return nil, err } item.ItemTags = strings.Split(tags, ",") items = append(items, item) } return items, nil }