Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
alirezaseifi opened this issue Mar 15, 2018 · 3 comments
Open

Comments

@alirezaseifi
Copy link
Contributor

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
Copy link
Owner

lefnire commented Mar 18, 2018

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
Copy link
Contributor Author

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
Copy link
Owner

lefnire commented Mar 20, 2018

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)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants