From b0f2c84d0ab4112040a4db49541eab504d1ec2c0 Mon Sep 17 00:00:00 2001 From: jwansek Date: Thu, 11 May 2023 14:54:25 +0100 Subject: Preliminarily added SIC section pay gap visualization --- database.py | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'database.py') diff --git a/database.py b/database.py index 3e52016..80edd3c 100644 --- a/database.py +++ b/database.py @@ -332,7 +332,7 @@ class PayGapDatabase: f = cursor.fetchone()[0] if f is not None: - pay.append((section_name, f)) + pay.append((section_name, float(f))) return sorted(pay, key = operator.itemgetter(1), reverse = True) @@ -347,5 +347,6 @@ if __name__ == "__main__": host = "db" with PayGapDatabase(host = host) as db: - print(db.get_pay_by_sic_section("hourly", None)) + print(db.get_years()) + print(db.get_pay_by_sic_section("bonuses", None)) -- cgit v1.2.3