Is your feature request related to a problem? Please describe.
.net samples for distributed transaction.

Is your feature request related to a problem? Please describe.

test func func FormatTimeMillis(tsMillis uint64) string and func func FormatDate(tsMillis uint64) string

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

Describe the solution you'd like
Process with ReadWriteSplittingExecutor

Is your feature request related to a problem? Please describe.
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

Is your feature request related to a problem? Please describe.
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

Is your feature request related to a problem? Please describe.
if topology is like that:

db: drug_0, table: drug_resource_0, drug_resource_1, drug_resource_2, drug_resource_3, drug_resource_4
db: drug_1, table: drug_resource_5, drug_resource_6, drug_resource_7, drug_resource_8, drug_resource_9

drug_resource table contains columns: id, name, code, purchase_price, etc.

when query select avg(purchase_price) from drug_resource where id > 15 and id <18, should rewrite the sql, such as select purchase_price from drug_resource_5 where id > 15 and id < 18, query on every shard, then calculate each result.

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

Is your feature request related to a problem? Please describe.
including go 、java、python samples

Is your feature request related to a problem? Please describe.
php samples for distributed transaction.

global_transaction_count{appid="", transactionname=""} 0
global_transaction_commit_count{appid="", transactionname=""} 0
global_transaction_rollback_count{appid="", transactionname=""} 0
branch_transaction_count{appid="", resourceid=""} 0
branch_transaction_commit_count{appid="", resourceid=""} 0
branch_transaction_rollback_count{appid="", resourceid=""} 0

Is your feature request related to a problem? Please describe.
if topology is like that:

db: drug_0, table: drug_resource_0, drug_resource_1, drug_resource_2, drug_resource_3, drug_resource_4
db: drug_1, table: drug_resource_5, drug_resource_6, drug_resource_7, drug_resource_8, drug_resource_9

drug_resource table contains columns: id, name, code, purchase_price, etc.

when query select min(purchase_price) from drug_resource where id > 15 and id <18, should rewrite the sql, such as select min(purchase_price) from drug_resource_5 where id > 15 and id < 18, query on every shard, then calculate each result.

max same as min

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

Is your feature request related to a problem? Please describe.
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

• I have searched the issues of this repository and believe that this is not a duplicate.

Describe the bug
In sidecar model, Kubernetes will send SIGTERM signals to all containers at the same time before destroying the pod, so dbpack container will stop at the same time as business containers, this may cause unpaid requests to fail.

I think DBPack should waiting for a length of time （terminationDrainDuration） before exiting can solve this problem. Just like Istio-Proxy does.

related code（cmd/cmd.go#L177）
`
dbpack.Start()

		ctx, cancel := context.WithCancel(context.Background())
		c := make(chan os.Signal, 2)
		signal.Notify(c, os.Interrupt, syscall.SIGTERM)
		go func() {
			<-c
			cancel()
			<-c
			os.Exit(1) // second signal. Exit directly.
		}()

		<-ctx.Done()

`

Describe the solution you'd like
There is a DistributedTransactionManager

func (manager *DistributedTransactionManager) branchCommit(bs *api.BranchSession) (api.BranchSession_BranchStatus, error) {
	db := resource.GetDBManager().GetDB(bs.ResourceID)
	if db == nil {
		return 0, fmt.Errorf("DB resource is not exist, db name: %s", bs.ResourceID)
	}

	if err := GetUndoLogManager().DeleteUndoLogByXID(db, bs.XID); err != nil {
		return api.PhaseTwoCommitting, err
	}
	if err := manager.storageDriver.DeleteBranchSession(context.Background(), bs.BranchID); err != nil {
		log.Error(err)
	}
	log.Debugf("branch session committed, branch id: %s, lock key: %s", bs.BranchID, bs.LockKey)
	return api.Complete, nil
}

When calling branchCommit method, should judge the type of BranchSession, if the branch type is api.TCC, should send http request to CommitRequestPath, the CommitRequestPath is serialized into ApplicationData of BranchSession.

When calling branchRollback should to the same thing as above.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

Describe the solution you'd like
Process with DBConnectionPreFilter

Is your feature request related to a problem? Please describe.
In sharding mode, global tables are the same on every db

Describe the solution you'd like
Support query from global table

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

Is your feature request related to a problem? Please describe.
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

Is your feature request related to a problem? Please describe.
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

Is your feature request related to a problem? Please describe.
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

/assign @zhu733756

Is your feature request related to a problem? Please describe.
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

Is your feature request related to a problem? Please describe.
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

Is your feature request related to a problem? Please describe.
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]
Currently only one column order by is supported

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

As described in the [compile section](https://cectc.github.io/dbpack-doc/#/getting_started?id=%e7%bc%96%e8%af%91) of getting started doc, a binary file is expected to be built in the dist directory when make build executed. When i run make build on my MacBook, a binary file is built in the project root directory and the file can not be executed because of an exec format error. I check the makefile and find the build doesn't work as it's expected to.

build:  ## build dbpack cli, and put in dist dir
	GOOS="linux"  GOARCH="amd64" CGO_ENABLED=0 go build -o dbpack ./cmd

Is your feature request related to a problem? Please describe.
refer to

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

Is your feature request related to a problem? Please describe.
test func GenerateXID() and func GetTransactionID()

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

Is your feature request related to a problem? Please describe.
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

Is your feature request related to a problem? Please describe.
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]
implement ShardingAlgorithm interface.

type ShardingAlgorithm interface {
	HasShardingKey(key string) bool
	Shard(condition *KeyCondition) (Condition, error)
	ShardRange(cond1, cond2 *KeyCondition) (Condition, error)
	AllShards() Condition
	AllowFullScan() bool
}

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

Is your feature request related to a problem? Please describe.
if topology is like that:

db: drug_0, table: drug_resource_0, drug_resource_1, drug_resource_2, drug_resource_3, drug_resource_4
db: drug_1, table: drug_resource_5, drug_resource_6, drug_resource_7, drug_resource_8, drug_resource_9

drug_resource table contains columns: id, name, code, purchase_price, etc.

when query select count(*) from drug_resource where id > 15 and id <18, should rewrite the sql, query on every shard, then sum each result.

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

Is your feature request related to a problem? Please describe.
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

Is your feature request related to a problem? Please describe.
Depending on the where condition, the delete request may need to be executed on a different DB.
You can refer to the sharding derivation method of the query request.

• I have searched the issues of this repository and believe that this is not a duplicate.

Describe the bug
Run go sample, add time.sleep(60) before the request returns, when timeout, business is running normally, return {"message":"success","success":true}, should rollback distributed transaction.

Is your feature request related to a problem? Please describe.
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]
there is a sql audit log specific, https://support.huaweicloud.com/usermanual-rds/rds_download_sql_auditing_log.html

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

• I have searched the issues of this repository and believe that this is not a duplicate.

Describe the bug
SET @@session.autocommit = OFF lead server panic for interface type assertion.

To Reproduce
Steps to reproduce the behavior:

1. run dbpack from command line
2. run python-samples order demo

Expected behavior
SET @@session.autocommit = OFF execute well, not panic the server.

Screenshots

Additional context
Add any other context about the problem here.

Is your feature request related to a problem? Please describe.
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]

• match TransactionInfo RequestPath
• match TCCResource PrepareRequestPath

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

Is your feature request related to a problem? Please describe.
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]

step1: support pgsql client connect to dbpack

step2: Forward pgsql request to PostgreSql database

Is your feature request related to a problem? Please describe.
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]

help us improve unit test coverage，please refer to https://app.codecov.io/gh/CECTC/dbpack/blob/dev/pkg/cond/condition.go

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

Is your feature request related to a problem? Please describe.
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]

implement ShardingAlgorithm interface.

type ShardingAlgorithm interface {
	HasShardingKey(key string) bool
	Shard(condition *KeyCondition) (Condition, error)
	ShardRange(cond1, cond2 *KeyCondition) (Condition, error)
	AllShards() Condition
	AllowFullScan() bool
}

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

• I have searched the issues of this repository and believe that this is not a duplicate.

Describe the bug
if we not start the etcd server, the code below

client, err := clientv3.New(config)

will connect the etcd background, so the dbpack server will hang.

Expected behavior
if the etcd server not start, dbpack should panic soon

Screenshots
If applicable, add screenshots to help explain your problem.

Additional context
Add any other context about the problem here.

Is your feature request related to a problem? Please describe.

If the primary key is not specified when inserting, the distributed primary key is used to insert.

Is your feature request related to a problem? Please describe.
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

Is your feature request related to a problem? Please describe.
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]

• match TransactionInfo RequestPath
• match TCCResource PrepareRequestPath

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

Is your feature request related to a problem? Please describe.
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

Is your feature request related to a problem? Please describe.
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]

such as : select id, name, age from employees where id > 1000 limit 100,10

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

Is your feature request related to a problem? Please describe.

Depending on the where condition, the update request may need to be executed on a different DB.
You can refer to the sharding derivation method of the query request.

• [√] I have searched the issues of this repository and believe that this is not a duplicate.

Describe the bug
same as title

Expected behavior
run success!

Is your feature request related to a problem? Please describe.
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

Are you using DBPack?

If you are using DBPack, first we would like to Thank You. Our goal is to grow the community, improve DBPack and help each other.

The purpose of this issue

We are always interested in finding out who is using DBPack, what attracted you to using it, how we can listen to your needs and if you are interested, help promote your organization.

• We have people reaching out to us asking, who uses DBPack in production?
• We’d like to listen to what you would like to see in DBPack and your scenarios?
• We'd like to help promote your organization and work with you

What we would like from you

Submit a comment in this issue to include the following information:

• Organization: CECTC (Required)
• Location: wuhan, hubei, China（Required）
• Usage：used to solving distributed transaction problem、read write splitting、sharding (Required)
• TransactionMode: AT\TCC
• Version: 0.1.0（Optional）
• Icon （Preferred）

Thanks again for your participation!

欢迎使用 DBPack，首先感谢您的使用，其次您可以参考下面的样例来提供您的信息以收集使用场景帮助提升改进：

* 组织：**电子云（Required）
* 地点：**武汉（Required）
* 用途：解决分布式事务问题、读写分离、分库分表（Required）
* 事务模式：AT\TCC
* 版本: 0.1.0（Optional）
* 公司图标：（Preferred）

Is your feature request related to a problem? Please describe.
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]

watch config key in etcd for dynamic update.

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

Is your feature request related to a problem? Please describe.
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.