my_list = [
    {
        "username": "ARFASTNET",
        "opening": 4111,
        "closing": 7494,
        "remarks": "Adjustment November Opening:4111 Closing:7494",
    },
    {
        "username": "A1Net",
        "opening": 20600,
        "closing": 22592,
        "remarks": "Adjustment November Opening:20600 Closing:22592",
    },
]


MONTH = 'november'
YEAR = '2022'

f = open("output.sql", "a")

for line in my_list:
    query = f"update public.finance_openingclosingstatement SET opening_balance='{line['opening']}',closing_balance='{line['closing']}',invoice_references='{line['remarks']}' WHERE reseller_username='{line['username']}' and year='{YEAR}' and month='{MONTH}';\n"
    
    f.write(query)

f.close()