add_category+replace_values - resource.table out of date?

[jamesrkg]

add_category already auto-ds._reload_variables() before closing, which is needed, however if we follow this up with replace_values we get a 400 bad request that the added category is not defined, e.g.:

ClientError: (<Response [400]>, 'https://app.crunch.io/api/datasets/909f580538cb46ddb4f3453d574a576e/table/', {u'status': u'400 Bad Request', u'message': u'Error executing command: Category 101 is not defined.'})

I think this is because ds.resource.table is out of date, even though the variables catalog is not:

scrunch/scrunch/datasets.py

Line 2365 in 4cfc508

resp = self.resource.table.post(json.dumps(payload))

Currently the only way to fix this is to refresh the dataset manually.

Perhaps when replace_values is called, the dataset needs to be auto-refreshed before taking any other action? This sounds expensive but would be preferable to an error and having to do that manually anyway.

How to reproduce this error:

1. Add a category to a variable using ds.add_category()
2. Replace values into that new category using ds.replace_values()