lefnire / tforce_btc_trader

TensorForce Bitcoin Trading Bot
http://ocdevel.com/podcasts/machine-learning/26
GNU Affero General Public License v3.0
820 stars 235 forks source link

(psycopg2.ProgrammingError) relation "coinbase" does not exist #27

Open alirezaseifi opened 6 years ago

alirezaseifi commented 6 years ago

I'm getting the following error by running python3 run.py --id 10 --name test --test

  File "tforce_btc_trader/env/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) relation "coinbase" does not exist
LINE 1: ...se.weighted_price as coinbase_weighted_price from coinbase o...
                                                             ^
 [SQL: 'select coinbase.open as coinbase_open, coinbase.high as coinbase_high, coinbase.low as coinbase_low, coinbase.close as coinbase_close, coinbase.volume_btc as coinbase_volume_btc, coinbase.volume_currency as coinbase_volume_currency, coinbase.weighted_price as coinbase_weighted_price from coinbase order by timestamp desc limit 100000 offset 0'] (Background on this error at: http://sqlalche.me/e/f405)
lefnire commented 6 years ago

Did you successfully import the Kaggle dataset into a database? What's the name of the database in your config.json? Can you run psql {that-database} then select * from coinbase limit 1? I think the database doesn't exist or wasn't setup properly.

alirezaseifi commented 6 years ago

I have created these dbs as suggested in the config and readme history, history_live and runs.

  "DB_RUNS": "postgres://localhost/runs",
  "DB_HISTORY": "postgres://localhost/history",
  "DB_HISTORY_LIVE": "postgres://localhost/history_live",

alireza_ ___applications_postgres_app_contents_versions_10_bin_psql__-p5432_-d__ ___applications_postgres_app_contents_versions_10_bin_psql__ _psql_-p5432_-d_btc_history_ _260x59_and_config_json_ _tforce_btc_trader

lefnire commented 6 years ago

Oh, very strange.. it's right there, coinbase. I'll do a fresh install sometime following the README & see if I can replicate. In the meantime, is there any more to that error - showing where the error occurs in tforce_btc_trader? (I'm assuming data._db_to_dataframe_main(), but just in case)