adding template from json on sqlite

[drheinheimer]

I'm trying to download/upload templates. My general process is: 1) clean up template (remove ids, etc.), 2) add template, repeating as needed with a new name if a a template with the same name already exists.

The issue is that I get back a unique error: "UNIQUE constraint failed: tAttr.attr_name, tAttr.attr_dimen"

However, I only get this on sqlite (my laptop) not with mysql (online).

My add_template routine is here

I assume this has to do with _get_attr_by_name_and_dimension. I tried messing around with the SQLalchemy query, but to no avail.

Any ideas?