D1: Use REST API instead of Python module #14

New issue

Closed

opened 2025-10-16 22:27:00 -07:00 by swee · 2 comments

swee commented

2025-10-16 22:27:00 -07:00

Owner

There is a lot of version mismatching with the cloudflare module and currently the D1 module is broken

Traceback (most recent call last):
  File "/home/swee/Git/IRCat/modules/pawserv.py", line 46, in command
    query = self.sql.chanserv_details(channel)
            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/swee/Git/IRCat/modules/cfd1.py", line 61, in chanserv_details
    e = self.cfexec("SELECT * FROM chanserv WHERE name=?;", [channel])
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/swee/Git/IRCat/modules/cfd1.py", line 27, in cfexec
    return query[0].results
           ~~~~~^^^
TypeError: 'SyncSinglePage[QueryResult]' object is not subscriptable

There is a lot of version mismatching with the `cloudflare` module and currently the D1 module is broken ``` Traceback (most recent call last): File "/home/swee/Git/IRCat/modules/pawserv.py", line 46, in command query = self.sql.chanserv_details(channel) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/swee/Git/IRCat/modules/cfd1.py", line 61, in chanserv_details e = self.cfexec("SELECT * FROM chanserv WHERE name=?;", [channel]) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/swee/Git/IRCat/modules/cfd1.py", line 27, in cfexec return query[0].results ~~~~~^^^ TypeError: 'SyncSinglePage[QueryResult]' object is not subscriptable ```

swee added the

Kind/Bug

Priority

Critical

labels

2025-10-16 22:27:00 -07:00

swee self-assigned this

2025-10-16 22:27:01 -07:00

swee commented

2025-11-08 18:29:24 -08:00

Author

Owner

I recently created the aiocfd1 Python module, so the move might be a bit simpler (Only when I rewrite IRCat with an Async structure) :3

I recently created the [`aiocfd1`](https://git.swee.codes/swee/aiocfd1) Python module, so the move might be a bit simpler (Only when I rewrite IRCat with an Async structure) :3

swee added the

Status

Blocked

label

2025-11-08 18:30:08 -08:00

swee commented

2026-02-26 16:11:14 -08:00

Author

Owner

This project will be rewritten in Go, which can lock module versions.

swee closed this issue

2026-02-26 16:11:14 -08:00