-
Notifications
You must be signed in to change notification settings - Fork 267
/
tcc_fence_store_sql.go
65 lines (51 loc) · 2.67 KB
/
tcc_fence_store_sql.go
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
/*
* Licensed to the Apache Software Foundation (ASF) under one or more
* contributor license agreements. See the NOTICE file distributed with
* this work for additional information regarding copyright ownership.
* The ASF licenses this file to You under the Apache License, Version 2.0
* (the "License"); you may not use this file except in compliance with
* the License. You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package sql
import (
"fmt"
"strconv"
"github.com/seata/seata-go/pkg/rm/tcc/fence/enum"
)
var (
// localTccLogPlaced The enum LocalTccLogPlaced
localTccLogPlaced = " %s "
// insertLocalTccLog The enum InsertLocalTccLog
insertLocalTccLog = "insert into " + localTccLogPlaced + " (xid, branch_id, action_name, status, gmt_create, gmt_modified) values ( ?,?,?,?,?,?)"
// queryByBranchIdAndXid The enum QueryByBranchIdAndXid
queryByBranchIdAndXid = "select xid, branch_id, action_name, status, gmt_create, gmt_modified from " + localTccLogPlaced + " where xid = ? and branch_id = ? for update"
// updateStatusByBranchIdAndXid The enum UpdateStatusByBranchIdAndXid
updateStatusByBranchIdAndXid = "update " + localTccLogPlaced + " set status = ?, gmt_modified = ? where xid = ? and branch_id = ? and status = ? "
// deleteByBranchIdAndXid The enum DeleteByBranchIdAndXid
deleteByBranchIdAndXid = "delete from " + localTccLogPlaced + " where xid = ? and branch_id = ? "
// deleteByDateAndStatus The enum DeleteByDateAndStatus
deleteByDateAndStatus = "delete from " + localTccLogPlaced + " where gmt_modified < ? and status in (" + strconv.Itoa(int(enum.StatusCommitted)) + " , " + strconv.Itoa(int(enum.StatusRollbacked)) + " , " + strconv.Itoa(int(enum.StatusSuspended)) + ")"
)
func GetInsertLocalTCCLogSQL(localTccTable string) string {
return fmt.Sprintf(insertLocalTccLog, localTccTable)
}
func GetQuerySQLByBranchIdAndXid(localTccTable string) string {
return fmt.Sprintf(queryByBranchIdAndXid, localTccTable)
}
func GetUpdateStatusSQLByBranchIdAndXid(localTccTable string) string {
return fmt.Sprintf(updateStatusByBranchIdAndXid, localTccTable)
}
func GetDeleteSQLByBranchIdAndXid(localTccTable string) string {
return fmt.Sprintf(deleteByBranchIdAndXid, localTccTable)
}
func GetDeleteSQLByMdfDateAndStatus(localTccTable string) string {
return fmt.Sprintf(deleteByDateAndStatus, localTccTable)
}