Skip to content
This repository has been archived by the owner on Sep 19, 2024. It is now read-only.

Credits Table Schema #810

Closed
Tracked by #787
0x4007 opened this issue Sep 23, 2023 · 15 comments · Fixed by #644
Closed
Tracked by #787

Credits Table Schema #810

0x4007 opened this issue Sep 23, 2023 · 15 comments · Fixed by #644

Comments

@0x4007
Copy link
Member

0x4007 commented Sep 23, 2023

Credits

Represents credit entries. Each entry may or may not be linked to a permit.

Field Type Description Example Value
id int8 Unique identifier for the credit entry. 999
created timestamptz Timestamp when the credit was created. 2023-09-15T11:20:23.004Z
updated timestamptz Timestamp when the credit was last updated. 2023-09-15T11:22:40.050Z
amount int8 Amount of the credit. 150000000000000000000
permitId int8 Foreign key to the Permits table (if applicable). 101
@GaryThisSidee
Copy link

/start

@ubiquibot
Copy link

ubiquibot bot commented Sep 25, 2023

Too many assigned issues, you have reached your max of 2

@GaryThisSidee
Copy link

/start

@ubiquibot
Copy link

ubiquibot bot commented Oct 8, 2023

Deadline Sun, 08 Oct 2023 21:20:27 UTC
Registered Wallet 0x2bBc6a8314044d70684C74CfA0E117eb75E3708c
Tips:
  • Use /wallet 0x0000...0000 if you want to update your registered payment wallet address @user.
  • Be sure to open a draft pull request as soon as possible to communicate updates on your progress.
  • Be sure to provide timely updates to us when requested, or you will be automatically unassigned from the bounty.

    @ubiquibot
    Copy link

    ubiquibot bot commented Oct 13, 2023

    Do you have any updates @GaryThisSidee? If you would like to release the bounty back to the DevPool, please comment /stop
    Last activity time: Mon Oct 09 2023 13:26:17 GMT+0000 (Coordinated Universal Time)

    @0x4007 0x4007 linked a pull request Oct 16, 2023 that will close this issue
    @ubiquibot
    Copy link

    ubiquibot bot commented Oct 16, 2023

    @GaryThisSidee - Releasing the bounty back to dev pool because the allocated duration already ended!
    Last activity time: Mon Oct 09 2023 13:26:17 GMT+0000 (Coordinated Universal Time)

    @0x4007 0x4007 self-assigned this Oct 19, 2023
    @ubiquibot
    Copy link

    ubiquibot bot commented Oct 19, 2023

    @pavlovcik The time limit for this bounty is on Thu, 19 Oct 2023 06:45:40 UTC

    @ubiquibot
    Copy link

    ubiquibot bot commented Oct 19, 2023

    These linked pull requests are closed: #851

    @ubiquibot ubiquibot bot unassigned 0x4007 Oct 19, 2023
    @ubiquibot
    Copy link

    ubiquibot bot commented Oct 19, 2023

    @pavlovcik - Releasing the bounty back to dev pool because the allocated duration already ended!
    Last activity time: Sat Sep 23 2023 13:38:57 GMT+0000 (Coordinated Universal Time)

    @ubiquibot
    Copy link

    ubiquibot bot commented Oct 19, 2023

    These linked pull requests are closed: #851

    @ubiquibot
    Copy link

    ubiquibot bot commented Oct 19, 2023

    @pavlovcik - Releasing the bounty back to dev pool because the allocated duration already ended!
    Last activity time: Sat Sep 23 2023 13:38:57 GMT+0000 (Coordinated Universal Time)

    Copy link

    ubiquibot bot commented Feb 17, 2024

    + Evaluating results. Please wait...

    @0x4007 0x4007 self-assigned this Feb 17, 2024
    Copy link

    ubiquibot bot commented Feb 17, 2024

    @pavlovcik the deadline is at 2024-02-17T12:34:53.811Z

    @0x4007 0x4007 reopened this Feb 19, 2024
    @0x4007 0x4007 closed this as completed Feb 19, 2024
    Copy link

    ubiquibot bot commented Feb 19, 2024

    + Evaluating results. Please wait...

    Copy link

    ubiquibot bot commented Feb 19, 2024

    [ 320 WXDAI ]

    @pavlovcik
    Contributions Overview
    ViewContributionCountReward
    IssueSpecification141
    IssueTask1.00112.5
    ReviewComment13111
    ReviewComment1355.5
    Conversation Incentives
    CommentFormattingRelevanceReward
    ## **Credits**

    Represents credit entries. Each entry may or m...

    41

    h2:
      count: 1
      score: "1"
      words: 3
    code:
      count: 5
      score: "5"
      words: 5
    td:
      count: 20
      score: "20"
      words: 66
    
    141
    This should have merged this in weeks ago. The number of outstan...
    18.2-18.2
    @0xcodercrane In this case you should consider just regenerating...
    7.6-7.6
    Don't think it matters the order regarding conflicts but technic...
    3.8-3.8
    Will need to e2e test and merge...
    1.4-1.4
    Review comments at https://github.com/ubiquity/ubiquibot/pull/84...
    2-2
    There are many dimensions of your proposal to consider so it's h...
    16.8-16.8
    This should work on personal accounts (not just organizations) a...
    4.8-4.8
    Notes to self on incentive calculation architecture:
    • work bac...
    9.6
    li:
      count: 2
      score: "4"
      words: 21
    
    -9.6
    I think next week. It feels really close to being done but I'm a...
    5.6-5.6
    @wannacfuture its better that you branch from here instead of pu...
    3.8-3.8
    > I'm trying to use the new version with workflow dispatcher and...
    17
    code:
      count: 1
      score: "2"
      words: 26
    
    -17
    You guys should make sure you're using the same version of Node....
    18.4-18.4
    @gitcoindev maybe you can help fix the knip CI here...
    2-2
    This should have merged this in weeks ago. The number of outstan...
    9.1-9.1
    @0xcodercrane In this case you should consider just regenerating...
    3.8-3.8
    Don't think it matters the order regarding conflicts but technic...
    1.9-1.9
    Will need to e2e test and merge...
    0.7-0.7
    Review comments at https://github.com/ubiquity/ubiquibot/pull/84...
    1-1
    There are many dimensions of your proposal to consider so it's h...
    8.4-8.4
    This should work on personal accounts (not just organizations) a...
    2.4-2.4
    Notes to self on incentive calculation architecture:
    • work bac...
    4.8
    li:
      count: 2
      score: "2"
      words: 21
    
    -4.8
    I think next week. It feels really close to being done but I'm a...
    2.8-2.8
    @wannacfuture its better that you branch from here instead of pu...
    1.9-1.9
    > I'm trying to use the new version with workflow dispatcher and...
    8.5
    code:
      count: 1
      score: "1"
      words: 26
    
    -8.5
    You guys should make sure you're using the same version of Node....
    9.2-9.2
    @gitcoindev maybe you can help fix the knip CI here...
    1-1

    [ 0 WXDAI ]

    @BeanieMen
    Contributions Overview
    ViewContributionCountReward
    ReviewComment10
    Conversation Incentives
    CommentFormattingRelevanceReward
    🎉...
    ---

    [ 52.6 WXDAI ]

    @gitcoindev
    Contributions Overview
    ViewContributionCountReward
    ReviewComment752.6
    Conversation Incentives
    CommentFormattingRelevanceReward
    > There also seems to be an issue with ubiquibot-logger > > `...
    9.1
    code:
      count: 4
      score: "4"
      words: 4
    
    -9.1
    > > Hi @whilefoo , the `ubiquibot-logger` is an ESM module https...
    7.3
    code:
      count: 5
      score: "5"
      words: 7
    
    -7.3
    > > > Hi @whilefoo , the `ubiquibot-logger` is an ESM module htt...
    14.9
    code:
      count: 7
      score: "7"
      words: 10
    
    -14.9
    hi @whilefoo I will give this priority and try to fix till Monda...
    1.4-1.4
    @whilefoo I am on v0.3.4 already, so far no luck but closer and ...
    5.2-5.2
    hi @whilefoo could you please check ubiquibot-logger v0.3.5 ? I...
    8.9
    code:
      count: 1
      score: "1"
      words: 6
    
    -8.9
    Btw, about @pavlovcik 's last comment, I agree that we should sy...
    5.8-5.8

    [ 1.6 WXDAI ]

    @0xcodercrane
    Contributions Overview
    ViewContributionCountReward
    ReviewComment11.6
    Conversation Incentives
    CommentFormattingRelevanceReward
    should I merge https://github.com/ubiquity/ubiquibot/pull/643 in...
    1.6-1.6

    [ 0.6 WXDAI ]

    @wannacfuture
    Contributions Overview
    ViewContributionCountReward
    ReviewComment10.6
    Conversation Incentives
    CommentFormattingRelevanceReward
    should I resolve the conflicts? @pavlovcik ...
    0.6-0.6

    [ 139.7 WXDAI ]

    @rndquu
    Contributions Overview
    ViewContributionCountReward
    ReviewComment3139.7
    Conversation Incentives
    CommentFormattingRelevanceReward
    @pavlovcik

    There is the supabase [diff tool](https://supabas...

    42.1

    a:
      count: 4
      score: "4"
      words: 7
    li:
      count: 7
      score: "7"
      words: 110
    code:
      count: 10
      score: "10"
      words: 11
    
    -42.1
    @pavlovcik

    Regarding the locations and metadata.

    This i...

    96

    h2:
      count: 2
      score: "2"
      words: 11
    h3:
      count: 4
      score: "4"
      words: 4
    a:
      count: 2
      score: "2"
      words: 3
    li:
      count: 10
      score: "10"
      words: 170
    code:
      count: 21
      score: "21"
      words: 67
    td:
      count: 16
      score: "16"
      words: 57
    
    -96
    > Alternatively we do the two API calls but there's a good chanc...
    1.6-1.6

    [ 25.4 WXDAI ]

    @whilefoo
    Contributions Overview
    ViewContributionCountReward
    ReviewComment525.4
    Conversation Incentives
    CommentFormattingRelevanceReward
    I'm trying to use the new version with workflow dispatcher and I...
    6.8
    code:
      count: 1
      score: "1"
      words: 26
    
    -6.8
    There also seems to be an issue with ubiquibot-logger
    co...</a></h6></td><td><details><summary>7.9</summary>
    <pre>code:
      count: 1
      score: "1"
      words: 0
    </pre>
    </details></td><td>-</td><td>7.9</td></tr><tr><td><h6><a href="https://github.com/ubiquity/ubiquibot/pull/644#issuecomment-1850189172">> Hi @whilefoo , the `ubiquibot-logger` is an ESM module https:/...</a></h6></td><td><details><summary>8.9</summary>
    <pre>code:
      count: 5
      score: "5"
      words: 7
    </pre>
    </details></td><td>-</td><td>8.9</td></tr><tr><td><h6><a href="https://github.com/ubiquity/ubiquibot/pull/644#issuecomment-1859155851">> Following the article https://dev.to/tigawanna/building-and-pu...</a></h6></td><td>1.2</td><td>-</td><td>1.2</td></tr><tr><td><h6><a href="https://github.com/ubiquity/ubiquibot/pull/644#issuecomment-1872954224">@gitcoindev it's working now, thanks!...</a></h6></td><td>0.6</td><td>-</td><td>0.6</td></tr></tbody></table>
      </details>
      
    
      <details>
        <summary>
          <b
            ><h3>
              <a
                href="https://pay.ubq.fi/?claim=W3sidHlwZSI6ImVyYzIwLXBlcm1pdCIsInBlcm1pdCI6eyJwZXJtaXR0ZWQiOnsidG9rZW4iOiIweGU5MUQxNTNFMGI0MTUxOEEyQ2U4RGQzRDc5NDRGYTg2MzQ2M2E5N2QiLCJhbW91bnQiOiIzNzAwMDAwMDAwMDAwMDAwMDAwIn0sIm5vbmNlIjoiNjY2NTA3OTA3NDQzMTk1NTk5NzQ0NTEwOTEwMjU2Mjk3OTI3MjIyMjYxNTM3Nzc2NzMxMTA4MDQ2MTIxNTE1Mjc2NjE5NjQzMjEwMjYiLCJkZWFkbGluZSI6IjExNTc5MjA4OTIzNzMxNjE5NTQyMzU3MDk4NTAwODY4NzkwNzg1MzI2OTk4NDY2NTY0MDU2NDAzOTQ1NzU4NDAwNzkxMzEyOTYzOTkzNSJ9LCJ0cmFuc2ZlckRldGFpbHMiOnsidG8iOiIweGM0ZmM2M2Q4OGRkNDExYjE5YWNmODZmYjU2YmE1MDk0MTYxMWIzYTciLCJyZXF1ZXN0ZWRBbW91bnQiOiIzNzAwMDAwMDAwMDAwMDAwMDAwIn0sIm93bmVyIjoiMHg0NENhMTVEYjEwMWZEMWMxOTQ0NjdEYjZBRjBjNjdDNkJiRjRBQjUxIiwic2lnbmF0dXJlIjoiMHgxNDBmMzFmNzgzNmIxNzkwMWNlYThlNzA5ODQyYmQxMzQ4YjhlMjRiOGU2OGMxNzQ4NmU1OTA3NmUwOTUyY2MxNjYyNjA5Yzc2NDRkNzE5MzBhMDMxMThhNWFkZjBjNDhlOTA4ZTRiOTEyYWM4ZmM2ODYyNjU0NTkwMWVhYmZmMjFiIiwibmV0d29ya0lkIjoxMDB9XQ%3D%3D"
              >
                [ 3.7 WXDAI ]</a
              >
            </h3>
            <h6>@EtherealGlow</h6></b
          >
        </summary>
        <h6>Contributions Overview</h6>
    <table><thead>
    <tr><th>View</th><th>Contribution</th><th>Count</th><th>Reward</th>
    </thead><tbody>
    <tr><td>Review</td><td>Comment</td><td>5</td><td>3.7</td></tr>
    </tbody></table>
        <h6>Conversation Incentives</h6><table><thead><tr><th>Comment</th><th>Formatting</th><th>Relevance</th><th>Reward</th></tr></thead><tbody><tr><td><h6><a href="https://github.com/ubiquity/ubiquibot/pull/644#issuecomment-1783856208">I pray for the refactor to be done quickly 🙏...</a></h6></td><td>0.9</td><td>-</td><td>0.9</td></tr><tr><td><h6><a href="https://github.com/ubiquity/ubiquibot/pull/644#issuecomment-1792385039">Do you guys have any estimate on when the refactor will be done ...</a></h6></td><td>1.3</td><td>-</td><td>1.3</td></tr><tr><td><h6><a href="https://github.com/ubiquity/ubiquibot/pull/644#issuecomment-1807904469">Any new estimate for how much time is left?...</a></h6></td><td>0.9</td><td>-</td><td>0.9</td></tr><tr><td><h6><a href="https://github.com/ubiquity/ubiquibot/pull/644#issuecomment-1823077738">🙏...</a></h6></td><td>-</td><td>-</td><td>-</td></tr><tr><td><h6><a href="https://github.com/ubiquity/ubiquibot/pull/644#issuecomment-1840080819">When will the refactor be done 😭...</a></h6></td><td>0.6</td><td>-</td><td>0.6</td></tr></tbody></table>
      </details>
      
    <!-- Ubiquity - Transactions - generatePermits - 6fa67c1
    [
      {
        "permit": {
          "permitted": {
            "token": "0xe91D153E0b41518A2Ce8Dd3D7944Fa863463a97d",
            "amount": "320000000000000000000"
          },
          "nonce": "27749007168237333968126603985158696279675844426910470193221329103974251835759",
          "deadline": "115792089237316195423570985008687907853269984665640564039457584007913129639935"
        },
        "transferDetails": {
          "to": "0x4007CE2083c7F3E18097aeB3A39bb8eC149a341d",
          "requestedAmount": "320000000000000000000"
        },
        "owner": "0x44Ca15Db101fD1c194467Db6AF0c67C6BbF4AB51",
        "signature": "0x2f9ae5dc89cf1191bbfdbb4b505b356796a37d1410109f50e19a49a84a74724773905e2d46eb7bdce6411becc0ccfc2e8d0f6216907704fedb6b52b6f087e44f1b",
        "networkId": 100
      },
      {
        "permit": {
          "permitted": {
            "token": "0xe91D153E0b41518A2Ce8Dd3D7944Fa863463a97d",
            "amount": "0"
          },
          "nonce": "104289937003322649816471209948059830011196273733702737049772246498341315723422",
          "deadline": "115792089237316195423570985008687907853269984665640564039457584007913129639935"
        },
        "transferDetails": {
          "to": "0x24fbA1343132DE969Aeef0B1BD5CaAE1fB102978",
          "requestedAmount": "0"
        },
        "owner": "0x44Ca15Db101fD1c194467Db6AF0c67C6BbF4AB51",
        "signature": "0xb365837ee02dee0df2501ff34ff694e1386b3f81780dfffdafc8bff380fb43df2bdae7e305cfec2ee1f2d502fd03381bff7183b9eb93f07d552d789307f0c8121b",
        "networkId": 100
      },
      {
        "permit": {
          "permitted": {
            "token": "0xe91D153E0b41518A2Ce8Dd3D7944Fa863463a97d",
            "amount": "52600000000000000000"
          },
          "nonce": "111807644867837540986159269278691378815734879102280583227305040671971154635649",
          "deadline": "115792089237316195423570985008687907853269984665640564039457584007913129639935"
        },
        "transferDetails": {
          "to": "0x7e92476D69Ff1377a8b45176b1829C4A5566653a",
          "requestedAmount": "52600000000000000000"
        },
        "owner": "0x44Ca15Db101fD1c194467Db6AF0c67C6BbF4AB51",
        "signature": "0x47f07af2ebd325d9573269506074080bc002134456c8cd6d56bce08b32b118823c943c43e247c26415beddbae44a929e1ea46677357353049a02aa35010ad95a1c",
        "networkId": 100
      },
      {
        "permit": {
          "permitted": {
            "token": "0xe91D153E0b41518A2Ce8Dd3D7944Fa863463a97d",
            "amount": "1600000000000000000"
          },
          "nonce": "70804091454814561040035309607031260804452120916295036662545651615732497370285",
          "deadline": "115792089237316195423570985008687907853269984665640564039457584007913129639935"
        },
        "transferDetails": {
          "to": "0x00868BB3BA2B36316c2fc42E4aFB6D4246b77E46",
          "requestedAmount": "1600000000000000000"
        },
        "owner": "0x44Ca15Db101fD1c194467Db6AF0c67C6BbF4AB51",
        "signature": "0x40e86abec2852f594a445daca8cb6aa165896ebc8f47277efe9eec2cb47958a82bacd11376ab5d762929c43ae4f474e0c37711196a4fe750b48eeb0c8820e1ff1c",
        "networkId": 100
      },
      {
        "permit": {
          "permitted": {
            "token": "0xe91D153E0b41518A2Ce8Dd3D7944Fa863463a97d",
            "amount": "600000000000000000"
          },
          "nonce": "51265331171950124366800056434079139904121490573222396874790836695233783166137",
          "deadline": "115792089237316195423570985008687907853269984665640564039457584007913129639935"
        },
        "transferDetails": {
          "to": "0x9e4ef4353c928cd3eb473e8f12aecf58c208ef40",
          "requestedAmount": "600000000000000000"
        },
        "owner": "0x44Ca15Db101fD1c194467Db6AF0c67C6BbF4AB51",
        "signature": "0x1b9c8cef0c3ad518103f90a9f91238ff13a4695d5db5b7fe1f4efe13e4fb35fc449f951aa0f59742dc145007d8b0124b05f856846c217a9f41356dd0879879d61b",
        "networkId": 100
      },
      {
        "permit": {
          "permitted": {
            "token": "0xe91D153E0b41518A2Ce8Dd3D7944Fa863463a97d",
            "amount": "139700000000000000000"
          },
          "nonce": "87857632748303657012025142301555110113592296186216909578564383752242658193900",
          "deadline": "115792089237316195423570985008687907853269984665640564039457584007913129639935"
        },
        "transferDetails": {
          "to": "0x336C033842FA316d470e820c81b742e62A0765DC",
          "requestedAmount": "139700000000000000000"
        },
        "owner": "0x44Ca15Db101fD1c194467Db6AF0c67C6BbF4AB51",
        "signature": "0xd4eb0e39a8030d2164a7e34771e44bf3d09cde94c76fdaf1d77319c2f6998b1f0049af86497e2c9144b4ba7bf6d7f13c5a6039413059d4efbd263ca934a46e311b",
        "networkId": 100
      },
      {
        "permit": {
          "permitted": {
            "token": "0xe91D153E0b41518A2Ce8Dd3D7944Fa863463a97d",
            "amount": "25400000000000000000"
          },
          "nonce": "14612109123960004831028012043133283454879272629205379505452590107324735062209",
          "deadline": "115792089237316195423570985008687907853269984665640564039457584007913129639935"
        },
        "transferDetails": {
          "to": "0xCee33C98410DEbe67A319Cb94F39e403435Df319",
          "requestedAmount": "25400000000000000000"
        },
        "owner": "0x44Ca15Db101fD1c194467Db6AF0c67C6BbF4AB51",
        "signature": "0x5b55751e97b2dfe44a29f0a4d49e7e9f379eb97fb05f73eb9b5d5a6e3556d311396f06786c5ded92aaa0cf4882c74e821c920d0a93d2e6a807ce7e78c7fdb0da1c",
        "networkId": 100
      },
      {
        "permit": {
          "permitted": {
            "token": "0xe91D153E0b41518A2Ce8Dd3D7944Fa863463a97d",
            "amount": "3700000000000000000"
          },
          "nonce": "66650790744319559974451091025629792722226153777673110804612151527661964321026",
          "deadline": "115792089237316195423570985008687907853269984665640564039457584007913129639935"
        },
        "transferDetails": {
          "to": "0xc4fc63d88dd411b19acf86fb56ba50941611b3a7",
          "requestedAmount": "3700000000000000000"
        },
        "owner": "0x44Ca15Db101fD1c194467Db6AF0c67C6BbF4AB51",
        "signature": "0x140f31f7836b17901cea8e709842bd1348b8e24b8e68c17486e59076e0952cc1662609c7644d71930a03118a5adf0c48e908e4b912ac8fc68626545901eabff21b",
        "networkId": 100
      }
    ]
    -->
    

    Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
    Projects
    None yet
    Development

    Successfully merging a pull request may close this issue.

    2 participants