Comments (14)
pvssrikanth
commented on September 28, 2024
1
Thanks Sir
For your guidance reply
I will try and revert
Thanks for your kind support
Regards
Srikanth
…On Wednesday, September 14, 2022, Evgeniy Tretyakov < ***@***.***> wrote:
1. You have opened port 5432 in docker for your database, and 5436 in
your .env file, so you need 5432 in your .env file. So the lines
should look like this: DB_ASYNC_CONNECTION_STR="
postgresql+asyncpg://{your_user}:{your_password}@
localhost:5432/heroes_db"
2. As I understand your issue - you have another app with tables and
data in it and you want to migrate the service to fastapi. So you need to
create app with fastapi with all tables and then migrate your data from
Django database to a new one with.
—
Reply to this email directly, view it on GitHub
<#1 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/AEGAGU2V4KEZAUO3X2A6MI3V6HCB3ANCNFSM6AAAAAAQKNJFFU>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
from hero-app.
ETretyakov
commented on September 28, 2024
Hi!
It seems you have generated some new migration file, because I don't have any with such name - "abf1ce0bccc0". I believe it is located by this path "migrations/versions/abf1ce0bccc0.py".
So If you want me to help you, you need:
- to provide the content of your migration file "migrations/versions/abf1ce0bccc0.py";
- give me the whole log of the error.
Waiting for your response)
from hero-app.
pvssrikanth
commented on September 28, 2024
Dear Sir,
Thanks for your prompt response and support.
Please find contents of the file pasted below
"""heroes
Revision ID: 886322ad66ff
Revises:
Create Date: 2022-05-21 18:06:29.571698
"""
import sqlalchemy as sa
import sqlmodel
from alembic import op
from sqlalchemy.dialects import postgresql
# revision identifiers, used by Alembic.
revision = '886322ad66ff'
down_revision = None
branch_labels = None
depends_on = None
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('hrs_heroes',
sa.Column('role', postgresql.ENUM('mage', 'assassin', 'warrior',
'priest', 'tank', name='hrs_role'), nullable=True),
sa.Column('uuid', sqlmodel.sql.sqltypes.GUID(),
server_default=sa.text('gen_random_uuid()'), nullable=False),
sa.Column('nickname', sqlmodel.sql.sqltypes.AutoString(length=255),
nullable=False),
sa.Column('created_at', sa.DateTime(),
server_default=sa.text('current_timestamp(0)'), nullable=False),
sa.Column('updated_at', sa.DateTime(),
server_default=sa.text('current_timestamp(0)'), nullable=False),
sa.PrimaryKeyConstraint('uuid', name=op.f('pk_hrs_heroes'))
)
op.create_index(op.f('ix_hrs_heroes_uuid'), 'hrs_heroes', ['uuid'],
unique=True)
# ### end Alembic commands ###
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_index(op.f('ix_hrs_heroes_uuid'), table_name='hrs_heroes')
op.drop_table('hrs_heroes')
# ### end Alembic commands ###
***@***.***:~/srik/hero-app/migrations/versions$ ls
0001_886322ad66ff_heroes.py
***@***.***:~/srik/hero-app/migrations/versions$
…-------------------------whole log of error pasted below
---------------------
Sending build context to Docker daemon 254kB
Step 1/10 : FROM python:3-slim-buster
---> 8addbbd4348f
Step 2/10 : ARG ENV_FILE
---> Using cache
---> 2d1ae12000af
Step 3/10 : ENV ENV_FILE=${ENV_FILE} PYTHONFAULTHANDLER=1
PYTHONUNBUFFERED=1 PYTHONHASHSEED=random PIP_NO_CACHE_DIR=off
PIP_DISABLE_PIP_VERSION_CHECK=on PIP_DEFAULT_TIMEOUT=100
POETRY_VERSION=1.1.13
---> Using cache
---> 46d7fdb1489e
Step 4/10 : RUN pip install "poetry==$POETRY_VERSION"
---> Using cache
---> 62ba6ecc748c
Step 5/10 : WORKDIR /vyce-backend
---> Using cache
---> 90bcd2b4f87e
Step 6/10 : COPY poetry.lock pyproject.toml /vyce-backend/
---> Using cache
---> e8daeb108606
Step 7/10 : RUN poetry config virtualenvs.create false && poetry install
--no-interaction --no-ansi
---> Using cache
---> c62073e24125
Step 8/10 : COPY . /vyce-backend
---> Using cache
---> 18f14461e5e8
Step 9/10 : RUN alembic upgrade head
---> Running in 92f9f8940382
Traceback (most recent call last):
File "/usr/local/bin/alembic", line 8, in <module>
sys.exit(main())
File "/usr/local/lib/python3.10/site-packages/alembic/config.py", line
588, in main
CommandLine(prog=prog).main(argv=argv)
File "/usr/local/lib/python3.10/site-packages/alembic/config.py", line
582, in main
self.run_cmd(cfg, options)
File "/usr/local/lib/python3.10/site-packages/alembic/config.py", line
559, in run_cmd
fn(
File "/usr/local/lib/python3.10/site-packages/alembic/command.py", line
320, in upgrade
script.run_env()
File "/usr/local/lib/python3.10/site-packages/alembic/script/base.py",
line 563, in run_env
util.load_python_file(self.dir, "env.py")
File "/usr/local/lib/python3.10/site-packages/alembic/util/pyfiles.py",
line 92, in load_python_file
module = load_module_py(module_id, path)
File "/usr/local/lib/python3.10/site-packages/alembic/util/pyfiles.py",
line 108, in load_module_py
spec.loader.exec_module(module) # type: ignore
File "<frozen importlib._bootstrap_external>", line 883, in exec_module
File "<frozen importlib._bootstrap>", line 241, in
_call_with_frames_removed
File "/vyce-backend/migrations/env.py", line 27, in <module>
from app.heroes.models import Hero # noqa: 'autogenerate' support
File "/vyce-backend/./app/__init__.py", line 9, in <module>
settings = Settings()
File "pydantic/env_settings.py", line 38, in
pydantic.env_settings.BaseSettings.__init__
File "pydantic/main.py", line 341, in pydantic.main.BaseModel.__init__
pydantic.error_wrappers.ValidationError: 7 validation errors for Settings
api_v1_prefix
field required (type=value_error.missing)
debug
field required (type=value_error.missing)
project_name
field required (type=value_error.missing)
version
field required (type=value_error.missing)
description
field required (type=value_error.missing)
db_async_connection_str
field required (type=value_error.missing)
db_async_test_connection_str
field required (type=value_error.missing)
The command '/bin/sh -c alembic upgrade head' returned a non-zero code: 1
***@***.***:~/srik/hero-app$
Thanking you for your help
Regards,
srikanth
On Mon, Sep 12, 2022 at 9:21 PM Evgeniy Tretyakov ***@***.***> wrote:
Hi!
It seems you have generated some new migration file, because I don't have
any with such name - "abf1ce0bccc0". I believe it is located by this path
"migrations/versions/abf1ce0bccc0.py".
So If you want me to help you, you need:
1. to provide the content of your migration file
"migrations/versions/abf1ce0bccc0.py";
2. give me the whole log of the error.
Waiting for your response)
—
Reply to this email directly, view it on GitHub
<#1 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/AEGAGUZKF5JDR42ZCMJRHXTV55GP7ANCNFSM6AAAAAAQKNJFFU>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
from hero-app.
ETretyakov
commented on September 28, 2024
You have forgot to add .env file to the root of your repository, the content of the .env file should be like this:
# BASE
API_V1_PREFIX="/api/v1"
DEBUG=True
PROJECT_NAME="Heroes App (local)"
VERSION="0.1.0"
DESCRIPTION="The API for Heroes app."
# DATABASE
DB_ASYNC_CONNECTION_STR="postgresql+asyncpg://hero:[email protected]:5436/heroes_db"
DB_ASYNC_TEST_CONNECTION_STR="postgresql+asyncpg://hero:[email protected]:5436/heroes_db_tests"
DB_EXCLUDE_TABLES="[]"
Pay attention to the connection string it should comply with your database settings
from hero-app.
pvssrikanth
commented on September 28, 2024
Thanks Sir,
For the guidance
But when i created .env
still getting issues
Step 9/10 : RUN alembic upgrade head
---> Running in 1e10484d0271
Traceback (most recent call last):
File "/usr/local/bin/alembic", line 8, in <module>
sys.exit(main())
File "/usr/local/lib/python3.10/site-packages/alembic/config.py", line
588, in main
CommandLine(prog=prog).main(argv=argv)
File "/usr/local/lib/python3.10/site-packages/alembic/config.py", line
582, in main
self.run_cmd(cfg, options)
File "/usr/local/lib/python3.10/site-packages/alembic/config.py", line
559, in run_cmd
fn(
File "/usr/local/lib/python3.10/site-packages/alembic/command.py", line
320, in upgrade
script.run_env()
File "/usr/local/lib/python3.10/site-packages/alembic/script/base.py",
line 563, in run_env
util.load_python_file(self.dir, "env.py")
File "/usr/local/lib/python3.10/site-packages/alembic/util/pyfiles.py",
line 92, in load_python_file
module = load_module_py(module_id, path)
File "/usr/local/lib/python3.10/site-packages/alembic/util/pyfiles.py",
line 108, in load_module_py
spec.loader.exec_module(module) # type: ignore
File "<frozen importlib._bootstrap_external>", line 883, in exec_module
File "<frozen importlib._bootstrap>", line 241, in
_call_with_frames_removed
File "/vyce-backend/migrations/env.py", line 27, in <module>
from app.heroes.models import Hero # noqa: 'autogenerate' support
File "/vyce-backend/./app/__init__.py", line 9, in <module>
settings = Settings()
File "pydantic/env_settings.py", line 38, in
pydantic.env_settings.BaseSettings.__init__
File "pydantic/main.py", line 341, in pydantic.main.BaseModel.__init__
pydantic.error_wrappers.ValidationError: 7 validation errors for Settings
api_v1_prefix
field required (type=value_error.missing)
debug
field required (type=value_error.missing)
project_name
field required (type=value_error.missing)
version
field required (type=value_error.missing)
description
field required (type=value_error.missing)
db_async_connection_str
field required (type=value_error.missing)
db_async_test_connection_str
field required (type=value_error.missing)
The command '/bin/sh -c alembic upgrade head' returned a non-zero code: 1
***@***.***:~/srik/hero-app$
CAN you please guide if my .env which is pointing to postgresql another
server configuration is wrong OR shall i install postgresql from here in
this server.
The command '/bin/sh -c alembic upgrade head' returned a non-zero code: 1
***@***.***:~/srik/hero-app$ cat .env
# BASE
API_V1_PREFIX="/api/v1"
DEBUG=True
PROJECT_NAME="IIB App (local)"
VERSION="0.1.0"
DESCRIPTION="The API rest open api app."
# DATABASE
#DB_ASYNC_CONNECTION_STR="postgresql+asyncpg://
***@***.***:5436/heroes_db"
#DB_ASYNC_TEST_CONNECTION_STR="postgresql+asyncpg://
***@***.***:5436/heroes_db_tests"
#DB_EXCLUDE_TABLES="[]"
DB_ASYNC_CONNECTION_STR="postgresql+asyncpg://
***@***.***:5432/heroes_db"
DB_ASYNC_TEST_CONNECTION_STR="postgresql+asyncpg://
***@***.***:5432/heroes_db_tests"
DB_EXCLUDE_TABLES="[]"
***@***.***:~/srik/hero-app$
Regards,
…On Mon, Sep 12, 2022 at 11:46 PM Evgeniy Tretyakov ***@***.***> wrote:
You have forgot to add *.env* file to the root of your repository, the
content of the *.env* file should be like this:
# BASE
API_V1_PREFIX="/api/v1"
DEBUG=True
PROJECT_NAME="Heroes App (local)"
VERSION="0.1.0"
DESCRIPTION="The API for Heroes app."
# DATABASE
***@***.***:5436/heroes_db"
***@***.***:5436/heroes_db_tests"
DB_EXCLUDE_TABLES="[]"
Pay attention to the connection string it should comply with your database
settings
—
Reply to this email directly, view it on GitHub
<#1 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/AEGAGUZIV6OUGU3CH6B2JDDV55XORANCNFSM6AAAAAAQKNJFFU>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
from hero-app.
ETretyakov
commented on September 28, 2024
Well, .env file looks fine.
The error related to the failure of reading environment variables by pydantic Settings. Do you run alembic upgrade head command from the project root directory?
from hero-app.
pvssrikanth
commented on September 28, 2024
No Sir
Shall i run that command
I thought docker will take care
Shall i run it explicitly and followed with docker
Thanks for your guidance
…On Tuesday, September 13, 2022, Evgeniy Tretyakov ***@***.***> wrote:
Well, .env file looks fine.
The error related to the failure of reading environment variables by
pydantic Settings. Do you run alembic upgrade head command from the
project root directory?
—
Reply to this email directly, view it on GitHub
<#1 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/AEGAGU6Z7PWFL7BFMWE3OXTV6B5THANCNFSM6AAAAAAQKNJFFU>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
from hero-app.
ETretyakov
commented on September 28, 2024
Ok, I see the problem.
Use this command to build Docker container: docker build --build-arg ENV_FILE=".env" -t hero-app -f Dockerfile .
And this command to start container: docker run -d -p "8080:80" --name hero-app hero-app
Also pay attention to connection strings, i.e. on Mac OSX database on localhost would look like this: postgresql+asyncpg://hero:[email protected]:5436/heroes_db
from hero-app.
pvssrikanth
commented on September 28, 2024
Thanks for the Reply sir,
when i ran docker command
I am getting following error
• Installing markupsafe (2.1.1)
OSError
Could not find a suitable TLS CA certificate bundle, invalid path:
/usr/local/lib/python3.10/site-packages/certifi/cacert.pem
at /usr/local/lib/python3.10/site-packages/requests/adapters.py:263 in
cert_verify
259│ if not cert_loc:
260│ cert_loc =
extract_zipped_paths(DEFAULT_CA_BUNDLE_PATH)
261│
262│ if not cert_loc or not os.path.exists(cert_loc):
→ 263│ raise OSError(
264│ f"Could not find a suitable TLS CA
certificate bundle, "
265│ f"invalid path: {cert_loc}"
266│ )
267│
• Updating packaging (20.9 -> 21.3)
• Installing pluggy (1.0.0)
• Installing py (1.11.0)
• Installing tomli (2.0.1)
• Installing typing-extensions (4.2.0)
The command '/bin/sh -c poetry config virtualenvs.create false && poetry
install --no-interaction --no-ansi' returned a non-zero code: 1
AND I went creating env3.8 and tried
(env) ***@***.***:~/srik/hero-app$ alembic upgrade head
Traceback (most recent call last):
File "/usr/bin/alembic", line 11, in <module>
load_entry_point('alembic==1.1.0.dev0', 'console_scripts', 'alembic')()
File "/usr/lib/python3/dist-packages/alembic/config.py", line 540, in main
CommandLine(prog=prog).main(argv=argv)
File "/usr/lib/python3/dist-packages/alembic/config.py", line 534, in main
self.run_cmd(cfg, options)
File "/usr/lib/python3/dist-packages/alembic/config.py", line 511, in
run_cmd
fn(
File "/usr/lib/python3/dist-packages/alembic/command.py", line 279, in
upgrade
script.run_env()
File "/usr/lib/python3/dist-packages/alembic/script/base.py", line 475,
in run_env
util.load_python_file(self.dir, "env.py")
File "/usr/lib/python3/dist-packages/alembic/util/pyfiles.py", line 98,
in load_python_file
module = load_module_py(module_id, path)
File "/usr/lib/python3/dist-packages/alembic/util/compat.py", line 174,
in load_module_py
spec.loader.exec_module(module)
File "<frozen importlib._bootstrap_external>", line 848, in exec_module
File "<frozen importlib._bootstrap>", line 219, in
_call_with_frames_removed
File "/home/srikanth/srik/hero-app/migrations/env.py", line 8, in <module>
from sqlalchemy.ext.asyncio import AsyncEngine
ModuleNotFoundError: No module named 'sqlalchemy.ext.asyncio'
(env) ***@***.***:~/srik/hero-app$
Kindly advise what next to do
Thanking you
srikanth
…On Tue, Sep 13, 2022 at 9:15 PM Evgeniy Tretyakov ***@***.***> wrote:
Ok, I see the problem.
Use this command to build Docker container: docker build --build-arg
ENV_FILE=".env" -t hero-app -f Dockerfile .
And this command to start container: docker run -d -p "8080:80" --name
hero-app hero-app
Also pay attention to connection strings, i.e. on Mac OSX database on
localhost would look like this:
***@***.***:5436/heroes_db
—
Reply to this email directly, view it on GitHub
<#1 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/AEGAGU4QRKGOJH22T25IFITV6CORTANCNFSM6AAAAAAQKNJFFU>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
from hero-app.
pvssrikanth
commented on September 28, 2024
Dear Sir,
Step 9/10 : RUN alembic upgrade head
---> Running in 5c2793a8b21f
Traceback (most recent call last):
File "/usr/local/bin/alembic", line 8, in <module>
sys.exit(main())
File "/usr/local/lib/python3.10/site-packages/alembic/config.py", line
588, in main
CommandLine(prog=prog).main(argv=argv)
File "/usr/local/lib/python3.10/site-packages/alembic/config.py", line
582, in main
self.run_cmd(cfg, options)
File "/usr/local/lib/python3.10/site-packages/alembic/config.py", line
559, in run_cmd
fn(
File "/usr/local/lib/python3.10/site-packages/alembic/command.py", line
320, in upgrade
script.run_env()
File "/usr/local/lib/python3.10/site-packages/alembic/script/base.py",
line 563, in run_env
util.load_python_file(self.dir, "env.py")
File "/usr/local/lib/python3.10/site-packages/alembic/util/pyfiles.py",
line 92, in load_python_file
module = load_module_py(module_id, path)
File "/usr/local/lib/python3.10/site-packages/alembic/util/pyfiles.py",
line 108, in load_module_py
spec.loader.exec_module(module) # type: ignore
File "<frozen importlib._bootstrap_external>", line 883, in exec_module
File "<frozen importlib._bootstrap>", line 241, in
_call_with_frames_removed
File "/vyce-backend/migrations/env.py", line 97, in <module>
asyncio.run(run_migrations_online())
File "/usr/local/lib/python3.10/asyncio/runners.py", line 44, in run
return loop.run_until_complete(main)
File "/usr/local/lib/python3.10/asyncio/base_events.py", line 646, in
run_until_complete
return future.result()
File "/vyce-backend/migrations/env.py", line 88, in run_migrations_online
async with connectable.connect() as connection:
File
"/usr/local/lib/python3.10/site-packages/sqlalchemy/ext/asyncio/base.py",
line 60, in __aenter__
return await self.start(is_ctxmanager=True)
File
"/usr/local/lib/python3.10/site-packages/sqlalchemy/ext/asyncio/engine.py",
line 155, in start
await (greenlet_spawn(self.sync_engine.connect))
File
"/usr/local/lib/python3.10/site-packages/sqlalchemy/util/_concurrency_py3k.py",
line 126, in greenlet_spawn
result = context.throw(*sys.exc_info())
File
"/usr/local/lib/python3.10/site-packages/sqlalchemy/future/engine.py", line
406, in connect
return super(Engine, self).connect()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py",
line 3234, in connect
return self._connection_cls(self, close_with_result=close_with_result)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py",
line 96, in __init__
else engine.raw_connection()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py",
line 3313, in raw_connection
return self._wrap_pool_connect(self.pool.connect, _connection)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py",
line 3280, in _wrap_pool_connect
return fn()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py",
line 310, in connect
return _ConnectionFairy._checkout(self)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py",
line 868, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py",
line 476, in checkout
rec = pool._do_get()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/impl.py",
line 256, in _do_get
return self._create_connection()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py",
line 256, in _create_connection
return _ConnectionRecord(self)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py",
line 371, in __init__
self.__connect()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py",
line 665, in __connect
with util.safe_reraise():
File
"/usr/local/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py",
line 70, in __exit__
compat.raise_(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/compat.py",
line 207, in raise_
raise exception
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py",
line 661, in __connect
self.dbapi_connection = connection = pool._invoke_creator(self)
File
"/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/create.py", line
590, in connect
return dialect.connect(*cargs, **cparams)
File
"/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py",
line 597, in connect
return self.dbapi.connect(*cargs, **cparams)
File
"/usr/local/lib/python3.10/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py",
line 777, in connect
await_only(self.asyncpg.connect(*arg, **kw)),
File
"/usr/local/lib/python3.10/site-packages/sqlalchemy/util/_concurrency_py3k.py",
line 68, in await_only
return current.driver.switch(awaitable)
File
"/usr/local/lib/python3.10/site-packages/sqlalchemy/util/_concurrency_py3k.py",
line 121, in greenlet_spawn
value = await result
File "/usr/local/lib/python3.10/site-packages/asyncpg/connection.py",
line 2085, in connect
return await connect_utils._connect(
File "/usr/local/lib/python3.10/site-packages/asyncpg/connect_utils.py",
line 881, in _connect
return await _connect_addr(
File "/usr/local/lib/python3.10/site-packages/asyncpg/connect_utils.py",
line 790, in _connect_addr
return await __connect_addr(params_retry, timeout, False, *args)
File "/usr/local/lib/python3.10/site-packages/asyncpg/connect_utils.py",
line 831, in __connect_addr
await compat.wait_for(connected, timeout=timeout)
File "/usr/local/lib/python3.10/site-packages/asyncpg/compat.py", line
66, in wait_for
return await asyncio.wait_for(fut, timeout)
File "/usr/local/lib/python3.10/asyncio/tasks.py", line 445, in wait_for
return fut.result()
asyncpg.exceptions.InvalidPasswordError: password authentication failed for
user "postgres"
The command '/bin/sh -c alembic upgrade head' returned a non-zero code: 1
(env) ***@***.***:~/srik/hero-app$
However from dbadmin I WAS ABLE TO connect DB
[image: image.png]
Kindly help me resolve this error
Thanking you
On Tue, Sep 13, 2022 at 9:24 PM Srikanth Pokkuluri ***@***.***>
wrote:
… Thanks for the Reply sir,
when i ran docker command
I am getting following error
• Installing markupsafe (2.1.1)
OSError
Could not find a suitable TLS CA certificate bundle, invalid path:
/usr/local/lib/python3.10/site-packages/certifi/cacert.pem
at /usr/local/lib/python3.10/site-packages/requests/adapters.py:263 in
cert_verify
259│ if not cert_loc:
260│ cert_loc =
extract_zipped_paths(DEFAULT_CA_BUNDLE_PATH)
261│
262│ if not cert_loc or not os.path.exists(cert_loc):
→ 263│ raise OSError(
264│ f"Could not find a suitable TLS CA
certificate bundle, "
265│ f"invalid path: {cert_loc}"
266│ )
267│
• Updating packaging (20.9 -> 21.3)
• Installing pluggy (1.0.0)
• Installing py (1.11.0)
• Installing tomli (2.0.1)
• Installing typing-extensions (4.2.0)
The command '/bin/sh -c poetry config virtualenvs.create false && poetry
install --no-interaction --no-ansi' returned a non-zero code: 1
AND I went creating env3.8 and tried
(env) ***@***.***:~/srik/hero-app$ alembic upgrade head
Traceback (most recent call last):
File "/usr/bin/alembic", line 11, in <module>
load_entry_point('alembic==1.1.0.dev0', 'console_scripts', 'alembic')()
File "/usr/lib/python3/dist-packages/alembic/config.py", line 540, in
main
CommandLine(prog=prog).main(argv=argv)
File "/usr/lib/python3/dist-packages/alembic/config.py", line 534, in
main
self.run_cmd(cfg, options)
File "/usr/lib/python3/dist-packages/alembic/config.py", line 511, in
run_cmd
fn(
File "/usr/lib/python3/dist-packages/alembic/command.py", line 279, in
upgrade
script.run_env()
File "/usr/lib/python3/dist-packages/alembic/script/base.py", line 475,
in run_env
util.load_python_file(self.dir, "env.py")
File "/usr/lib/python3/dist-packages/alembic/util/pyfiles.py", line 98,
in load_python_file
module = load_module_py(module_id, path)
File "/usr/lib/python3/dist-packages/alembic/util/compat.py", line 174,
in load_module_py
spec.loader.exec_module(module)
File "<frozen importlib._bootstrap_external>", line 848, in exec_module
File "<frozen importlib._bootstrap>", line 219, in
_call_with_frames_removed
File "/home/srikanth/srik/hero-app/migrations/env.py", line 8, in
<module>
from sqlalchemy.ext.asyncio import AsyncEngine
ModuleNotFoundError: No module named 'sqlalchemy.ext.asyncio'
(env) ***@***.***:~/srik/hero-app$
Kindly advise what next to do
Thanking you
srikanth
On Tue, Sep 13, 2022 at 9:15 PM Evgeniy Tretyakov <
***@***.***> wrote:
> Ok, I see the problem.
>
> Use this command to build Docker container: docker build --build-arg
> ENV_FILE=".env" -t hero-app -f Dockerfile .
> And this command to start container: docker run -d -p "8080:80" --name
> hero-app hero-app
>
> Also pay attention to connection strings, i.e. on Mac OSX database on
> localhost would look like this:
> ***@***.***:5436/heroes_db
>
> —
> Reply to this email directly, view it on GitHub
> <#1 (comment)>,
> or unsubscribe
> <https://github.com/notifications/unsubscribe-auth/AEGAGU4QRKGOJH22T25IFITV6CORTANCNFSM6AAAAAAQKNJFFU>
> .
> You are receiving this because you authored the thread.Message ID:
> ***@***.***>
>
from hero-app.
ETretyakov
commented on September 28, 2024
Please tell me what OS do you use, and where is your database located (local, docker, external)?
from hero-app.
pvssrikanth
commented on September 28, 2024
Dear Sir,
I am using ubuntu20.2 details below
***@***.***:~/srik/hero-app$ cat /etc/lsb-release
DISTRIB_ID=Ubuntu
DISTRIB_RELEASE=20.04
DISTRIB_CODENAME=focal
DISTRIB_DESCRIPTION="Ubuntu 20.04.5 LTS"
***@***.***:~/srik/hero-app$
and I have installed locally Postgresql using docker , details below
[sudo] password for srikanth:
CONTAINER ID IMAGE COMMAND CREATED
STATUS PORTS NAMES
1aeb8cd5d93b dpage/pgadmin4 "/entrypoint.sh" 12 hours ago Up
12 hours 443/tcp, 0.0.0.0:5050->80/tcp, :::5050->80/tcp
pgadmin_container
976b00b5bfe9 postgres "docker-entrypoint.s…" 12 hours ago Up
12 hours 0.0.0.0:5432->5432/tcp, :::5432->5432/tcp
postgres_container
***@***.***:~/srik/hero-app$
and contents of .env is below where i pointed to the localhost
***@***.***:~/srik/hero-app$ cat .env
# BASE
API_V1_PREFIX="/api/v1"
DEBUG=True
PROJECT_NAME="IIB App (local)"
VERSION="0.1.0"
DESCRIPTION="The API rest open api app."
# DATABASE
#DB_ASYNC_CONNECTION_STR="postgresql+asyncpg://
***@***.***:5436/heroes_db"
#DB_ASYNC_TEST_CONNECTION_STR="postgresql+asyncpg://
***@***.***:5436/heroes_db_tests"
#DB_EXCLUDE_TABLES="[]"
DB_ASYNC_CONNECTION_STR="postgresql+asyncpg://
***@***.***:5432/postgres"
DB_ASYNC_TEST_CONNECTION_STR="postgresql+asyncpg://
***@***.***:5432/postgres"
DB_EXCLUDE_TABLES="[]"
***@***.***:~/srik/hero-app$
Please help in resolving this issue.
AND one Technical query, Assume i have postgresql database with tables
populated by another python-django webapplication.
AND i want to create a fastapi on specific table pointing enabling CRUD
operations, any thoughts sir , is it easy to do or redesign completely and
load table once again.
Thanks again for your kind support to me.
Regards,
srikanth
…On Wed, Sep 14, 2022 at 12:30 AM Evgeniy Tretyakov ***@***.***> wrote:
Please tell me what OS do you use, and where is your database located
(local, docker, external)?
—
Reply to this email directly, view it on GitHub
<#1 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/AEGAGUZESHUMDINR2G452P3V6DFOFANCNFSM6AAAAAAQKNJFFU>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
from hero-app.
ETretyakov
commented on September 28, 2024
- You have opened port 5432 in docker for your database, and 5436 in your
.envfile, so you need 5432 in your.envfile. So the lines should look like this:DB_ASYNC_CONNECTION_STR="postgresql+asyncpg://{your_user}:{your_password}@localhost:5432/heroes_db" - As I understand your issue - you have another app with tables and data in it and you want to migrate the service to fastapi. So you need to create app with fastapi with all tables and then migrate your data from Django database to a new one with.
from hero-app.
pvssrikanth
commented on September 28, 2024
Dear Sir,
Still facing issue
***@***.***:~/srik/hero-app$ docker run d47c154c24f8
Traceback (most recent call last):
File "/usr/local/bin/uvicorn", line 8, in <module>
sys.exit(main())
File "/usr/local/lib/python3.10/site-packages/click/core.py", line 1130,
in __call__
return self.main(*args, **kwargs)
File "/usr/local/lib/python3.10/site-packages/click/core.py", line 1055,
in main
rv = self.invoke(ctx)
File "/usr/local/lib/python3.10/site-packages/click/core.py", line 1404,
in invoke
return ctx.invoke(self.callback, **ctx.params)
File "/usr/local/lib/python3.10/site-packages/click/core.py", line 760,
in invoke
return __callback(*args, **kwargs)
File "/usr/local/lib/python3.10/site-packages/uvicorn/main.py", line 437,
in main
run(app, **kwargs)
File "/usr/local/lib/python3.10/site-packages/uvicorn/main.py", line 463,
in run
server.run()
File "/usr/local/lib/python3.10/site-packages/uvicorn/server.py", line
60, in run
return asyncio.run(self.serve(sockets=sockets))
File "/usr/local/lib/python3.10/asyncio/runners.py", line 44, in run
return loop.run_until_complete(main)
File "/usr/local/lib/python3.10/asyncio/base_events.py", line 646, in
run_until_complete
return future.result()
File "/usr/local/lib/python3.10/site-packages/uvicorn/server.py", line
67, in serve
config.load()
File "/usr/local/lib/python3.10/site-packages/uvicorn/config.py", line
458, in load
self.loaded_app = import_from_string(self.app)
File "/usr/local/lib/python3.10/site-packages/uvicorn/importer.py", line
21, in import_from_string
module = importlib.import_module(module_str)
File "/usr/local/lib/python3.10/importlib/__init__.py", line 126, in
import_module
return _bootstrap._gcd_import(name[level:], package, level)
File "<frozen importlib._bootstrap>", line 1050, in _gcd_import
File "<frozen importlib._bootstrap>", line 1027, in _find_and_load
File "<frozen importlib._bootstrap>", line 992, in _find_and_load_unlocked
File "<frozen importlib._bootstrap>", line 241, in
_call_with_frames_removed
File "<frozen importlib._bootstrap>", line 1050, in _gcd_import
File "<frozen importlib._bootstrap>", line 1027, in _find_and_load
File "<frozen importlib._bootstrap>", line 1006, in
_find_and_load_unlocked
File "<frozen importlib._bootstrap>", line 688, in _load_unlocked
File "<frozen importlib._bootstrap_external>", line 883, in exec_module
File "<frozen importlib._bootstrap>", line 241, in
_call_with_frames_removed
File "/vyce-backend/./app/__init__.py", line 9, in <module>
settings = Settings()
File "pydantic/env_settings.py", line 38, in
pydantic.env_settings.BaseSettings.__init__
File "pydantic/main.py", line 341, in pydantic.main.BaseModel.__init__
pydantic.error_wrappers.ValidationError: 7 validation errors for Settings
api_v1_prefix
field required (type=value_error.missing)
debug
field required (type=value_error.missing)
project_name
field required (type=value_error.missing)
version
field required (type=value_error.missing)
description
field required (type=value_error.missing)
db_async_connection_str
field required (type=value_error.missing)
db_async_test_connection_str
field required (type=value_error.missing)
***@***.***:~/srik/hero-app$ vi Dockerfile
I have corrected the database configuration file
and was able to connect the PGADMIN database GUI
***@***.***:~/srik/hero-app$ cat .env
# BASE
API_V1_PREFIX="/api/v1"
DEBUG=True
PROJECT_NAME="IIB App (local)"
VERSION="0.1.0"
DESCRIPTION="The API rest open api app."
DB_ASYNC_CONNECTION_STR="postgresql+asyncpg://
***@***.***:5432/heroes_db"
DB_ASYNC_TEST_CONNECTION_STR="postgresql+asyncpg://
***@***.***:5432/heroes_db"
DB_EXCLUDE_TABLES="[]"
***@***.***:~/srik/hero-app$
Please advice.
Regards,
…On Mon, Sep 12, 2022 at 9:21 PM Evgeniy Tretyakov ***@***.***> wrote:
Hi!
It seems you have generated some new migration file, because I don't have
any with such name - "abf1ce0bccc0". I believe it is located by this path
"migrations/versions/abf1ce0bccc0.py".
So If you want me to help you, you need:
1. to provide the content of your migration file
"migrations/versions/abf1ce0bccc0.py";
2. give me the whole log of the error.
Waiting for your response)
—
Reply to this email directly, view it on GitHub
<#1 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/AEGAGUZKF5JDR42ZCMJRHXTV55GP7ANCNFSM6AAAAAAQKNJFFU>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
from hero-app.
Related Issues (2)
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from hero-app.