xugu_sock_send.go 6.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249
  1. package xugu
  2. import (
  3. "encoding/binary"
  4. "fmt"
  5. )
  6. func SockSendCommandN(pConn *xuguConn, sql string, num int) (int, error) {
  7. ret := 0
  8. var err error
  9. cmd_len := len(sql)
  10. ret, err = RhSend(pConn, []byte("?"), 1)
  11. if err != nil {
  12. return 0, err
  13. }
  14. ret, err = rhSendInt32(pConn, uint32(cmd_len))
  15. if err != nil {
  16. return 0, err
  17. }
  18. ret, err = RhSend(pConn, []byte(sql), cmd_len+1)
  19. if err != nil {
  20. return 0, err
  21. }
  22. if num != 0 {
  23. ret, err = rhSendInt32(pConn, uint32(num)) //param num
  24. if err != nil {
  25. return 0, err
  26. }
  27. } else {
  28. ret, err = rhSendInt32(pConn, uint32(0))
  29. if err != nil {
  30. return 0, err
  31. }
  32. }
  33. return ret, nil
  34. }
  35. // func SockSendCommand0(pConn *xuguConn, sql string) (int, error) {
  36. // cmdLen := len(sql)
  37. // //发送问号字符 ?
  38. // ret, err := RhSend(pConn, []byte("?"), cmdLen)
  39. // if err != nil {
  40. // return 0, err
  41. // }
  42. // // Comand_Len
  43. // lengthInt32 := uint32(len(sql))
  44. // ret, err = rhSendInt32(pConn, lengthInt32)
  45. // if err != nil {
  46. // return 0, err
  47. // }
  48. // // Comand_str
  49. // ret, err = RhSend(pConn, []byte(sql), cmdLen+1)
  50. // if err != nil {
  51. // return 0, err
  52. // }
  53. // data := make([]byte, 1)
  54. // ret, err = RhSend(pConn, data, 1)
  55. // if err != nil {
  56. // return 0, err
  57. // }
  58. // // Param_num
  59. // ret, err = rhSendInt32(pConn, 0)
  60. // if err != nil {
  61. // return 0, err
  62. // }
  63. // fmt.Println("SockSendCommand0 msg", pConn.sendBuff.String())
  64. // RhFlush(pConn)
  65. // return ret, nil
  66. // }
  67. func sockSendPutStatement(pConn *xuguConn, sql []byte, values *[]xuguValue, paramCount int) {
  68. if pConn.sendBuff.Len() > 0 {
  69. //将缓冲区重置为空
  70. pConn.sendBuff.Reset()
  71. }
  72. // ?
  73. pConn.sendBuff.Write([]byte("?"))
  74. // Comand_Len
  75. sqlLength := uint32(len(sql))
  76. var networkBytes [4]byte
  77. binary.BigEndian.PutUint32(networkBytes[:], sqlLength)
  78. pConn.sendBuff.Write(networkBytes[:])
  79. // Comand_str
  80. pConn.sendBuff.Write(sql)
  81. //'0' 结束符
  82. binary.BigEndian.PutUint32(networkBytes[:], 0)
  83. pConn.sendBuff.Write([]byte{0})
  84. // Param_num
  85. if paramCount > 0 {
  86. fmt.Println("paramCount> 0: ", paramCount)
  87. binary.BigEndian.PutUint32(networkBytes[:], uint32(paramCount))
  88. pConn.sendBuff.Write(networkBytes[:])
  89. } else {
  90. binary.BigEndian.PutUint32(networkBytes[:], 0)
  91. pConn.sendBuff.Write(networkBytes[:])
  92. }
  93. if values != nil {
  94. fmt.Println("values 不为空")
  95. // Param_num { Param_name_len Param_name Param_INOUT Param_DType Param_Data_Len Param_Data }
  96. for _, value := range *values {
  97. //Param_name_len
  98. var Param_name_len [2]byte
  99. binary.BigEndian.PutUint16(Param_name_len[:], uint16(len(value.paramName)))
  100. pConn.sendBuff.Write(Param_name_len[:])
  101. fmt.Println("Param_name_len sendBuff ", pConn.sendBuff.Bytes())
  102. //Param_name
  103. if value.paramName == nil {
  104. //pConn.sendBuff.Write([]byte{0})
  105. } else {
  106. pConn.sendBuff.Write(value.paramName[:])
  107. fmt.Println("Param_name sendBuff ", pConn.sendBuff.Bytes())
  108. }
  109. //Param_INOUT
  110. Param_INOUT := [2]byte{0x1}
  111. pConn.sendBuff.Write(reverseBytes(Param_INOUT[:]))
  112. fmt.Println("Param_INOUT sendBuff ", pConn.sendBuff.Bytes())
  113. //Param_DType
  114. var Param_DType [2]byte
  115. binary.BigEndian.PutUint16(Param_DType[:], uint16(value.types))
  116. pConn.sendBuff.Write(Param_DType[:])
  117. fmt.Println("Param_DType sendBuff ", pConn.sendBuff.Bytes())
  118. //Param_Data_Len
  119. var Param_Data_Len [4]byte
  120. binary.BigEndian.PutUint32(Param_Data_Len[:], uint32(value.valueLength))
  121. pConn.sendBuff.Write(Param_Data_Len[:])
  122. fmt.Println("Param_Data_Len sendBuff ", pConn.sendBuff.Bytes())
  123. //Param_Data
  124. pConn.sendBuff.Write([]byte(value.value))
  125. fmt.Println("Param_Data sendBuff ", pConn.sendBuff.Bytes())
  126. }
  127. }
  128. fmt.Println("SockSendPutStatement msg", pConn.sendBuff.String())
  129. fmt.Println("SockSendPutStatement msg", pConn.sendBuff.Bytes())
  130. }
  131. // RhSend Go 版本的 rh_send 函数
  132. // TODO :加密连接还没有实现
  133. func RhSend(pConn *xuguConn, buff []byte, length int) (int, error) {
  134. pConn.mu.Lock()
  135. defer pConn.mu.Unlock()
  136. //没有内容则不发送
  137. if length == 0 {
  138. return 0, nil
  139. }
  140. //连接里是否有加密
  141. if pConn.useSSL {
  142. fmt.Println("加密未实现")
  143. return length, nil
  144. // if length > 2*1024 {
  145. // EncryptBuff(pconn, buff)
  146. // if _, err := pconn.conn.Write(pconn.sendBuff.Bytes()); err != nil {
  147. // pconn.sendBuff.Reset()
  148. // return 0, err
  149. // }
  150. // pconn.sendBuff.Reset()
  151. // _, err := pconn.conn.Write(bufPrintln()
  152. // return len(buff), err
  153. // } else if pconn.sendBuff.Len()+length >= BUFF_SIZE {
  154. // if _, err := pconn.conn.Write(pconn.sendBuff.Bytes()); err != nil {
  155. // pconn.sendBuff.Reset()
  156. // return 0, err
  157. // }
  158. // pconn.sendBuff.Reset()
  159. // _, err := pconn.sendBuff.Write(buff)
  160. // if err != nil {
  161. // return 0, err
  162. // }
  163. // EncryptBuff(pconn, pconn.sendBuff.Bytes())
  164. // return len(buff), nil
  165. // } else {
  166. // pconn.sendBuff.Write(buff)
  167. // EncryptBuff(pconn, pconn.sendBuff.Bytes()[pconn.sendBuff.Len()-length:])
  168. // return length, nil
  169. // }
  170. } else {
  171. /*如果数据长度大于 2048,先发送缓冲区中的数据,然后直接发送新的大数据块。*/
  172. if length > 2048 {
  173. if _, err := pConn.conn.Write(pConn.sendBuff.Bytes()); err != nil {
  174. //将缓冲区重置为空
  175. pConn.sendBuff.Reset()
  176. return 0, err
  177. }
  178. //将缓冲区重置为空
  179. pConn.sendBuff.Reset()
  180. //发送新的大数据块
  181. _, err := pConn.conn.Write(buff)
  182. return length, err
  183. } else if pConn.sendBuff.Len()+length >= 8*1024 {
  184. //缓冲区空间不足:
  185. /*- 如果当前缓冲区中的数据加上新数据的长度超过 `8 * 1024` 字节,
  186. 则先发送缓冲区中的数据,然后重置缓冲区,将新数据拷贝到缓冲区中。*/
  187. if _, err := pConn.conn.Write(pConn.sendBuff.Bytes()); err != nil {
  188. pConn.sendBuff.Reset()
  189. return 0, err
  190. }
  191. pConn.sendBuff.Reset()
  192. pConn.sendBuff.Write(buff)
  193. return length, nil
  194. } else {
  195. //TODO: 这里c代码里是添加到缓存buff里面 ,不直接发送
  196. pConn.sendBuff.Write(buff)
  197. return length, nil
  198. }
  199. }
  200. }
  201. func rhSendInt32(pConn *xuguConn, i uint32) (int, error) {
  202. // 创建一个 4 字节的缓冲区,用于存储网络字节序的 int32 值
  203. var networkBytes [4]byte
  204. // 将 int32 值转换为网络字节序(大端字节序)并写入缓冲区
  205. binary.BigEndian.PutUint32(networkBytes[:], i)
  206. //fmt.Println("networkBytes[] ", networkBytes[:])
  207. return RhSend(pConn, networkBytes[:], 4)
  208. }
  209. func RhFlush(pConn *xuguConn) (int, error) {
  210. if pConn.sendBuff.Len() > 0 {
  211. if _, err := pConn.conn.Write(pConn.sendBuff.Bytes()); err != nil {
  212. pConn.sendBuff.Reset()
  213. return 0, err
  214. }
  215. pConn.sendBuff.Reset()
  216. }
  217. return 0, nil
  218. }
  219. func XGC_Execute(pConn *xuguConn) int {
  220. fmt.Println("\n ---XGC_Execute")
  221. //发送没有参数的sql
  222. //SockSendCommand0(pConn, sql)
  223. //sockSendPutStatement(pConn, []byte(sql), values)
  224. pConn.conn.Write(pConn.sendBuff.Bytes())
  225. fmt.Println("\n ---XGC_Execute end")
  226. return 0
  227. }