migrations fail for database name containing "-"

[stanislav-brabec]

Describe the bug
Applying memory.0007_use_trigram...Traceback (most recent call last):
File "/usr/lib/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.SyntaxError: syntax error at or near "-"
LINE 1: ALTER DATABASE weblate-staging SET pg_trgm.similarity_thresh...
^
To Reproduce
Set the database name to "weblate-staging"

I worked around this by changing of
ALTER DATABASE {} SET
to
ALTER DATABASE "{}" SET
in 0007_use_trigram.py and 0008_adjust_similarity.py.

weblate-4.1.1

[nijel]

Weblate 4.2 has changed this to role based, see bbf6f11 and #3940, but the problem could exist there as well.

[github-actions]

Thank you for your report, the issue you have reported has just been fixed.

• In case you see a problem with the fix, please comment on this issue.
• In case you see a similar problem, please open a separate issue.
• If you are happy with the outcome, consider supporting Weblate by donating.