Почетна Преглед Помоћ
Пријавите се
libf
/
odbtools
1
0
Креирај огранак 0
Датотеке Дискусије 0 Захтеви за спајање 0 Вики
Дрво: 28a4c2b13f
Гране Ознаке
odbtools
/
restapi
/
insert_test.go

insert_test.go 37 KB
Историја Датотека

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243 
  1. package restapi_test
    2. 

  2. 

  3. import (
    4. 

  4. 	"fmt"
    5. 

  5. 	"testing"
    6. 

  6. 

  7. 	"git.wecise.com/wecise/odbtools/restapi"
    8. 

  8. 	"gitee.com/wecisecode/util/cast"
    9. 

  9. 	"github.com/stretchr/testify/assert"
    10. 

  10. )
    11. 

  11. 

  12. var url = "http://47.92.151.165:8080/mxobject/mql"
    13. 

  13. 

  14. var insertsales = `{"mql": "insert into /aia/Sales (id,AgencyCode,AAMTeamCode,ME,AgencyChnl,SumCommission,OldSumCommission,CommRate,OldCommRate,MaxCommRate,MinCommRate,FirstperiodComm,CommBusiRate,DDOff,GSizeLoad,RiskMargin,TotalVariable,Retension,SerialNo,AgencyName,MECode,MEAM,AgentCode,GrpContNo) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);", 
    15. 

  15. "values": [
    16. 

  16. ["aia_Sales:H000019403", "G00***0199", null, null, "GVS", "832.2", "0", null, null, null, null, "832.2", 1.0, 0.0, null, null, null, 0.0, "H000019403", "周芳", null, "张三", "098***9844", "G09***6563"], 
    17. 

  17. ["aia_Sales:0006746152", "098***4719", null, null, "TM", "81,487.13", "66,713.17", null, null, null, null, "70074.18", 1.0, 0.47, 0.1, -0.145, 0.195, 0.15, "0006746152", null, null, "张三", "098***4719", "G09***956B"], 
    18. 

  18. ["aia_Sales:0007517914", "098***4719", null, null, "TM", "115,914.15", "81,487.13", null, null, null, null, "113805.9", 1.0, 0.47, 0.1, 0.05, 0.195, 0.345, "0007517914", "中任公司", null, "张三", "098***4719", "G09***956C"], 
    19. 

  19. ["aia_Sales:0007040503", "G00***5165", null, null, "GVS", "2,364.20", "0", null, null, null, null, "2,364.20", 1.0, null, null, null, null, 0.0, "0007040503", "戴勇", null, "张三", "098***8360", "G09***855A"], 
    20. 

  20. ["aia_Sales:0007506281", "098***4719", null, null, "TM", "14,994.72", "0", null, null, null, null, "14994.72", 1.0, 0.47, 0.1, 0.05, 0.195, 0.345, "0007506281", "中任公司", null, "张三", "098***4719", "G09***402A"], 
    21. 

  21. ["aia_Sales:0007011185", "G00***3185", null, null, "PKG", "3,670.64", "4,280.80", null, null, null, null, "3,670.64", 1.0, null, null, null, null, 0.0, "0007011185", "王烨", null, "张三", "098***5006", "G09***604A"], 
    22. 

  22. ["aia_Sales:0007015907", "G00***3165", null, null, "PKG", "8,540.24", "0", null, null, null, null, "8,540.24", 1.0, null, null, null, null, 0.0, "0007015907", "顾远", null, "张三", "098***3112", "G09***689A"], 
    23. 

  23. ["aia_Sales:0006919888", "G00***6529", null, null, "PKG", "4,404.20", "5,574.11", null, null, null, null, "6300.32", 1.0, null, null, null, null, 0.0, "0006919888", "温甜1", null, "张三", "098***3556", "G09***709D"], 
    24. 

  24. ["aia_Sales:0000150572", "G00***0199", null, null, "GVS", "1,851.80", "1,172.20", null, null, null, null, "1,851.80", 1.0, 0.0, null, null, null, 0.0, "0000150572", "周芳", null, "张三", "098***9844", "G09***616C"], 
    25. 

  25. ["aia_Sales:0000963771", "G00***0199", null, null, "GVS", "2,273", "1,851.80", null, null, null, null, "2,273.00", 1.0, 0.0, null, null, null, 0.0, "0000963771", "周芳", null, "张三", "098***9844", "G09***616D"], 
    26. 

  26. ["aia_Sales:0005752638", "G00***0199", null, null, "GVS", "3,186.63", "2,273", null, null, null, null, "3,187.80", 1.0, null, null, null, null, 0.0, "0005752638", "周芳", null, "张三", "098***9844", "G09***616E"], 
    27. 

  27. ["aia_Sales:0006420764", "G00***0199", null, null, "GVS", "3,554", "3,186.63", null, null, null, null, "3,554.00", 1.0, null, null, null, null, 0.0, "0006420764", "周芳", null, "张三", "098***9844", "G09***616F"], 
    28. 

  28. ["aia_Sales:0007041279", "G00***0199", null, null, "GVS", "4,120.80", "3,554", null, null, null, null, "4,120.80", 1.0, null, null, null, null, 0.0, "0007041279", "周芳", null, "张三", "098***9844", "G09***616G"], 
    29. 

  29. ["aia_Sales:0006988671", "G00***3348", null, null, "PKG", "5,795.36", "0", null, null, null, null, "5,795.36", 1.0, null, null, null, null, 0.0, "0006988671", "任", null, "张三", "098***6082", "G09***517A"], 
    30. 

  30. ["aia_Sales:0006993715", "G00***3530", null, null, "PKG", "6,597.60", "0", null, null, null, null, "6597.6", 1.0, null, null, null, null, 0.0, "0006993715", "邵雯", null, "张三", "098***9136", "G09***545A"], 
    31. 

  31. ["aia_Sales:0006960163", "G00***3148", null, null, "PKG", "16,309.04", "16,665.40", null, null, null, null, "16,309.04", 1.0, null, null, null, null, 0.0, "0006960163", "朱俊", null, "张三", "098***4835", "G09***124B"], 
    32. 

  32. ["aia_Sales:H000019404", "G00***0199", null, null, "GVS", null, null, null, null, null, null, "832.2", 1, null, null, null, null, null, "H000019404", "周芳", null, "张三", "098***9844", "G09***6563"], 
    33. 

  33. ["aia_Sales:H000045151", "G10***2372", null, null, "GVS", "2,671.80", "0", null, null, null, null, "2145", 1.0, 0.0, null, null, null, 0.0, "H000045151", "郭云", null, "张三", "108***7926", "G10***1593"], 
    34. 

  34. ["aia_Sales:0000158000", "G10***2372", null, null, "GVS", "3,158.40", "3,663.80", null, null, null, null, "95.00", 1.0, 0.0, null, null, null, 0.0, "0000158000", "郭云", null, "张三", "108***7926", "G10***522C"], 
    35. 

  35. ["aia_Sales:0000964550", "G10***2372", null, null, "GVS", "4,058", "3,158.40", null, null, null, null, "4058", 1.0, 0.0, null, null, null, 0.0, "0000964550", "郭云", null, "张三", "108***7926", "G10***522D"], 
    36. 

  36. ["aia_Sales:0005771455", "G10***2372", null, null, "GVS", "4,094.60", "4,058", null, null, null, null, "0", 1.0, null, null, null, null, 0.0, "0005771455", "郭云", null, "张三", "108***7926", "G10***522E"], 
    37. 

  37. ["aia_Sales:0006350611", "G10***2372", null, null, "GVS", "4,058", "4,094.60", null, null, null, null, "0.00", 1.0, null, null, null, null, 0.0, "0006350611", "郭云", null, "张三", "108***7926", "G10***522F"], 
    38. 

  38. ["aia_Sales:0006978571", "G10***2372", null, null, "GVS", "3,123", "4,058", null, null, null, null, "0", 1.0, null, null, null, null, 0.0, "0006978571", "郭云", null, "张三", "108***7926", "G10***522G"], 
    39. 

  39. ["aia_Sales:0007033797", "G00***1144", null, null, "PKG", "357.6", "0", null, null, null, null, "357.6", 1.0, 0.15, 0.2, 0.05, 0.1405, 0.3905, "0007033797", "冬1", null, "张三", "108***3689", "G10***779A"], 
    40. 

  40. ["aia_Sales:H000045152", "G10***2372", null, null, "GVS", null, null, null, null, null, null, "2671.8", 1, null, null, null, null, null, "H000045152", "郭云", null, "张三", "108***7926", "G10***1593"], 
    41. 

  41. ["aia_Sales:0007016749", "G11***6902", null, null, "PKG", "23,654.08", "0", null, null, null, null, "23654.08", 1.0, null, null, null, null, 0.0, "0007016749", "璐", null, "张三", "118***7193", "G11***404A"], 
    42. 

  42. ["aia_Sales:0000158813", "G11***0000", null, null, "GVS", "1,712.60", "2,696.40", null, null, null, null, "1712.6", 1.0, null, null, null, null, 0.0, "0000158813", "COMPANY", null, "张三", "118***4695", "G11***655A"], 
    43. 

  43. ["aia_Sales:0000962013", "G11***0000", null, null, "GVS", "874.2", "1,712.60", null, null, null, null, "874.20", 1.0, null, null, null, null, 0.0, "0000962013", "COMPANY", null, "张三", "118***4695", "G11***655D"], 
    44. 

  44. ["aia_Sales:0005793389", "G11***0000", null, null, "GVS", "988.2", "874.2", null, null, null, null, "988.20", 1.0, null, null, null, null, 0.0, "0005793389", "COMPANY", null, "张三", "118***4695", "G11***655E"], 
    45. 

  45. ["aia_Sales:0006388232", "G11***0000", null, null, "GVS", "661.17", "988.2", null, null, null, null, "683.40", 1.0, null, null, null, null, 0.0, "0006388232", "COMPANY", null, "张三", "118***4695", "G11***655F"], 
    46. 

  46. ["aia_Sales:0006957792", "G11***6395", null, null, "PKG", "15,133.28", "17,262.17", null, null, null, null, "15133.28", 1.0, null, null, null, null, 0.0, "0006957792", "华1", null, "张三", "118***1970", "G11***172D"], 
    47. 

  47. ["aia_Sales:0000956582", "G11***3075", null, null, "GVS", "541.4", "0", null, null, null, null, "541", 1.0, null, null, null, null, 0.0, "0000956582", "畅1", null, "张三", "118***5565", "G11***987A"], 
    48. 

  48. ["aia_Sales:0005772189", "G11***3075", null, null, "GVS", "705.6", "541.4", null, null, null, null, "705.6", 1.0, null, null, null, null, 0.0, "0005772189", "畅1", null, "张三", "118***5565", "G11***987B"], 
    49. 

  49. ["aia_Sales:0000966987", "G11***0000", null, null, "GVS", "610", "1,712.60", null, null, null, null, "610", 1.0, null, null, null, null, 0.0, "0000966987", "COMPANY", null, "张三", "118***4695", "G11***036A"], 
    50. 

  50. ["aia_Sales:0005793391", "G11***0000", null, null, "GVS", "1,219.40", "610", null, null, null, null, "1,219.40", 1.0, null, null, null, null, 0.0, "0005793391", "COMPANY", null, "张三", "118***4695", "G11***036E"], 
    51. 

  51. ["aia_Sales:0006388445", "G11***0000", null, null, "GVS", "807.97", "1,219.40", null, null, null, null, "793.00", 1.0, null, null, null, null, 0.0, "0006388445", "COMPANY", null, "张三", "118***4695", "G11***036F"], 
    52. 

  52. ["aia_Sales:0006978573", "G11***0000", null, null, "GVS", "1,104.60", "807.97", null, null, null, null, "1104.6", 1.0, null, null, null, null, 0.0, "0006978573", "COMPANY", null, "张三", "118***4695", "G11***036G"], 
    53. 

  53. ["aia_Sales:0006966649", null, null, null, "PKG", "5,039.76", "0", null, null, null, null, "5,039.76", null, null, null, null, null, 0.0, "0006966649", null, null, "张三", "118***4102", "G11***175A"], 
    54. 

  54. ["aia_Sales:0007067397", "***", null, null, "PKG", null, null, null, null, null, null, "5039.76", 1, null, null, null, null, null, "0007067397", null, null, "张三", "118***4102", "G11***175A"], 
    55. 

  55. ["aia_Sales:0007039113", "G11***2210", null, null, "PKG", "199", "0", null, null, null, null, "199", 1.0, 0.15, 0.2, 0.05, 0.1405, 0.3905, "0007039113", "范婷2", null, "张三", "118***9251", "G11***644A"], 
    56. 

  56. ["aia_Sales:0007040498", "G11***6380", null, null, "PKG", "1,946", "0", null, null, null, null, "1946", 1.0, 0.15, 0.2, 0.05, 0.1405, 0.3905, "0007040498", "张6", null, "张三", "118***0127", "G11***624A"], 
    57. 

  57. ["aia_Sales:0006419647", "G11***3075", null, null, "GVS", "1,051.41", "705.6", null, null, null, null, "1054", 1.0, null, null, null, null, 0.0, "0006419647", "畅1", null, "张三", "118***5565", "G11***049A"], 
    58. 

  58. ["aia_Sales:0006978574", "G11***3075", null, null, "GVS", "999.6", "1,051.41", null, null, null, null, "999.6", 1.0, null, null, null, null, 0.0, "0006978574", "畅1", null, "张三", "118***5565", "G11***049D"], 
    59. 

  59. ["aia_Sales:H000070599", "G11***0000", null, null, "GVS", "2,096.80", "0", null, null, null, null, "2096.8", 1.0, 0.0, null, null, null, 0.0, "H000070599", "COMPANY", null, "张三", "118***4695", "G11***0401"], 
    60. 

  60. ["aia_Sales:0000968431", "G11***0000", null, null, "GVS", "454.6", "1,712.60", null, null, null, null, "454.6", 1.0, null, null, null, null, 0.0, "0000968431", "COMPANY", null, "张三", "118***4695", "G11***040A"], 
    61. 

  61. ["aia_Sales:0005793390", "G11***0000", null, null, "GVS", "330.6", "454.6", null, null, null, null, "330.6", 1.0, null, null, null, null, 0.0, "0005793390", "COMPANY", null, "张三", "118***4695", "G11***040E"], 
    62. 

  62. ["aia_Sales:0006404067", "G11***0000", null, null, "GVS", "523.4", "330.6", null, null, null, null, "523.4", 1.0, null, null, null, null, 0.0, "0006404067", "COMPANY", null, "张三", "118***4695", "G11***040F"], 
    63. 

  63. ["aia_Sales:0006978576", "G11***0000", null, null, "GVS", "646.6", "523.4", null, null, null, null, "646.6", 1.0, null, null, null, null, 0.0, "0006978576", "COMPANY", null, "张三", "118***4695", "G11***040G"], 
    64. 

  64. ["aia_Sales:0007005968", "G11***6939", null, null, "PKG", "6,795.04", "0", null, null, null, null, "6395.04", 1.0, null, null, null, null, 0.0, "0007005968", "段丽1", null, "张三", "118***0101", "G11***347A"], 
    65. 

  65. ["aia_Sales:H000070600", "G11***0000", null, null, "GVS", null, null, null, null, null, null, "2096.8", 1, null, null, null, null, null, "H000070600", "COMPANY", null, "张三", "118***4695", "G11***0401"], 
    66. 

  66. ["aia_Sales:0006957832", "G12***1802", null, null, "PKG", "6,518.48", "5,240.11", null, null, null, null, "6518.48", 1.0, null, null, null, null, 0.0, "0006957832", "海组", null, "张三", "128***6414", "G12***402B"], 
    67. 

  67. ["aia_Sales:0007015836", "G12***1833", null, null, "PKG", "5,418.88", "6,965.52", null, null, null, null, "5351.68", 1.0, null, null, null, null, 0.0, "0007015836", "恒组", null, "张三", "128***9259", "G12***806B"], 
    68. 

  68. ["aia_Sales:0007195178", "G00***0900", null, null, "GVS", "2,468.20", "2,427.80", null, null, null, null, "2468.2", 1.0, null, null, null, null, 0.0, "0007195178", "唐芬", null, "张三", "258***1018", "G25***359F"], 
    69. 

  69. ["aia_Sales:0007136926", "G00***0000", null, null, "GVS", "1,001.60", "969.4", null, null, null, null, "1001.6", 1.0, null, null, null, null, 0.0, "0007136926", "COMPANY", null, "张三", "258***1385", "G25***926G"], 
    70. 

  70. ["aia_Sales:0007140150", "G00***0092", null, null, "TM", "1,152.77", "1,122.88", null, null, null, null, "47.6", 1.0, 0.0, 0.15, 0.2, 0.1405, 0.4905, "0007140150", "谭颜", null, "张三", "258***1579", "G25***950L"], 
    71. 

  71. ["aia_Sales:0007126904", "G00***2222", null, null, "PKG", "307.2", "307.19", null, null, null, null, "8.4", 1.0, null, null, null, null, 0.0, "0007126904", "公司", null, "张三", "258***8778", "G25***153G"], 
    72. 

  72. ["aia_Sales:0007081385", "G00***0260", null, null, "GVS", "1,066.80", "1,066.80", null, null, null, null, "698", 1.0, null, null, null, null, 0.0, "0007081385", "范兰", null, "张三", "258***9834", "G25***188G"], 
    73. 

  73. ["aia_Sales:0007148478", "G00***0549", null, null, "PKG", "4,399.40", "3,443.62", null, null, null, null, "130.2", 1.0, null, null, null, null, 0.0, "0007148478", "谭红", null, "张三", "258***8953", "G25***223H"], 
    74. 

  74. ["aia_Sales:0007110890", "G00***0041", null, null, "PKG", "483", "483", null, null, null, null, "19.6", 1.0, null, null, null, null, 0.0, "0007110890", "刘波", null, "张三", "258***2123", "G25***258I"], 
    75. 

  75. ["aia_Sales:0007106884", "G00***0581", null, null, "PKG", "743.4", "743.4", null, null, null, null, "25.2", 1.0, null, null, null, null, 0.0, "0007106884", "罗中", null, "张三", "258***8557", "G25***272H"], 
    76. 

  76. ["aia_Sales:0007160774", "G25***4146", null, null, "PKG", "349.8", "336.44", null, null, null, null, "14", 1.0, null, null, null, null, 0.0, "0007160774", "丹", null, "张三", "258***0189", "G25***328H"], 
    77. 

  77. ["aia_Sales:0007159876", "G25***3173", null, null, "PKG", "635", "627.4", null, null, null, null, "21", 1.0, null, null, null, null, 0.0, "0007159876", "司宜", null, "张三", "258***4955", "G25***342H"], 
    78. 

  78. ["aia_Sales:55728968-e56f-11f0-8eff-b88687bddf52", "098***4719", null, null, "TM", "11,430.97", "0", null, null, null, null, "8089.2", 1.0, 0.47, 0.1, -0.145, 0.195, 0.15, "55728968-e56f-11f0-8eff-b88687bddf52", null, null, null, "098***4719", "G09***549A"], 
    79. 

  79. ["aia_Sales:5572b02e-e56f-11f0-8408-b88687bddf52", "098***4719", null, null, "TM", "8,898.30", "11,430.97", null, null, null, null, "12457.62", 1.0, 0.47, 0.1, -0.145, 0.195, 0.15, "5572b02e-e56f-11f0-8408-b88687bddf52", null, null, null, "098***4719", "G09***549B"], 
    80. 

  80. ["aia_Sales:5572d726-e56f-11f0-a5ef-b88687bddf52", "098***4719", null, null, "TM", "45,616.63", "0", null, null, null, null, "46552.88", 1.0, 0.47, 0.1, -0.145, 0.235, 0.19, "5572d726-e56f-11f0-a5ef-b88687bddf52", null, null, null, "098***4719", "G09***746A"], 
    81. 

  81. ["aia_Sales:5572fe1c-e56f-11f0-8543-b88687bddf52", "098***4719", null, null, "TM", "14,494.36", "45,616.63", null, null, null, null, "36387.12", 1.0, 0.47, 0.1, -0.145, 0.235, 0.19, "5572fe1c-e56f-11f0-8543-b88687bddf52", null, null, null, "098***4719", "G09***746B"], 
    82. 

  82. ["aia_Sales:55732514-e56f-11f0-9d06-b88687bddf52", "098***4719", null, null, "TM", "5,913.74", "0", null, null, null, null, "6920.64", 1.0, 0.47, 0.1, -0.145, 0.195, 0.15, "55732514-e56f-11f0-9d06-b88687bddf52", null, null, null, "098***4719", "G09***830A"], 
    83. 

  83. ["aia_Sales:55734bf7-e56f-11f0-b41c-b88687bddf52", "098***4719", null, null, "TM", "66,713.17", "0", null, null, null, null, "66076.56", 1.0, 0.47, 0.1, -0.145, 0.195, 0.15, "55734bf7-e56f-11f0-b41c-b88687bddf52", null, null, null, "098***4719", "G09***956A"], 
    84. 

  84. ["aia_Sales:557399d9-e56f-11f0-8df7-b88687bddf52", "***", null, null, "TM", "19,790.43", "0", null, null, null, null, "15298.56", 1.0, 0.47, 0.1, 0.05, 0.195, 0.345, "557399d9-e56f-11f0-8df7-b88687bddf52", "中任公司", null, null, "098***4719", "G09***889A"], 
    85. 

  85. ["aia_Sales:5574d19b-e56f-11f0-8121-b88687bddf52", "G00***3831", null, null, "GTA", "514", null, null, null, null, null, "514", null, null, null, null, null, null, "5574d19b-e56f-11f0-8121-b88687bddf52", "徐3", null, null, "098***7989", "G09***167A"], 
    86. 

  86. ["aia_Sales:5574f882-e56f-11f0-bb60-b88687bddf52", "G00***3169", null, null, "GTA", "520.6", null, null, null, null, null, "520.6", null, null, null, null, null, null, "5574f882-e56f-11f0-bb60-b88687bddf52", "杜敏", null, null, "098***6143", "G09***580A"], 
    87. 

  87. ["aia_Sales:55754667-e56f-11f0-a6c8-b88687bddf52", "G00***2510", null, null, "GTA", "512.4", null, null, null, null, null, "512.4", null, null, null, null, null, null, "55754667-e56f-11f0-a6c8-b88687bddf52", "峰", null, null, "098***3690", "G09***853A"], 
    88. 

  88. ["aia_Sales:55756d57-e56f-11f0-addb-b88687bddf52", "G00***1947", null, null, "GTA", "330", null, null, null, null, null, "330", null, null, null, null, null, null, "55756d57-e56f-11f0-addb-b88687bddf52", "晔", null, null, "098***9318", "G09***029A"], 
    89. 

  89. ["aia_Sales:5575bb5e-e56f-11f0-9e3c-b88687bddf52", "G00***1596", null, null, "GTA", "659.4", null, null, null, null, null, "659.4", null, null, null, null, null, null, "5575bb5e-e56f-11f0-9e3c-b88687bddf52", "王权", null, null, "098***6213", "G09***099A"], 
    90. 

  90. ["aia_Sales:5575e233-e56f-11f0-be97-b88687bddf52", "G00***1947", null, null, "GTA", "2335.2", null, null, null, null, null, "2335.2", null, null, null, null, null, null, "5575e233-e56f-11f0-be97-b88687bddf52", "晔", null, null, "098***9318", "G09***345A"], 
    91. 

  91. ["aia_Sales:55765714-e56f-11f0-ba41-b88687bddf52", "G00***2018", null, null, "GTA", "257", null, null, null, null, null, "257", null, null, null, null, null, null, "55765714-e56f-11f0-ba41-b88687bddf52", "王军", null, null, "098***9854", "G09***366A"], 
    92. 

  92. ["aia_Sales:55767e42-e56f-11f0-bb76-b88687bddf52", "G00***0236", null, null, "GTA", "15457.69", null, null, null, null, null, "484.4", null, null, null, null, null, null, "55767e42-e56f-11f0-bb76-b88687bddf52", "罗远", null, null, "098***6836", "G09***868A"], 
    93. 

  93. ["aia_Sales:5576a4fd-e56f-11f0-8359-b88687bddf52", "G00***3831", null, null, "GTA", "210.63", null, null, null, null, null, "211.6", null, null, null, null, null, null, "5576a4fd-e56f-11f0-8359-b88687bddf52", "徐3", null, null, "098***7989", "G09***715A"], 
    94. 

  94. ["aia_Sales:5576cbf5-e56f-11f0-b8b4-b88687bddf52", "G00***2510", null, null, "GTA", "939.4", null, null, null, null, null, "939.4", null, null, null, null, null, null, "5576cbf5-e56f-11f0-b8b4-b88687bddf52", "峰", null, null, "098***3690", "G09***737A"],
    95. 

  95. ["aia_Sales:XH000019403", "G00***0199", null, null, "GVS", "832.2", "0", null, null, null, null, "832.2", 1.0, 0.0, null, null, null, 0.0, "H000019403", "周芳", null, "张三", "098***9844", "G09***6563"], 
    96. 

  96. ["aia_Sales:X0006746152", "098***4719", null, null, "TM", "81,487.13", "66,713.17", null, null, null, null, "70074.18", 1.0, 0.47, 0.1, -0.145, 0.195, 0.15, "0006746152", null, null, "张三", "098***4719", "G09***956B"], 
    97. 

  97. ["aia_Sales:X0007517914", "098***4719", null, null, "TM", "115,914.15", "81,487.13", null, null, null, null, "113805.9", 1.0, 0.47, 0.1, 0.05, 0.195, 0.345, "0007517914", "中任公司", null, "张三", "098***4719", "G09***956C"], 
    98. 

  98. ["aia_Sales:X0007040503", "G00***5165", null, null, "GVS", "2,364.20", "0", null, null, null, null, "2,364.20", 1.0, null, null, null, null, 0.0, "0007040503", "戴勇", null, "张三", "098***8360", "G09***855A"], 
    99. 

  99. ["aia_Sales:X0007506281", "098***4719", null, null, "TM", "14,994.72", "0", null, null, null, null, "14994.72", 1.0, 0.47, 0.1, 0.05, 0.195, 0.345, "0007506281", "中任公司", null, "张三", "098***4719", "G09***402A"], 
    100. 

  100. ["aia_Sales:X0007011185", "G00***3185", null, null, "PKG", "3,670.64", "4,280.80", null, null, null, null, "3,670.64", 1.0, null, null, null, null, 0.0, "0007011185", "王烨", null, "张三", "098***5006", "G09***604A"], 
    101. 

  101. ["aia_Sales:X0007015907", "G00***3165", null, null, "PKG", "8,540.24", "0", null, null, null, null, "8,540.24", 1.0, null, null, null, null, 0.0, "0007015907", "顾远", null, "张三", "098***3112", "G09***689A"], 
    102. 

  102. ["aia_Sales:X0006919888", "G00***6529", null, null, "PKG", "4,404.20", "5,574.11", null, null, null, null, "6300.32", 1.0, null, null, null, null, 0.0, "0006919888", "温甜1", null, "张三", "098***3556", "G09***709D"], 
    103. 

  103. ["aia_Sales:X0000150572", "G00***0199", null, null, "GVS", "1,851.80", "1,172.20", null, null, null, null, "1,851.80", 1.0, 0.0, null, null, null, 0.0, "0000150572", "周芳", null, "张三", "098***9844", "G09***616C"], 
    104. 

  104. ["aia_Sales:X0000963771", "G00***0199", null, null, "GVS", "2,273", "1,851.80", null, null, null, null, "2,273.00", 1.0, 0.0, null, null, null, 0.0, "0000963771", "周芳", null, "张三", "098***9844", "G09***616D"], 
    105. 

  105. ["aia_Sales:X0005752638", "G00***0199", null, null, "GVS", "3,186.63", "2,273", null, null, null, null, "3,187.80", 1.0, null, null, null, null, 0.0, "0005752638", "周芳", null, "张三", "098***9844", "G09***616E"], 
    106. 

  106. ["aia_Sales:X0006420764", "G00***0199", null, null, "GVS", "3,554", "3,186.63", null, null, null, null, "3,554.00", 1.0, null, null, null, null, 0.0, "0006420764", "周芳", null, "张三", "098***9844", "G09***616F"], 
    107. 

  107. ["aia_Sales:X0007041279", "G00***0199", null, null, "GVS", "4,120.80", "3,554", null, null, null, null, "4,120.80", 1.0, null, null, null, null, 0.0, "0007041279", "周芳", null, "张三", "098***9844", "G09***616G"], 
    108. 

  108. ["aia_Sales:X0006988671", "G00***3348", null, null, "PKG", "5,795.36", "0", null, null, null, null, "5,795.36", 1.0, null, null, null, null, 0.0, "0006988671", "任", null, "张三", "098***6082", "G09***517A"], 
    109. 

  109. ["aia_Sales:X0006993715", "G00***3530", null, null, "PKG", "6,597.60", "0", null, null, null, null, "6597.6", 1.0, null, null, null, null, 0.0, "0006993715", "邵雯", null, "张三", "098***9136", "G09***545A"], 
    110. 

  110. ["aia_Sales:X0006960163", "G00***3148", null, null, "PKG", "16,309.04", "16,665.40", null, null, null, null, "16,309.04", 1.0, null, null, null, null, 0.0, "0006960163", "朱俊", null, "张三", "098***4835", "G09***124B"], 
    111. 

  111. ["aia_Sales:XH000019404", "G00***0199", null, null, "GVS", null, null, null, null, null, null, "832.2", 1, null, null, null, null, null, "H000019404", "周芳", null, "张三", "098***9844", "G09***6563"], 
    112. 

  112. ["aia_Sales:XH000045151", "G10***2372", null, null, "GVS", "2,671.80", "0", null, null, null, null, "2145", 1.0, 0.0, null, null, null, 0.0, "H000045151", "郭云", null, "张三", "108***7926", "G10***1593"], 
    113. 

  113. ["aia_Sales:X0000158000", "G10***2372", null, null, "GVS", "3,158.40", "3,663.80", null, null, null, null, "95.00", 1.0, 0.0, null, null, null, 0.0, "0000158000", "郭云", null, "张三", "108***7926", "G10***522C"], 
    114. 

  114. ["aia_Sales:X0000964550", "G10***2372", null, null, "GVS", "4,058", "3,158.40", null, null, null, null, "4058", 1.0, 0.0, null, null, null, 0.0, "0000964550", "郭云", null, "张三", "108***7926", "G10***522D"], 
    115. 

  115. ["aia_Sales:X0005771455", "G10***2372", null, null, "GVS", "4,094.60", "4,058", null, null, null, null, "0", 1.0, null, null, null, null, 0.0, "0005771455", "郭云", null, "张三", "108***7926", "G10***522E"], 
    116. 

  116. ["aia_Sales:X0006350611", "G10***2372", null, null, "GVS", "4,058", "4,094.60", null, null, null, null, "0.00", 1.0, null, null, null, null, 0.0, "0006350611", "郭云", null, "张三", "108***7926", "G10***522F"], 
    117. 

  117. ["aia_Sales:X0006978571", "G10***2372", null, null, "GVS", "3,123", "4,058", null, null, null, null, "0", 1.0, null, null, null, null, 0.0, "0006978571", "郭云", null, "张三", "108***7926", "G10***522G"], 
    118. 

  118. ["aia_Sales:X0007033797", "G00***1144", null, null, "PKG", "357.6", "0", null, null, null, null, "357.6", 1.0, 0.15, 0.2, 0.05, 0.1405, 0.3905, "0007033797", "冬1", null, "张三", "108***3689", "G10***779A"], 
    119. 

  119. ["aia_Sales:XH000045152", "G10***2372", null, null, "GVS", null, null, null, null, null, null, "2671.8", 1, null, null, null, null, null, "H000045152", "郭云", null, "张三", "108***7926", "G10***1593"], 
    120. 

  120. ["aia_Sales:X0007016749", "G11***6902", null, null, "PKG", "23,654.08", "0", null, null, null, null, "23654.08", 1.0, null, null, null, null, 0.0, "0007016749", "璐", null, "张三", "118***7193", "G11***404A"], 
    121. 

  121. ["aia_Sales:X0000158813", "G11***0000", null, null, "GVS", "1,712.60", "2,696.40", null, null, null, null, "1712.6", 1.0, null, null, null, null, 0.0, "0000158813", "COMPANY", null, "张三", "118***4695", "G11***655A"], 
    122. 

  122. ["aia_Sales:X0000962013", "G11***0000", null, null, "GVS", "874.2", "1,712.60", null, null, null, null, "874.20", 1.0, null, null, null, null, 0.0, "0000962013", "COMPANY", null, "张三", "118***4695", "G11***655D"], 
    123. 

  123. ["aia_Sales:X0005793389", "G11***0000", null, null, "GVS", "988.2", "874.2", null, null, null, null, "988.20", 1.0, null, null, null, null, 0.0, "0005793389", "COMPANY", null, "张三", "118***4695", "G11***655E"], 
    124. 

  124. ["aia_Sales:X0006388232", "G11***0000", null, null, "GVS", "661.17", "988.2", null, null, null, null, "683.40", 1.0, null, null, null, null, 0.0, "0006388232", "COMPANY", null, "张三", "118***4695", "G11***655F"], 
    125. 

  125. ["aia_Sales:X0006957792", "G11***6395", null, null, "PKG", "15,133.28", "17,262.17", null, null, null, null, "15133.28", 1.0, null, null, null, null, 0.0, "0006957792", "华1", null, "张三", "118***1970", "G11***172D"], 
    126. 

  126. ["aia_Sales:X0000956582", "G11***3075", null, null, "GVS", "541.4", "0", null, null, null, null, "541", 1.0, null, null, null, null, 0.0, "0000956582", "畅1", null, "张三", "118***5565", "G11***987A"], 
    127. 

  127. ["aia_Sales:X0005772189", "G11***3075", null, null, "GVS", "705.6", "541.4", null, null, null, null, "705.6", 1.0, null, null, null, null, 0.0, "0005772189", "畅1", null, "张三", "118***5565", "G11***987B"], 
    128. 

  128. ["aia_Sales:X0000966987", "G11***0000", null, null, "GVS", "610", "1,712.60", null, null, null, null, "610", 1.0, null, null, null, null, 0.0, "0000966987", "COMPANY", null, "张三", "118***4695", "G11***036A"], 
    129. 

  129. ["aia_Sales:X0005793391", "G11***0000", null, null, "GVS", "1,219.40", "610", null, null, null, null, "1,219.40", 1.0, null, null, null, null, 0.0, "0005793391", "COMPANY", null, "张三", "118***4695", "G11***036E"], 
    130. 

  130. ["aia_Sales:X0006388445", "G11***0000", null, null, "GVS", "807.97", "1,219.40", null, null, null, null, "793.00", 1.0, null, null, null, null, 0.0, "0006388445", "COMPANY", null, "张三", "118***4695", "G11***036F"], 
    131. 

  131. ["aia_Sales:X0006978573", "G11***0000", null, null, "GVS", "1,104.60", "807.97", null, null, null, null, "1104.6", 1.0, null, null, null, null, 0.0, "0006978573", "COMPANY", null, "张三", "118***4695", "G11***036G"], 
    132. 

  132. ["aia_Sales:X0006966649", null, null, null, "PKG", "5,039.76", "0", null, null, null, null, "5,039.76", null, null, null, null, null, 0.0, "0006966649", null, null, "张三", "118***4102", "G11***175A"], 
    133. 

  133. ["aia_Sales:X0007067397", "***", null, null, "PKG", null, null, null, null, null, null, "5039.76", 1, null, null, null, null, null, "0007067397", null, null, "张三", "118***4102", "G11***175A"], 
    134. 

  134. ["aia_Sales:X0007039113", "G11***2210", null, null, "PKG", "199", "0", null, null, null, null, "199", 1.0, 0.15, 0.2, 0.05, 0.1405, 0.3905, "0007039113", "范婷2", null, "张三", "118***9251", "G11***644A"], 
    135. 

  135. ["aia_Sales:X0007040498", "G11***6380", null, null, "PKG", "1,946", "0", null, null, null, null, "1946", 1.0, 0.15, 0.2, 0.05, 0.1405, 0.3905, "0007040498", "张6", null, "张三", "118***0127", "G11***624A"], 
    136. 

  136. ["aia_Sales:X0006419647", "G11***3075", null, null, "GVS", "1,051.41", "705.6", null, null, null, null, "1054", 1.0, null, null, null, null, 0.0, "0006419647", "畅1", null, "张三", "118***5565", "G11***049A"], 
    137. 

  137. ["aia_Sales:X0006978574", "G11***3075", null, null, "GVS", "999.6", "1,051.41", null, null, null, null, "999.6", 1.0, null, null, null, null, 0.0, "0006978574", "畅1", null, "张三", "118***5565", "G11***049D"], 
    138. 

  138. ["aia_Sales:XH000070599", "G11***0000", null, null, "GVS", "2,096.80", "0", null, null, null, null, "2096.8", 1.0, 0.0, null, null, null, 0.0, "H000070599", "COMPANY", null, "张三", "118***4695", "G11***0401"], 
    139. 

  139. ["aia_Sales:X0000968431", "G11***0000", null, null, "GVS", "454.6", "1,712.60", null, null, null, null, "454.6", 1.0, null, null, null, null, 0.0, "0000968431", "COMPANY", null, "张三", "118***4695", "G11***040A"], 
    140. 

  140. ["aia_Sales:X0005793390", "G11***0000", null, null, "GVS", "330.6", "454.6", null, null, null, null, "330.6", 1.0, null, null, null, null, 0.0, "0005793390", "COMPANY", null, "张三", "118***4695", "G11***040E"], 
    141. 

  141. ["aia_Sales:X0006404067", "G11***0000", null, null, "GVS", "523.4", "330.6", null, null, null, null, "523.4", 1.0, null, null, null, null, 0.0, "0006404067", "COMPANY", null, "张三", "118***4695", "G11***040F"], 
    142. 

  142. ["aia_Sales:X0006978576", "G11***0000", null, null, "GVS", "646.6", "523.4", null, null, null, null, "646.6", 1.0, null, null, null, null, 0.0, "0006978576", "COMPANY", null, "张三", "118***4695", "G11***040G"], 
    143. 

  143. ["aia_Sales:X0007005968", "G11***6939", null, null, "PKG", "6,795.04", "0", null, null, null, null, "6395.04", 1.0, null, null, null, null, 0.0, "0007005968", "段丽1", null, "张三", "118***0101", "G11***347A"], 
    144. 

  144. ["aia_Sales:XH000070600", "G11***0000", null, null, "GVS", null, null, null, null, null, null, "2096.8", 1, null, null, null, null, null, "H000070600", "COMPANY", null, "张三", "118***4695", "G11***0401"], 
    145. 

  145. ["aia_Sales:X0006957832", "G12***1802", null, null, "PKG", "6,518.48", "5,240.11", null, null, null, null, "6518.48", 1.0, null, null, null, null, 0.0, "0006957832", "海组", null, "张三", "128***6414", "G12***402B"], 
    146. 

  146. ["aia_Sales:X0007015836", "G12***1833", null, null, "PKG", "5,418.88", "6,965.52", null, null, null, null, "5351.68", 1.0, null, null, null, null, 0.0, "0007015836", "恒组", null, "张三", "128***9259", "G12***806B"], 
    147. 

  147. ["aia_Sales:X0007195178", "G00***0900", null, null, "GVS", "2,468.20", "2,427.80", null, null, null, null, "2468.2", 1.0, null, null, null, null, 0.0, "0007195178", "唐芬", null, "张三", "258***1018", "G25***359F"], 
    148. 

  148. ["aia_Sales:X0007136926", "G00***0000", null, null, "GVS", "1,001.60", "969.4", null, null, null, null, "1001.6", 1.0, null, null, null, null, 0.0, "0007136926", "COMPANY", null, "张三", "258***1385", "G25***926G"], 
    149. 

  149. ["aia_Sales:X0007140150", "G00***0092", null, null, "TM", "1,152.77", "1,122.88", null, null, null, null, "47.6", 1.0, 0.0, 0.15, 0.2, 0.1405, 0.4905, "0007140150", "谭颜", null, "张三", "258***1579", "G25***950L"], 
    150. 

  150. ["aia_Sales:X0007126904", "G00***2222", null, null, "PKG", "307.2", "307.19", null, null, null, null, "8.4", 1.0, null, null, null, null, 0.0, "0007126904", "公司", null, "张三", "258***8778", "G25***153G"], 
    151. 

  151. ["aia_Sales:X0007081385", "G00***0260", null, null, "GVS", "1,066.80", "1,066.80", null, null, null, null, "698", 1.0, null, null, null, null, 0.0, "0007081385", "范兰", null, "张三", "258***9834", "G25***188G"], 
    152. 

  152. ["aia_Sales:X0007148478", "G00***0549", null, null, "PKG", "4,399.40", "3,443.62", null, null, null, null, "130.2", 1.0, null, null, null, null, 0.0, "0007148478", "谭红", null, "张三", "258***8953", "G25***223H"], 
    153. 

  153. ["aia_Sales:X0007110890", "G00***0041", null, null, "PKG", "483", "483", null, null, null, null, "19.6", 1.0, null, null, null, null, 0.0, "0007110890", "刘波", null, "张三", "258***2123", "G25***258I"], 
    154. 

  154. ["aia_Sales:X0007106884", "G00***0581", null, null, "PKG", "743.4", "743.4", null, null, null, null, "25.2", 1.0, null, null, null, null, 0.0, "0007106884", "罗中", null, "张三", "258***8557", "G25***272H"], 
    155. 

  155. ["aia_Sales:X0007160774", "G25***4146", null, null, "PKG", "349.8", "336.44", null, null, null, null, "14", 1.0, null, null, null, null, 0.0, "0007160774", "丹", null, "张三", "258***0189", "G25***328H"], 
    156. 

  156. ["aia_Sales:X0007159876", "G25***3173", null, null, "PKG", "635", "627.4", null, null, null, null, "21", 1.0, null, null, null, null, 0.0, "0007159876", "司宜", null, "张三", "258***4955", "G25***342H"], 
    157. 

  157. ["aia_Sales:X55728968-e56f-11f0-8eff-b88687bddf52", "098***4719", null, null, "TM", "11,430.97", "0", null, null, null, null, "8089.2", 1.0, 0.47, 0.1, -0.145, 0.195, 0.15, "55728968-e56f-11f0-8eff-b88687bddf52", null, null, null, "098***4719", "G09***549A"], 
    158. 

  158. ["aia_Sales:X5572b02e-e56f-11f0-8408-b88687bddf52", "098***4719", null, null, "TM", "8,898.30", "11,430.97", null, null, null, null, "12457.62", 1.0, 0.47, 0.1, -0.145, 0.195, 0.15, "5572b02e-e56f-11f0-8408-b88687bddf52", null, null, null, "098***4719", "G09***549B"], 
    159. 

  159. ["aia_Sales:X5572d726-e56f-11f0-a5ef-b88687bddf52", "098***4719", null, null, "TM", "45,616.63", "0", null, null, null, null, "46552.88", 1.0, 0.47, 0.1, -0.145, 0.235, 0.19, "5572d726-e56f-11f0-a5ef-b88687bddf52", null, null, null, "098***4719", "G09***746A"], 
    160. 

  160. ["aia_Sales:X5572fe1c-e56f-11f0-8543-b88687bddf52", "098***4719", null, null, "TM", "14,494.36", "45,616.63", null, null, null, null, "36387.12", 1.0, 0.47, 0.1, -0.145, 0.235, 0.19, "5572fe1c-e56f-11f0-8543-b88687bddf52", null, null, null, "098***4719", "G09***746B"], 
    161. 

  161. ["aia_Sales:X55732514-e56f-11f0-9d06-b88687bddf52", "098***4719", null, null, "TM", "5,913.74", "0", null, null, null, null, "6920.64", 1.0, 0.47, 0.1, -0.145, 0.195, 0.15, "55732514-e56f-11f0-9d06-b88687bddf52", null, null, null, "098***4719", "G09***830A"], 
    162. 

  162. ["aia_Sales:X55734bf7-e56f-11f0-b41c-b88687bddf52", "098***4719", null, null, "TM", "66,713.17", "0", null, null, null, null, "66076.56", 1.0, 0.47, 0.1, -0.145, 0.195, 0.15, "55734bf7-e56f-11f0-b41c-b88687bddf52", null, null, null, "098***4719", "G09***956A"], 
    163. 

  163. ["aia_Sales:X557399d9-e56f-11f0-8df7-b88687bddf52", "***", null, null, "TM", "19,790.43", "0", null, null, null, null, "15298.56", 1.0, 0.47, 0.1, 0.05, 0.195, 0.345, "557399d9-e56f-11f0-8df7-b88687bddf52", "中任公司", null, null, "098***4719", "G09***889A"], 
    164. 

  164. ["aia_Sales:X5574d19b-e56f-11f0-8121-b88687bddf52", "G00***3831", null, null, "GTA", "514", null, null, null, null, null, "514", null, null, null, null, null, null, "5574d19b-e56f-11f0-8121-b88687bddf52", "徐3", null, null, "098***7989", "G09***167A"], 
    165. 

  165. ["aia_Sales:X5574f882-e56f-11f0-bb60-b88687bddf52", "G00***3169", null, null, "GTA", "520.6", null, null, null, null, null, "520.6", null, null, null, null, null, null, "5574f882-e56f-11f0-bb60-b88687bddf52", "杜敏", null, null, "098***6143", "G09***580A"], 
    166. 

  166. ["aia_Sales:X55754667-e56f-11f0-a6c8-b88687bddf52", "G00***2510", null, null, "GTA", "512.4", null, null, null, null, null, "512.4", null, null, null, null, null, null, "55754667-e56f-11f0-a6c8-b88687bddf52", "峰", null, null, "098***3690", "G09***853A"], 
    167. 

  167. ["aia_Sales:X55756d57-e56f-11f0-addb-b88687bddf52", "G00***1947", null, null, "GTA", "330", null, null, null, null, null, "330", null, null, null, null, null, null, "55756d57-e56f-11f0-addb-b88687bddf52", "晔", null, null, "098***9318", "G09***029A"], 
    168. 

  168. ["aia_Sales:X5575bb5e-e56f-11f0-9e3c-b88687bddf52", "G00***1596", null, null, "GTA", "659.4", null, null, null, null, null, "659.4", null, null, null, null, null, null, "5575bb5e-e56f-11f0-9e3c-b88687bddf52", "王权", null, null, "098***6213", "G09***099A"], 
    169. 

  169. ["aia_Sales:X5575e233-e56f-11f0-be97-b88687bddf52", "G00***1947", null, null, "GTA", "2335.2", null, null, null, null, null, "2335.2", null, null, null, null, null, null, "5575e233-e56f-11f0-be97-b88687bddf52", "晔", null, null, "098***9318", "G09***345A"], 
    170. 

  170. ["aia_Sales:X55765714-e56f-11f0-ba41-b88687bddf52", "G00***2018", null, null, "GTA", "257", null, null, null, null, null, "257", null, null, null, null, null, null, "55765714-e56f-11f0-ba41-b88687bddf52", "王军", null, null, "098***9854", "G09***366A"], 
    171. 

  171. ["aia_Sales:X55767e42-e56f-11f0-bb76-b88687bddf52", "G00***0236", null, null, "GTA", "15457.69", null, null, null, null, null, "484.4", null, null, null, null, null, null, "55767e42-e56f-11f0-bb76-b88687bddf52", "罗远", null, null, "098***6836", "G09***868A"], 
    172. 

  172. ["aia_Sales:X5576a4fd-e56f-11f0-8359-b88687bddf52", "G00***3831", null, null, "GTA", "210.63", null, null, null, null, null, "211.6", null, null, null, null, null, null, "5576a4fd-e56f-11f0-8359-b88687bddf52", "徐3", null, null, "098***7989", "G09***715A"], 
    173. 

  173. ["aia_Sales:X5576cbf5-e56f-11f0-b8b4-b88687bddf52", "G00***2510", null, null, "GTA", "939.4", null, null, null, null, null, "939.4", null, null, null, null, null, null, "5576cbf5-e56f-11f0-b8b4-b88687bddf52", "峰", null, null, "098***3690", "G09***737A"]]}`
    174. 

  174. 

  175. func TestInsert(t *testing.T) {
    176. 

  176. 	fmt.Println("insert")
    177. 

  177. 	data, e := restapi.Request("POST", url, insertsales)
    178. 

  178. 	if !assert.Nil(t, e, e) {
    179. 

  179. 		return
    180. 

  180. 	}
    181. 

  181. 	fmt.Println(data)
    182. 

  182. }
    183. 

  183. 

  184. var deletemql = "delete from /aia/Sales"
    185. 

  185. 

  186. // var deletesales = `{"mql": "delete from /aia/Sales"}`
    187. 

  187. 

  188. func TestDelete(t *testing.T) {
    189. 

  189. 	fmt.Println("delete")
    190. 

  190. 	data, e := restapi.Request("POST", url, deletemql)
    191. 

  191. 	if !assert.Nil(t, e, e) {
    192. 

  192. 		return
    193. 

  193. 	}
    194. 

  194. 	fmt.Println(data)
    195. 

  195. }
    196. 

  196. 

  197. func TestSelect(t *testing.T) {
    198. 

  198. 	testSelect(t, -1)
    199. 

  199. }
    200. 

  200. 

  201. var selectmql = "select count(*) from /aia/sales"
    202. 

  202. 

  203. // var selectsales = `{"mql": "select count(*) from /aia/sales"}`
    204. 

  204. 

  205. func testSelect(t *testing.T, count int) bool {
    206. 

  206. 	// data, e := restapi.Request("GET", url+"?mql=select%20count(*)%20from%20/aia/Sales", "")
    207. 

  207. 	data, e := restapi.Request("POST", url, selectmql)
    208. 

  208. 	if !assert.Nil(t, e, e) {
    209. 

  209. 		return false
    210. 

  210. 	}
    211. 

  211. 	fmt.Println(data)
    212. 

  212. 	if count >= 0 {
    213. 

  213. 		ok := false
    214. 

  214. 		if data != nil && data["message"] != nil {
    215. 

  215. 			ms, _ := data["message"].([]any)
    216. 

  216. 			if len(ms) > 0 {
    217. 

  217. 				mdata, _ := ms[0].(map[string]any)
    218. 

  218. 				if mdata != nil && assert.Equal(t, count, cast.ToInt(mdata["count"])) {
    219. 

  219. 					ok = true
    220. 

  220. 				}
    221. 

  221. 			}
    222. 

  222. 		}
    223. 

  223. 		if !ok {
    224. 

  224. 			return false
    225. 

  225. 		}
    226. 

  226. 	}
    227. 

  227. 	return true
    228. 

  228. }
    229. 

  229. 

  230. func TestDummy(t *testing.T) {
    231. 

  231. 	for i := 0; i < 100; i++ {
    232. 

  232. 		TestDelete(t)
    233. 

  233. 		// time.Sleep(5 * time.Second)
    234. 

  234. 		if !testSelect(t, 0) {
    235. 

  235. 			return
    236. 

  236. 		}
    237. 

  237. 		TestInsert(t)
    238. 

  238. 		// time.Sleep(3 * time.Second)
    239. 

  239. 		if !testSelect(t, 158) {
    240. 

  240. 			return
    241. 

  241. 		}
    242. 

  242. 	}
    243. 

  243. }
    244.