peter-gy

import subprocess
from shutil import which
from typing import NamedTuple, List
from datetime import datetime
import json
import re
import sys


class Commit(NamedTuple):

peter-gy

Install psycopg2 in Mac M1

Error while installing through pip install psycopg2 looks like this:

Please add the directory containing pg_config to the PATH

or specify the full executable path with the option (...)

Reference to the solution here.

peter-gy

group: 2019.01.29-A: Supermarkt

artikel = {
id:number, bezeichnung:string, verkaufspreis:number, kategorie:string

}

lieferant = {
id:number, name:string, adresse:string, rabatt:number

peter-gy

group: 2020.01.28-A: Architektur-Datenbank 

bauwerk = {
id:number, name:string, ort:string, besucheranzahl:number
1, 'Candice', 'Bangladesh', 249
2, 'Kip', 'Budapest', 769
3, 'Garek', 'Bratislava', 497
4, 'Bradly', 'Boston', 871
5, 'Wynn', 'Boston', 317
6, 'Vance', 'Bratislava', 548