Error: Inferring metadata on Windows about oemof-tabular

[jnnr]

@FelixMau: Can you reproduce this bug?

[jnnr]

@srhbrnds, could you check this on your machine?

[srhbrnds]

@jnnr I will try to reproduce this bug today. Shall i test on branch fixes/metadata-windows or another?

[srhbrnds]

I tried to rerun the example on branch fixes/metadata-windows and receive the following error:
FileNotFoundError: [Errno 2] No such file or directory: 'foreign_keys.json'

It traces back to the config.py line 12

with open(FOREIGN_KEYS_FILE, "r") as fk_file:
    FOREIGN_KEYS = json.load(fk_file)

Since the file foreign_keys.json exits in /src/oemof/tabular/config/ I assume the path is still the problem. I debugged the config.py and I don't receive the problem. I receive this output after running line 12 ff.

[FOREIGN_KEYS: {'bus': ['volatile', 'dispatchable', 'storage', 'load', 'reservoir', 'shortage', 'excess'], 'profile': ['load', 'volatile', 'ror'], 'from_to_bus': ['connection', 'line', 'conversion'], 'chp': ['backpressure', 'extraction', 'chp']}]

Do you have any idea on why the porblem occurs when running the script but not in debugger mode @jnnr ?

[jnnr]

Do you have any idea on why the porblem occurs when running the script but not in debugger mode @jnnr ?

Maybe you are on different environments when you debug and when you run the script? Just guessing.

[jnnr]

@jnnr I will try to reproduce this bug today. Shall i test on branch fixes/metadata-windows or another?

Thanks! fixes/metadata-windows is quite old and might not include all necessary changes. Could make sense to start a fresh branch to fix the problem - however you like!

[srhbrnds]

The problem was caused by a relational path, I managed to resolve it partially. I will push my changes tomorrow.

[jnnr]

After a discussion, we found out: Actually, we do not want to have os-dependent metadata. The standard is unix-style separators (https://specs.frictionlessdata.io/data-resource/#data-location). Therefore, infer_metadata should give / as separator on any os.
Next, we can check if datapackages created like this can be run on any os.