Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[May 10] As a Donor, I want to receive GIVbacks from my recurring donations. #1483

Closed
7 of 11 tasks
divine-comedian opened this issue Aug 25, 2023 · 21 comments
Closed
7 of 11 tasks

Comments

@divine-comedian
Copy link
Collaborator

divine-comedian commented Aug 25, 2023

Users should get GIVbacks for making recurring donations to verified projects with GIVbacks eligible tokens

We can use the accounting API to track the amount and dollar value of super fluid streams made between two points in time. We can add this into our regular GIVbacks calculations
https://accounting.superfluid.dev/v1/swagger

I think we should have this happen in the background, automatically, and not add any complexity to the UI.

Tagging @laurenluz to see what she thinks


After making a GIVbacks eligible recurring donation users should receive GIVbacks based on the USD value of the recurring donation(s) made during the specific GIVbacks round

example:

User sets stream for 10 DAI / month to project A - that's approx $ 0.328 per day

GIVbacks round is 14 days - user has recurring donation for entire duration of round that should mean they have $4.6 of GIVbacks eligible donations when running the calculation

Any recurring donation value made outside the GIVbacks range should not be included in calculation. Having multiple recurring donations to many projects or the same project with different tokens should also be taken into account similarity

AC

  • user can create recurring donation to a project w/ Optimism address
  • when donating token logos show up with GIVbacks eligible symbol on them
  • on success page users sees some text confirming they will get GIVbacks from their recurring donation
  • GIVbacks calculation for recurring donation returns correct amount
  • value of recurring donations made outside of givbacks calculation dates are not counted
  • givbacks factor from project's rank is applied correctly
  • donations to non-verified projects are not included in calculation
  • recurring donations made to several projects by the same user, within the givbacks calculation dates are calculated correctly
  • several recurring donations in different tokens, made to the same project is calculated correctly
  • token prices are fetched correctly in givbacks calculation for OP, ETH, DAI, USDC, GIV
  • GIVbacks factor changes when recurring donation is applied across multiple rounds is applied correctly (project increases or decreases in rank)
@laurenluz
Copy link
Member

Sounds good!

I don't think we need add anything special to the UI for givbacks.

@divine-comedian
Copy link
Collaborator Author

@jainkrati - who can we give this one too for the research?

@jainkrati
Copy link
Collaborator

jainkrati commented May 2, 2024

@mohammadranjbarz can you guide @RamRamez to take this up and give to QA by May 10

@jainkrati jainkrati changed the title As a Donor, I want to receive GIVbacks from my recurring donations. [May 10] As a Donor, I want to receive GIVbacks from my recurring donations. May 2, 2024
@mohammadranjbarz
Copy link
Collaborator

@mohammadranjbarz can you guide @RamRamez to take this up and give to QA by May 10

Sure, good idea, @RamRamez please ping me when you decided to work on this

@divine-comedian
Copy link
Collaborator Author

divine-comedian commented May 8, 2024

Use the mini donations to count towards the GIVbacks calculation, not the accounting API

We have everything in the data already including GIVbacks factor to add it into the calculations, if we used the accounting API we would miss this.

@mohammadranjbarz
Copy link
Collaborator

@mhmdksh Can you give me the link of givback-calculation staging, because the current link you already sent me doesn't work, and we need it for testing this issue (and also @maryjaf needs that for another issue)
And CD pipeline doesn't work for staging of givback-calcualtion project, it might be related to that

mohammadranjbarz added a commit that referenced this issue May 21, 2024
* add activeQfRoundId to sortingBy InstantBoosting

* add orderBy totalDonations and totalReactions

* feat: add getRecurringDonationStats resolver

* fix filtering by QF

* remove qfRounds joins for non qf round filters

* add some temp logs

* remove temp logs

* fix: changes test cases of recuring donations stats
- create recored with createdAt field in past so test result won't be related to other endpoints test cases

* Fix projectActualserviceView

* fix stream balance depleted issue (#1496)

Co-authored-by: mohammadranjbarz <mranjbar.z2993@gmail.com>

* rebuild

* refresh and fetch user address separately (#1499)

* Added pg_trgm extension migration (#1502)

* fix: change recurring donations stats query to single query

* fix recurring donation count

* WIP: projectIds textArea

* fix actual matching cap (#1507)

* fix query error

* fix user donations count

* fix recurring donation count tests

* fix user recurring donation query

* fix user recurring donation test

* add donations relation to qfround

* add findArchivedQfRounds endpoint

* add findArchivedQfRounds endpoint

* feat: add sponsors & banner images upload

* add sortBy to findArchivedQfRounds

* 1.23.3

* add new test graphql query

* add tests for new QfArchivedRounds

* fixes on qfArchivedRounds query

* add new tests for qfArchivedRounds query

* fix findArchivedQfRounds tests

* fix: keep already uploaded sponsors images

* fix skip and limit for findArchivedQfRounds

* Add logs and refactor the bootstrap code to help investigate latency problem

* Add poolSize to orm config

* Fix eslint errors

* remove changing squareRootSumOfProjects when cap is overflown

* Trigger ortto activity when user saves their profile info for the first time (#1520)

* add newUser to updateUser query

* add createOrttoProfile

* add createOrttoProfile to NotificationAdapterInterface

* add createOrttoProfile to MockNotificationAdapter

* add CREATE_ORTTO_PROFILE event

* Allow to set the matching pool token & amount to be something other than usd (#1517)

* Allow to set the matching pool token & amount to be something other than USD in adminjs

* Allow to set the matching pool token & amount to be something other than USD in QFRound table

* add null to allocatedTokenSymbol and allocatedTokenChainId

* add nullable true to allocatedTokenSymbol and allocatedTokenChainId

* add allocatedFundUSDPreferred and allocatedFundUSD to qfRound

* Comment migrations

* Hotfix db improvements (#1523)

* add extra configurations for postgresql connections

* add master and slave replication strategy for typeorm

* add qfRound to qfRoundStats

* fix qfRoundStatsQuery

* Hotfix staging fix latency (#1528)

* add project donation summary view entity

* convert projectQueries to querybuilder

* add cache to projectDonationSummary queries

* add configurable cache to slow queries

* remove massive recurring donation log

* add await for project queries

* Add logs to projectVerificationForm

* Add logs to projectVerificationForm

* fix: add project Ids list textarea for qf round edit

* Master to staging (#1543)

* Hotfix db improvements (#1523) (#1524)

* add extra configurations for postgresql connections

* add master and slave replication strategy for typeorm

Co-authored-by: CarlosQ96 <92376054+CarlosQ96@users.noreply.github.com>

* Fix/db replica production (#1525)

* Hotfix db improvements (#1523)

* add extra configurations for postgresql connections

* add master and slave replication strategy for typeorm

* Define db read only configs

---------

Co-authored-by: CarlosQ96 <92376054+CarlosQ96@users.noreply.github.com>

* update comment

* Hotfix latency issues for prod (#1529)

* Hotfix staging fix latency (#1528)

* add project donation summary view entity

* convert projectQueries to querybuilder

* add cache to projectDonationSummary queries

* add configurable cache to slow queries

* remove massive recurring donation log

* add await for project queries

* Add informative logs for draft donation service job (#1537)

* Fix eslint errors

* Fix/master test (#1541)

* Fixed master test issue

* Returned test to master pipeline

* Comment executing donation summary view

---------

Co-authored-by: Mohammad Ranjbar Z <mranjbar.z2993@gmail.com>

---------

Co-authored-by: CarlosQ96 <92376054+CarlosQ96@users.noreply.github.com>
Co-authored-by: Carlos <carlos.quintero096@gmail.com>
Co-authored-by: mohammadranjbarz <mranjbar.z2993@gmail.com>

* Fix/word similarity - staging (#1546)

* Hotfix db improvements (#1523) (#1524)

* add extra configurations for postgresql connections

* add master and slave replication strategy for typeorm

Co-authored-by: CarlosQ96 <92376054+CarlosQ96@users.noreply.github.com>

* Fix/db replica production (#1525)

* Hotfix db improvements (#1523)

* add extra configurations for postgresql connections

* add master and slave replication strategy for typeorm

* Define db read only configs

---------

Co-authored-by: CarlosQ96 <92376054+CarlosQ96@users.noreply.github.com>

* update comment

* Hotfix latency issues for prod (#1529)

* Hotfix staging fix latency (#1528)

* add project donation summary view entity

* convert projectQueries to querybuilder

* add cache to projectDonationSummary queries

* add configurable cache to slow queries

* remove massive recurring donation log

* add await for project queries

* Add informative logs for draft donation service job (#1537)

* Fix eslint errors

* Fix/master test (#1541)

* Fixed master test issue

* Returned test to master pipeline

* Comment executing donation summary view

---------

Co-authored-by: Mohammad Ranjbar Z <mranjbar.z2993@gmail.com>

* Fixed word similarity issue

* Removed unused import

---------

Co-authored-by: CarlosQ96 <92376054+CarlosQ96@users.noreply.github.com>
Co-authored-by: Carlos <carlos.quintero096@gmail.com>
Co-authored-by: mohammadranjbarz <mranjbar.z2993@gmail.com>

* remove refresh_project_summary_from totals and add user cache (#1539)

* Remove users field from project

* Remove users field from filterProjectsQuery

* Remove projects field from user

* remove added logs

* fix eslint errors

* remove users from Project.create

* remove users from Project.create in testUtils.ts

* remove projectOwnerId

* replace admin with adminUserId

* Add recurring donation join to donations() endpoint (#1554)

related to #1483

* replace admin with adminUserId in SEED data

* replace admin with adminUserId

* replace admin with adminUserId in projectResolver.ts

* replace admin with adminUserId in projectsTab.ts

* replace admin with adminUserId in projectResolver.test.ts

* replace admin with adminUserId in projectResolver.ts

* add allocatedFundUSD and allocatedTokenSymbol to qfArchivedRounds

* fix nullable

* remove admin from project

* replace admin with adminUserId

* replace admin with adminUserId

* add adminUserId field

* drop admin column

* fix: add telegram to ProjectSocialMediaType enum to allow adding telegram url

* Add some logs

* Fix eslint errors

* Add maxQueuedJobs for draft donation worker

* Fix eslint errors

* fix unstable test case

* Disable concurrency for draft donation worker

* add indexes to project_summary_view (#1568)

* improve projectBySlug query

* fix: change output types to float

* Ignore small differences of amounts when matching draft donation for erc20

* add graphql-fields

* add getVerificationFormStatusByProjectId

* refactor projectBySlug

* add findProjectIdBySlug

* fix projectBySlug tests with new changes

* fix projectBySlug tests with new changes

* fix projectBySlug tests with new changes

* remove projectVerificationForm assert

* add logs

* fix title in should return projects with indicated slug test

* Add streamed mini donations to qf round (#1557)

* Add streamed mini donations to qf round

related to Giveth/giveth-dapps-v2#3284

* Fix eslint error

* Fix eslint errors

* make verificationFormStatus field public

* Reduce test runnning time (#1574)

* fix: reduce test runnning time

* fix: add permissions test case

* fix: add permissions test case

* fix: refactor (excluding permissions test cases from global beforeEach)

---------

Co-authored-by: Ramin <raminramazanpour@gmail.com>
Co-authored-by: Meriem-BM <barhoumi.meriem1@gmail.com>
Co-authored-by: CarlosQ96 <92376054+CarlosQ96@users.noreply.github.com>
Co-authored-by: Amin Latifi <a.latifi.al@gmail.com>
Co-authored-by: Carlos <carlos.quintero096@gmail.com>
@mohammadranjbarz
Copy link
Collaborator

@maryjaf

@WhyldWanderer
Copy link

WhyldWanderer commented May 23, 2024

Just a heads up that Round 61 & 62 GIVbacks are currently on hold waiting for this implementation.

Users are asking...
Is there an ETA for this to be completed? I can communicate this with them.
Thanks!

@maryjaf
Copy link
Collaborator

maryjaf commented May 27, 2024

  • GIVbacks calculation for recurring donation returns correct amount
  • value of recurring donations made outside of givbacks calculation dates are not counted
  • givbacks factor from project's rank is applied correctly
  • donations to non-verified projects are not included in calculation
  • recurring donations made to several projects by the same user, within the givbacks calculation dates are calculated correctly
  • several recurring donations in different tokens, made to the same project is calculated correctly
  • token prices are fetched correctly in givbacks calculation for OP, ETH, DAI, USDC, GIV
  • GIVbacks factor changes when recurring donation is applied across multiple rounds is applied correctly (project increases or decreases in rank)

For complete these ACs I need your help and access @mohammadranjbarz If you have a chance, let's set up a call

and please take a look on this Tx @mohammadranjbarz
-I donated to a project(recurring donation)
-but I didn't see this tx in response of get_eligible_donations
0xc643e72a324241c2348842f2db266df42c38a5a37de00d46e1a66a9f2c08bbdc

image.png

@maryjaf
Copy link
Collaborator

maryjaf commented May 27, 2024

and please take a look on this Tx @mohammadranjbarz
-I donated to a project(recurring donation)
-but I didn't see this tx in response of get_eligible_donations
0xc643e72a324241c2348842f2db266df42c38a5a37de00d46e1a66a9f2c08bbdc

also for this donation:
0x1bbdd9cab93c5f14b8551584e33278fca01d01ed394af6dcad5396a4567649a2
https://staging.giveth.io/project/mejan?tab=donations
image

@mohammadranjbarz
Copy link
Collaborator

@maryjaf I will set a call with you

mohammadranjbarz added a commit that referenced this issue May 27, 2024
* Ignore small differences of amounts when matching draft donation for … (#1573)

* Ignore small differences of amounts when matching draft donation for erc20

* Fix eslint errors

* Release Integrate QF with super fluid streamed donations (#1555)

* add activeQfRoundId to sortingBy InstantBoosting

* add orderBy totalDonations and totalReactions

* feat: add getRecurringDonationStats resolver

* fix filtering by QF

* remove qfRounds joins for non qf round filters

* add some temp logs

* remove temp logs

* fix: changes test cases of recuring donations stats
- create recored with createdAt field in past so test result won't be related to other endpoints test cases

* Fix projectActualserviceView

* fix stream balance depleted issue (#1496)

Co-authored-by: mohammadranjbarz <mranjbar.z2993@gmail.com>

* rebuild

* refresh and fetch user address separately (#1499)

* Added pg_trgm extension migration (#1502)

* fix: change recurring donations stats query to single query

* fix recurring donation count

* WIP: projectIds textArea

* fix actual matching cap (#1507)

* fix query error

* fix user donations count

* fix recurring donation count tests

* fix user recurring donation query

* fix user recurring donation test

* add donations relation to qfround

* add findArchivedQfRounds endpoint

* add findArchivedQfRounds endpoint

* feat: add sponsors & banner images upload

* add sortBy to findArchivedQfRounds

* 1.23.3

* add new test graphql query

* add tests for new QfArchivedRounds

* fixes on qfArchivedRounds query

* add new tests for qfArchivedRounds query

* fix findArchivedQfRounds tests

* fix: keep already uploaded sponsors images

* fix skip and limit for findArchivedQfRounds

* Add logs and refactor the bootstrap code to help investigate latency problem

* Add poolSize to orm config

* Fix eslint errors

* remove changing squareRootSumOfProjects when cap is overflown

* Trigger ortto activity when user saves their profile info for the first time (#1520)

* add newUser to updateUser query

* add createOrttoProfile

* add createOrttoProfile to NotificationAdapterInterface

* add createOrttoProfile to MockNotificationAdapter

* add CREATE_ORTTO_PROFILE event

* Allow to set the matching pool token & amount to be something other than usd (#1517)

* Allow to set the matching pool token & amount to be something other than USD in adminjs

* Allow to set the matching pool token & amount to be something other than USD in QFRound table

* add null to allocatedTokenSymbol and allocatedTokenChainId

* add nullable true to allocatedTokenSymbol and allocatedTokenChainId

* add allocatedFundUSDPreferred and allocatedFundUSD to qfRound

* Comment migrations

* Hotfix db improvements (#1523)

* add extra configurations for postgresql connections

* add master and slave replication strategy for typeorm

* add qfRound to qfRoundStats

* fix qfRoundStatsQuery

* Hotfix staging fix latency (#1528)

* add project donation summary view entity

* convert projectQueries to querybuilder

* add cache to projectDonationSummary queries

* add configurable cache to slow queries

* remove massive recurring donation log

* add await for project queries

* Add logs to projectVerificationForm

* Add logs to projectVerificationForm

* fix: add project Ids list textarea for qf round edit

* Master to staging (#1543)

* Hotfix db improvements (#1523) (#1524)

* add extra configurations for postgresql connections

* add master and slave replication strategy for typeorm

Co-authored-by: CarlosQ96 <92376054+CarlosQ96@users.noreply.github.com>

* Fix/db replica production (#1525)

* Hotfix db improvements (#1523)

* add extra configurations for postgresql connections

* add master and slave replication strategy for typeorm

* Define db read only configs

---------

Co-authored-by: CarlosQ96 <92376054+CarlosQ96@users.noreply.github.com>

* update comment

* Hotfix latency issues for prod (#1529)

* Hotfix staging fix latency (#1528)

* add project donation summary view entity

* convert projectQueries to querybuilder

* add cache to projectDonationSummary queries

* add configurable cache to slow queries

* remove massive recurring donation log

* add await for project queries

* Add informative logs for draft donation service job (#1537)

* Fix eslint errors

* Fix/master test (#1541)

* Fixed master test issue

* Returned test to master pipeline

* Comment executing donation summary view

---------

Co-authored-by: Mohammad Ranjbar Z <mranjbar.z2993@gmail.com>

---------

Co-authored-by: CarlosQ96 <92376054+CarlosQ96@users.noreply.github.com>
Co-authored-by: Carlos <carlos.quintero096@gmail.com>
Co-authored-by: mohammadranjbarz <mranjbar.z2993@gmail.com>

* Fix/word similarity - staging (#1546)

* Hotfix db improvements (#1523) (#1524)

* add extra configurations for postgresql connections

* add master and slave replication strategy for typeorm

Co-authored-by: CarlosQ96 <92376054+CarlosQ96@users.noreply.github.com>

* Fix/db replica production (#1525)

* Hotfix db improvements (#1523)

* add extra configurations for postgresql connections

* add master and slave replication strategy for typeorm

* Define db read only configs

---------

Co-authored-by: CarlosQ96 <92376054+CarlosQ96@users.noreply.github.com>

* update comment

* Hotfix latency issues for prod (#1529)

* Hotfix staging fix latency (#1528)

* add project donation summary view entity

* convert projectQueries to querybuilder

* add cache to projectDonationSummary queries

* add configurable cache to slow queries

* remove massive recurring donation log

* add await for project queries

* Add informative logs for draft donation service job (#1537)

* Fix eslint errors

* Fix/master test (#1541)

* Fixed master test issue

* Returned test to master pipeline

* Comment executing donation summary view

---------

Co-authored-by: Mohammad Ranjbar Z <mranjbar.z2993@gmail.com>

* Fixed word similarity issue

* Removed unused import

---------

Co-authored-by: CarlosQ96 <92376054+CarlosQ96@users.noreply.github.com>
Co-authored-by: Carlos <carlos.quintero096@gmail.com>
Co-authored-by: mohammadranjbarz <mranjbar.z2993@gmail.com>

* remove refresh_project_summary_from totals and add user cache (#1539)

* Remove users field from project

* Remove users field from filterProjectsQuery

* Remove projects field from user

* remove added logs

* fix eslint errors

* remove users from Project.create

* remove users from Project.create in testUtils.ts

* remove projectOwnerId

* replace admin with adminUserId

* Add recurring donation join to donations() endpoint (#1554)

related to #1483

* replace admin with adminUserId in SEED data

* replace admin with adminUserId

* replace admin with adminUserId in projectResolver.ts

* replace admin with adminUserId in projectsTab.ts

* replace admin with adminUserId in projectResolver.test.ts

* replace admin with adminUserId in projectResolver.ts

* add allocatedFundUSD and allocatedTokenSymbol to qfArchivedRounds

* fix nullable

* remove admin from project

* replace admin with adminUserId

* replace admin with adminUserId

* add adminUserId field

* drop admin column

* fix: add telegram to ProjectSocialMediaType enum to allow adding telegram url

* Add some logs

* Fix eslint errors

* Add maxQueuedJobs for draft donation worker

* Fix eslint errors

* fix unstable test case

* Disable concurrency for draft donation worker

* add indexes to project_summary_view (#1568)

* improve projectBySlug query

* fix: change output types to float

* Ignore small differences of amounts when matching draft donation for erc20

* add graphql-fields

* add getVerificationFormStatusByProjectId

* refactor projectBySlug

* add findProjectIdBySlug

* fix projectBySlug tests with new changes

* fix projectBySlug tests with new changes

* fix projectBySlug tests with new changes

* remove projectVerificationForm assert

* add logs

* fix title in should return projects with indicated slug test

* Add streamed mini donations to qf round (#1557)

* Add streamed mini donations to qf round

related to Giveth/giveth-dapps-v2#3284

* Fix eslint error

* Fix eslint errors

* make verificationFormStatus field public

* Reduce test runnning time (#1574)

* fix: reduce test runnning time

* fix: add permissions test case

* fix: add permissions test case

* fix: refactor (excluding permissions test cases from global beforeEach)

---------

Co-authored-by: Ramin <raminramazanpour@gmail.com>
Co-authored-by: Meriem-BM <barhoumi.meriem1@gmail.com>
Co-authored-by: CarlosQ96 <92376054+CarlosQ96@users.noreply.github.com>
Co-authored-by: Amin Latifi <a.latifi.al@gmail.com>
Co-authored-by: Carlos <carlos.quintero096@gmail.com>

* WIP add base network

* Continue on integrating with base chain

* Fix migrations

* Fix migrations

* Add test cases about filteriing base network

* Add BASE node http urls for rpc

* Add BASE node http urls for rpc

* Add missing things for integrating with base

* Fix creating new token with coingeckoId

related to #1564

* Fill base mainnet tokens

related to #1561

---------

Co-authored-by: Ramin <raminramazanpour@gmail.com>
Co-authored-by: Meriem-BM <barhoumi.meriem1@gmail.com>
Co-authored-by: CarlosQ96 <92376054+CarlosQ96@users.noreply.github.com>
Co-authored-by: Amin Latifi <a.latifi.al@gmail.com>
Co-authored-by: Carlos <carlos.quintero096@gmail.com>
mohammadranjbarz added a commit that referenced this issue May 28, 2024
* Ignore small differences of amounts when matching draft donation for … (#1573)

* Ignore small differences of amounts when matching draft donation for erc20

* Fix eslint errors

* Release Integrate QF with super fluid streamed donations (#1555)

* add activeQfRoundId to sortingBy InstantBoosting

* add orderBy totalDonations and totalReactions

* feat: add getRecurringDonationStats resolver

* fix filtering by QF

* remove qfRounds joins for non qf round filters

* add some temp logs

* remove temp logs

* fix: changes test cases of recuring donations stats
- create recored with createdAt field in past so test result won't be related to other endpoints test cases

* Fix projectActualserviceView

* fix stream balance depleted issue (#1496)

Co-authored-by: mohammadranjbarz <mranjbar.z2993@gmail.com>

* rebuild

* refresh and fetch user address separately (#1499)

* Added pg_trgm extension migration (#1502)

* fix: change recurring donations stats query to single query

* fix recurring donation count

* WIP: projectIds textArea

* fix actual matching cap (#1507)

* fix query error

* fix user donations count

* fix recurring donation count tests

* fix user recurring donation query

* fix user recurring donation test

* add donations relation to qfround

* add findArchivedQfRounds endpoint

* add findArchivedQfRounds endpoint

* feat: add sponsors & banner images upload

* add sortBy to findArchivedQfRounds

* 1.23.3

* add new test graphql query

* add tests for new QfArchivedRounds

* fixes on qfArchivedRounds query

* add new tests for qfArchivedRounds query

* fix findArchivedQfRounds tests

* fix: keep already uploaded sponsors images

* fix skip and limit for findArchivedQfRounds

* Add logs and refactor the bootstrap code to help investigate latency problem

* Add poolSize to orm config

* Fix eslint errors

* remove changing squareRootSumOfProjects when cap is overflown

* Trigger ortto activity when user saves their profile info for the first time (#1520)

* add newUser to updateUser query

* add createOrttoProfile

* add createOrttoProfile to NotificationAdapterInterface

* add createOrttoProfile to MockNotificationAdapter

* add CREATE_ORTTO_PROFILE event

* Allow to set the matching pool token & amount to be something other than usd (#1517)

* Allow to set the matching pool token & amount to be something other than USD in adminjs

* Allow to set the matching pool token & amount to be something other than USD in QFRound table

* add null to allocatedTokenSymbol and allocatedTokenChainId

* add nullable true to allocatedTokenSymbol and allocatedTokenChainId

* add allocatedFundUSDPreferred and allocatedFundUSD to qfRound

* Comment migrations

* Hotfix db improvements (#1523)

* add extra configurations for postgresql connections

* add master and slave replication strategy for typeorm

* add qfRound to qfRoundStats

* fix qfRoundStatsQuery

* Hotfix staging fix latency (#1528)

* add project donation summary view entity

* convert projectQueries to querybuilder

* add cache to projectDonationSummary queries

* add configurable cache to slow queries

* remove massive recurring donation log

* add await for project queries

* Add logs to projectVerificationForm

* Add logs to projectVerificationForm

* fix: add project Ids list textarea for qf round edit

* Master to staging (#1543)

* Hotfix db improvements (#1523) (#1524)

* add extra configurations for postgresql connections

* add master and slave replication strategy for typeorm

Co-authored-by: CarlosQ96 <92376054+CarlosQ96@users.noreply.github.com>

* Fix/db replica production (#1525)

* Hotfix db improvements (#1523)

* add extra configurations for postgresql connections

* add master and slave replication strategy for typeorm

* Define db read only configs

---------

Co-authored-by: CarlosQ96 <92376054+CarlosQ96@users.noreply.github.com>

* update comment

* Hotfix latency issues for prod (#1529)

* Hotfix staging fix latency (#1528)

* add project donation summary view entity

* convert projectQueries to querybuilder

* add cache to projectDonationSummary queries

* add configurable cache to slow queries

* remove massive recurring donation log

* add await for project queries

* Add informative logs for draft donation service job (#1537)

* Fix eslint errors

* Fix/master test (#1541)

* Fixed master test issue

* Returned test to master pipeline

* Comment executing donation summary view

---------

Co-authored-by: Mohammad Ranjbar Z <mranjbar.z2993@gmail.com>

---------

Co-authored-by: CarlosQ96 <92376054+CarlosQ96@users.noreply.github.com>
Co-authored-by: Carlos <carlos.quintero096@gmail.com>
Co-authored-by: mohammadranjbarz <mranjbar.z2993@gmail.com>

* Fix/word similarity - staging (#1546)

* Hotfix db improvements (#1523) (#1524)

* add extra configurations for postgresql connections

* add master and slave replication strategy for typeorm

Co-authored-by: CarlosQ96 <92376054+CarlosQ96@users.noreply.github.com>

* Fix/db replica production (#1525)

* Hotfix db improvements (#1523)

* add extra configurations for postgresql connections

* add master and slave replication strategy for typeorm

* Define db read only configs

---------

Co-authored-by: CarlosQ96 <92376054+CarlosQ96@users.noreply.github.com>

* update comment

* Hotfix latency issues for prod (#1529)

* Hotfix staging fix latency (#1528)

* add project donation summary view entity

* convert projectQueries to querybuilder

* add cache to projectDonationSummary queries

* add configurable cache to slow queries

* remove massive recurring donation log

* add await for project queries

* Add informative logs for draft donation service job (#1537)

* Fix eslint errors

* Fix/master test (#1541)

* Fixed master test issue

* Returned test to master pipeline

* Comment executing donation summary view

---------

Co-authored-by: Mohammad Ranjbar Z <mranjbar.z2993@gmail.com>

* Fixed word similarity issue

* Removed unused import

---------

Co-authored-by: CarlosQ96 <92376054+CarlosQ96@users.noreply.github.com>
Co-authored-by: Carlos <carlos.quintero096@gmail.com>
Co-authored-by: mohammadranjbarz <mranjbar.z2993@gmail.com>

* remove refresh_project_summary_from totals and add user cache (#1539)

* Remove users field from project

* Remove users field from filterProjectsQuery

* Remove projects field from user

* remove added logs

* fix eslint errors

* remove users from Project.create

* remove users from Project.create in testUtils.ts

* remove projectOwnerId

* replace admin with adminUserId

* Add recurring donation join to donations() endpoint (#1554)

related to #1483

* replace admin with adminUserId in SEED data

* replace admin with adminUserId

* replace admin with adminUserId in projectResolver.ts

* replace admin with adminUserId in projectsTab.ts

* replace admin with adminUserId in projectResolver.test.ts

* replace admin with adminUserId in projectResolver.ts

* add allocatedFundUSD and allocatedTokenSymbol to qfArchivedRounds

* fix nullable

* remove admin from project

* replace admin with adminUserId

* replace admin with adminUserId

* add adminUserId field

* drop admin column

* fix: add telegram to ProjectSocialMediaType enum to allow adding telegram url

* Add some logs

* Fix eslint errors

* Add maxQueuedJobs for draft donation worker

* Fix eslint errors

* fix unstable test case

* Disable concurrency for draft donation worker

* add indexes to project_summary_view (#1568)

* improve projectBySlug query

* fix: change output types to float

* Ignore small differences of amounts when matching draft donation for erc20

* add graphql-fields

* add getVerificationFormStatusByProjectId

* refactor projectBySlug

* add findProjectIdBySlug

* fix projectBySlug tests with new changes

* fix projectBySlug tests with new changes

* fix projectBySlug tests with new changes

* remove projectVerificationForm assert

* add logs

* fix title in should return projects with indicated slug test

* Add streamed mini donations to qf round (#1557)

* Add streamed mini donations to qf round

related to Giveth/giveth-dapps-v2#3284

* Fix eslint error

* Fix eslint errors

* make verificationFormStatus field public

* Reduce test runnning time (#1574)

* fix: reduce test runnning time

* fix: add permissions test case

* fix: add permissions test case

* fix: refactor (excluding permissions test cases from global beforeEach)

---------

Co-authored-by: Ramin <raminramazanpour@gmail.com>
Co-authored-by: Meriem-BM <barhoumi.meriem1@gmail.com>
Co-authored-by: CarlosQ96 <92376054+CarlosQ96@users.noreply.github.com>
Co-authored-by: Amin Latifi <a.latifi.al@gmail.com>
Co-authored-by: Carlos <carlos.quintero096@gmail.com>

* WIP add base network

* Continue on integrating with base chain

* Fix migrations

* Fix migrations

* Add test cases about filteriing base network

* Add BASE node http urls for rpc

* Add BASE node http urls for rpc

* Add missing things for integrating with base

* Fix creating new token with coingeckoId

related to #1564

* Fill base mainnet tokens

related to #1561

* add coingeckoId to BASE_SEPOLIA

---------

Co-authored-by: mohammadranjbarz <mranjbar.z2993@gmail.com>
Co-authored-by: Ramin <raminramazanpour@gmail.com>
Co-authored-by: CarlosQ96 <92376054+CarlosQ96@users.noreply.github.com>
Co-authored-by: Amin Latifi <a.latifi.al@gmail.com>
Co-authored-by: Carlos <carlos.quintero096@gmail.com>
Co-authored-by: Meriem-B <135605616+Meriem-B@users.noreply.github.com>
@laurenluz
Copy link
Member

@maryjaf @mohammadranjbarz - what's the status on here? is ashley able to pull this givbacks data yet for review?

mohammadranjbarz added a commit that referenced this issue Jun 2, 2024
* add activeQfRoundId to sortingBy InstantBoosting

* add orderBy totalDonations and totalReactions

* feat: add getRecurringDonationStats resolver

* fix filtering by QF

* remove qfRounds joins for non qf round filters

* add some temp logs

* remove temp logs

* fix: changes test cases of recuring donations stats
- create recored with createdAt field in past so test result won't be related to other endpoints test cases

* Fix projectActualserviceView

* fix stream balance depleted issue (#1496)

Co-authored-by: mohammadranjbarz <mranjbar.z2993@gmail.com>

* rebuild

* refresh and fetch user address separately (#1499)

* Added pg_trgm extension migration (#1502)

* fix: change recurring donations stats query to single query

* fix recurring donation count

* WIP: projectIds textArea

* fix actual matching cap (#1507)

* fix query error

* fix user donations count

* fix recurring donation count tests

* fix user recurring donation query

* fix user recurring donation test

* add donations relation to qfround

* add findArchivedQfRounds endpoint

* add findArchivedQfRounds endpoint

* feat: add sponsors & banner images upload

* add sortBy to findArchivedQfRounds

* 1.23.3

* add new test graphql query

* add tests for new QfArchivedRounds

* fixes on qfArchivedRounds query

* add new tests for qfArchivedRounds query

* fix findArchivedQfRounds tests

* fix: keep already uploaded sponsors images

* fix skip and limit for findArchivedQfRounds

* Add logs and refactor the bootstrap code to help investigate latency problem

* Add poolSize to orm config

* Fix eslint errors

* remove changing squareRootSumOfProjects when cap is overflown

* Trigger ortto activity when user saves their profile info for the first time (#1520)

* add newUser to updateUser query

* add createOrttoProfile

* add createOrttoProfile to NotificationAdapterInterface

* add createOrttoProfile to MockNotificationAdapter

* add CREATE_ORTTO_PROFILE event

* Allow to set the matching pool token & amount to be something other than usd (#1517)

* Allow to set the matching pool token & amount to be something other than USD in adminjs

* Allow to set the matching pool token & amount to be something other than USD in QFRound table

* add null to allocatedTokenSymbol and allocatedTokenChainId

* add nullable true to allocatedTokenSymbol and allocatedTokenChainId

* add allocatedFundUSDPreferred and allocatedFundUSD to qfRound

* Comment migrations

* Hotfix db improvements (#1523)

* add extra configurations for postgresql connections

* add master and slave replication strategy for typeorm

* add qfRound to qfRoundStats

* fix qfRoundStatsQuery

* Hotfix staging fix latency (#1528)

* add project donation summary view entity

* convert projectQueries to querybuilder

* add cache to projectDonationSummary queries

* add configurable cache to slow queries

* remove massive recurring donation log

* add await for project queries

* Add logs to projectVerificationForm

* Add logs to projectVerificationForm

* fix: add project Ids list textarea for qf round edit

* Master to staging (#1543)

* Hotfix db improvements (#1523) (#1524)

* add extra configurations for postgresql connections

* add master and slave replication strategy for typeorm

Co-authored-by: CarlosQ96 <92376054+CarlosQ96@users.noreply.github.com>

* Fix/db replica production (#1525)

* Hotfix db improvements (#1523)

* add extra configurations for postgresql connections

* add master and slave replication strategy for typeorm

* Define db read only configs

---------

Co-authored-by: CarlosQ96 <92376054+CarlosQ96@users.noreply.github.com>

* update comment

* Hotfix latency issues for prod (#1529)

* Hotfix staging fix latency (#1528)

* add project donation summary view entity

* convert projectQueries to querybuilder

* add cache to projectDonationSummary queries

* add configurable cache to slow queries

* remove massive recurring donation log

* add await for project queries

* Add informative logs for draft donation service job (#1537)

* Fix eslint errors

* Fix/master test (#1541)

* Fixed master test issue

* Returned test to master pipeline

* Comment executing donation summary view

---------

Co-authored-by: Mohammad Ranjbar Z <mranjbar.z2993@gmail.com>

---------

Co-authored-by: CarlosQ96 <92376054+CarlosQ96@users.noreply.github.com>
Co-authored-by: Carlos <carlos.quintero096@gmail.com>
Co-authored-by: mohammadranjbarz <mranjbar.z2993@gmail.com>

* Fix/word similarity - staging (#1546)

* Hotfix db improvements (#1523) (#1524)

* add extra configurations for postgresql connections

* add master and slave replication strategy for typeorm

Co-authored-by: CarlosQ96 <92376054+CarlosQ96@users.noreply.github.com>

* Fix/db replica production (#1525)

* Hotfix db improvements (#1523)

* add extra configurations for postgresql connections

* add master and slave replication strategy for typeorm

* Define db read only configs

---------

Co-authored-by: CarlosQ96 <92376054+CarlosQ96@users.noreply.github.com>

* update comment

* Hotfix latency issues for prod (#1529)

* Hotfix staging fix latency (#1528)

* add project donation summary view entity

* convert projectQueries to querybuilder

* add cache to projectDonationSummary queries

* add configurable cache to slow queries

* remove massive recurring donation log

* add await for project queries

* Add informative logs for draft donation service job (#1537)

* Fix eslint errors

* Fix/master test (#1541)

* Fixed master test issue

* Returned test to master pipeline

* Comment executing donation summary view

---------

Co-authored-by: Mohammad Ranjbar Z <mranjbar.z2993@gmail.com>

* Fixed word similarity issue

* Removed unused import

---------

Co-authored-by: CarlosQ96 <92376054+CarlosQ96@users.noreply.github.com>
Co-authored-by: Carlos <carlos.quintero096@gmail.com>
Co-authored-by: mohammadranjbarz <mranjbar.z2993@gmail.com>

* remove refresh_project_summary_from totals and add user cache (#1539)

* Remove users field from project

* Remove users field from filterProjectsQuery

* Remove projects field from user

* remove added logs

* fix eslint errors

* remove users from Project.create

* remove users from Project.create in testUtils.ts

* remove projectOwnerId

* replace admin with adminUserId

* Add recurring donation join to donations() endpoint (#1554)

related to #1483

* replace admin with adminUserId in SEED data

* replace admin with adminUserId

* replace admin with adminUserId in projectResolver.ts

* replace admin with adminUserId in projectsTab.ts

* replace admin with adminUserId in projectResolver.test.ts

* replace admin with adminUserId in projectResolver.ts

* add allocatedFundUSD and allocatedTokenSymbol to qfArchivedRounds

* fix nullable

* remove admin from project

* replace admin with adminUserId

* replace admin with adminUserId

* add adminUserId field

* drop admin column

* Implementing read-only node replica in local

* fix: add telegram to ProjectSocialMediaType enum to allow adding telegram url

* Add some logs

* Fix eslint errors

* Add maxQueuedJobs for draft donation worker

* Fix eslint errors

* fix unstable test case

* Disable concurrency for draft donation worker

* add indexes to project_summary_view (#1568)

* improve projectBySlug query

* fix: change output types to float

* Ignore small differences of amounts when matching draft donation for erc20

* add graphql-fields

* add getVerificationFormStatusByProjectId

* refactor projectBySlug

* add findProjectIdBySlug

* fix projectBySlug tests with new changes

* fix projectBySlug tests with new changes

* fix projectBySlug tests with new changes

* remove projectVerificationForm assert

* add logs

* fix title in should return projects with indicated slug test

* Add streamed mini donations to qf round (#1557)

* Add streamed mini donations to qf round

related to Giveth/giveth-dapps-v2#3284

* Fix eslint error

* Fix eslint errors

* make verificationFormStatus field public

* Reduce test runnning time (#1574)

* fix: reduce test runnning time

* fix: add permissions test case

* fix: add permissions test case

* fix: refactor (excluding permissions test cases from global beforeEach)

* add migration and columns for totals in project entity (#1571)

* add migration and columns for totals in project entity

* add service to update project totals

* add filling the value for new fields

* WIP add base network

* add word similarity to search

* fix word similarity test case

* add defaultMode to replication

* Continue on integrating with base chain

* Fix migrations

* Fix migrations

* optimize projectById

* add passport score to streams minidonations

* Add methods for adding matching to totals usd received (#1582)

* add methods for adding matching to totals usd received

* Update src/repositories/qfRoundHistoryRepository.ts

Co-authored-by: coderabbitai[bot] <136622811+coderabbitai[bot]@users.noreply.github.com>

---------

Co-authored-by: mohammadranjbarz <mranjbar.z2993@gmail.com>
Co-authored-by: coderabbitai[bot] <136622811+coderabbitai[bot]@users.noreply.github.com>

* add coalesce to get 0 always incase null total matching

* Add test cases about filteriing base network

* Add BASE node http urls for rpc

* Add BASE node http urls for rpc

* Add missing things for integrating with base

* merge stage

* Limit characters of each cell to less than 5000 characters

* Fix eslint errors

* Fix creating new token with coingeckoId

related to #1564

* Fill base mainnet tokens

related to #1561

* optimize qfRounds query

* Add base chain (#1579)

* Ignore small differences of amounts when matching draft donation for … (#1573)

* Ignore small differences of amounts when matching draft donation for erc20

* Fix eslint errors

* Release Integrate QF with super fluid streamed donations (#1555)

* add activeQfRoundId to sortingBy InstantBoosting

* add orderBy totalDonations and totalReactions

* feat: add getRecurringDonationStats resolver

* fix filtering by QF

* remove qfRounds joins for non qf round filters

* add some temp logs

* remove temp logs

* fix: changes test cases of recuring donations stats
- create recored with createdAt field in past so test result won't be related to other endpoints test cases

* Fix projectActualserviceView

* fix stream balance depleted issue (#1496)

Co-authored-by: mohammadranjbarz <mranjbar.z2993@gmail.com>

* rebuild

* refresh and fetch user address separately (#1499)

* Added pg_trgm extension migration (#1502)

* fix: change recurring donations stats query to single query

* fix recurring donation count

* WIP: projectIds textArea

* fix actual matching cap (#1507)

* fix query error

* fix user donations count

* fix recurring donation count tests

* fix user recurring donation query

* fix user recurring donation test

* add donations relation to qfround

* add findArchivedQfRounds endpoint

* add findArchivedQfRounds endpoint

* feat: add sponsors & banner images upload

* add sortBy to findArchivedQfRounds

* 1.23.3

* add new test graphql query

* add tests for new QfArchivedRounds

* fixes on qfArchivedRounds query

* add new tests for qfArchivedRounds query

* fix findArchivedQfRounds tests

* fix: keep already uploaded sponsors images

* fix skip and limit for findArchivedQfRounds

* Add logs and refactor the bootstrap code to help investigate latency problem

* Add poolSize to orm config

* Fix eslint errors

* remove changing squareRootSumOfProjects when cap is overflown

* Trigger ortto activity when user saves their profile info for the first time (#1520)

* add newUser to updateUser query

* add createOrttoProfile

* add createOrttoProfile to NotificationAdapterInterface

* add createOrttoProfile to MockNotificationAdapter

* add CREATE_ORTTO_PROFILE event

* Allow to set the matching pool token & amount to be something other than usd (#1517)

* Allow to set the matching pool token & amount to be something other than USD in adminjs

* Allow to set the matching pool token & amount to be something other than USD in QFRound table

* add null to allocatedTokenSymbol and allocatedTokenChainId

* add nullable true to allocatedTokenSymbol and allocatedTokenChainId

* add allocatedFundUSDPreferred and allocatedFundUSD to qfRound

* Comment migrations

* Hotfix db improvements (#1523)

* add extra configurations for postgresql connections

* add master and slave replication strategy for typeorm

* add qfRound to qfRoundStats

* fix qfRoundStatsQuery

* Hotfix staging fix latency (#1528)

* add project donation summary view entity

* convert projectQueries to querybuilder

* add cache to projectDonationSummary queries

* add configurable cache to slow queries

* remove massive recurring donation log

* add await for project queries

* Add logs to projectVerificationForm

* Add logs to projectVerificationForm

* fix: add project Ids list textarea for qf round edit

* Master to staging (#1543)

* Hotfix db improvements (#1523) (#1524)

* add extra configurations for postgresql connections

* add master and slave replication strategy for typeorm

Co-authored-by: CarlosQ96 <92376054+CarlosQ96@users.noreply.github.com>

* Fix/db replica production (#1525)

* Hotfix db improvements (#1523)

* add extra configurations for postgresql connections

* add master and slave replication strategy for typeorm

* Define db read only configs

---------

Co-authored-by: CarlosQ96 <92376054+CarlosQ96@users.noreply.github.com>

* update comment

* Hotfix latency issues for prod (#1529)

* Hotfix staging fix latency (#1528)

* add project donation summary view entity

* convert projectQueries to querybuilder

* add cache to projectDonationSummary queries

* add configurable cache to slow queries

* remove massive recurring donation log

* add await for project queries

* Add informative logs for draft donation service job (#1537)

* Fix eslint errors

* Fix/master test (#1541)

* Fixed master test issue

* Returned test to master pipeline

* Comment executing donation summary view

---------

Co-authored-by: Mohammad Ranjbar Z <mranjbar.z2993@gmail.com>

---------

Co-authored-by: CarlosQ96 <92376054+CarlosQ96@users.noreply.github.com>
Co-authored-by: Carlos <carlos.quintero096@gmail.com>
Co-authored-by: mohammadranjbarz <mranjbar.z2993@gmail.com>

* Fix/word similarity - staging (#1546)

* Hotfix db improvements (#1523) (#1524)

* add extra configurations for postgresql connections

* add master and slave replication strategy for typeorm

Co-authored-by: CarlosQ96 <92376054+CarlosQ96@users.noreply.github.com>

* Fix/db replica production (#1525)

* Hotfix db improvements (#1523)

* add extra configurations for postgresql connections

* add master and slave replication strategy for typeorm

* Define db read only configs

---------

Co-authored-by: CarlosQ96 <92376054+CarlosQ96@users.noreply.github.com>

* update comment

* Hotfix latency issues for prod (#1529)

* Hotfix staging fix latency (#1528)

* add project donation summary view entity

* convert projectQueries to querybuilder

* add cache to projectDonationSummary queries

* add configurable cache to slow queries

* remove massive recurring donation log

* add await for project queries

* Add informative logs for draft donation service job (#1537)

* Fix eslint errors

* Fix/master test (#1541)

* Fixed master test issue

* Returned test to master pipeline

* Comment executing donation summary view

---------

Co-authored-by: Mohammad Ranjbar Z <mranjbar.z2993@gmail.com>

* Fixed word similarity issue

* Removed unused import

---------

Co-authored-by: CarlosQ96 <92376054+CarlosQ96@users.noreply.github.com>
Co-authored-by: Carlos <carlos.quintero096@gmail.com>
Co-authored-by: mohammadranjbarz <mranjbar.z2993@gmail.com>

* remove refresh_project_summary_from totals and add user cache (#1539)

* Remove users field from project

* Remove users field from filterProjectsQuery

* Remove projects field from user

* remove added logs

* fix eslint errors

* remove users from Project.create

* remove users from Project.create in testUtils.ts

* remove projectOwnerId

* replace admin with adminUserId

* Add recurring donation join to donations() endpoint (#1554)

related to #1483

* replace admin with adminUserId in SEED data

* replace admin with adminUserId

* replace admin with adminUserId in projectResolver.ts

* replace admin with adminUserId in projectsTab.ts

* replace admin with adminUserId in projectResolver.test.ts

* replace admin with adminUserId in projectResolver.ts

* add allocatedFundUSD and allocatedTokenSymbol to qfArchivedRounds

* fix nullable

* remove admin from project

* replace admin with adminUserId

* replace admin with adminUserId

* add adminUserId field

* drop admin column

* fix: add telegram to ProjectSocialMediaType enum to allow adding telegram url

* Add some logs

* Fix eslint errors

* Add maxQueuedJobs for draft donation worker

* Fix eslint errors

* fix unstable test case

* Disable concurrency for draft donation worker

* add indexes to project_summary_view (#1568)

* improve projectBySlug query

* fix: change output types to float

* Ignore small differences of amounts when matching draft donation for erc20

* add graphql-fields

* add getVerificationFormStatusByProjectId

* refactor projectBySlug

* add findProjectIdBySlug

* fix projectBySlug tests with new changes

* fix projectBySlug tests with new changes

* fix projectBySlug tests with new changes

* remove projectVerificationForm assert

* add logs

* fix title in should return projects with indicated slug test

* Add streamed mini donations to qf round (#1557)

* Add streamed mini donations to qf round

related to Giveth/giveth-dapps-v2#3284

* Fix eslint error

* Fix eslint errors

* make verificationFormStatus field public

* Reduce test runnning time (#1574)

* fix: reduce test runnning time

* fix: add permissions test case

* fix: add permissions test case

* fix: refactor (excluding permissions test cases from global beforeEach)

---------

Co-authored-by: Ramin <raminramazanpour@gmail.com>
Co-authored-by: Meriem-BM <barhoumi.meriem1@gmail.com>
Co-authored-by: CarlosQ96 <92376054+CarlosQ96@users.noreply.github.com>
Co-authored-by: Amin Latifi <a.latifi.al@gmail.com>
Co-authored-by: Carlos <carlos.quintero096@gmail.com>

* WIP add base network

* Continue on integrating with base chain

* Fix migrations

* Fix migrations

* Add test cases about filteriing base network

* Add BASE node http urls for rpc

* Add BASE node http urls for rpc

* Add missing things for integrating with base

* Fix creating new token with coingeckoId

related to #1564

* Fill base mainnet tokens

related to #1561

---------

Co-authored-by: Ramin <raminramazanpour@gmail.com>
Co-authored-by: Meriem-BM <barhoumi.meriem1@gmail.com>
Co-authored-by: CarlosQ96 <92376054+CarlosQ96@users.noreply.github.com>
Co-authored-by: Amin Latifi <a.latifi.al@gmail.com>
Co-authored-by: Carlos <carlos.quintero096@gmail.com>

* Add coingeckoId to BASE_SEPOLIA (#1592)

* Ignore small differences of amounts when matching draft donation for … (#1573)

* Ignore small differences of amounts when matching draft donation for erc20

* Fix eslint errors

* Release Integrate QF with super fluid streamed donations (#1555)

* add activeQfRoundId to sortingBy InstantBoosting

* add orderBy totalDonations and totalReactions

* feat: add getRecurringDonationStats resolver

* fix filtering by QF

* remove qfRounds joins for non qf round filters

* add some temp logs

* remove temp logs

* fix: changes test cases of recuring donations stats
- create recored with createdAt field in past so test result won't be related to other endpoints test cases

* Fix projectActualserviceView

* fix stream balance depleted issue (#1496)

Co-authored-by: mohammadranjbarz <mranjbar.z2993@gmail.com>

* rebuild

* refresh and fetch user address separately (#1499)

* Added pg_trgm extension migration (#1502)

* fix: change recurring donations stats query to single query

* fix recurring donation count

* WIP: projectIds textArea

* fix actual matching cap (#1507)

* fix query error

* fix user donations count

* fix recurring donation count tests

* fix user recurring donation query

* fix user recurring donation test

* add donations relation to qfround

* add findArchivedQfRounds endpoint

* add findArchivedQfRounds endpoint

* feat: add sponsors & banner images upload

* add sortBy to findArchivedQfRounds

* 1.23.3

* add new test graphql query

* add tests for new QfArchivedRounds

* fixes on qfArchivedRounds query

* add new tests for qfArchivedRounds query

* fix findArchivedQfRounds tests

* fix: keep already uploaded sponsors images

* fix skip and limit for findArchivedQfRounds

* Add logs and refactor the bootstrap code to help investigate latency problem

* Add poolSize to orm config

* Fix eslint errors

* remove changing squareRootSumOfProjects when cap is overflown

* Trigger ortto activity when user saves their profile info for the first time (#1520)

* add newUser to updateUser query

* add createOrttoProfile

* add createOrttoProfile to NotificationAdapterInterface

* add createOrttoProfile to MockNotificationAdapter

* add CREATE_ORTTO_PROFILE event

* Allow to set the matching pool token & amount to be something other than usd (#1517)

* Allow to set the matching pool token & amount to be something other than USD in adminjs

* Allow to set the matching pool token & amount to be something other than USD in QFRound table

* add null to allocatedTokenSymbol and allocatedTokenChainId

* add nullable true to allocatedTokenSymbol and allocatedTokenChainId

* add allocatedFundUSDPreferred and allocatedFundUSD to qfRound

* Comment migrations

* Hotfix db improvements (#1523)

* add extra configurations for postgresql connections

* add master and slave replication strategy for typeorm

* add qfRound to qfRoundStats

* fix qfRoundStatsQuery

* Hotfix staging fix latency (#1528)

* add project donation summary view entity

* convert projectQueries to querybuilder

* add cache to projectDonationSummary queries

* add configurable cache to slow queries

* remove massive recurring donation log

* add await for project queries

* Add logs to projectVerificationForm

* Add logs to projectVerificationForm

* fix: add project Ids list textarea for qf round edit

* Master to staging (#1543)

* Hotfix db improvements (#1523) (#1524)

* add extra configurations for postgresql connections

* add master and slave replication strategy for typeorm

Co-authored-by: CarlosQ96 <92376054+CarlosQ96@users.noreply.github.com>

* Fix/db replica production (#1525)

* Hotfix db improvements (#1523)

* add extra configurations for postgresql connections

* add master and slave replication strategy for typeorm

* Define db read only configs

---------

Co-authored-by: CarlosQ96 <92376054+CarlosQ96@users.noreply.github.com>

* update comment

* Hotfix latency issues for prod (#1529)

* Hotfix staging fix latency (#1528)

* add project donation summary view entity

* convert projectQueries to querybuilder

* add cache to projectDonationSummary queries

* add configurable cache to slow queries

* remove massive recurring donation log

* add await for project queries

* Add informative logs for draft donation service job (#1537)

* Fix eslint errors

* Fix/master test (#1541)

* Fixed master test issue

* Returned test to master pipeline

* Comment executing donation summary view

---------

Co-authored-by: Mohammad Ranjbar Z <mranjbar.z2993@gmail.com>

---------

Co-authored-by: CarlosQ96 <92376054+CarlosQ96@users.noreply.github.com>
Co-authored-by: Carlos <carlos.quintero096@gmail.com>
Co-authored-by: mohammadranjbarz <mranjbar.z2993@gmail.com>

* Fix/word similarity - staging (#1546)

* Hotfix db improvements (#1523) (#1524)

* add extra configurations for postgresql connections

* add master and slave replication strategy for typeorm

Co-authored-by: CarlosQ96 <92376054+CarlosQ96@users.noreply.github.com>

* Fix/db replica production (#1525)

* Hotfix db improvements (#1523)

* add extra configurations for postgresql connections

* add master and slave replication strategy for typeorm

* Define db read only configs

---------

Co-authored-by: CarlosQ96 <92376054+CarlosQ96@users.noreply.github.com>

* update comment

* Hotfix latency issues for prod (#1529)

* Hotfix staging fix latency (#1528)

* add project donation summary view entity

* convert projectQueries to querybuilder

* add cache to projectDonationSummary queries

* add configurable cache to slow queries

* remove massive recurring donation log

* add await for project queries

* Add informative logs for draft donation service job (#1537)

* Fix eslint errors

* Fix/master test (#1541)

* Fixed master test issue

* Returned test to master pipeline

* Comment executing donation summary view

---------

Co-authored-by: Mohammad Ranjbar Z <mranjbar.z2993@gmail.com>

* Fixed word similarity issue

* Removed unused import

---------

Co-authored-by: CarlosQ96 <92376054+CarlosQ96@users.noreply.github.com>
Co-authored-by: Carlos <carlos.quintero096@gmail.com>
Co-authored-by: mohammadranjbarz <mranjbar.z2993@gmail.com>

* remove refresh_project_summary_from totals and add user cache (#1539)

* Remove users field from project

* Remove users field from filterProjectsQuery

* Remove projects field from user

* remove added logs

* fix eslint errors

* remove users from Project.create

* remove users from Project.create in testUtils.ts

* remove projectOwnerId

* replace admin with adminUserId

* Add recurring donation join to donations() endpoint (#1554)

related to #1483

* replace admin with adminUserId in SEED data

* replace admin with adminUserId

* replace admin with adminUserId in projectResolver.ts

* replace admin with adminUserId in projectsTab.ts

* replace admin with adminUserId in projectResolver.test.ts

* replace admin with adminUserId in projectResolver.ts

* add allocatedFundUSD and allocatedTokenSymbol to qfArchivedRounds

* fix nullable

* remove admin from project

* replace admin with adminUserId

* replace admin with adminUserId

* add adminUserId field

* drop admin column

* fix: add telegram to ProjectSocialMediaType enum to allow adding telegram url

* Add some logs

* Fix eslint errors

* Add maxQueuedJobs for draft donation worker

* Fix eslint errors

* fix unstable test case

* Disable concurrency for draft donation worker

* add indexes to project_summary_view (#1568)

* improve projectBySlug query

* fix: change output types to float

* Ignore small differences of amounts when matching draft donation for erc20

* add graphql-fields

* add getVerificationFormStatusByProjectId

* refactor projectBySlug

* add findProjectIdBySlug

* fix projectBySlug tests with new changes

* fix projectBySlug tests with new changes

* fix projectBySlug tests with new changes

* remove projectVerificationForm assert

* add logs

* fix title in should return projects with indicated slug test

* Add streamed mini donations to qf round (#1557)

* Add streamed mini donations to qf round

related to Giveth/giveth-dapps-v2#3284

* Fix eslint error

* Fix eslint errors

* make verificationFormStatus field public

* Reduce test runnning time (#1574)

* fix: reduce test runnning time

* fix: add permissions test case

* fix: add permissions test case

* fix: refactor (excluding permissions test cases from global beforeEach)

---------

Co-authored-by: Ramin <raminramazanpour@gmail.com>
Co-authored-by: Meriem-BM <barhoumi.meriem1@gmail.com>
Co-authored-by: CarlosQ96 <92376054+CarlosQ96@users.noreply.github.com>
Co-authored-by: Amin Latifi <a.latifi.al@gmail.com>
Co-authored-by: Carlos <carlos.quintero096@gmail.com>

* WIP add base network

* Continue on integrating with base chain

* Fix migrations

* Fix migrations

* Add test cases about filteriing base network

* Add BASE node http urls for rpc

* Add BASE node http urls for rpc

* Add missing things for integrating with base

* Fix creating new token with coingeckoId

related to #1564

* Fill base mainnet tokens

related to #1561

* add coingeckoId to BASE_SEPOLIA

---------

Co-authored-by: mohammadranjbarz <mranjbar.z2993@gmail.com>
Co-authored-by: Ramin <raminramazanpour@gmail.com>
Co-authored-by: CarlosQ96 <92376054+CarlosQ96@users.noreply.github.com>
Co-authored-by: Amin Latifi <a.latifi.al@gmail.com>
Co-authored-by: Carlos <carlos.quintero096@gmail.com>
Co-authored-by: Meriem-B <135605616+Meriem-B@users.noreply.github.com>

* Deleting redis

* sync all donations totals (#1594)

* sync all donations totals

* add update qfroundmatching

* Add coingeckoId for BASE ETH

* Changee isGivbaclEligble of base chain tokens to false

---------

Co-authored-by: Ramin <raminramazanpour@gmail.com>
Co-authored-by: Meriem-BM <barhoumi.meriem1@gmail.com>
Co-authored-by: Mohammad Ranjbar Z <mranjbar.z2993@gmail.com>
Co-authored-by: Amin Latifi <a.latifi.al@gmail.com>
Co-authored-by: Rolazo <nicobaena96@gmail.com>
Co-authored-by: coderabbitai[bot] <136622811+coderabbitai[bot]@users.noreply.github.com>
Co-authored-by: Meriem-B <135605616+Meriem-B@users.noreply.github.com>
Co-authored-by: Nicolas <38561963+Rolazo@users.noreply.github.com>
@jainkrati
Copy link
Collaborator

@maryjaf @mohammadranjbarz pls close this issue, if not already done

@WhyldWanderer
Copy link

I have pulled the data needed for the GIVbacks rounds and it seems that we are now showing recurring donations!!
Woohoo!

Hard to tell if they were all included or if we missed some but I do see that they are showing in the data now.
Thanks!

@divine-comedian
Copy link
Collaborator Author

Okay, is there anyway to verify the rest of the acceptance criteria I've posted above?

@maryjaf
Copy link
Collaborator

maryjaf commented Jun 9, 2024

and please take a look on this Tx @mohammadranjbarz
-I donated to a project(recurring donation)
-but I didn't see this tx in response of get_eligible_donations
0xc643e72a324241c2348842f2db266df42c38a5a37de00d46e1a66a9f2c08bbdc

also for this donation: 0x1bbdd9cab93c5f14b8551584e33278fca01d01ed394af6dcad5396a4567649a2 https://staging.giveth.io/project/mejan?tab=donations image

I've checked with @mohammadranjbarz and this link https://givback.develop.giveth.io/api-docs/ returns the data of production not stg
Could you please check it @mhmdksh

@maryjaf
Copy link
Collaborator

maryjaf commented Jun 11, 2024

I've checked with @mohammadranjbarz and this link https://givback.develop.giveth.io/api-docs/ returns the data of production not stg
Could you please check it @mhmdksh

I checked givback for recurring donation on production link https://givbacks.giveth.io/api-docs/ and it seems everything is fine,
but this problem on stg should be fixed by devops team.
this link https://givback.develop.giveth.io/api-docs/ returns the data of production not stg

@jainkrati
Copy link
Collaborator

@mhmdksh could you please help

@mhmdksh
Copy link
Collaborator

mhmdksh commented Jun 19, 2024

I've checked with @mohammadranjbarz and this link https://givback.develop.giveth.io/api-docs/ returns the data of production not stg
Could you please check it @mhmdksh

I checked givback for recurring donation on production link https://givbacks.giveth.io/api-docs/ and it seems everything is fine, but this problem on stg should be fixed by devops team. this link https://givback.develop.giveth.io/api-docs/ returns the data of production not stg

@maryjaf @jainkrati I'll be taking a look today

@divine-comedian
Copy link
Collaborator Author

@mhmdksh - What is the update please? Can we test?

@mhmdksh
Copy link
Collaborator

mhmdksh commented Jun 26, 2024

@divine-comedian @maryjaf There was a misconfig on the staging givback calculation service we changed the below two values:

GIVETHIO_BASE_URL=https://impact-graph.serve.giveth.io
GIVETHIO_DAPP_URL=https://staging.giveth.io

It should be returning the right info now, @maryjaf Can you confirm please

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
Status: Done
Development

No branches or pull requests

9 participants