search

wasabi222 / janitor

provider maintenance email parser
Other
52 stars 14 forks source link

Few more fixes and debug logs #6

Closed mirceaulinic closed 5 years ago

mirceaulinic commented 5 years ago

I've managed to get the app up and running with Postgres, there are some things sqlalchemy doesn't deal with nicely, for example the filters must be sent as text otherwise the search won't work, and fails with:

Job "run_loop (trigger: interval[0:05:00], next run at: 2019-07-29 09:23:14 UTC)" raised an exception
Traceback (most recent call last):
  File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1244, in _execute_context
    cursor, statement, parameters, context
  File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 552, in do_execute
    cursor.execute(statement, parameters)
psycopg2.errors.UndefinedFunction: operator does not exist: boolean = integer
LINE 3: ...nance_id = 'TTN-0003181128' AND maintenance.rescheduled = 0 
                                                                   ^
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.

I've also split up the Docker image into a base version with Janitor only, and another one with Janitor and Nginx -- it's usually preferred to have these running in separate containers.

Also fixes #5.

wasabi222 commented 5 years ago

@mirceaulinic I just pushed the changes to fix the columns from BOOLEAN to INT. Can you remove the casting of ints to strs in Providers.py and then I can merge this?