jabrell / pyeutl Goto Github PK

Dear Jan,

This issue may be related to the amazing work you have conducted here. I recently read about the European Union's Effort Sharing Regulation (ESR) (formerly decision - ESD). It seems that Non-ETS sectors' (agriculture, residential etc.) emissions are nationally maintained inside dedicated registers. The EU even seems to have teams of technical experts to annually audit these registers (see https://climate.ec.europa.eu/eu-action/effort-sharing-member-states-emission-targets/implementation-effort-sharing-decision_en).

I wonder if these registers are open for the public (e.g. the German ESD register)? If yes, it would be interesting to spectate it. Are you aware about those ESD registers? (see https://climate.ec.europa.eu/eu-action/effort-sharing-member-states-emission-targets_en)

This is a super cool project, and data I didn't know existed until today. This might a silly question (and I didn't see this in the source data), but is there information about the price these units were traded at? So if one account holder purchases an EUA from another, for example, is the price of that transaction known? Would it be the prevailing market price at that time?

Anyway regardless this is really neat, thanks for putting all of this together.

Hello - I am getting this error when trying to access the data:

OperationalError: (psycopg2.OperationalError) FATAL: password authentication failed for user "eutlAdmin"

Might you know what the issue could be?

On Windows 10 Pro, when running the setup_db.py I receive the following error:

Traceback (most recent call last):
File "", line 1, in
File "C:\Program Files\JetBrains\PyCharm Community Edition 2021.1.2\plugins\python-ce\helpers\pydev_pydev_bundle\pydev_umd.py", line 197, in runfile
pydev_imports.execfile(filename, global_vars, local_vars) # execute the script
File "C:\Program Files\JetBrains\PyCharm Community Edition 2021.1.2\plugins\python-ce\helpers\pydev_pydev_imps_pydev_execfile.py", line 18, in execfile
exec(compile(contents+"\n", file, 'exec'), glob, loc)
File "C:/Users/xxx/PycharmProjects/eutl_orm/scripts/setup_db.py", line 22, in
dal = DataAccessLayer(**connectionSettings)
File "C:\Users\xxx\PycharmProjects\eutl_orm\eutl_orm\dataAccessLayer.py", line 46, in init
self.connect()
File "C:\Users\xxx\PycharmProjects\eutl_orm\eutl_orm\dataAccessLayer.py", line 53, in connect
self.metadata = MetaData(bind=self.engine, reflect=True)
TypeError: init() got an unexpected keyword argument 'reflect'

When changing this line:

https://github.com/jabrell/eutl_orm/blob/c5fac2c4e59dd7a3eb38f0045bcc2616beae0a36/eutl_orm/dataAccessLayer.py#L53

to: self.metadata = MetaData(bind=self.engine)

the problem does not appear any longer and I can populate the DB.