decentraland / marketplace-server

53%

main: 53%

LAST BUILD ON BRANCH feat/query-improvements

branch: feat/query-improvements

CHANGE BRANCH

x

Reset

Sync Branches

• feat/query-improvements
• breaking/remove-balances-endpoint
• chore/fix-eslint-issues
• chore/log-database-url
• chore/trigger-deploy
• chore/trigger-deployment
• dependabot/npm_and_yarn/dcl/eslint-config-1.1.8
• dependabot/npm_and_yarn/dcl/eslint-config-1.1.9
• dependabot/npm_and_yarn/ethers-6.6.5
• dependabot/npm_and_yarn/ethers-6.6.7
• dependabot/npm_and_yarn/ethers-6.7.0
• dependabot/npm_and_yarn/ethers-6.7.1
• dependabot/npm_and_yarn/node-fetch-and-decentraland-crypto-middleware-2.7.0
• dependabot/npm_and_yarn/nodemon-3.0.1
• dependabot/npm_and_yarn/tough-cookie-4.1.3
• dependabot/npm_and_yarn/types/node-20.4.1
• dependabot/npm_and_yarn/types/node-20.4.2
• dependabot/npm_and_yarn/types/node-20.4.4
• dependabot/npm_and_yarn/types/node-20.4.5
• dependabot/npm_and_yarn/types/node-20.4.6
• dependabot/npm_and_yarn/types/node-20.4.7
• dependabot/npm_and_yarn/types/node-20.4.8
• dependabot/npm_and_yarn/types/node-20.4.9
• dependabot/npm_and_yarn/types/node-20.5.0
• dependabot/npm_and_yarn/types/node-20.5.1
• dependabot/npm_and_yarn/types/node-20.5.3
• dependabot/npm_and_yarn/types/node-20.5.4
• dependabot/npm_and_yarn/types/node-20.5.6
• dependabot/npm_and_yarn/types/node-20.5.7
• dependabot/npm_and_yarn/types/node-20.5.9
• dependabot/npm_and_yarn/types/node-20.6.0
• dependabot/npm_and_yarn/types/node-20.6.2
• dependabot/npm_and_yarn/types/node-20.6.3
• dependabot/npm_and_yarn/types/node-20.6.5
• dependabot/npm_and_yarn/types/node-20.7.0
• dependabot/npm_and_yarn/types/node-20.7.1
• dependabot/npm_and_yarn/types/node-20.8.0
• dependabot/npm_and_yarn/well-known-components/http-server-2.0.0
• dependabot/npm_and_yarn/well-known-components/interfaces-1.4.2
• dependabot/npm_and_yarn/word-wrap-1.2.4
• feat/117-dapps-database-connection
• feat/118-POST-trades
• feat/accept-orders-trade
• feat/accept-regex-cors
• feat/add-bids-handler
• feat/add-border-radius
• feat/add-endpoint-received
• feat/add-expire-date
• feat/add-favorites
• feat/add-fingerprint-contract-check
• feat/add-hashed-signature
• feat/add-if-not-exists-to-migration
• feat/add-item-type-filter-to-wearables-handler
• feat/add-items-endpoint
• feat/add-log-notifiaction
• feat/add-logging-event
• feat/add-matic-amoy-collection-store
• feat/add-migrations-obj
• feat/add-nft-endpoint
• feat/add-notification-item-sold
• feat/add-only-logo-param
• feat/add-orders-endpoint
• feat/add-public-order-trades
• feat/add-queries-timeout
• feat/add-rentals
• feat/add-rented-assets
• feat/add-search-by-utility
• feat/add-seller-bids
• feat/add-some-item-intgration-tests
• feat/add-statement_timeout
• feat/add-trade-created-notification
• feat/add-trade-id-items
• feat/add-try-catch-nfts
• feat/add-verify-metadata-content-opt
• feat/add-wert-publication-fees-target
• feat/allow-new-rarity
• feat/anon-and-search-id
• feat/bids-filters
• feat/catalog-query-updates
• feat/catalog-trades
• feat/check-blockchain-owner
• feat/check-ecdsa-signature
• feat/check-signer
• feat/cors
• feat/create-session-when-sign-wert-message
• feat/encode-extra-info
• feat/endpoint-to-recreate-trades-mv
• feat/enhace-catalog-with-favorites
• feat/ens
• feat/ens-image-generator-endpoint
• feat/fix-create-extension
• feat/fix-trade-network
• feat/fuzzy-search
• feat/get-trade-endpoint
• feat/improve-catalog-queries
• feat/improve-catalog-query
• feat/improve-land-queries
• feat/improve-lands-query
• feat/improve-orders-query
• feat/improve-queries
• feat/integration-tests-nfts-and-catalog
• feat/lands-price-bug
• feat/lands-query-refactor
• feat/log-db
• feat/log-query
• feat/log-response
• feat/mv-changes
• feat/only-minting-logic
• feat/order-seconds-expires
• feat/orders-query
• feat/owners-endpoint
• feat/picks-utility-logic
• feat/prices
• feat/query-squids
• feat/rankings-endpoint
• feat/rankings-refactor
• feat/readme-and-scripts
• feat/refresh-transak-token
• feat/remove-ens-image-code
• feat/remove-logs
• feat/remove-stg-env
• feat/rollback-expires-at-change
• feat/rollback-kill-stg
• feat/sales-endpoint
• feat/search_estate_size-issue
• feat/split-catalog-total
• feat/squid-catalog
• feat/stats-and-trending-endpoints
• feat/tags-search
• feat/trades-mv
• feat/transak-orders-endpoint
• feat/trigger-deploy
• feat/trigger-deploy-prd
• feat/trigger-redeploy
• feat/unified-trades-items-query
• feat/update-dcl-schemas
• feat/update-decentraland-transactions
• feat/update-decentraland-tx
• feat/update-mv-job
• feat/update-squid
• feat/upgrade-subgraph-urls
• feat/use-api-key-for-sessions
• feat/use-mv-view-on-orders-query
• feat/use-new-squid-fields
• feat/use-nft-owner-address
• feat/use-nft-owner-and-address
• feat/use-right-expires-at-normalized-field
• feat/use-views
• feat/user-assets
• feat/user-balances
• feat/validate-builder-signer
• feat/volume-endpoint
• feat/wert-signer-endpoint
• fix/117-table-names
• fix/5-mins-job
• fix/add-await
• fix/add-emotes-missing-where-query
• fix/add-index-if-not-exists
• fix/add-inter-font
• fix/add-librsvg-dev
• fix/catalog-filter-network
• fix/catalog-issue
• fix/catalog-query
• fix/catalog-query-count
• fix/catalog-search-metadata
• fix/catalog-search-query
• fix/catalog-total-count
• fix/default-env-value
• fix/dev-deps
• fix/dockerfile
• fix/edit-readme
• fix/emote-body-shapes
• fix/emotes-params-network-schema
• fix/ens-image-styles
• fix/ens-logo-path
• fix/ens-price-endpoint
• fix/ens-query
• fix/ens-query-slow
• fix/ens-total
• fix/error-not-handled
• fix/estates-filters
• fix/ethereum-orders
• fix/events-publishing
• fix/filter-items-by-text
• fix/filter-zero-if-owner
• fix/filter-zero-size-estates
• fix/first-listed-at-ambiguous
• fix/fix-node-version
• fix/fix-trades-with-no-price
• fix/integration-tests
• fix/is-on-sale
• fix/item-creatorship-changed
• fix/item-id-filter
• fix/item-id-nft-listings
• fix/items-params
• fix/items-query
• fix/items-sold-at
• fix/keccak-calc
• fix/lands-query
• fix/lands-recently-listed
• fix/logs
• fix/marketplace-squid-schema
• fix/metrics
• fix/missing-fields-in-trades
• fix/missing-nft-join
• fix/missing-picked-by-param
• fix/missing-rentals
• fix/move-wkc-tracer-to-deps
• fix/network
• fix/network-filter
• fix/newest-items
• fix/nft-id
• fix/nfts-and-orders-query
• fix/nfts-by-owner-query
• fix/nfts-on-sale-query
• fix/nfts-queries
• fix/nfts-query-filters
• fix/nfts-sorts
• fix/not-expired
• fix/not-on-sale
• fix/not-on-sale-items-filtered
• fix/not-on-sale-query
• fix/old-orders-filter
• fix/only-minting-where
• fix/only-retrieve-orders-owned-by-the-creator
• fix/order-status
• fix/orders-query
• fix/owner-queries
• fix/owners-filter-missing
• fix/p-limit-missing
• fix/parcels-coords
• fix/prevent-estate-trades-without-fingerprint
• fix/price-filter-bug
• fix/prices-and-body-shape-filters
• fix/ranking-queries
• fix/re-deploy
• fix/recently-listed-emotes-query
• fix/recently-listed-nfts-query
• fix/recently-listed-query
• fix/recently-sale-nfts-query
• fix/remove-alter-foerign-table
• fix/remove-bytes-conversion
• fix/remove-logs
• fix/rentals-listings
• fix/sales-and-bids-queries
• fix/search
• fix/search-not-working
• fix/search-tags-query
• fix/several-queries
• fix/sort-order
• fix/tests
• fix/total-volume-bug
• fix/trade-asset-item
• fix/update-dep
• fix/use-builder-sserver-db-host-var
• fix/use-tracer-when-logging
• fix/view
• main
• refs/tags/0.0.1
• refs/tags/0.0.2
• refs/tags/0.0.3
• refs/tags/0.0.4
• refs/tags/1.0.0
• refs/tags/1.0.1
• refs/tags/1.0.2
• refs/tags/1.0.3
• refs/tags/1.0.4
• refs/tags/1.0.6
• refs/tags/1.0.7
• refs/tags/1.0.8
• refs/tags/1.05
• refs/tags/1.1.0
• refs/tags/1.10.0
• refs/tags/1.10.1
• refs/tags/1.10.2
• refs/tags/1.11.0
• refs/tags/1.12.0
• refs/tags/1.13.0
• refs/tags/1.14.0
• refs/tags/1.14.1
• refs/tags/1.15.0
• refs/tags/1.16.0
• refs/tags/1.17.0
• refs/tags/1.17.1
• refs/tags/1.17.2
• refs/tags/1.17.3
• refs/tags/1.18.0
• refs/tags/1.19.0
• refs/tags/1.2.0
• refs/tags/1.2.1
• refs/tags/1.20.0
• refs/tags/1.21.0
• refs/tags/1.21.1
• refs/tags/1.21.2
• refs/tags/1.21.3
• refs/tags/1.22.0
• refs/tags/1.23.0
• refs/tags/1.24.0
• refs/tags/1.25.0
• refs/tags/1.25.1
• refs/tags/1.25.2
• refs/tags/1.26.0
• refs/tags/1.27.1
• refs/tags/1.29.0
• refs/tags/1.3.0
• refs/tags/1.3.1
• refs/tags/1.3.2
• refs/tags/1.3.3
• refs/tags/1.3.4
• refs/tags/1.30.0
• refs/tags/1.30.1
• refs/tags/1.30.2
• refs/tags/1.31.0
• refs/tags/1.32.0
• refs/tags/1.32.1
• refs/tags/1.32.2
• refs/tags/1.33.0
• refs/tags/1.34.0
• refs/tags/1.35.0
• refs/tags/1.35.1
• refs/tags/1.35.2
• refs/tags/1.35.3
• refs/tags/1.35.4
• refs/tags/1.36.0
• refs/tags/1.37.0
• refs/tags/1.38.0
• refs/tags/1.39.0
• refs/tags/1.39.1
• refs/tags/1.39.2
• refs/tags/1.39.3
• refs/tags/1.4.0
• refs/tags/1.4.1
• refs/tags/1.40.0
• refs/tags/1.40.1
• refs/tags/1.41.0
• refs/tags/1.42.0
• refs/tags/1.43.0
• refs/tags/1.43.1
• refs/tags/1.44.0
• refs/tags/1.44.1
• refs/tags/1.45.0
• refs/tags/1.45.1
• refs/tags/1.45.2
• refs/tags/1.45.3
• refs/tags/1.46.0
• refs/tags/1.47.0
• refs/tags/1.48.0
• refs/tags/1.48.1
• refs/tags/1.48.2
• refs/tags/1.49.0
• refs/tags/1.49.1
• refs/tags/1.49.2
• refs/tags/1.49.3
• refs/tags/1.49.4
• refs/tags/1.49.5
• refs/tags/1.49.6
• refs/tags/1.5.0
• refs/tags/1.6.0
• refs/tags/1.7.0
• refs/tags/1.8.0
• refs/tags/1.9.0
• refs/tags/1.9.1
• refs/tags/1.9.2
• refs/tags/2.0.0
• refs/tags/2.0.1
• refs/tags/2.0.2
• refs/tags/2.1.0
• refs/tags/2.1.1
• refs/tags/2.2.0
• refs/tags/2.2.1
• refs/tags/2.3.0
• refs/tags/2.4.0
• refs/tags/2.4.1
• refs/tags/2.5.0
• refs/tags/2.6.0
• refs/tags/2.6.1
• refs/tags/2.6.2
• refs/tags/2.6.3
• refs/tags/2.7.0
• refs/tags/2.7.1
• refs/tags/2.8.0
• refs/tags/2.8.1

Build # 13136008756

Build Type

Pull #256

github

Committed by juanmahidalgo

Commit Message

feat: improve several queries standarizing trades CTE

Pull Request Pull Request #256: feat: improve several queries standarizing trades CTE

Run Details

614 of 1523 branches covered (40.32%)

Branch coverage included in aggregate %.

11 of 15 new or added lines in 4 files covered. (73.33%)

1743 of 2958 relevant lines covered (58.92%)

6.43 hits per line