transaction.go 5.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250
  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. tableRows := make([]*request.TableRow, 0)
  58. for _, reqTableRow := range reqTableItem.TableRows {
  59. tableRow, err := tx.client.formTableRow(reqTableRow)
  60. if err != nil {
  61. return "", err
  62. }
  63. tableRows = append(tableRows, tableRow)
  64. }
  65. tableRowItems = append(tableRowItems, &request.InsertTableRowItem{
  66. TablePrefixWithSchema: reqTableItem.TablePrefixWithSchema,
  67. Version: reqTableItem.Version,
  68. KeyColumns: reqTableItem.KeyColumns,
  69. TableRows: tableRows,
  70. })
  71. }
  72. err = tx.stream.Send(&request.TransactionOperation{
  73. Request: &request.TransactionOperation_InsertBatchTxRequest{
  74. InsertBatchTxRequest: &request.InsertBatchTxRequest{
  75. Items: tableRowItems,
  76. UserID: req.UserID,
  77. },
  78. }})
  79. if err != nil {
  80. return "", err
  81. }
  82. txResponse, err := tx.stream.Recv()
  83. if err != nil {
  84. return "", err
  85. }
  86. return txResponse.Statement, nil
  87. }
  88. func (tx *Transaction) DeleteTx(req *client.DeleteRequest) (string, error) {
  89. var err error
  90. defer func() {
  91. if err != nil {
  92. innerErr := tx.stream.CloseSend()
  93. if innerErr != nil {
  94. panic(innerErr)
  95. }
  96. }
  97. }()
  98. err = tx.stream.Send(&request.TransactionOperation{
  99. Request: &request.TransactionOperation_DeleteTxRequest{
  100. DeleteTxRequest: &request.DeleteTxRequest{
  101. TablePrefixWithSchema: req.TablePrefixWithSchema,
  102. Version: req.Version,
  103. KeyValues: req.KeyValues,
  104. UserID: req.UserID,
  105. },
  106. }})
  107. if err != nil {
  108. return "", err
  109. }
  110. txResponse, err := tx.stream.Recv()
  111. if err != nil {
  112. return "", err
  113. }
  114. return txResponse.Statement, nil
  115. }
  116. func (tx *Transaction) DeleteBatchTx(req *client.DeleteBatchRequest) (string, error) {
  117. var err error
  118. defer func() {
  119. if err != nil {
  120. innerErr := tx.stream.CloseSend()
  121. if innerErr != nil {
  122. panic(innerErr)
  123. }
  124. }
  125. }()
  126. tableRowItems := make([]*request.DeleteTableRowItem, 0)
  127. for _, reqTableItem := range req.Items {
  128. items := make([]*request.DeleteItem, 0)
  129. for _, reqKeyValues := range reqTableItem.KeyValues {
  130. items = append(items, &request.DeleteItem{
  131. KeyValues: reqKeyValues,
  132. })
  133. }
  134. tableRowItems = append(tableRowItems, &request.DeleteTableRowItem{
  135. TablePrefixWithSchema: reqTableItem.TablePrefixWithSchema,
  136. Version: reqTableItem.Version,
  137. Items: items,
  138. })
  139. }
  140. err = tx.stream.Send(&request.TransactionOperation{
  141. Request: &request.TransactionOperation_DeleteBatchTxRequest{
  142. DeleteBatchTxRequest: &request.DeleteBatchTxRequest{
  143. Items: tableRowItems,
  144. UserID: req.UserID,
  145. },
  146. }})
  147. if err != nil {
  148. return "", err
  149. }
  150. txResponse, err := tx.stream.Recv()
  151. if err != nil {
  152. return "", err
  153. }
  154. return txResponse.Statement, nil
  155. }
  156. func (tx *Transaction) UpdateTx(req *client.UpdateRequest) (string, error) {
  157. var err error
  158. defer func() {
  159. if err != nil {
  160. innerErr := tx.stream.CloseSend()
  161. if innerErr != nil {
  162. panic(innerErr)
  163. }
  164. }
  165. }()
  166. reqNewTableRowMap, err := tx.client.formTableRow(req.NewTableRow)
  167. if err != nil {
  168. return "", err
  169. }
  170. err = tx.stream.Send(&request.TransactionOperation{
  171. Request: &request.TransactionOperation_UpdateTxRequest{
  172. UpdateTxRequest: &request.UpdateTxRequest{
  173. TablePrefixWithSchema: req.TablePrefixWithSchema,
  174. Version: req.Version,
  175. KeyValues: req.KeyValues,
  176. NewTableRow: reqNewTableRowMap,
  177. UserID: req.UserID,
  178. },
  179. }})
  180. if err != nil {
  181. return "", err
  182. }
  183. txResponse, err := tx.stream.Recv()
  184. if err != nil {
  185. return "", err
  186. }
  187. return txResponse.Statement, nil
  188. }
  189. func (tx *Transaction) End() error {
  190. var err error
  191. defer func() {
  192. innerErr := tx.stream.CloseSend()
  193. if innerErr != nil {
  194. panic(innerErr)
  195. }
  196. }()
  197. err = tx.stream.Send(&request.TransactionOperation{
  198. Request: &request.TransactionOperation_TransactionEndRequest{
  199. TransactionEndRequest: &request.TransactionEndRequest{},
  200. }})
  201. if err != nil {
  202. return err
  203. }
  204. _, err = tx.stream.Recv()
  205. if err != nil && err != io.EOF {
  206. return err
  207. }
  208. return nil
  209. }