intro
intro
RRailway
Created by intro on 8/25/2023 in #✋|help
Modify build command
i really wanted to try railway but it's just giving me too many issues rn
20 replies
RRailway
Created by intro on 8/25/2023 in #✋|help
Modify build command
so i was able to deploy my project with database on render
20 replies
RRailway
Created by intro on 8/25/2023 in #✋|help
Modify build command
so ideally, build command would install requirements, install psycopg2 and do flask upgrade and seed
20 replies
RRailway
Created by intro on 8/25/2023 in #✋|help
Modify build command
i have to use the railway cli in order to do that
20 replies
RRailway
Created by intro on 8/25/2023 in #✋|help
Modify build command
locally is sqlite
20 replies
RRailway
Created by intro on 8/25/2023 in #✋|help
Modify build command
i don't think so. he was specifically talking about the postgres instance
20 replies
RRailway
Created by intro on 8/25/2023 in #✋|help
Modify build command
no i asked my former teacher and he said this: "you do not want to use psycopg2 in development its doesn't play nice with an M1, and we only need to to connect to a postgres db, so by installing it separately in production only, we kind of protect ourselves from accidentally installing it in dev"
20 replies
RRailway
Created by intro on 8/25/2023 in #✋|help
Modify build command
3b4c3c14-6b11-4e8a-8f52-bb11ff2f2554
20 replies
RRailway
Created by intro on 8/24/2023 in #✋|help
Issues with Postgres DB
i guess i don't know how to tackle this
21 replies
RRailway
Created by intro on 8/24/2023 in #✋|help
Issues with Postgres DB
i'm gonna drop my schema and rerun all commands in hope that fixes it
21 replies
RRailway
Created by intro on 8/24/2023 in #✋|help
Issues with Postgres DB
this error is recurring
21 replies
RRailway
Created by intro on 8/24/2023 in #✋|help
Issues with Postgres DB
this is where i am stuck
21 replies
RRailway
Created by intro on 8/24/2023 in #✋|help
Issues with Postgres DB
21 replies
RRailway
Created by intro on 8/24/2023 in #✋|help
Issues with Postgres DB
railway run flask db upgrade gives an error:
21 replies
RRailway
Created by intro on 8/24/2023 in #✋|help
Issues with Postgres DB
railway run flask db migrate
INFO [sqlalchemy.engine.Engine] select pg_catalog.version()
INFO [sqlalchemy.engine.Engine] [raw sql] {}
INFO [sqlalchemy.engine.Engine] select current_schema()
INFO [sqlalchemy.engine.Engine] [raw sql] {}
INFO [sqlalchemy.engine.Engine] show standard_conforming_strings
INFO [sqlalchemy.engine.Engine] [raw sql] {}
INFO [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO [alembic.runtime.migration] Will assume transactional DDL.
INFO [sqlalchemy.engine.Engine] BEGIN (implicit)
INFO [sqlalchemy.engine.Engine] select relname from pg_class c join pg_namespace n on n.oid=c.relnamespace where pg_catalog.pg_table_is_visible(c.oid) and relname=%(name)s
INFO [sqlalchemy.engine.Engine] [generated in 0.00032s] {'name': 'alembic_version'}
INFO [sqlalchemy.engine.Engine] SELECT alembic_version.version_num
FROM alembic_version
INFO [sqlalchemy.engine.Engine] [generated in 0.00033s] {}
INFO [sqlalchemy.engine.Engine] select relname from pg_class c join pg_namespace n on n.oid=c.relnamespace where pg_catalog.pg_table_is_visible(c.oid) and relname=%(name)s
INFO [sqlalchemy.engine.Engine] [cached since 0.3868s ago] {'name': 'alembic_version'}
INFO [sqlalchemy.engine.Engine] SELECT c.relname FROM pg_class c JOIN pg_namespace n ON n.oid = c.relnamespace WHERE n.nspname = %(schema)s AND c.relkind in ('r', 'p')
INFO [sqlalchemy.engine.Engine] [generated in 0.00055s] {'schema': 'public'}
INFO [alembic.autogenerate.compare] Detected added table 'vault_manager.users'
INFO [sqlalchemy.engine.Engine] COMMIT
Generating /Users/hannarosenfeld/Desktop/Code/vault-
manager/backend/migrations/versions/e90d18d95171_.py ... done
Looking good? Run `railway up` to deploy your changes!
INFO [sqlalchemy.engine.Engine] select pg_catalog.version()
INFO [sqlalchemy.engine.Engine] [raw sql] {}
INFO [sqlalchemy.engine.Engine] select current_schema()
INFO [sqlalchemy.engine.Engine] [raw sql] {}
INFO [sqlalchemy.engine.Engine] show standard_conforming_strings
INFO [sqlalchemy.engine.Engine] [raw sql] {}
INFO [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO [alembic.runtime.migration] Will assume transactional DDL.
INFO [sqlalchemy.engine.Engine] BEGIN (implicit)
INFO [sqlalchemy.engine.Engine] select relname from pg_class c join pg_namespace n on n.oid=c.relnamespace where pg_catalog.pg_table_is_visible(c.oid) and relname=%(name)s
INFO [sqlalchemy.engine.Engine] [generated in 0.00032s] {'name': 'alembic_version'}
INFO [sqlalchemy.engine.Engine] SELECT alembic_version.version_num
FROM alembic_version
INFO [sqlalchemy.engine.Engine] [generated in 0.00033s] {}
INFO [sqlalchemy.engine.Engine] select relname from pg_class c join pg_namespace n on n.oid=c.relnamespace where pg_catalog.pg_table_is_visible(c.oid) and relname=%(name)s
INFO [sqlalchemy.engine.Engine] [cached since 0.3868s ago] {'name': 'alembic_version'}
INFO [sqlalchemy.engine.Engine] SELECT c.relname FROM pg_class c JOIN pg_namespace n ON n.oid = c.relnamespace WHERE n.nspname = %(schema)s AND c.relkind in ('r', 'p')
INFO [sqlalchemy.engine.Engine] [generated in 0.00055s] {'schema': 'public'}
INFO [alembic.autogenerate.compare] Detected added table 'vault_manager.users'
INFO [sqlalchemy.engine.Engine] COMMIT
Generating /Users/hannarosenfeld/Desktop/Code/vault-
manager/backend/migrations/versions/e90d18d95171_.py ... done
Looking good? Run `railway up` to deploy your changes!
21 replies
RRailway
Created by intro on 8/24/2023 in #✋|help
Issues with Postgres DB
I deleted the migrations folder and the db instance folder. Deleted all pycache files from backend railway run flask db init
Creating directory /Users/hannarosenfeld/Desktop/Code/vault-manager/backend/migrations ... done
Creating directory /Users/hannarosenfeld/Desktop/Code/vault-manager/backend/migrations/versions ... done
Generating /Users/hannarosenfeld/Desktop/Code/vault-manager/backend/migrations/script.py.mako ... done
Generating /Users/hannarosenfeld/Desktop/Code/vault-manager/backend/migrations/env.py ... done
Generating /Users/hannarosenfeld/Desktop/Code/vault-manager/backend/migrations/README ... done
Generating /Users/hannarosenfeld/Desktop/Code/vault-manager/backend/migrations/alembic.ini ... done
Please edit configuration/connection/logging settings in '/Users/hannarosenfeld/Desktop/Code/vault-
manager/backend/migrations/alembic.ini' before proceeding.
Looking good? Run `railway up` to deploy your changes!
Creating directory /Users/hannarosenfeld/Desktop/Code/vault-manager/backend/migrations ... done
Creating directory /Users/hannarosenfeld/Desktop/Code/vault-manager/backend/migrations/versions ... done
Generating /Users/hannarosenfeld/Desktop/Code/vault-manager/backend/migrations/script.py.mako ... done
Generating /Users/hannarosenfeld/Desktop/Code/vault-manager/backend/migrations/env.py ... done
Generating /Users/hannarosenfeld/Desktop/Code/vault-manager/backend/migrations/README ... done
Generating /Users/hannarosenfeld/Desktop/Code/vault-manager/backend/migrations/alembic.ini ... done
Please edit configuration/connection/logging settings in '/Users/hannarosenfeld/Desktop/Code/vault-
manager/backend/migrations/alembic.ini' before proceeding.
Looking good? Run `railway up` to deploy your changes!
-- migrations folder is being created, but not database instance
21 replies
RRailway
Created by intro on 8/24/2023 in #✋|help
Issues with Postgres DB
that looks the same
21 replies
RRailway
Created by intro on 8/24/2023 in #✋|help
Issues with Postgres DB
how would i know which db i am seeding
21 replies
RRailway
Created by intro on 8/24/2023 in #✋|help
Issues with Postgres DB
3b4c3c14-6b11-4e8a-8f52-bb11ff2f2554
21 replies
RRailway
Created by intro on 8/24/2023 in #✋|help
How would I connect my project with the SQL database ?
72 replies