und zwar hab ich folgendes Problem.
Meine Datenbank ist eine postgres-Datenbank bzw die Anbindung läuft über postgres.
Die Datenbank ist angelegt und will einfach per Skript mir nur paar Sachen in eine Tabelle eintragen lassen.
Tabelle ist ebenso angelegt. Hier der Code.
Code: Alles auswählen
import psycopg2
connection = psycopg2.connect("dbname=sqltest")
connection.commit()
cursor = connection.cursor()
cursor.execute('INSERT INTO staatsangehoerigkeit VALUES '
"('afghanisch') ,"
"('aegyptisch') ,"
"('albanisch') ,"
"('algerisch') ,"
"('amerikanisch') ,"
"('andorranisch') ,"
"('angolanisch') ,"
"('antiguanisch') ,"
"('aequatorialguineisch') ,"
"('argentinisch') ,"
"('armenisch') ,"
"('aserbaidschanisch') ,"
"('aethiopisch') ,"
"('australisch') ,"
"('bahamaisch') ,"
"('bahrainisch') ,"
"('bangladeschisch') ,"
"('barbadisch') ,"
"('belgisch') ,"
"('belizisch') ,"
"('beninisch') ,"
"('bhutanisch') ,"
"('bolivianisch') ,"
"('bosnisch-herzegowinisch') ,"
"('botsuanisch') ,"
"('brasilianisch') ,"
"('britisch') ,"
"('bruneiisch') ,"
"('bulgarisch') ,"
"('burkinisch') ,"
"('burundisch') ,"
"('chilenisch') ,"
"('chinesisch') ,"
"('costa-ricanisch') ,"
"('daenisch') ,"
"('deutsch') ,"
"('dominicanisch') ,"
"('dominikanisch') ,"
"('dschibutisch') ,"
"('ecuadorianisch') ,"
"('eritreisch') ,"
"('estnisch') ,"
"('fidschianisch') ,"
"('finnisch') ,"
"('franzoesisch') ,"
"('gabunisch') ,"
"('gambisch') ,"
"('georgisch') ,"
"('ghanaisch') ,"
"('grenadisch') ,"
"('griechisch') ,"
"('guatemaltekisch') ,"
"('guineisch') ,"
"('guinea-bissauisch') ,"
"('guyanisch') ,"
"('haitianisch') ,"
"('honduranisch') ,"
"('indisch') ,"
"('indonesisch') ,"
"('irakisch') ,"
"('iranisch') ,"
"('irisch') ,"
"('isländisch') ,"
"('israelisch') ,"
"('italienisch') ,"
"('ivorisch') ,"
"('jamaikanisch') ,"
"('japanisch') ,"
"('jemenitisch') ,"
"('jordanisch') ,"
"('kambodschanisch') ,"
"('kamerunisch') ,"
"('kanadisch') ,"
"('kapverdisch') ,"
"('kasachisch') ,"
"('katarisch') ,"
"('kenianisch') ,"
"('kirgisisch') ,"
"('kiribatisch') ,"
"('kolumbianisch') ,"
"('komorisch') ,"
"('kongolesisch') ,"
"('kongolesisch') ,"
"('kosovarisch') ,"
"('kroatisch') ,"
"('kubanisch') ,"
"('kuwaitisch') ,"
"('laotisch') ,"
"('lesothisch') ,"
"('lettisch') ,"
"('libanesisch') ,"
"('liberianisch') ,"
"('libysch') ,"
"('liechtensteinisch') ,"
"('litauisch') ,"
"('lucianisch') ,"
"('luxemburgisch') ,"
"('madagassisch') ,"
"('malawisch') ,"
"('malaysisch') ,"
"('maledivisch') ,"
"('malisch') ,"
"('maltesisch') ,"
"('marokkanisch') ,"
"('marshallisch') ,"
"('mauretanisch') ,"
"('mauritisch') ,"
"('mazedonisch') ,"
"('mexikanisch') ,"
"('mikronesisch') ,"
"('moldauisch') ,"
"('monegassisch') ,"
"('mongolisch') ,"
"('montenegrinisch') ,"
"('mosambikanisch') ,"
"('myanmarisch') ,"
"('namibisch') ,"
"('nauruisch') ,"
"('nepalesisch') ,"
"('neuseelaendisch') ,"
"('nicaraguanisch') ,"
"('niederländisch') ,"
"('nigrisch') ,"
"('nigerianisch') ,"
"('niueanisch') ,"
"('nordkoreanisch') ,"
"('norwegisch') ,"
"('omanisch') ,"
"('oesterreichisch') ,"
"('pakistanisch') ,"
"('palauisch') ,"
"('panamaisch') ,"
"('papua-neuguineisch') ,"
"('paraguayisch') ,"
"('peruanisch') ,"
"('philippinisch') ,"
"('polnisch') ,"
"('portugiesisch') ,"
"('ruandisch') ,"
"('rumaenisch') ,"
"('russisch') ,"
"('salomonisch') ,"
"('salvadorianisch') ,"
"('sambisch') ,"
"('samoanisch') ,"
"('san-marinesisch') ,"
"('são-toméisch') ,"
"('saudi-arabisch') ,"
"('schwedisch') ,"
"('schweizerisch') ,"
"('senegalesisch') ,"
"('serbisch') ,"
"('seychellisch') ,"
"('sierra-leonisch') ,"
"('simbabwisch') ,"
"('singapurisch') ,"
"('slowakisch') ,"
"('slowenisch') ,"
"('somalisch') ,"
"('spanisch') ,"
"('sri-lankisch') ,"
"('südafrikanisch') ,"
"('suedkoreanisch') ,"
"('suedsudanesisch') ,"
"('sudanesisch') ,"
"('suedsudanesisch') ,"
"('surinamisch') ,"
"('swasiländisch') ,"
"('syrisch') ,"
"('tadschikisch') ,"
"('tansanisch') ,"
"('thailändisch') ,"
"('timoresisch') ,"
"('togoisch') ,"
"('tongaisch') ,"
"('tschadisch') ,"
"('tschechisch') ,"
"('tunesisch') ,"
"('tuerkisch') ,"
"('turkmenisch') ,"
"('tuvaluisch') ,"
"('ugandisch') ,"
"('ukrainisch') ,"
"('ungarisch') ,"
"('uruguayisch') ,"
"('usbekisch') ,"
"('vanuatuisch') ,"
"('vatikanisch') ,"
"('venezolanisch') ,"
"('vietnamesisch') ,"
"('vincentisch') ,"
"('weißrussisch') ,"
"('zentralafrikanisch') ,"
"('zyprisch')")
connection.commit()
connection.close()
Traceback (most recent call last):
File "/home/karl/Schreibtisch/Projekte/Datenbank/nationalitaeten.py", line 2, in <module>
connection = psycopg2.connect("dbname=sqltest")
File "/usr/lib64/python3.4/site-packages/psycopg2/__init__.py", line 164, in connect
conn = _connect(dsn, connection_factory=connection_factory, async=async)
psycopg2.OperationalError
Vielleicht sehe ich auch den Fehler gerade nicht.
Vielen Dank, Kalli