Load the shape file data into PostgreSQL using python

I need script in vs code for python and i need requirement file as well.
1.i have a folder it have so many zip folder
2. the first step is to unzip all the folders
3. each folder has 5 different shapefile Trasse, Netzelemente, Pressbohrungen, Rohrnetzknoten, Spuelbohrungen.
4.then we create a new table named Trasse in the database and the coloums for this table we take coloums from the trasse shape file eg fid, geom, nutzung, bauweise, medien, baudatum, laenge_in_, device_nam, kw, and then we add two more coloums called file name, data_import(time stamp)
5.in the file name coloum we need to fill it with the folder name wich we unzipped and time as timestamp
6.in this process we fill the datatable with all the trasse data from each folder
7.then create another datatable called Netzelemente and repeat the process.
8. then create another datatable called Pressbohrungen and repeat the process.
9. then create another datatable called Rohrnetzknoten and repeat the process.
10. then create another datatable called Spuelbohrungen and repeat the process.