Add support for ON CLUSTER in Clickhouse while creating table

[shrinidhi111]

Describe the feature

Right now, gorm support AutoMigrate for clickhouse along with creating a table if it does not currently exists. But it cannot create cluster tables

Motivation

Although it is not an issue for development environments, while deploying to production most tables would be replicated.

The gorm:table_options appends values to the create table command. But in clickhouse the ON CLUSTER should be along with the create table command before the attributes and options are defined

What gorm does

CREATE TABLE `test_table`(`eventName` String,`datetime` DateTime64(3),`id` String) ON CLUSTER 'clustername'  ENGINE ReplicatedMergeTree ORDER BY datetime

What it is supposed to do

CREATE TABLE `test_table` ON CLUSTER 'clustername' (`eventName` String,`datetime` DateTime64(3),`id` String)  ENGINE ReplicatedMergeTree ORDER BY datetime

Code

ck.testTable.Set("gorm:table_options", "ON CLUSTER '"+clusterName+"' ENGINE ReplicatedMergeTree ORDER BY (datetime)").AutoMigrate(&TestStruct{})```

Related Issues