Advertisement
Guest User

Untitled

a guest
Jul 24th, 2019
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.88 KB | None | 0 0
  1. Error save strategy: near "ON": syntax error Unable to execute statement
  2. sql:
  3. INSERT INTO strategy (
  4. id_strategy,
  5. name_strategy,
  6. instrument,
  7. data_series,
  8. positions,
  9. avg_price,
  10. unrealized_pnl,
  11. realized_pnl,
  12. account,
  13. host,
  14. auto_connect
  15. ) VALUES (
  16. 1, /* id_strategy */
  17. 'Alfabot', /* name_strategy */
  18. '', /* instrument */
  19. '', /* data_series */
  20. 0, /* positions */
  21. 0, /* avg_price */
  22. 0, /* unrealized_pnl */
  23. 0, /* realized_pnl */
  24. 0, /* account */
  25. '127.0.0.1:1986', /* host */
  26. 0 /* auto_connect */
  27. ) ON CONFLICT(id_strategy) DO UPDATE SET
  28. name_strategy = 'Alfabot',
  29. instrument = '',
  30. data_series = '',
  31. positions = 0,
  32. avg_price = 0,
  33. unrealized_pnl = 0,
  34. realized_pnl = 0,
  35. account = 0,
  36. host = '127.0.0.1:1986',
  37. auto_connect = 0;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement