Das deutsche Python-Forum

Code: Alles auswählen

import json
#import datetime
#import requests
import firebirdsql
#import sys
#import glob, os

### Parameter für Datenbank aus json lesen
with open('db.json', encoding="utf8") as json_file:
    data = json.load(json_file)

#### Verbindung zur Firebird Datenbank herstellen
conn = firebirdsql.connect(
    host=(data['DB_Path']['Server']),
    database=(data['DB_Path']['Pfad']),
    port=(data['DB_Path']['Port']),
    user=(data['DB_Path']['User']),
    password=(data['DB_Path']['Pass'])
)
query = 'Select Name, Vorname, Datum, Helfernr From (Select tZ.ZeitraumID, tZ.Datum, tZ.Anmelden, tHZ.Helfernr, tHZ.HelferID, tH.Name, tH.Vorname From Zeitbuchungen tZ Left Join Helfer_zeitraeume tHZ On tZ.ZEITRAUMID = tHZ.ID Left Join Helfer tH On tHZ.helferid = tH.ID Where Cast(tZ.Datum As Date) = (select cast('Now' as date) from rdb$database)  And tZ.Anmelden = 1) t Group By Name, Vorname, Datum, Helfernr'

#query = "Select * from Feiertage"
cur = conn.cursor()
cur.execute(query)
print (cur.fetchall())

Code: Alles auswählen

query = "Select Name, Vorname, Datum, Helfernr From (Select tZ.ZeitraumID, tZ.Datum, tZ.Anmelden, tHZ.Helfernr, tHZ.HelferID, tH.Name, tH.Vorname From Zeitbuchungen tZ Left Join Helfer_zeitraeume tHZ On tZ.ZEITRAUMID = tHZ.ID Left Join Helfer tH On tHZ.helferid = tH.ID Where Cast(tZ.Datum As Date) = (select cast('Now' as date) from rdb$database)  And tZ.Anmelden = 1) t Group By Name, Vorname, Datum, Helfernr"