8 months ago
I have two seeders to input data into my postgres server on railway.
When I run the seeders, via CLI, It says they ran with no issues and the migrations finished, but there is no data within the required tables:
PS C:\Users\madis\source\incidents\backend> railway run npx sequelize-cli db:seed:all --seeders-path src/seeders --config src/config/config.js
Sequelize CLI [Node: 18.17.0, CLI: 6.6.2, ORM: 6.37.3]
Loaded configuration file "src\config\config.js".
Using environment "development".
== seed-global-roles: migrating =======
== seed-global-roles: migrated (0.017s)
== seed-permissions: migrating =======
== seed-permissions: migrated (0.002s)0 Replies
Command I am running:
railway run npx sequelize-cli db:seed:all --seeders-path src/seeders --config src/config/config.js8 months ago
how have you verified there isn't any data in the database?
8 months ago
the data tab will only show you tables in the default database, you might not be putting data into that database
What do you mean?
When my backend service spins up, and is connected to the postgres instance I made, it creates all the required tables I need via sequelize
I can log into pgAdmin4 to confirm, but im almost positive that the data isnt there, as a logged in user creating a tenant fails because on my backend, its trying to apply global roles to the user during tenant creation.
8 months ago
please check with pgadmin
8 months ago
so if your data isn't making it into that database, where is it going?
Great question. I only have one database on railway. So why is it telling me that it succeeded in migration for seeders?
8 months ago
that would be more of a question you have to ask yourself, we didn't write the seeder script haha
8 months ago
I would recommend you add better logging to the seeder script, if something is going wrong, why isn't it letting you know?
8 months ago
unfortunately there isn't much we can do here as this isn't necessarily a platform issue
8 months ago
there is not, but this would be an issue with the script, if it isnt doing what its suppoed to it should be telling you whats wrong
Wasn't a script issue, I solved it.
My config.ts for sequelize was set up in a way that if it fails connection, to default back to development NODE_ENV. It was failing because it was not recognizing postgres.railway.internal for the host.
8 months ago
ah, glad you solved that, partially a script issue, it should surface such errors.