Paths including spaces results into multiple version locations being present

[kidrahahjo]

Describe the bug

My migration path resides in a directory whose name has spaces in it.
This results in multiple versions being specified at runtime.

Expected behavior

Should escape these characters by default.

To Reproduce
Keep your migrations directory into a path which contains spaces and then execute

alembic revisions

Error

Multiple version locations present, please specify --version-path.

Versions.

• OS: Linux
• Python: 3.8
• Alembic: 1.7.7
• SQLAlchemy: 1.3.24
• Database: Postgres
• DBAPI:

Additional context

Have a nice day!

[zzzeek]

hi -

there's no detail here so I can only guess that you are using an old alembic.ini file and have not set version_path_separator to "os" or ":", ";".

for example setting up alembic.ini with these two paths:

version_path_separator = os
version_locations = %(here)s/path foo:%(here)s/path bar

allows them to work without issue

[classic@photon3 alembic:main]$ PYTHONPATH=~/dev/sqlalchemy/lib/ python -m alembic revision -m rev1 --version-path="path foo"
  Generating /home/classic/dev/alembic/path foo/e390886ccca8_rev1.py ...  done
  Running post write hook "black" ...
reformatted path foo/e390886ccca8_rev1.py
All done! ✨ 🍰 ✨
1 file reformatted.
  done
  Running post write hook "zimports" ...
[Writing]       path foo/e390886ccca8_rev1.py ([18% of lines are imports] [source +0L/-1L] [1 imports removed in 0.0057 sec])
  done
[classic@photon3 alembic:main]$ PYTHONPATH=~/dev/sqlalchemy/lib/ python -m alembic revision -m rev2 --version-path="path bar"
  Generating /home/classic/dev/alembic/path bar/8bf5f295a2b3_rev2.py ...  done
  Running post write hook "black" ...
reformatted path bar/8bf5f295a2b3_rev2.py
All done! ✨ 🍰 ✨
1 file reformatted.
  done
  Running post write hook "zimports" ...
[Writing]       path bar/8bf5f295a2b3_rev2.py ([18% of lines are imports] [source +0L/-1L] [1 imports removed in 0.0060 sec])
  done
[classic@photon3 alembic:main]$ PYTHONPATH=~/dev/sqlalchemy/lib/ python -m alembic history
e390886ccca8 -> 8bf5f295a2b3 (head), rev2
<base> -> e390886ccca8, rev1

as you can see both directories are addressable and searchable

[zzzeek]

also no issue w/ single version path

version_path_separator = os
version_locations = %(here)s/path foo

[classic@photon3 alembic:main]$ PYTHONPATH=~/dev/sqlalchemy/lib/ python -m alembic revision -m rev3
  Generating /home/classic/dev/alembic/path foo/ac6a75794798_rev3.py ...  done
  Running post write hook "black" ...
reformatted /home/classic/dev/alembic/path foo/ac6a75794798_rev3.py
All done! ✨ 🍰 ✨
1 file reformatted.
  done
  Running post write hook "zimports" ...
[Writing]       /home/classic/dev/alembic/path foo/ac6a75794798_rev3.py ([18% of lines are imports] [source +0L/-1L] [1 imports removed in 0.0057 sec])
  done