daemon

0.025111301524452

Traceback (most recent call last):

File "/Library/Frameworks/Python.framework/Versions/3.12/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context

self.dialect.do_execute(

File "/Library/Frameworks/Python.framework/Versions/3.12/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 941, in do_execute

cursor.execute(statement, parameters)

File "/Library/Frameworks/Python.framework/Versions/3.12/lib/python3.12/site-packages/pymysql/cursors.py", line 153, in execute

result = self._query(query)

^^^^^^^^^^^^^^^^^^

File "/Library/Frameworks/Python.framework/Versions/3.12/lib/python3.12/site-packages/pymysql/cursors.py", line 322, in _query

conn.query(q)

File "/Library/Frameworks/Python.framework/Versions/3.12/lib/python3.12/site-packages/pymysql/connections.py", line 563, in query

self._affected_rows = self._read_query_result(unbuffered=unbuffered)

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

File "/Library/Frameworks/Python.framework/Versions/3.12/lib/python3.12/site-packages/pymysql/connections.py", line 825, in _read_query_result

result.read()

File "/Library/Frameworks/Python.framework/Versions/3.12/lib/python3.12/site-packages/pymysql/connections.py", line 1199, in read

first_packet = self.connection._read_packet()

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

File "/Library/Frameworks/Python.framework/Versions/3.12/lib/python3.12/site-packages/pymysql/connections.py", line 775, in _read_packet

packet.raise_for_error()

File "/Library/Frameworks/Python.framework/Versions/3.12/lib/python3.12/site-packages/pymysql/protocol.py", line 219, in raise_for_error

err.raise_mysql_exception(self._data)

File "/Library/Frameworks/Python.framework/Versions/3.12/lib/python3.12/site-packages/pymysql/err.py", line 150, in raise_mysql_exception

raise errorclass(errno, errval)

pymysql.err.ProgrammingError: (1146, "Table 'hy.0.025111301524452' doesn't exist")

The above exception was the direct cause of the following exception:

Traceback (most recent call last):

File "/Volumes/DATA/M2/getindustry.py", line 320, in

drawcandle(selected.columns[0])

File "/Volumes/DATA/M2/getindustry.py", line 24, in drawcandle

stock = pd.read_sql("select * from `"+data+"`", conn)#read_csv(data+".csv",header=0)

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

File "/Library/Frameworks/Python.framework/Versions/3.12/lib/python3.12/site-packages/pandas/io/sql.py", line 734, in read_sql

return pandas_sql.read_query(

^^^^^^^^^^^^^^^^^^^^^^

File "/Library/Frameworks/Python.framework/Versions/3.12/lib/python3.12/site-packages/pandas/io/sql.py", line 1836, in read_query

result = self.execute(sql, params)

^^^^^^^^^^^^^^^^^^^^^^^^^

File "/Library/Frameworks/Python.framework/Versions/3.12/lib/python3.12/site-packages/pandas/io/sql.py", line 1659, in execute

return self.con.exec_driver_sql(sql, *args)

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

File "/Library/Frameworks/Python.framework/Versions/3.12/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1779, in exec_driver_sql

ret = self._execute_context(

^^^^^^^^^^^^^^^^^^^^^^

File "/Library/Frameworks/Python.framework/Versions/3.12/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1846, in _execute_context

return self._exec_single_context(

^^^^^^^^^^^^^^^^^^^^^^^^^^

File "/Library/Frameworks/Python.framework/Versions/3.12/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1986, in _exec_single_context

self._handle_dbapi_exception(

File "/Library/Frameworks/Python.framework/Versions/3.12/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 2355, in _handle_dbapi_exception

raise sqlalchemy_exception.with_traceback(exc_info[2]) from e

File "/Library/Frameworks/Python.framework/Versions/3.12/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context

self.dialect.do_execute(

File "/Library/Frameworks/Python.framework/Versions/3.12/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 941, in do_execute

cursor.execute(statement, parameters)

File "/Library/Frameworks/Python.framework/Versions/3.12/lib/python3.12/site-packages/pymysql/cursors.py", line 153, in execute

result = self._query(query)

^^^^^^^^^^^^^^^^^^

File "/Library/Frameworks/Python.framework/Versions/3.12/lib/python3.12/site-packages/pymysql/cursors.py", line 322, in _query

conn.query(q)

File "/Library/Frameworks/Python.framework/Versions/3.12/lib/python3.12/site-packages/pymysql/connections.py", line 563, in query

self._affected_rows = self._read_query_result(unbuffered=unbuffered)

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

File "/Library/Frameworks/Python.framework/Versions/3.12/lib/python3.12/site-packages/pymysql/connections.py", line 825, in _read_query_result

result.read()

File "/Library/Frameworks/Python.framework/Versions/3.12/lib/python3.12/site-packages/pymysql/connections.py", line 1199, in read

first_packet = self.connection._read_packet()

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

File "/Library/Frameworks/Python.framework/Versions/3.12/lib/python3.12/site-packages/pymysql/connections.py", line 775, in _read_packet

packet.raise_for_error()

File "/Library/Frameworks/Python.framework/Versions/3.12/lib/python3.12/site-packages/pymysql/protocol.py", line 219, in raise_for_error

err.raise_mysql_exception(self._data)

File "/Library/Frameworks/Python.framework/Versions/3.12/lib/python3.12/site-packages/pymysql/err.py", line 150, in raise_mysql_exception

raise errorclass(errno, errval)

sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'hy.0.025111301524452' doesn't exist")

[SQL: select * from `0.025111301524452`]

(Background on this error at: https://sqlalche.me/e/20/f405)