API tools faq
paste
Advertisement
caffeine314

dagg

caffeine314
Feb 24th, 2025
47
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.66 KB | None | 0 0
raw download clone embed print report
  1. PS C:\Users\p\Desktop\foo\dataAggregator> & c:/Users/p/Desktop/foo/dataAggregator/.venv/Scripts/python.exe c:/Users/p/Desktop/foo/dataAggregator/src/main.py
  2. [{'version()': '10.4.32-MariaDB'}]
  3. Traceback (most recent call last):
  4. File "C:\Users\p\Desktop\foo\dataAggregator\.venv\Lib\site-packages\sqlalchemy\engine\base.py", line 1964, in _exec_single_context
  5. self.dialect.do_execute(
  6. File "C:\Users\p\Desktop\foo\dataAggregator\.venv\Lib\site-packages\sqlalchemy\engine\default.py", line 942, in do_execute
  7. cursor.execute(statement, parameters)
  8. File "C:\Users\p\Desktop\foo\dataAggregator\.venv\Lib\site-packages\pymysql\cursors.py", line 153, in execute
  9. result = self._query(query)
  10. ^^^^^^^^^^^^^^^^^^
  11. File "C:\Users\p\Desktop\foo\dataAggregator\.venv\Lib\site-packages\pymysql\cursors.py", line 322, in _query
  12. conn.query(q)
  13. File "C:\Users\p\Desktop\foo\dataAggregator\.venv\Lib\site-packages\pymysql\connections.py", line 563, in query
  14. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  15. ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  16. File "C:\Users\p\Desktop\foo\dataAggregator\.venv\Lib\site-packages\pymysql\connections.py", line 825, in _read_query_result
  17. result.read()
  18. File "C:\Users\p\Desktop\foo\dataAggregator\.venv\Lib\site-packages\pymysql\connections.py", line 1199, in read
  19. first_packet = self.connection._read_packet()
  20. ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  21. File "C:\Users\p\Desktop\foo\dataAggregator\.venv\Lib\site-packages\pymysql\connections.py", line 775, in _read_packet
  22. packet.raise_for_error()
  23. File "C:\Users\p\Desktop\foo\dataAggregator\.venv\Lib\site-packages\pymysql\protocol.py", line 219, in raise_for_error
  24. err.raise_mysql_exception(self._data)
  25. File "C:\Users\p\Desktop\foo\dataAggregator\.venv\Lib\site-packages\pymysql\err.py", line 150, in raise_mysql_exception
  26. raise errorclass(errno, errval)
  27. pymysql.err.ProgrammingError: (1146, "Table 'dagg.fund' doesn't exist")
  28.  
  29. The above exception was the direct cause of the following exception:
  30.  
  31. Traceback (most recent call last):
  32. File "c:\Users\p\Desktop\foo\dataAggregator\src\main.py", line 28, in <module>
  33. asyncio.run( main() )
  34. File "C:\Program Files\WindowsApps\PythonSoftwareFoundation.Python.3.12_3.12.2544.0_x64__qbz5n2kfra8p0\Lib\asyncio\runners.py", line 195, in run
  35. return runner.run(main)
  36. ^^^^^^^^^^^^^^^^
  37. File "C:\Program Files\WindowsApps\PythonSoftwareFoundation.Python.3.12_3.12.2544.0_x64__qbz5n2kfra8p0\Lib\asyncio\runners.py", line 118, in run
  38. return self._loop.run_until_complete(task)
  39. ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  40. File "C:\Program Files\WindowsApps\PythonSoftwareFoundation.Python.3.12_3.12.2544.0_x64__qbz5n2kfra8p0\Lib\asyncio\base_events.py", line 691, in run_until_complete
  41. return future.result()
  42. ^^^^^^^^^^^^^^^
  43. File "c:\Users\p\Desktop\foo\dataAggregator\src\main.py", line 24, in main
  44. FundManager.populateFundDataFromScreener()
  45. File "c:\Users\p\Desktop\foo\dataAggregator\src\managers\fund.py", line 17, in populateFundDataFromScreener
  46. FundRepository.insert(
  47. File "c:\Users\p\Desktop\foo\dataAggregator\src\repositories\fund.py", line 15, in insert
  48. DB.executeQuery(query)
  49. File "c:\Users\p\Desktop\foo\dataAggregator\src\db\db.py", line 40, in executeQuery
  50. result = connection.execute(queryText)
  51. ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  52. File "C:\Users\p\Desktop\foo\dataAggregator\.venv\Lib\site-packages\sqlalchemy\engine\base.py", line 1416, in execute
  53. return method(
  54. ^^^^^
  55. File "C:\Users\p\Desktop\foo\dataAggregator\.venv\Lib\site-packages\sqlalchemy\sql\elements.py", line 516, in _execute_on_connection
  56. return connection._execute_clauseelement(
  57. ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  58. File "C:\Users\p\Desktop\foo\dataAggregator\.venv\Lib\site-packages\sqlalchemy\engine\base.py", line 1638, in _execute_clauseelement
  59. ret = self._execute_context(
  60. ^^^^^^^^^^^^^^^^^^^^^^
  61. File "C:\Users\p\Desktop\foo\dataAggregator\.venv\Lib\site-packages\sqlalchemy\engine\base.py", line 1843, in _execute_context
  62. return self._exec_single_context(
  63. ^^^^^^^^^^^^^^^^^^^^^^^^^^
  64. File "C:\Users\p\Desktop\foo\dataAggregator\.venv\Lib\site-packages\sqlalchemy\engine\base.py", line 1983, in _exec_single_context
  65. self._handle_dbapi_exception(
  66. File "C:\Users\p\Desktop\foo\dataAggregator\.venv\Lib\site-packages\sqlalchemy\engine\base.py", line 2352, in _handle_dbapi_exception
  67. raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
  68. File "C:\Users\p\Desktop\foo\dataAggregator\.venv\Lib\site-packages\sqlalchemy\engine\base.py", line 1964, in _exec_single_context
  69. self.dialect.do_execute(
  70. File "C:\Users\p\Desktop\foo\dataAggregator\.venv\Lib\site-packages\sqlalchemy\engine\default.py", line 942, in do_execute
  71. cursor.execute(statement, parameters)
  72. File "C:\Users\p\Desktop\foo\dataAggregator\.venv\Lib\site-packages\pymysql\cursors.py", line 153, in execute
  73. result = self._query(query)
  74. ^^^^^^^^^^^^^^^^^^
  75. File "C:\Users\p\Desktop\foo\dataAggregator\.venv\Lib\site-packages\pymysql\cursors.py", line 322, in _query
  76. conn.query(q)
  77. File "C:\Users\p\Desktop\foo\dataAggregator\.venv\Lib\site-packages\pymysql\connections.py", line 563, in query
  78. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  79. ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  80. File "C:\Users\p\Desktop\foo\dataAggregator\.venv\Lib\site-packages\pymysql\connections.py", line 825, in _read_query_result
  81. result.read()
  82. File "C:\Users\p\Desktop\foo\dataAggregator\.venv\Lib\site-packages\pymysql\connections.py", line 1199, in read
  83. first_packet = self.connection._read_packet()
  84. ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  85. File "C:\Users\p\Desktop\foo\dataAggregator\.venv\Lib\site-packages\pymysql\connections.py", line 775, in _read_packet
  86. packet.raise_for_error()
  87. File "C:\Users\p\Desktop\foo\dataAggregator\.venv\Lib\site-packages\pymysql\protocol.py", line 219, in raise_for_error
  88. err.raise_mysql_exception(self._data)
  89. File "C:\Users\p\Desktop\foo\dataAggregator\.venv\Lib\site-packages\pymysql\err.py", line 150, in raise_mysql_exception
  90. raise errorclass(errno, errval)
  91. sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'dagg.fund' doesn't exist")
  92. [SQL: INSERT INTO Fund (name, ticker, morningStarCategory, transactionFee) VALUES ('Fidelity Select Semiconductors Portfolio', 'FSELX', 'Technology', True)]
  93. (Background on this error at: https://sqlalche.me/e/20/f405)
  94. PS C:\Users\p\Desktop\foo\dataAggregator>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!