Advertisement
Guest User

Untitled

a guest
Mar 27th, 2017
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.87 KB | None | 0 0
  1. var context2 = {
  2. name: 'my_name',
  3. body: 'insert into Passn' +
  4. 'selectn' +
  5. ' "Number 1" as subject,n' +
  6. ' "The student id " || getString(e, "1") || " is present!" as text,n' +
  7. ' "abc@gmail.com" as receiver,n' +
  8. ' "abc@gmail.com" as cc,n' +
  9. 'from TestResults en' +
  10. 'where getNumber(e, "1") > 60'
  11. };
  12. console.log(context2);
  13.  
  14. // Output:
  15. Object {
  16. "body": "insert into Pass
  17. select
  18. "Number 1" as subject,
  19. "The student id " || getString(e, "1") || " is present!" as text,
  20. "abc@gmail.com" as receiver,
  21. "abc@gmail.com" as cc,
  22. from TestResults e
  23. where getNumber(e, "1") > 60",
  24. "name": "my_name"
  25. }
  26.  
  27. var a = 1;
  28. var b = "abc@gmail.com";
  29. var c = "my_name";
  30. var d = 60;
  31. var context1 = {
  32. name: `${c}`,
  33. body: 'insert into Passn' +
  34. 'selectn' +
  35. ` "Number ${a} " as subject,n` +
  36. ` "The student id " || getString(e, "${a}") || "is present!" as text,n` +
  37. ` "${b}" as receiver,n` +
  38. ' "abc@gmail.com" as cc,n' +
  39. 'from TestResults en' +
  40. `where getNumber(e, "${a}") > ${d}`
  41. };
  42.  
  43. console.log(context1);
  44.  
  45. // Output:
  46. Object {
  47. "body": "insert into Pass
  48. select
  49. "Number 1 " as subject,
  50. "The student id " || getString(e, "1") || "is present!" as text,
  51. "abc@gmail.com" as receiver,
  52. "abc@gmail.com" as cc,
  53. from TestResults e
  54. where getNumber(e, "1") > 60",
  55. "name": "my_name"
  56. }
  57.  
  58. var context2 = {
  59. name: 'my_name',
  60. body: 'insert into Passn' + 'selectn' + ' "Number 1" as subject,n' + ' "The student id " || getString(e, "1") || " is present!" as text,n' + ' "abc@gmail.com" as receiver,n' + ' "abc@gmail.com" as cc,n' + 'from TestResults en' + 'where getNumber(e, "1") > 60'
  61. };
  62.  
  63. var context1 = {
  64. name: "" + c,
  65. body: 'insert into Passn' + 'selectn' + (" "Number " + a + " " as subject,n") + (" "The student id " || getString(e, "" + a + "") || "is present!" as text,n") + (" "" + b + "" as receiver,n") + ' "abc@gmail.com" as cc,n' + 'from TestResults en' + ("where getNumber(e, "" + a + "") > " + d)
  66. };
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement