ubiquity / ubiquibot

Putting the 'A' in 'DAO'
https://github.com/marketplace/ubiquibot
MIT License
17 stars 59 forks source link

Debits Table Schema #809

Closed 0x4007 closed 11 months ago

0x4007 commented 11 months ago

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 commented 11 months ago

/start

ubiquibot[bot] commented 11 months ago

Deadline Sat, 23 Sep 2023 15:49:50 UTC
Registered Wallet 0x3623338046b101ecEc741De9C3594CC2176f39E5
Tips:
0x4007 commented 11 months ago

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

seprintour commented 11 months ago

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 commented 11 months ago

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

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

0x4007 commented 11 months ago

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

ubiquibot[bot] commented 11 months ago
! 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 commented 11 months ago

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

seprintour commented 11 months ago

@Keyrxng lol this is a much smaller issue too

is it counting comments?

seprintour commented 11 months ago

/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 commented 11 months ago

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

seprintour commented 11 months ago

So we're using bigint

0x4007 commented 11 months ago

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

seprintour commented 11 months ago

PR attached, doesn't need a QA

seprintour commented 11 months ago

@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[bot] commented 11 months ago

Task Creator Reward

pavlovcik: [ CLAIM 30 WXDAI ]

ubiquibot[bot] commented 11 months ago

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 commented 11 months ago

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 https://github.com/ubiquity/ubiquibot/issues/803

Keyrxng commented 11 months ago
! 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 commented 11 months ago

Yes I changed to 8000 and now it silent crashes.