diff options
| author | jwansek <eddie.atten.ea29@gmail.com> | 2023-05-11 14:54:25 +0100 |
|---|---|---|
| committer | jwansek <eddie.atten.ea29@gmail.com> | 2023-05-11 14:54:25 +0100 |
| commit | b0f2c84d0ab4112040a4db49541eab504d1ec2c0 (patch) | |
| tree | 0f68701380632db18ef2bd1ac827f4d45f164f0c /database.py | |
| parent | 2236addff431fc80ecbb3fbc5560274585ee6429 (diff) | |
| download | UKGenderPayGap-b0f2c84d0ab4112040a4db49541eab504d1ec2c0.tar.gz UKGenderPayGap-b0f2c84d0ab4112040a4db49541eab504d1ec2c0.zip | |
Preliminarily added SIC section pay gap visualization
Diffstat (limited to 'database.py')
| -rw-r--r-- | database.py | 5 |
1 files changed, 3 insertions, 2 deletions
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)) |