transaction.go 5.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252
  1. package dpsv1
  2. import (
  3. "git.sxidc.com/service-supports/dps-sdk/client"
  4. "git.sxidc.com/service-supports/dps-sdk/pb/v1"
  5. "git.sxidc.com/service-supports/dps-sdk/pb/v1/request"
  6. "io"
  7. )
  8. type Transaction struct {
  9. stream v1.CommandService_TransactionClient
  10. client *Client
  11. }
  12. func (tx *Transaction) InsertTx(req *client.InsertRequest) (string, error) {
  13. var err error
  14. defer func() {
  15. if err != nil {
  16. innerErr := tx.stream.CloseSend()
  17. if innerErr != nil {
  18. panic(innerErr)
  19. }
  20. }
  21. }()
  22. reqTableRow, err := tx.client.formTableRow(req.TableRow)
  23. if err != nil {
  24. return "", err
  25. }
  26. err = tx.stream.Send(&request.TransactionOperation{
  27. Request: &request.TransactionOperation_InsertTxRequest{
  28. InsertTxRequest: &request.InsertTxRequest{
  29. TablePrefixWithSchema: req.TablePrefixWithSchema,
  30. Version: req.Version,
  31. KeyColumns: req.KeyColumns,
  32. TableRow: reqTableRow,
  33. UserID: req.UserID,
  34. },
  35. }})
  36. if err != nil {
  37. return "", err
  38. }
  39. txResponse, err := tx.stream.Recv()
  40. if err != nil {
  41. return "", err
  42. }
  43. return txResponse.Statement, nil
  44. }
  45. func (tx *Transaction) InsertBatchTx(req *client.InsertBatchRequest) (string, error) {
  46. var err error
  47. defer func() {
  48. if err != nil {
  49. innerErr := tx.stream.CloseSend()
  50. if innerErr != nil {
  51. panic(innerErr)
  52. }
  53. }
  54. }()
  55. tableRowItems := make([]*request.InsertTableRowItem, 0)
  56. for _, reqTableItem := range req.Items {
  57. items := make([]*request.InsertItem, 0)
  58. for _, reqItem := range reqTableItem.Items {
  59. tableRow, err := tx.client.formTableRow(reqItem.TableRow)
  60. if err != nil {
  61. return "", err
  62. }
  63. items = append(items, &request.InsertItem{
  64. KeyColumns: reqItem.KeyColumns,
  65. TableRow: tableRow,
  66. })
  67. }
  68. tableRowItems = append(tableRowItems, &request.InsertTableRowItem{
  69. TablePrefixWithSchema: reqTableItem.TablePrefixWithSchema,
  70. Version: reqTableItem.Version,
  71. Items: items,
  72. })
  73. }
  74. err = tx.stream.Send(&request.TransactionOperation{
  75. Request: &request.TransactionOperation_InsertBatchTxRequest{
  76. InsertBatchTxRequest: &request.InsertBatchTxRequest{
  77. Items: tableRowItems,
  78. UserID: req.UserID,
  79. },
  80. }})
  81. if err != nil {
  82. return "", err
  83. }
  84. txResponse, err := tx.stream.Recv()
  85. if err != nil {
  86. return "", err
  87. }
  88. return txResponse.Statement, nil
  89. }
  90. func (tx *Transaction) DeleteTx(req *client.DeleteRequest) (string, error) {
  91. var err error
  92. defer func() {
  93. if err != nil {
  94. innerErr := tx.stream.CloseSend()
  95. if innerErr != nil {
  96. panic(innerErr)
  97. }
  98. }
  99. }()
  100. err = tx.stream.Send(&request.TransactionOperation{
  101. Request: &request.TransactionOperation_DeleteTxRequest{
  102. DeleteTxRequest: &request.DeleteTxRequest{
  103. TablePrefixWithSchema: req.TablePrefixWithSchema,
  104. Version: req.Version,
  105. KeyValues: req.KeyValues,
  106. UserID: req.UserID,
  107. },
  108. }})
  109. if err != nil {
  110. return "", err
  111. }
  112. txResponse, err := tx.stream.Recv()
  113. if err != nil {
  114. return "", err
  115. }
  116. return txResponse.Statement, nil
  117. }
  118. func (tx *Transaction) DeleteBatchTx(req *client.DeleteBatchRequest) (string, error) {
  119. var err error
  120. defer func() {
  121. if err != nil {
  122. innerErr := tx.stream.CloseSend()
  123. if innerErr != nil {
  124. panic(innerErr)
  125. }
  126. }
  127. }()
  128. tableRowItems := make([]*request.DeleteTableRowItem, 0)
  129. for _, reqTableItem := range req.Items {
  130. items := make([]*request.DeleteItem, 0)
  131. for _, reqItem := range reqTableItem.Items {
  132. items = append(items, &request.DeleteItem{
  133. KeyValues: reqItem.KeyValues,
  134. })
  135. }
  136. tableRowItems = append(tableRowItems, &request.DeleteTableRowItem{
  137. TablePrefixWithSchema: reqTableItem.TablePrefixWithSchema,
  138. Version: reqTableItem.Version,
  139. Items: items,
  140. })
  141. }
  142. err = tx.stream.Send(&request.TransactionOperation{
  143. Request: &request.TransactionOperation_DeleteBatchTxRequest{
  144. DeleteBatchTxRequest: &request.DeleteBatchTxRequest{
  145. Items: tableRowItems,
  146. UserID: req.UserID,
  147. },
  148. }})
  149. if err != nil {
  150. return "", err
  151. }
  152. txResponse, err := tx.stream.Recv()
  153. if err != nil {
  154. return "", err
  155. }
  156. return txResponse.Statement, nil
  157. }
  158. func (tx *Transaction) UpdateTx(req *client.UpdateRequest) (string, error) {
  159. var err error
  160. defer func() {
  161. if err != nil {
  162. innerErr := tx.stream.CloseSend()
  163. if innerErr != nil {
  164. panic(innerErr)
  165. }
  166. }
  167. }()
  168. reqNewTableRowMap, err := tx.client.formTableRow(req.NewTableRow)
  169. if err != nil {
  170. return "", err
  171. }
  172. err = tx.stream.Send(&request.TransactionOperation{
  173. Request: &request.TransactionOperation_UpdateTxRequest{
  174. UpdateTxRequest: &request.UpdateTxRequest{
  175. TablePrefixWithSchema: req.TablePrefixWithSchema,
  176. Version: req.Version,
  177. KeyValues: req.KeyValues,
  178. NewTableRow: reqNewTableRowMap,
  179. UserID: req.UserID,
  180. },
  181. }})
  182. if err != nil {
  183. return "", err
  184. }
  185. txResponse, err := tx.stream.Recv()
  186. if err != nil {
  187. return "", err
  188. }
  189. return txResponse.Statement, nil
  190. }
  191. func (tx *Transaction) End() error {
  192. var err error
  193. defer func() {
  194. innerErr := tx.stream.CloseSend()
  195. if innerErr != nil {
  196. panic(innerErr)
  197. }
  198. }()
  199. err = tx.stream.Send(&request.TransactionOperation{
  200. Request: &request.TransactionOperation_TransactionEndRequest{
  201. TransactionEndRequest: &request.TransactionEndRequest{},
  202. }})
  203. if err != nil {
  204. return err
  205. }
  206. _, err = tx.stream.Recv()
  207. if err != nil && err != io.EOF {
  208. return err
  209. }
  210. return nil
  211. }