codinggarden / inventory-app

Model a SQL Database

See the backend folder for more info about the DB.

inventory-app's Issues

Setup Objection.js

• Install library
• Create a Model

Windows Problem with Docker Volume of Postgres

So on line 7 from the docker-compose file it says: - ./docker-data/db-data:/var/lib/postgresql/data
 This works fine on my Mac but does not on Windows.
 It complains about chmod (probably because docker is a different user?)
 It is not something new perse (see docker-library/postgres#435) and there are many other issue's on git about it.
Being new myself to Docker i tried some stuff but i could not figure it out.
 I hope you could tell me how to achieve the same on Windows so I could follow. ☺️

I have a windows 10 Home edition, I know you might say that it doesn’t work on windows 10 Home but it does indeed. You just have to get the Windows 10 Home Version 2004 and it will work! I have tried it and it works without volumes but when I map volumes it starts complaining about chmod thing! 💔

Hope you can help me, and I don’t have a Mac in hand to work on so my only choice is have it work on windows. 💔☺️

[Docker] Volumes within db causes issue's on Windows

So on line 7 from the docker-compose file it says: - ./docker-data/db-data:/var/lib/postgresql/data
This works fine on my Mac but does not on Windows.
It complains about chmod (probabaly because docker is a different user?)
It is not something new perse (see docker-library/postgres#435) and there are many other issue's on git about it.

Being new myself to Docker i tried some stuff but i could not figure it out.
I hope you could tell me how to achieve the same on Windows so i could follow on my Desktop (and not laptop)

Jest timing out during testing

When running npm run test or npx jest I receive the following complaint:

Jest did not exit one second after the test run has completed.

This usually means that there are asynchronous operations that weren't stopped in your tests. Consider running Jest with `--detectOpenHandles` to troubleshoot this issue.

When adding the --detectOpenHandles flag, the command never finishes after the tests conclude.

Docker compose up not reading from .env file

So I'm following along what CJ did in the stream ,
i set up the docker-compose and .env as shown , but when running docker-compose up it says this
The POSTGRES_PASSWORD variable is not set. Defaulting to a blank string.
The POSTGRES_USER variable is not set. Defaulting to a blank string.
The POSTGRES_DB variable is not set. Defaulting to a blank string.

Add Signup / Login Routes

• Install dependencies
• Mount routes
• Validate request body
• Generate token
• Verify token
• isLoggedIn middleware
• Rate limit endpoints

Filtering Item info

inventory-app/backend/src/api/items/items.routes.js

Line 27 in c24c31e

.withGraphFetched('item_infos')

I think we want to filter item_info on deleted_at column. I think we don't want to list the deleted item infos.

Empty data when seeding

How it behaves

When emptying the database's data on seeding, the table names are be gotten by the object key.

How it should behave

When emptying the database's data on seeding, the table names should be gotten by the object value instead of the object key. Otherwise, if the value is changed there will not be any changes and the table names will be the same despite the value.

Possible fix

Replace line 13 of the file with the path backend/db/seeds/00_initial.js from
Object.keys(tableNames).map((name) => knex(name).del()) to
Object.values(tableNames).map((table) => knex(table).del())