Function performProofQuery

controller/proof_query.go:79–232

(req ProofQueryRequest)

}

func performProofQuery(req ProofQueryRequest) ([]ProofQueryResponseSingle, ProofQueryPaginationResponse) {
	pagination := ProofQueryPaginationResponse{
		Total:   0,
		Per:     PER_PAGE,
		Current: req.Page,
		Next:    0,
	}
	if pagination.Current <= 0 { // `page` param not provided. Set it to 1.
		pagination.Current = 1
	}
	offsetCount := pagination.Per * (pagination.Current - 1)

	result := make([]ProofQueryResponseSingle, 0, 0)
	proofs := make([]model.Proof, 0, 0)
	tx := model.ReadOnlyDB.Model(&model.Proof{})

	// support selected fields only.
	orderBy := "id"
	order := "desc"
	switch strings.ToLower(req.SortBy) {
	case "id", "last_arweave_id", "created_at", "last_checked_at", "proof_chain_id", "platform", "identity", "alt_id":
		orderBy = strings.ToLower(req.SortBy)
	}
	switch strings.ToLower(req.Order) {
	case "asc", "desc":
		order = strings.ToLower(req.Order)
	}

	if strings.ToLower(req.SortBy) == "activated_at" {
		orderBy = "created_at"
		tx = model.ReadOnlyDB.Table("proof").
			Select("proof.*, proof_chains.*").
			Joins("INNER JOIN proof_chains ON proof.persona = proof_chains.persona").
			Order("proof_chains.created_at " + order).
			Model(&model.Proof{})
	} else {
		tx = tx.Order(orderBy + " " + order)
	}

	switch req.Platform {
	case string(types.Platforms.NextID):
		{
			tx = tx.Where("proof.persona IN ?", req.Identity).Offset(offsetCount).Limit(pagination.Per).Find(&proofs)
			pagination.Total = tx.RowsAffected
		}
	case "":
		{ // All platform
			if req.ExactMatch {
				tx = tx.Where("proof.identity = ? OR proof.alt_id = ?", strings.ToLower(req.Identity[0]), strings.ToLower(req.Identity[0]))
			} else {
				tx = tx.Where("proof.identity LIKE ? OR proof.alt_id LIKE ?", "%"+strings.ToLower(req.Identity[0])+"%", "%"+strings.ToLower(req.Identity[0])+"%")
			}

			for i, id := range req.Identity {
				if i == 0 {
					continue
				}
				if req.ExactMatch {