🔒 Need help with sqlite database

[real cave]

I am getting an error and i'm not sure how. Please help i cant work without a database.

AttributeError
AttributeError: 'list' object has no attribute 'strip'

Traceback (most recent call last)
File "C:\Users\\AppData\Local\Programs\Python\Python312\Lib\site-packages\flask\app.py", line 1488, in __call__
return self.wsgi_app(environ, start_response)
       ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^Open an interactive python shell in this frame
File "C:\Users\\AppData\Local\Programs\Python\Python312\Lib\site-packages\flask\app.py", line 1466, in wsgi_app
response = self.handle_exception(e)
           ^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\\AppData\Local\Programs\Python\Python312\Lib\site-packages\flask\app.py", line 1463, in wsgi_app
response = self.full_dispatch_request()
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\\AppData\Local\Programs\Python\Python312\Lib\site-packages\flask\app.py", line 873, in full_dispatch_request
return self.finalize_request(rv)
       ^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\DCrokett\AppData\Local\Programs\Python\Python312\Lib\site-packages\flask\app.py", line 892, in finalize_request
response = self.make_response(rv)
           ^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\\AppData\Local\Programs\Python\Python312\Lib\site-packages\flask\app.py", line 1215, in make_response
rv.status_code = status
^^^^^^^^^^^^^^
File "C:\Users\\AppData\Local\Programs\Python\Python312\Lib\site-packages\werkzeug\sansio\response.py", line 146, in status_code
self.status = code  # type: ignore
^^^^^^^^^^^
File "C:\Users\\AppData\Local\Programs\Python\Python312\Lib\site-packages\werkzeug\sansio\response.py", line 155, in status
self._status, self._status_code = self._clean_status(value)
                                  ^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\\AppData\Local\Programs\Python\Python312\Lib\site-packages\werkzeug\sansio\response.py", line 161, in _clean_status
value = value.strip()
        ^^^^^^^^^^^

[wind elbow]

@real cave

Python help channel opened

Remember to:

• Ask your Python question, not if you can ask or if there's an expert who can help.
• Show a code sample as text (rather than a screenshot) and the error message, if you've got one.
• Explain what you expect to happen and what actually happens.

:warning: Do not pip install anything that isn't related to your question, especially if asked to over DMs.

Closes after a period of inactivity, or when you send !close.

[real cave]

https://paste.pythondiscord.com/EFMQ

[warm sandal]

@real cave What URL were trying to serve when the error happened?

[river raven]

I'll just go on a limb and assume it's happening due to this line, fetchall returns a list

[real cave]

Ip/GetAccountInfo

[real cave]

So how do i return the information i need?

[river raven]

most likely by converting it to a json string

[warm sandal]

don't you have to format the data as JSON or something?

[real cave]

I thought i was saving time here

[river raven]

hmmm https://flask.palletsprojects.com/en/3.0.x/api/#flask.json.jsonify

A dict or list returned from a view will be converted to a JSON response automatically without needing to call this.
so ig you can also just wrap it in []:

return [User.fetchall(), Pass.fetchall(), Id.fetchall()]

[river raven]

if you could be less rude to helpers, that'd be great

[real cave]

How was i rude

[warm sandal]

notice how many people have said something like this.

[real cave]

Like what

[warm sandal]

This was rude: "I still dont wwant it shown now hush". There's a whole line of comments like this. You act entitled to help, and you're rude when people ask you for details.

or: "If personal information is in a file or error code duh im not gonna show it"

@real cave if i'm not mistaken, this isn't the first time you've had people advising you to adjust your approach.

[real cave]

Well it's just the truth

I don't do things for no reason

[warm sandal]

"duh" is rude. "Now hush" is rude. You delayed getting help by not showing the details. You should adjust your approach.

[real cave]

Details which included information i didn't want public

You should check messages again

[molten ridge]

is fixed?

[real cave]

Yuh

Btw I will be back bc I don't yet know how to handle some stuff which I'm sure I'll struggle on for hours tomorrow

[wind elbow]

Python help channel closed

This help channel has been closed and it's no longer possible to send messages here. If your question wasn't answered, feel free to create a new post in #1035199133436354600. To maximize your chances of getting a response, check out this guide on asking good questions.