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

Debits Table Schema #809

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

Debits Table Schema #809

0x4007 opened this issue Sep 23, 2023 · 20 comments · Fixed by #813

Comments

@0x4007
Copy link
Member

0x4007 commented Sep 23, 2023

Debits

Represents deductions "penalties" made to assignees when an issue is re-opened.

Field Type Description Example Value
id int8 Unique identifier for the debit entry. 1
created timestamptz Timestamp when the debit was created. 2023-09-15T10:30:45.012Z
updated timestamptz Timestamp when the debit was last updated. 2023-09-15T10:35:20.100Z
amount int8 Amount deducted. 500
@seprintour
Copy link
Contributor

/start

@ubiquibot
Copy link

ubiquibot bot commented Sep 23, 2023

Deadline Sat, 23 Sep 2023 15:49:50 UTC
Registered Wallet 0x3623338046b101ecEc741De9C3594CC2176f39E5
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.

    @0x4007
    Copy link
    Member Author

    0x4007 commented Sep 23, 2023

    For the amount lets do what supports 1e18 format BigInteger?

    @seprintour
    Copy link
    Contributor

    I think the amount for debit and credit should be a float or big integer if we are converting decimal to bigint because permit amount is not always in whole numbers

    @seprintour
    Copy link
    Contributor

    For the amount lets do what supports 1e18 format BigInteger?

    Yea, so on the bot we convert the decimal to 1e18

    @0x4007
    Copy link
    Member Author

    0x4007 commented Sep 23, 2023

    /ask what supabase column datatype is best for 1e18 format numbers? in the context of ethereum tokens and how they represent amounts

    @ubiquibot
    Copy link

    ubiquibot bot commented Sep 23, 2023

    ! Error: This model's maximum context length is 16385 tokens. However, you requested 17152 tokens (768 in the messages, 16384 in the completion). Please reduce the length of the messages or completion.

    @0x4007
    Copy link
    Member Author

    0x4007 commented Sep 23, 2023

    @Keyrxng lol this is a much smaller issue too. Perhaps it should ignore commands and bot comments i.e. the /start prompt

    @seprintour
    Copy link
    Contributor

    @Keyrxng lol this is a much smaller issue too

    is it counting comments?

    @seprintour
    Copy link
    Contributor

    /ask what supabase column datatype is best for 1e18 format numbers? in the context of ethereum tokens and how they represent amounts

    https://chat.openai.com/share/b4d90deb-49fd-4c95-982f-dedb1c9c6e33

    @0x4007
    Copy link
    Member Author

    0x4007 commented Sep 23, 2023

    lol I am ahead of you https://chat.openai.com/share/e8f7eb03-807f-44f3-b7fe-3d883dcf08e4

    @seprintour
    Copy link
    Contributor

    So we're using bigint

    @0x4007
    Copy link
    Member Author

    0x4007 commented Sep 23, 2023

    "int8" i'm updating the specs based on this conversation

    @seprintour
    Copy link
    Contributor

    seprintour commented Sep 23, 2023

    PR attached, doesn't need a QA

    @seprintour
    Copy link
    Contributor

    @pavlovcik Review so i can create the new permit table and copy data over.

    After all tables have been merged #812 can create a query that'd move over all penalties to Debit, Permit and Settlements if it will be possible.. or we may have to reset penalties

    @ubiquibot
    Copy link

    ubiquibot bot commented Sep 23, 2023

    Task Creator Reward

    pavlovcik: [ CLAIM 30 WXDAI ]

    @ubiquibot
    Copy link

    ubiquibot bot commented Sep 23, 2023

    Task Assignee Reward

    [ CLAIM 112.5 WXDAI ]

    0x362333804...C2176f39E5

    If you've enjoyed your experience in the DevPool, we'd appreciate your support. Follow Ubiquity on GitHub and star this repo. Your endorsement means the world to us and helps us grow!
    We are excited to announce that the DevPool and UbiquiBot are now available to partners! Our ideal collaborators are globally distributed crypto-native organizations, who actively work on open source on GitHub, and excel in research & development. If you can introduce us to the repository maintainers in these types of companies, we have a special bonus in store for you!

    @0x4007
    Copy link
    Member Author

    0x4007 commented Sep 23, 2023

    Task Assignee Reward

    [ CLAIM 112.5 WXDAI ]

    0x362333804...C2176f39E5

    If you've enjoyed your experience in the DevPool, we'd appreciate your support. Follow Ubiquity on GitHub and star this repo. Your endorsement means the world to us and helps us grow!
    We are excited to announce that the DevPool and UbiquiBot are now available to partners! Our ideal collaborators are globally distributed crypto-native organizations, who actively work on open source on GitHub, and excel in research & development. If you can introduce us to the repository maintainers in these types of companies, we have a special bonus in store for you!

    This is unexpected @0xcodercrane why is this unreliable ref #803

    @Keyrxng
    Copy link
    Member

    Keyrxng commented Sep 23, 2023

    ! Error: This model's maximum context length is 16385 tokens. However, you requested 17152 tokens (768 in the messages, 16384 in the completion). Please reduce the length of the messages or completion.

    16384 in the completion

    this means the token limit has been set so that the output is equivalent to 16k, max_tokens represents output amount.

    So requesting a 16k output including a 768 in actual message context, so in total you are requesting 17152 which is above the maximum for that model.

    drop the token limit to half or 2/3

    @0x4007
    Copy link
    Member Author

    0x4007 commented Sep 23, 2023

    Yes I changed to 8000 and now it silent crashes.

    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.

    3 participants