lorey
/ postgres_pandas_backup.py
Last active
July 24, 2017 13:46
PostgreSQL tables to csv (Backup database tables as CSV with Pandas)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import os | |
| import pandas as pd | |
| import psycopg2 | |
| from dotenv import find_dotenv | |
| from dotenv import load_dotenv | |
| from psycopg2.extras import DictCursor | |
| def main(): |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| mkdir -p ./rs/ | |
| for semester in $(seq -f "%02g" 4 15); do | |
| wget -O ./rs/20${semester}_SS_aufgaben.pdf --user "rs" --password "rechner.strukturen" https://capp.itec.kit.edu/teaching/rs/ss${semester}/kl/aufgaben.pdf ; | |
| wget -O ./rs/20${semester}_WS_aufgaben.pdf --user "rs" --password "rechner.strukturen" https://capp.itec.kit.edu/teaching/rs/ws${semester}/kl/aufgaben.pdf ; | |
| wget -O ./rs/20${semester}_SS_loesung.pdf --user "rs" --password "rechner.strukturen" https://capp.itec.kit.edu/teaching/rs/ss${semester}/kl/loesung.pdf ; | |
| wget -O ./rs/20${semester}_WS_loesung.pdf --user "rs" --password "rechner.strukturen" https://capp.itec.kit.edu/teaching/rs/ws${semester}/kl/loesung.pdf ; | |
| done |
NewerOlder