def sql_write(query, data):
    #is used to update or insert a new value inside a table. For reading data from the SQL table, use the sql_read function.

    conn = psycopg2.connect(database="productdatabase", user="postgres",password="Welkom01",host="172.16.0.2",port="5432")
    cur = conn.cursor()

    cur.execute(query,data)
    conn.commit()
    conn.close()



insertionlist = ['Cisco Catalyst Test', 1, 200, 200 , 'Test', 1,2,10000,1,'Cisco',]
query= "insert into product(productnaam,product_type,aantallen,prijs,productbeschrijving,poorttypeID,aantal_poorten,serienummer,voorraadID) values (%s, %s, %s, %s, %s, %s, %s, %s, %s,)",

sql_write(query,insertionlist)