trigger

[23bca310]

explain trigger syntax

[23bca311]

cur.execute(''' create trigger if not exists product_rate_qty before insert on product for each row begin select case when new.prate = 0 THEN raise (abort, 'Product rate cannot be zero.') when new.pqty = 0 THEN raise (abort, 'Product quantity cannot be zero.') end; end; ''')

[23bca310]

how to write table data into csv file using writer object

[23bca311]

with open('product2.csv','w',newline='')as file: writer=csv.writer(file) writer.writerow(['userid','pid','pname','prate','pqty'])

explain this code