Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Traceback (most recent call last):
- File "cron.py", line 5, in <module>
- instance.conexion("162.144.52.66" ,"bicimoto","7-%H1*Zl~&2,M&d]KD","bicimoto_autopartes" )
- File "C:UsersRafaelCDesktopscripts-dbcommun.py", line 84, in conexion
- VALUES (%s,%s, %s, %s, %s, %s,%s ,%s,%s,%s)",("no",1,1,clienteid,0,clienteid,"draft",1,clienteid,hoy,hoy))
- TypeError: not all arguments converted during string formatting
- hoy = str(datetime.now())
- print hoy
- conn = psycopg2.connect(dbname="testing",host = "localhost", user ="jpozzo", password ="bicimoto*")
- cur = conn.cursor()
- for response in request:
- for data in element['orden']:
- ids = data['id']
- cur.execute("INSERT INTO sale_order (invoice_status, user_id,warehouse_id,partner_shipping_id,amount_total,partner_invoice_id,state,company_id,partner_id,create_date,date_order)
- VALUES (%s,%s, %s, %s, %s, %s,%s ,%s,%s,%s)",("no",1,1,clienteid,0,clienteid,"draft",1,clienteid,hoy,hoy))
- conn.commit()
Add Comment
Please, Sign In to add comment