search

caiobran / mstables

MorningStar.com scraper that consolidates tens of thousands of financial records into a SQLite relational database. Class 'dataframes' easily converts the SQLite data into pandas DataFrames (see Jupyter notebook for examples)
MIT License
180 stars 46 forks source link

Fail to initialize database, Win10 #3

Closed shifunan closed 4 years ago

shifunan commented 4 years ago

Hi, first of all, thanks for sharing this tool, looks very interesting! I tried to run this on win10, it failed with the following message. Would be great if you can take a look! Thanks!

(base) C:\Users\shifu\OneDrive\Documents\GitHub\mstables>python main.py 'clear' is not recognized as an internal or external command, operable program or batch file. ================================================================= ====================== Welcome to msTables ====================== Available actions: 0 - Change database file name (current name = 'mstables.sqlite') 1 - Create database tables and import latest symbols 2 - Download Morningstar data into database 3 - Erase all records from database tables 4 - Delete all database tables 5 - Erase all downloaded history from 'Fetched_urls' table 6 - Create a database back-up file ================================================================= Enter action no.: 1 Please wait, database tables are being created ... Traceback (most recent call last): File "main.py", line 161, in <module> main(db_file) File "main.py", line 100, in main msg = fetch.create_tables(db_file['path']) File "C:\Users\shifu\OneDrive\Documents\GitHub\mstables\fetch.py", line 58, in create_tables conn = sqlite3.connect(db_file) sqlite3.OperationalError: unable to open database file

shifunan commented 4 years ago

Erm, somehow the returns are not being respected, here is the error message

Enter action no.: 1

Please wait, database tables are being created ...

Traceback (most recent call last): File "main.py", line 161, in main(db_file) File "main.py", line 100, in main msg = fetch.create_tables(db_file['path']) File "C:\Users\shifu\OneDrive\Documents\GitHub\mstables\fetch.py", line 58, in create_tables conn = sqlite3.connect(db_file) sqlite3.OperationalError: unable to open database file

shifunan commented 4 years ago

never mind, saw that the package is only meant for Linux distros