fix(python): application launch on Windows

[RogerHYang]

resolves #4207

Issues Resolved

UnicodeEncodeError when printing

Traceback (most recent call last):
  File "C:\hostedtoolcache\windows\Python\3.8.10\x64\lib\threading.py", line 932, in _bootstrap_inner
    self.run()
  File "C:\hostedtoolcache\windows\Python\3.8.10\x64\lib\threading.py", line 870, in run
    self._target(*self._args, **self._kwargs)
  File "D:\a\phoenix\phoenix\test-launch-app\lib\site-packages\phoenix\db\migrate.py", line 47, in migrate
    raise e
  File "D:\a\phoenix\phoenix\test-launch-app\lib\site-packages\phoenix\db\migrate.py", line 32, in migrate
    printif(log_migrations, "\U0001f3c3\u200d\u2640\ufe0f\u200d\u27a1\ufe0f Running migrations on the database.")
  File "D:\a\phoenix\phoenix\test-launch-app\lib\site-packages\phoenix\db\migrate.py", line [19](https://github.com/Arize-ai/phoenix/actions/runs/10459913636/job/28964961557#step:6:20), in printif
    print(text)
  File "C:\hostedtoolcache\windows\Python\3.8.10\x64\lib\encodings\cp1252.py", line 19, in encode
    return codecs.charmap_encode(input,self.errors,encoding_table)[0]
UnicodeEncodeError: 'charmap' codec can't encode characters in position 0-6: character maps to <undefined>

Should use sqlean.py for migrations

#4270 Traceback (most recent call last):
  File "D:\a\phoenix\phoenix\test-launch-app\lib\site-packages\sqlalchemy\engine\base.py", line 1967, in _exec_single_context
    self.dialect.do_execute(
  File "D:\a\phoenix\phoenix\test-launch-app\lib\site-packages\sqlalchemy\engine\default.py", line 941, in do_execute
    cursor.execute(statement, parameters)
  File "D:\a\phoenix\phoenix\test-launch-app\lib\site-packages\sqlalchemy\dialects\sqlite\aiosqlite.py", line 147, in execute
    self._adapt_connection._handle_exception(error)
  File "D:\a\phoenix\phoenix\test-launch-app\lib\site-packages\sqlalchemy\dialects\sqlite\aiosqlite.py", line 298, in _handle_exception
    raise error
  File "D:\a\phoenix\phoenix\test-launch-app\lib\site-packages\sqlalchemy\dialects\sqlite\aiosqlite.py", line 129, in execute
    self.await_(_cursor.execute(operation, parameters))
  File "D:\a\phoenix\phoenix\test-launch-app\lib\site-packages\sqlalchemy\util\_concurrency_py3k.py", line 132, in await_only
    return current.parent.switch(awaitable)  # type: ignore[no-any-return,attr-defined] # noqa: E501
  File "D:\a\phoenix\phoenix\test-launch-app\lib\site-packages\sqlalchemy\util\_concurrency_py3k.py", line 196, in greenlet_spawn
    value = await result
  File "D:\a\phoenix\phoenix\test-launch-app\lib\site-packages\aiosqlite\cursor.py", line 48, in execute
    await self._execute(self._cursor.execute, sql, parameters)
  File "D:\a\phoenix\phoenix\test-launch-app\lib\site-packages\aiosqlite\cursor.py", line 40, in _execute
    return await self._conn._execute(fn, *args, **kwargs)
  File "D:\a\phoenix\phoenix\test-launch-app\lib\site-packages\aiosqlite\core.py", line 132, in _execute
    return await future
  File "D:\a\phoenix\phoenix\test-launch-app\lib\site-packages\aiosqlite\core.py", line 115, in run
    result = function()
sqlite3.OperationalError: no such function: JSON_EXTRACT

PosixPath should be urljoin

Traceback (most recent call last):
  File "C:\hostedtoolcache\windows\Python\3.8.10\x64\lib\runpy.py", line 194, in _run_module_as_main
    return _run_code(code, main_globals, None,
  File "C:\hostedtoolcache\windows\Python\3.8.10\x64\lib\runpy.py", line 87, in _run_code
    exec(code, run_globals)
  File "D:\a\phoenix\phoenix\test-launch-app\lib\site-packages\phoenix\server\main.py", line 287, in <module>
    ui_path=PosixPath(f"http://{host}:{port}", host_root_path),
  File "C:\hostedtoolcache\windows\Python\3.8.10\x64\lib\pathlib.py", line 1044, in __new__
    raise NotImplementedError("cannot instantiate %r on your system"
NotImplementedError: cannot instantiate 'PosixPath' on your system

[review-notebook-app]

Check out this pull request on 

See visual diffs & provide feedback on Jupyter Notebooks.

---

Powered by ReviewNB