Hi,
I want to record my custom form in my database but don't succeed
controllers.py :
@http.route('/coopaname_helpdesk/post_form_ticket/<string:model_name>', methods=['POST'], type = 'http', auth='public', website= True )
def website_form(self, model_name, **kwargs):
try:
data = { 'test' : 'success'}
cnx = psycopg2.connect('dbname=<coopaname-2019-06-03>', 'user=<admin>')
mark = cnx.cursor()
query = ("""
INSERT INTO <monmarchepublic> ('x_cat','x_objet_consultation','x_membre_interne','x_membre_externe','x_equipeok','x_admin','x_type_marche','x_ville_adju','x_date_order','x_date_limite','x_duree_marche','x_montant_marche','x_num_ref','x_pj','x_name','x_mail','x_inputstreet1','x_inputcity1','x_inputzip1','x_inputstreet2','x_inputcity2','x_inputzip2')
VALUES (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,);
"""
)
mark.execute(query)
return json.dumps(data)
except:
return json.dumps({'error_fields': " Tout cassé"})But it's doesn't work, can you help me my friends please