mirror of
https://github.com/hanzoai/tasks.git
synced 2026-10-04 02:04:03 +00:00
Rodrigo ZhouandGitHub
d49786debf
* Create base schema for PostgreSQL 12 * Changes to PostgreSQL 12 visibility schame to support advanced visibility * Create PostgreSQL 12 db interface and configs
115 lines
4.3 KiB
Go
115 lines
4.3 KiB
Go
// The MIT License
|
|
//
|
|
// Copyright (c) 2020 Temporal Technologies Inc. All rights reserved.
|
|
//
|
|
// Copyright (c) 2020 Uber Technologies, Inc.
|
|
//
|
|
// Permission is hereby granted, free of charge, to any person obtaining a copy
|
|
// of this software and associated documentation files (the "Software"), to deal
|
|
// in the Software without restriction, including without limitation the rights
|
|
// to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
|
|
// copies of the Software, and to permit persons to whom the Software is
|
|
// furnished to do so, subject to the following conditions:
|
|
//
|
|
// The above copyright notice and this permission notice shall be included in
|
|
// all copies or substantial portions of the Software.
|
|
//
|
|
// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
|
|
// IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
|
|
// FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
|
|
// AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
|
|
// LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
|
|
// OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
|
|
// THE SOFTWARE.
|
|
|
|
package tests
|
|
|
|
const (
|
|
testUser = "temporal"
|
|
testPassword = "temporal"
|
|
|
|
testMySQLExecutionSchemaFile = "../../schema/mysql/v57/temporal/schema.sql"
|
|
testMySQLVisibilitySchemaFile = "../../schema/mysql/v57/visibility/schema.sql"
|
|
testMySQLExecutionSchemaVersionDir = "../../schema/mysql/v57/temporal/versioned"
|
|
testMySQLVisibilitySchemaVersionDir = "../../schema/mysql/v57/visibility/versioned"
|
|
|
|
testMySQL8ExecutionSchemaFile = "../../schema/mysql/v8/temporal/schema.sql"
|
|
testMySQL8VisibilitySchemaFile = "../../schema/mysql/v8/visibility/schema.sql"
|
|
testMySQL8ExecutionSchemaVersionDir = "../../schema/mysql/v8/temporal/versioned"
|
|
testMySQL8VisibilitySchemaVersionDir = "../../schema/mysql/v8/visibility/versioned"
|
|
|
|
testMySQLQuery = `
|
|
-- test sql file content
|
|
|
|
CREATE TABLE executions(
|
|
shard_id INT NOT NULL,
|
|
namespace_id BINARY(16) NOT NULL,
|
|
workflow_id VARCHAR(255) NOT NULL,
|
|
run_id BINARY(16) NOT NULL,
|
|
--
|
|
next_event_id BIGINT NOT NULL,
|
|
last_write_version BIGINT NOT NULL,
|
|
data BLOB NOT NULL,
|
|
data_encoding VARCHAR(16) NOT NULL,
|
|
state BLOB NOT NULL,
|
|
state_encoding VARCHAR(16) NOT NULL,
|
|
PRIMARY KEY (shard_id, namespace_id, workflow_id, run_id)
|
|
);
|
|
|
|
CREATE TABLE current_executions(
|
|
shard_id INT NOT NULL,
|
|
namespace_id BINARY(16) NOT NULL,
|
|
workflow_id VARCHAR(255) NOT NULL,
|
|
--
|
|
run_id BINARY(16) NOT NULL,
|
|
create_request_id VARCHAR(64) NOT NULL,
|
|
state INT NOT NULL,
|
|
status INT NOT NULL,
|
|
start_version BIGINT NOT NULL,
|
|
last_write_version BIGINT NOT NULL,
|
|
PRIMARY KEY (shard_id, namespace_id, workflow_id)
|
|
);
|
|
`
|
|
testPostgreSQLExecutionSchemaFile = "../../schema/postgresql/v96/temporal/schema.sql"
|
|
testPostgreSQLVisibilitySchemaFile = "../../schema/postgresql/v96/visibility/schema.sql"
|
|
testPostgreSQLExecutionSchemaVersionDir = "../../schema/postgresql/v96/temporal/versioned"
|
|
testPostgreSQLVisibilitySchemaVersionDir = "../../schema/postgresql/v96/visibility/versioned"
|
|
|
|
testPostgreSQL12ExecutionSchemaFile = "../../schema/postgresql/v12/temporal/schema.sql"
|
|
testPostgreSQL12VisibilitySchemaFile = "../../schema/postgresql/v12/visibility/schema.sql"
|
|
testPostgreSQL12ExecutionSchemaVersionDir = "../../schema/postgresql/v12/temporal/versioned"
|
|
testPostgreSQL12VisibilitySchemaVersionDir = "../../schema/postgresql/v12/visibility/versioned"
|
|
|
|
testPostgreSQLQuery = `
|
|
-- test sql file content
|
|
|
|
CREATE TABLE executions(
|
|
shard_id INTEGER NOT NULL,
|
|
namespace_id BYTEA NOT NULL,
|
|
workflow_id VARCHAR(255) NOT NULL,
|
|
run_id BYTEA NOT NULL,
|
|
--
|
|
next_event_id BIGINT NOT NULL,
|
|
last_write_version BIGINT NOT NULL,
|
|
data BYTEA NOT NULL,
|
|
data_encoding VARCHAR(16) NOT NULL,
|
|
state BYTEA NOT NULL,
|
|
state_encoding VARCHAR(16) NOT NULL,
|
|
PRIMARY KEY (shard_id, namespace_id, workflow_id, run_id)
|
|
);
|
|
|
|
CREATE TABLE current_executions(
|
|
shard_id INTEGER NOT NULL,
|
|
namespace_id BYTEA NOT NULL,
|
|
workflow_id VARCHAR(255) NOT NULL,
|
|
--
|
|
run_id BYTEA NOT NULL,
|
|
create_request_id VARCHAR(64) NOT NULL,
|
|
state INTEGER NOT NULL,
|
|
status INTEGER NOT NULL,
|
|
last_write_version BIGINT NOT NULL,
|
|
PRIMARY KEY (shard_id, namespace_id, workflow_id)
|
|
);
|
|
`
|
|
)
|