How to return the code and files to the state "a second before" the commit and push?

Question

git

0) Pushed a commit from Pychram
1) On the github site, I deleted the .venv folder of my django project (something I thought that I didn’t need it there). Perhaps I changed a couple of letters in settings.py
2) Continued to work locally in Pycharm. Implemented something, made changes to the database (sqlite)
3) From Pychram I decided to commit and push.
4) Pycharm offered me to kindly merge, but I chose some other option. For some reason, I decided that the selected option would simply push all the changes from the machine, not paying attention to the fact that there were changes on github (and there is no whole folder there)
5) As a result, everything somehow got mixed up on my computer, part of the code changes (from item 2) remained, part was removed. The database also lost new data.

How to return the code and files to the state "a second before" the commit and push (item 3)? That is, to the state when everything worked locally