Python Crud.insert_many Beispiele

Beispiel #1

Datei: example.py Projekt: Ahmed512w/Python-PostgreSQL-CRUD

#!/usr/bin/env python3
from crud import Crud

table = Crud(user='******',
             password='******',
             host='127.0.0.1',
             port='5432',
             dbname='postgres',
             table='cities',
             primarykey='city')

table.connect()

table.insert(city='fayoum', address='south of cairo')

table.insert_many(columns=('city', 'address'),
                  rows=[['matrooh', 'north'], ['luxor', 'south']])

table.commit()

table.select_all()

table.select_all(primaryKey_value='luxor')

table.select(columns=['address'], primaryKey_value='luxor')

table.select(columns=['address'])

table.update(column='address',
             column_value='50 KM south of cairo',
             primaryKey_value='fayoum')