search

lefnire / tforce_btc_trader

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

Table runs does not exist #31

Open thegamecat opened 6 years ago

thegamecat commented 6 years ago

Running hypersearch.py is giving me this error: sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) relation "runs" does not exist LINE 1: select hypers, returns from runs where flag='conv2d' ^ [SQL: 'select hypers, returns from runs where flag=%(f)s'] [parameters: {'f': 'conv2d'}]

Which looks to me like the runs table does not exist in hyper_runs - which makes sense as there seems to be nothing trying to create it?

I've created the table but I don't know what data types to use.

Update: Bigint[] everything apart from agent and flag which are text and it works!

Update 2: I'm not seeing any of the runs being written to the table and looking at the dataset I'm seeing on the console I'm assuming I have the datatypes very wrong - any view of what the datatypes are would be great.

FYI using Ubuntu 16.04, python 3.6

thegamecat commented 6 years ago

Update: I made all fields varchar and a serial id field and it seems to work.

lefnire commented 6 years ago

Did you run the last command in the data section of readme?

thegamecat commented 6 years ago

Nope.

I'm a moron :)

Are there any other tables that need to be created?

lefnire commented 6 years ago

I've gotten this a few times, I'll have to make that section more obvious / automatic

thegamecat commented 6 years ago

Tbh your instructions are fine.

The issue is, as a bit of a linux / python noob, it took me 2 days to build an ubuntu box with all the requirements on it. This was after I tried to install it all with Winbash - only to realise that you can't install cuda etc on winbash (which is logical...). So the basic things like that step were just missed.