mattermost-mobile/app/database/schema/server/test.ts
Christopher Speller 6000e69886
Agents "RHS" view (#9318)
* Add agents RHS functionality for mobile

Implements a dedicated agents interface accessible from the home screen, featuring:
- Agent chat screen with bot selector and message input
- Thread list screen showing all agent conversations
- Remote actions for fetching bots and threads from plugin API
- Navigation between chat, threads, and individual conversations
- Integration with plus menu for easy access

Follows similar pattern to playbooks with modal screens and navigation helpers.

* Fix icon name for agents menu item

Change robot-happy-outline to robot-happy to resolve PropType validation error.

* Add agents button to sidebar and fix agent chat issues

- Add AgentsButton component to channel list sidebar below Drafts
- Fix thread navigation to use fetchAndSwitchToThread instead of switchToChannelById
- Replace custom TextInput with PostDraft component in agent_chat
- Fix icon name from message-reply-text-outline to reply-outline
- Add missing i18n translations for agents UI

* Implement automatic navigation to thread after sending agent message

* Implement bot selector bottom sheet with avatars. Replace click-and-cycle behavior with a proper bottom sheet menu showing all available agents with their profile pictures. Add bot avatar display to the dropdown button for better visual identification.

* Top bar design modifications.

* Add intro graphic and text

* Fix autocomplete not working

* Tweak styles and icons.

* Remove unused

* Add version/enabled check

* Remove excessive agent button

* Style fixes

* Use non-blocking then() for onPostCreated callback in send message hook

* Add unit tests for agents product components and actions

* Review feedback, offline support

* I18n

* Tests

* Address PR review feedback: deletion handling, UI fixes, schema docs

* Remove unnecessary deleteNotPresent flag from agents handlers

* Fix agents archived channel, empty data guard, and stale relative time

* Add smoke test for AgentChat and extend ToolCard test coverage

* Fix test quality issues: remove useless tests, strengthen assertions

* Address PR review: remove barrel file, add version comment

* Mock reanimated in CitationsList test to fix CI failure

* Fix CitationsList tests after always-mounted animation change

* Address PR review: typography, Pressable, FormattedText, schema bump, and cleanup

* Apply CLAUDE.md patterns across agents codebase: Pressable, typography, FormattedText, logDebug

* Fix schema test to expect version 19
2026-03-16 09:48:32 -07:00

993 lines
53 KiB
TypeScript

// Copyright (c) 2015-present Mattermost, Inc. All Rights Reserved.
// See LICENSE.txt for license information.
/* eslint-disable max-lines */
import {AGENTS_TABLES} from '@agents/constants/database';
import {MM_TABLES} from '@constants/database';
import {PLAYBOOK_TABLES} from '@playbooks/constants/database';
import {serverSchema} from './index';
const {AI_BOT, AI_THREAD} = AGENTS_TABLES;
const {
CATEGORY,
CATEGORY_CHANNEL,
CHANNEL,
CHANNEL_BOOKMARK,
CHANNEL_INFO,
CHANNEL_MEMBERSHIP,
CONFIG,
CUSTOM_EMOJI,
CUSTOM_PROFILE_FIELD,
CUSTOM_PROFILE_ATTRIBUTE,
DRAFT,
FILE,
GROUP,
GROUP_CHANNEL,
GROUP_MEMBERSHIP,
GROUP_TEAM,
MY_CHANNEL,
MY_CHANNEL_SETTINGS,
MY_TEAM,
POST,
POSTS_IN_CHANNEL,
POSTS_IN_THREAD,
PREFERENCE,
REACTION,
ROLE,
SCHEDULED_POST,
SYSTEM,
TEAM,
TEAM_CHANNEL_HISTORY,
TEAM_MEMBERSHIP,
TEAM_SEARCH_HISTORY,
THREAD,
THREAD_PARTICIPANT,
THREADS_IN_TEAM,
TEAM_THREADS_SYNC,
USER,
} = MM_TABLES.SERVER;
const {PLAYBOOK_RUN, PLAYBOOK_CHECKLIST, PLAYBOOK_CHECKLIST_ITEM, PLAYBOOK_RUN_ATTRIBUTE, PLAYBOOK_RUN_ATTRIBUTE_VALUE} = PLAYBOOK_TABLES;
describe('*** Test schema for SERVER database ***', () => {
it('=> The SERVER SCHEMA should strictly match', () => {
expect(serverSchema).toEqual({
version: 19,
unsafeSql: undefined,
tables: {
[AI_BOT]: {
name: AI_BOT,
unsafeSql: undefined,
columns: {
display_name: {name: 'display_name', type: 'string'},
username: {name: 'username', type: 'string'},
last_icon_update: {name: 'last_icon_update', type: 'number'},
dm_channel_id: {name: 'dm_channel_id', type: 'string', isIndexed: true},
channel_access_level: {name: 'channel_access_level', type: 'number'},
channel_ids: {name: 'channel_ids', type: 'string'},
user_access_level: {name: 'user_access_level', type: 'number'},
user_ids: {name: 'user_ids', type: 'string'},
team_ids: {name: 'team_ids', type: 'string'},
},
columnArray: [
{name: 'display_name', type: 'string'},
{name: 'username', type: 'string'},
{name: 'last_icon_update', type: 'number'},
{name: 'dm_channel_id', type: 'string', isIndexed: true},
{name: 'channel_access_level', type: 'number'},
{name: 'channel_ids', type: 'string'},
{name: 'user_access_level', type: 'number'},
{name: 'user_ids', type: 'string'},
{name: 'team_ids', type: 'string'},
],
},
[AI_THREAD]: {
name: AI_THREAD,
unsafeSql: undefined,
columns: {
message: {name: 'message', type: 'string'},
title: {name: 'title', type: 'string'},
channel_id: {name: 'channel_id', type: 'string', isIndexed: true},
reply_count: {name: 'reply_count', type: 'number'},
update_at: {name: 'update_at', type: 'number', isIndexed: true},
},
columnArray: [
{name: 'message', type: 'string'},
{name: 'title', type: 'string'},
{name: 'channel_id', type: 'string', isIndexed: true},
{name: 'reply_count', type: 'number'},
{name: 'update_at', type: 'number', isIndexed: true},
],
},
[CATEGORY]: {
name: CATEGORY,
unsafeSql: undefined,
columns: {
collapsed: {name: 'collapsed', type: 'boolean'},
display_name: {name: 'display_name', type: 'string'},
muted: {name: 'muted', type: 'boolean'},
sort_order: {name: 'sort_order', type: 'number'},
sorting: {name: 'sorting', type: 'string'},
team_id: {name: 'team_id', type: 'string', isIndexed: true},
type: {name: 'type', type: 'string'},
},
columnArray: [
{name: 'collapsed', type: 'boolean'},
{name: 'display_name', type: 'string'},
{name: 'muted', type: 'boolean'},
{name: 'sort_order', type: 'number'},
{name: 'sorting', type: 'string'},
{name: 'team_id', type: 'string', isIndexed: true},
{name: 'type', type: 'string'},
],
},
[CATEGORY_CHANNEL]: {
name: CATEGORY_CHANNEL,
unsafeSql: undefined,
columns: {
category_id: {name: 'category_id', type: 'string', isIndexed: true},
channel_id: {name: 'channel_id', type: 'string', isIndexed: true},
sort_order: {name: 'sort_order', type: 'number'},
},
columnArray: [
{name: 'category_id', type: 'string', isIndexed: true},
{name: 'channel_id', type: 'string', isIndexed: true},
{name: 'sort_order', type: 'number'},
],
},
[CHANNEL_INFO]: {
name: CHANNEL_INFO,
unsafeSql: undefined,
columns: {
guest_count: {name: 'guest_count', type: 'number'},
header: {name: 'header', type: 'string'},
member_count: {name: 'member_count', type: 'number'},
pinned_post_count: {name: 'pinned_post_count', type: 'number'},
files_count: {name: 'files_count', type: 'number'},
purpose: {name: 'purpose', type: 'string'},
},
columnArray: [
{name: 'guest_count', type: 'number'},
{name: 'header', type: 'string'},
{name: 'member_count', type: 'number'},
{name: 'pinned_post_count', type: 'number'},
{name: 'files_count', type: 'number'},
{name: 'purpose', type: 'string'},
],
},
[CHANNEL]: {
name: CHANNEL,
unsafeSql: undefined,
columns: {
create_at: {name: 'create_at', type: 'number'},
creator_id: {name: 'creator_id', type: 'string', isIndexed: true},
delete_at: {name: 'delete_at', type: 'number'},
display_name: {name: 'display_name', type: 'string'},
is_group_constrained: {
name: 'is_group_constrained',
type: 'boolean',
},
name: {name: 'name', type: 'string', isIndexed: true},
shared: {name: 'shared', type: 'boolean'},
team_id: {name: 'team_id', type: 'string', isIndexed: true},
type: {name: 'type', type: 'string'},
update_at: {name: 'update_at', type: 'number'},
banner_info: {name: 'banner_info', type: 'string', isOptional: true},
abac_policy_enforced: {name: 'abac_policy_enforced', type: 'boolean', isOptional: true},
autotranslation: {name: 'autotranslation', type: 'boolean', isOptional: true},
},
columnArray: [
{name: 'create_at', type: 'number'},
{name: 'creator_id', type: 'string', isIndexed: true},
{name: 'delete_at', type: 'number'},
{name: 'display_name', type: 'string'},
{name: 'is_group_constrained', type: 'boolean'},
{name: 'name', type: 'string', isIndexed: true},
{name: 'shared', type: 'boolean'},
{name: 'team_id', type: 'string', isIndexed: true},
{name: 'type', type: 'string'},
{name: 'update_at', type: 'number'},
{name: 'banner_info', type: 'string', isOptional: true},
{name: 'abac_policy_enforced', type: 'boolean', isOptional: true},
{name: 'autotranslation', type: 'boolean', isOptional: true},
],
},
[CHANNEL_BOOKMARK]: {
name: CHANNEL_BOOKMARK,
unsafeSql: undefined,
columns: {
create_at: {name: 'create_at', type: 'number'},
update_at: {name: 'update_at', type: 'number'},
delete_at: {name: 'delete_at', type: 'number'},
channel_id: {name: 'channel_id', type: 'string', isIndexed: true},
owner_id: {name: 'owner_id', type: 'string'},
file_id: {name: 'file_id', type: 'string', isOptional: true},
display_name: {name: 'display_name', type: 'string'},
sort_order: {name: 'sort_order', type: 'number'},
link_url: {name: 'link_url', type: 'string', isOptional: true},
image_url: {name: 'image_url', type: 'string', isOptional: true},
emoji: {name: 'emoji', type: 'string', isOptional: true},
type: {name: 'type', type: 'string'},
original_id: {name: 'original_id', type: 'string', isOptional: true},
parent_id: {name: 'parent_id', type: 'string', isOptional: true},
},
columnArray: [
{name: 'create_at', type: 'number'},
{name: 'update_at', type: 'number'},
{name: 'delete_at', type: 'number'},
{name: 'channel_id', type: 'string', isIndexed: true},
{name: 'owner_id', type: 'string'},
{name: 'file_id', type: 'string', isOptional: true},
{name: 'display_name', type: 'string'},
{name: 'sort_order', type: 'number'},
{name: 'link_url', type: 'string', isOptional: true},
{name: 'image_url', type: 'string', isOptional: true},
{name: 'emoji', type: 'string', isOptional: true},
{name: 'type', type: 'string'},
{name: 'original_id', type: 'string', isOptional: true},
{name: 'parent_id', type: 'string', isOptional: true},
],
},
[CHANNEL_MEMBERSHIP]: {
name: CHANNEL_MEMBERSHIP,
unsafeSql: undefined,
columns: {
channel_id: {name: 'channel_id', type: 'string', isIndexed: true},
user_id: {name: 'user_id', type: 'string', isIndexed: true},
scheme_admin: {name: 'scheme_admin', type: 'boolean'},
},
columnArray: [
{name: 'channel_id', type: 'string', isIndexed: true},
{name: 'user_id', type: 'string', isIndexed: true},
{name: 'scheme_admin', type: 'boolean'},
],
},
[CONFIG]: {
name: CONFIG,
unsafeSql: undefined,
columns: {
value: {name: 'value', type: 'string'},
},
columnArray: [
{name: 'value', type: 'string'},
],
},
[CUSTOM_EMOJI]: {
name: CUSTOM_EMOJI,
unsafeSql: undefined,
columns: {
name: {name: 'name', type: 'string', isIndexed: true},
},
columnArray: [{name: 'name', type: 'string', isIndexed: true}],
},
[CUSTOM_PROFILE_FIELD]: {
name: CUSTOM_PROFILE_FIELD,
unsafeSql: undefined,
columns: {
group_id: {name: 'group_id', type: 'string'},
name: {name: 'name', type: 'string'},
type: {name: 'type', type: 'string'},
target_id: {name: 'target_id', type: 'string'},
target_type: {name: 'target_type', type: 'string'},
create_at: {name: 'create_at', type: 'number'},
update_at: {name: 'update_at', type: 'number'},
delete_at: {name: 'delete_at', type: 'number'},
attrs: {name: 'attrs', type: 'string', isOptional: true},
},
columnArray: [
{name: 'group_id', type: 'string'},
{name: 'name', type: 'string'},
{name: 'type', type: 'string'},
{name: 'target_id', type: 'string'},
{name: 'target_type', type: 'string'},
{name: 'create_at', type: 'number'},
{name: 'update_at', type: 'number'},
{name: 'delete_at', type: 'number'},
{name: 'attrs', type: 'string', isOptional: true},
],
},
[CUSTOM_PROFILE_ATTRIBUTE]: {
name: CUSTOM_PROFILE_ATTRIBUTE,
unsafeSql: undefined,
columns: {
field_id: {name: 'field_id', type: 'string', isIndexed: true},
user_id: {name: 'user_id', type: 'string', isIndexed: true},
value: {name: 'value', type: 'string'},
},
columnArray: [
{name: 'field_id', type: 'string', isIndexed: true},
{name: 'user_id', type: 'string', isIndexed: true},
{name: 'value', type: 'string'},
],
},
[MY_CHANNEL]: {
name: MY_CHANNEL,
unsafeSql: undefined,
columns: {
is_unread: {name: 'is_unread', type: 'boolean'},
last_post_at: {name: 'last_post_at', type: 'number'},
last_viewed_at: {name: 'last_viewed_at', type: 'number'},
manually_unread: {name: 'manually_unread', type: 'boolean'},
mentions_count: {name: 'mentions_count', type: 'number'},
message_count: {name: 'message_count', type: 'number'},
roles: {name: 'roles', type: 'string'},
viewed_at: {name: 'viewed_at', type: 'number'},
last_fetched_at: {name: 'last_fetched_at', type: 'number', isIndexed: true},
last_playbook_runs_fetch_at: {name: 'last_playbook_runs_fetch_at', type: 'number'},
autotranslation_disabled: {name: 'autotranslation_disabled', type: 'boolean', isOptional: true},
},
columnArray: [
{name: 'is_unread', type: 'boolean'},
{name: 'last_post_at', type: 'number'},
{name: 'last_viewed_at', type: 'number'},
{name: 'manually_unread', type: 'boolean'},
{name: 'mentions_count', type: 'number'},
{name: 'message_count', type: 'number'},
{name: 'roles', type: 'string'},
{name: 'viewed_at', type: 'number'},
{name: 'last_fetched_at', type: 'number', isIndexed: true},
{name: 'last_playbook_runs_fetch_at', type: 'number'},
{name: 'autotranslation_disabled', type: 'boolean', isOptional: true},
],
},
[MY_CHANNEL_SETTINGS]: {
name: MY_CHANNEL_SETTINGS,
unsafeSql: undefined,
columns: {
notify_props: {name: 'notify_props', type: 'string'},
},
columnArray: [
{name: 'notify_props', type: 'string'},
],
},
[POSTS_IN_CHANNEL]: {
name: POSTS_IN_CHANNEL,
unsafeSql: undefined,
columns: {
channel_id: {name: 'channel_id', type: 'string', isIndexed: true},
earliest: {name: 'earliest', type: 'number'},
latest: {name: 'latest', type: 'number'},
},
columnArray: [
{name: 'channel_id', type: 'string', isIndexed: true},
{name: 'earliest', type: 'number'},
{name: 'latest', type: 'number'},
],
},
[DRAFT]: {
name: DRAFT,
unsafeSql: undefined,
columns: {
channel_id: {name: 'channel_id', type: 'string', isIndexed: true},
files: {name: 'files', type: 'string'},
message: {name: 'message', type: 'string'},
root_id: {name: 'root_id', type: 'string', isIndexed: true},
metadata: {name: 'metadata', type: 'string', isOptional: true},
update_at: {name: 'update_at', type: 'number'},
type: {name: 'type', type: 'string', isOptional: true},
},
columnArray: [
{name: 'channel_id', type: 'string', isIndexed: true},
{name: 'files', type: 'string'},
{name: 'message', type: 'string'},
{name: 'root_id', type: 'string', isIndexed: true},
{name: 'metadata', type: 'string', isOptional: true},
{name: 'update_at', type: 'number'},
{name: 'type', type: 'string', isOptional: true},
],
},
[FILE]: {
name: FILE,
unsafeSql: undefined,
columns: {
extension: {name: 'extension', type: 'string'},
height: {name: 'height', type: 'number'},
image_thumbnail: {name: 'image_thumbnail', type: 'string'},
local_path: {name: 'local_path', type: 'string', isOptional: true},
mime_type: {name: 'mime_type', type: 'string'},
name: {name: 'name', type: 'string'},
post_id: {name: 'post_id', type: 'string', isIndexed: true},
size: {name: 'size', type: 'number'},
width: {name: 'width', type: 'number'},
is_blocked: {name: 'is_blocked', type: 'boolean'},
},
columnArray: [
{name: 'extension', type: 'string'},
{name: 'height', type: 'number'},
{name: 'image_thumbnail', type: 'string'},
{name: 'local_path', type: 'string', isOptional: true},
{name: 'mime_type', type: 'string'},
{name: 'name', type: 'string'},
{name: 'post_id', type: 'string', isIndexed: true},
{name: 'size', type: 'number'},
{name: 'width', type: 'number'},
{name: 'is_blocked', type: 'boolean'},
],
},
[GROUP]: {
name: GROUP,
unsafeSql: undefined,
columns: {
display_name: {name: 'display_name', type: 'string'},
name: {name: 'name', type: 'string', isIndexed: true},
description: {name: 'description', type: 'string'},
source: {name: 'source', type: 'string'},
remote_id: {name: 'remote_id', type: 'string', isIndexed: true},
created_at: {name: 'created_at', type: 'number'},
updated_at: {name: 'updated_at', type: 'number'},
deleted_at: {name: 'deleted_at', type: 'number'},
member_count: {name: 'member_count', type: 'number'},
},
columnArray: [
{name: 'display_name', type: 'string'},
{name: 'name', type: 'string', isIndexed: true},
{name: 'description', type: 'string'},
{name: 'source', type: 'string'},
{name: 'remote_id', type: 'string', isIndexed: true},
{name: 'created_at', type: 'number'},
{name: 'updated_at', type: 'number'},
{name: 'deleted_at', type: 'number'},
{name: 'member_count', type: 'number'},
],
},
[GROUP_CHANNEL]: {
name: GROUP_CHANNEL,
unsafeSql: undefined,
columns: {
group_id: {name: 'group_id', type: 'string', isIndexed: true},
channel_id: {name: 'channel_id', type: 'string', isIndexed: true},
created_at: {name: 'created_at', type: 'number'},
updated_at: {name: 'updated_at', type: 'number'},
deleted_at: {name: 'deleted_at', type: 'number'},
},
columnArray: [
{name: 'group_id', type: 'string', isIndexed: true},
{name: 'channel_id', type: 'string', isIndexed: true},
{name: 'created_at', type: 'number'},
{name: 'updated_at', type: 'number'},
{name: 'deleted_at', type: 'number'},
],
},
[GROUP_MEMBERSHIP]: {
name: GROUP_MEMBERSHIP,
unsafeSql: undefined,
columns: {
group_id: {name: 'group_id', type: 'string', isIndexed: true},
user_id: {name: 'user_id', type: 'string', isIndexed: true},
created_at: {name: 'created_at', type: 'number'},
updated_at: {name: 'updated_at', type: 'number'},
deleted_at: {name: 'deleted_at', type: 'number'},
},
columnArray: [
{name: 'group_id', type: 'string', isIndexed: true},
{name: 'user_id', type: 'string', isIndexed: true},
{name: 'created_at', type: 'number'},
{name: 'updated_at', type: 'number'},
{name: 'deleted_at', type: 'number'},
],
},
[GROUP_TEAM]: {
name: GROUP_TEAM,
unsafeSql: undefined,
columns: {
group_id: {name: 'group_id', type: 'string', isIndexed: true},
team_id: {name: 'team_id', type: 'string', isIndexed: true},
created_at: {name: 'created_at', type: 'number'},
updated_at: {name: 'updated_at', type: 'number'},
deleted_at: {name: 'deleted_at', type: 'number'},
},
columnArray: [
{name: 'group_id', type: 'string', isIndexed: true},
{name: 'team_id', type: 'string', isIndexed: true},
{name: 'created_at', type: 'number'},
{name: 'updated_at', type: 'number'},
{name: 'deleted_at', type: 'number'},
],
},
[PLAYBOOK_RUN]: {
name: PLAYBOOK_RUN,
unsafeSql: undefined,
columns: {
playbook_id: {name: 'playbook_id', type: 'string'},
name: {name: 'name', type: 'string'},
description: {name: 'description', type: 'string'},
is_active: {name: 'is_active', type: 'boolean', isIndexed: true},
owner_user_id: {name: 'owner_user_id', type: 'string'},
team_id: {name: 'team_id', type: 'string'},
channel_id: {name: 'channel_id', type: 'string', isIndexed: true},
post_id: {name: 'post_id', type: 'string', isOptional: true},
create_at: {name: 'create_at', type: 'number'},
end_at: {name: 'end_at', type: 'number'},
active_stage: {name: 'active_stage', type: 'number'},
active_stage_title: {name: 'active_stage_title', type: 'string'},
participant_ids: {name: 'participant_ids', type: 'string'}, // JSON string
summary: {name: 'summary', type: 'string'},
current_status: {name: 'current_status', type: 'string', isIndexed: true},
last_status_update_at: {name: 'last_status_update_at', type: 'number'},
retrospective_enabled: {name: 'retrospective_enabled', type: 'boolean'},
retrospective: {name: 'retrospective', type: 'string'},
retrospective_published_at: {name: 'retrospective_published_at', type: 'number'},
sync: {name: 'sync', type: 'string', isIndexed: true, isOptional: true},
last_sync_at: {name: 'last_sync_at', type: 'number', isOptional: true},
items_order: {name: 'items_order', type: 'string'},
previous_reminder: {name: 'previous_reminder', type: 'number', isOptional: true},
update_at: {name: 'update_at', type: 'number'},
type: {name: 'type', type: 'string'},
},
columnArray: [
{name: 'playbook_id', type: 'string'},
{name: 'name', type: 'string'},
{name: 'description', type: 'string'},
{name: 'is_active', type: 'boolean', isIndexed: true},
{name: 'owner_user_id', type: 'string'},
{name: 'team_id', type: 'string'},
{name: 'channel_id', type: 'string', isIndexed: true},
{name: 'post_id', type: 'string', isOptional: true},
{name: 'create_at', type: 'number'},
{name: 'end_at', type: 'number'},
{name: 'active_stage', type: 'number'},
{name: 'active_stage_title', type: 'string'},
{name: 'participant_ids', type: 'string'}, // JSON string
{name: 'summary', type: 'string'},
{name: 'current_status', type: 'string', isIndexed: true},
{name: 'last_status_update_at', type: 'number'},
{name: 'retrospective_enabled', type: 'boolean'},
{name: 'retrospective', type: 'string'},
{name: 'retrospective_published_at', type: 'number'},
{name: 'sync', type: 'string', isIndexed: true, isOptional: true},
{name: 'last_sync_at', type: 'number', isOptional: true},
{name: 'previous_reminder', type: 'number', isOptional: true},
{name: 'items_order', type: 'string'},
{name: 'update_at', type: 'number'},
{name: 'type', type: 'string'},
],
},
[PLAYBOOK_CHECKLIST]: {
name: PLAYBOOK_CHECKLIST,
unsafeSql: undefined,
columns: {
run_id: {name: 'run_id', type: 'string', isIndexed: true},
title: {name: 'title', type: 'string'},
sync: {name: 'sync', type: 'string', isIndexed: true, isOptional: true},
last_sync_at: {name: 'last_sync_at', type: 'number', isOptional: true},
items_order: {name: 'items_order', type: 'string'},
update_at: {name: 'update_at', type: 'number'},
},
columnArray: [
{name: 'run_id', type: 'string', isIndexed: true},
{name: 'title', type: 'string'},
{name: 'sync', type: 'string', isIndexed: true, isOptional: true},
{name: 'last_sync_at', type: 'number', isOptional: true},
{name: 'items_order', type: 'string'},
{name: 'update_at', type: 'number'},
],
},
[PLAYBOOK_CHECKLIST_ITEM]: {
name: PLAYBOOK_CHECKLIST_ITEM,
unsafeSql: undefined,
columns: {
checklist_id: {name: 'checklist_id', type: 'string', isIndexed: true},
title: {name: 'title', type: 'string'},
state: {name: 'state', type: 'string', isIndexed: true},
state_modified: {name: 'state_modified', type: 'number'},
assignee_id: {name: 'assignee_id', type: 'string', isOptional: true},
assignee_modified: {name: 'assignee_modified', type: 'number'},
command: {name: 'command', type: 'string', isOptional: true},
command_last_run: {name: 'command_last_run', type: 'number'},
description: {name: 'description', type: 'string'},
due_date: {name: 'due_date', type: 'number'},
completed_at: {name: 'completed_at', type: 'number'},
task_actions: {name: 'task_actions', type: 'string', isOptional: true}, // JSON string
condition_action: {name: 'condition_action', type: 'string'},
condition_reason: {name: 'condition_reason', type: 'string'},
sync: {name: 'sync', type: 'string', isIndexed: true, isOptional: true},
last_sync_at: {name: 'last_sync_at', type: 'number', isOptional: true},
update_at: {name: 'update_at', type: 'number'},
},
columnArray: [
{name: 'checklist_id', type: 'string', isIndexed: true},
{name: 'title', type: 'string'},
{name: 'state', type: 'string', isIndexed: true},
{name: 'state_modified', type: 'number'},
{name: 'assignee_id', type: 'string', isOptional: true},
{name: 'assignee_modified', type: 'number'},
{name: 'command', type: 'string', isOptional: true},
{name: 'command_last_run', type: 'number'},
{name: 'description', type: 'string'},
{name: 'due_date', type: 'number'},
{name: 'completed_at', type: 'number'},
{name: 'task_actions', type: 'string', isOptional: true}, // JSON string
{name: 'condition_action', type: 'string'},
{name: 'condition_reason', type: 'string'},
{name: 'sync', type: 'string', isIndexed: true, isOptional: true},
{name: 'last_sync_at', type: 'number', isOptional: true},
{name: 'update_at', type: 'number'},
],
},
[PLAYBOOK_RUN_ATTRIBUTE]: {
name: PLAYBOOK_RUN_ATTRIBUTE,
unsafeSql: undefined,
columns: {
group_id: {name: 'group_id', type: 'string'},
name: {name: 'name', type: 'string'},
type: {name: 'type', type: 'string'},
target_id: {name: 'target_id', type: 'string'},
target_type: {name: 'target_type', type: 'string'},
create_at: {name: 'create_at', type: 'number'},
update_at: {name: 'update_at', type: 'number'},
delete_at: {name: 'delete_at', type: 'number'},
attrs: {name: 'attrs', type: 'string', isOptional: true},
},
columnArray: [
{name: 'group_id', type: 'string'},
{name: 'name', type: 'string'},
{name: 'type', type: 'string'},
{name: 'target_id', type: 'string'},
{name: 'target_type', type: 'string'},
{name: 'create_at', type: 'number'},
{name: 'update_at', type: 'number'},
{name: 'delete_at', type: 'number'},
{name: 'attrs', type: 'string', isOptional: true},
],
},
[PLAYBOOK_RUN_ATTRIBUTE_VALUE]: {
name: PLAYBOOK_RUN_ATTRIBUTE_VALUE,
unsafeSql: undefined,
columns: {
attribute_id: {name: 'attribute_id', type: 'string', isIndexed: true},
run_id: {name: 'run_id', type: 'string', isIndexed: true},
value: {name: 'value', type: 'string'},
update_at: {name: 'update_at', type: 'number'},
},
columnArray: [
{name: 'attribute_id', type: 'string', isIndexed: true},
{name: 'run_id', type: 'string', isIndexed: true},
{name: 'value', type: 'string'},
{name: 'update_at', type: 'number'},
],
},
[POSTS_IN_THREAD]: {
name: POSTS_IN_THREAD,
unsafeSql: undefined,
columns: {
earliest: {name: 'earliest', type: 'number'},
latest: {name: 'latest', type: 'number'},
root_id: {name: 'root_id', type: 'string', isIndexed: true},
},
columnArray: [
{name: 'earliest', type: 'number'},
{name: 'latest', type: 'number'},
{name: 'root_id', type: 'string', isIndexed: true},
],
},
[POST]: {
name: POST,
unsafeSql: undefined,
columns: {
channel_id: {name: 'channel_id', type: 'string', isIndexed: true},
create_at: {name: 'create_at', type: 'number'},
delete_at: {name: 'delete_at', type: 'number'},
edit_at: {name: 'edit_at', type: 'number'},
is_pinned: {name: 'is_pinned', type: 'boolean'},
message: {name: 'message', type: 'string'},
message_source: {name: 'message_source', type: 'string'},
metadata: {name: 'metadata', type: 'string', isOptional: true},
original_id: {name: 'original_id', type: 'string'},
pending_post_id: {name: 'pending_post_id', type: 'string', isIndexed: true},
previous_post_id: {name: 'previous_post_id', type: 'string'},
props: {name: 'props', type: 'string'},
root_id: {name: 'root_id', type: 'string'},
type: {name: 'type', type: 'string', isIndexed: true},
update_at: {name: 'update_at', type: 'number'},
user_id: {name: 'user_id', type: 'string', isIndexed: true},
},
columnArray: [
{name: 'channel_id', type: 'string', isIndexed: true},
{name: 'create_at', type: 'number'},
{name: 'delete_at', type: 'number'},
{name: 'edit_at', type: 'number'},
{name: 'is_pinned', type: 'boolean'},
{name: 'message', type: 'string'},
{name: 'message_source', type: 'string'},
{name: 'metadata', type: 'string', isOptional: true},
{name: 'original_id', type: 'string'},
{name: 'pending_post_id', type: 'string', isIndexed: true},
{name: 'previous_post_id', type: 'string'},
{name: 'props', type: 'string'},
{name: 'root_id', type: 'string'},
{name: 'type', type: 'string', isIndexed: true},
{name: 'update_at', type: 'number'},
{name: 'user_id', type: 'string', isIndexed: true},
],
},
[PREFERENCE]: {
name: PREFERENCE,
unsafeSql: undefined,
columns: {
category: {name: 'category', type: 'string', isIndexed: true},
name: {name: 'name', type: 'string'},
user_id: {name: 'user_id', type: 'string', isIndexed: true},
value: {name: 'value', type: 'string'},
},
columnArray: [
{name: 'category', type: 'string', isIndexed: true},
{name: 'name', type: 'string'},
{name: 'user_id', type: 'string', isIndexed: true},
{name: 'value', type: 'string'},
],
},
[REACTION]: {
name: REACTION,
unsafeSql: undefined,
columns: {
create_at: {name: 'create_at', type: 'number'},
emoji_name: {name: 'emoji_name', type: 'string'},
post_id: {name: 'post_id', type: 'string', isIndexed: true},
user_id: {name: 'user_id', type: 'string', isIndexed: true},
},
columnArray: [
{name: 'create_at', type: 'number'},
{name: 'emoji_name', type: 'string'},
{name: 'post_id', type: 'string', isIndexed: true},
{name: 'user_id', type: 'string', isIndexed: true},
],
},
[MY_TEAM]: {
name: MY_TEAM,
unsafeSql: undefined,
columns: {
roles: {name: 'roles', type: 'string'},
},
columnArray: [
{name: 'roles', type: 'string'},
],
},
[ROLE]: {
name: ROLE,
unsafeSql: undefined,
columns: {
name: {name: 'name', type: 'string', isIndexed: true},
permissions: {name: 'permissions', type: 'string'},
},
columnArray: [
{name: 'name', type: 'string', isIndexed: true},
{name: 'permissions', type: 'string'},
],
},
[SCHEDULED_POST]: {
name: SCHEDULED_POST,
unsafeSql: undefined,
columns: {
channel_id: {name: 'channel_id', type: 'string', isIndexed: true},
message: {name: 'message', type: 'string'},
files: {name: 'files', type: 'string'},
root_id: {name: 'root_id', type: 'string', isIndexed: true},
metadata: {name: 'metadata', type: 'string', isOptional: true},
create_at: {name: 'create_at', type: 'number'},
update_at: {name: 'update_at', type: 'number'},
scheduled_at: {name: 'scheduled_at', type: 'number'},
processed_at: {name: 'processed_at', type: 'number'},
error_code: {name: 'error_code', type: 'string'},
type: {name: 'type', type: 'string', isOptional: true},
},
columnArray: [
{name: 'channel_id', type: 'string', isIndexed: true},
{name: 'files', type: 'string'},
{name: 'message', type: 'string'},
{name: 'root_id', type: 'string', isIndexed: true},
{name: 'metadata', type: 'string', isOptional: true},
{name: 'create_at', type: 'number'},
{name: 'update_at', type: 'number'},
{name: 'scheduled_at', type: 'number'},
{name: 'processed_at', type: 'number'},
{name: 'error_code', type: 'string'},
{name: 'type', type: 'string', isOptional: true},
],
},
[SYSTEM]: {
name: SYSTEM,
unsafeSql: undefined,
columns: {
value: {name: 'value', type: 'string'},
},
columnArray: [
{name: 'value', type: 'string'},
],
},
[TEAM]: {
name: TEAM,
unsafeSql: undefined,
columns: {
allowed_domains: {name: 'allowed_domains', type: 'string'},
description: {name: 'description', type: 'string'},
display_name: {name: 'display_name', type: 'string'},
is_allow_open_invite: {
name: 'is_allow_open_invite',
type: 'boolean',
},
is_group_constrained: {
name: 'is_group_constrained',
type: 'boolean',
},
last_team_icon_updated_at: {
name: 'last_team_icon_updated_at',
type: 'number',
},
name: {name: 'name', type: 'string'},
type: {name: 'type', type: 'string'},
update_at: {name: 'update_at', type: 'number'},
invite_id: {name: 'invite_id', type: 'string'},
},
columnArray: [
{name: 'allowed_domains', type: 'string'},
{name: 'description', type: 'string'},
{name: 'display_name', type: 'string'},
{name: 'is_allow_open_invite', type: 'boolean'},
{name: 'is_group_constrained', type: 'boolean'},
{name: 'last_team_icon_updated_at', type: 'number'},
{name: 'name', type: 'string'},
{name: 'type', type: 'string'},
{name: 'update_at', type: 'number'},
{name: 'invite_id', type: 'string'},
],
},
[TEAM_CHANNEL_HISTORY]: {
name: TEAM_CHANNEL_HISTORY,
unsafeSql: undefined,
columns: {
channel_ids: {name: 'channel_ids', type: 'string'},
},
columnArray: [
{name: 'channel_ids', type: 'string'},
],
},
[TEAM_MEMBERSHIP]: {
name: TEAM_MEMBERSHIP,
unsafeSql: undefined,
columns: {
team_id: {name: 'team_id', type: 'string', isIndexed: true},
user_id: {name: 'user_id', type: 'string', isIndexed: true},
scheme_admin: {name: 'scheme_admin', type: 'boolean'},
},
columnArray: [
{name: 'team_id', type: 'string', isIndexed: true},
{name: 'user_id', type: 'string', isIndexed: true},
{name: 'scheme_admin', type: 'boolean'},
],
},
[TEAM_SEARCH_HISTORY]: {
name: TEAM_SEARCH_HISTORY,
unsafeSql: undefined,
columns: {
created_at: {name: 'created_at', type: 'number'},
display_term: {name: 'display_term', type: 'string'},
team_id: {name: 'team_id', type: 'string', isIndexed: true},
term: {name: 'term', type: 'string'},
},
columnArray: [
{name: 'created_at', type: 'number'},
{name: 'display_term', type: 'string'},
{name: 'team_id', type: 'string', isIndexed: true},
{name: 'term', type: 'string'},
],
},
[THREAD]: {
name: THREAD,
unsafeSql: undefined,
columns: {
is_following: {name: 'is_following', type: 'boolean'},
last_reply_at: {name: 'last_reply_at', type: 'number'},
last_viewed_at: {name: 'last_viewed_at', type: 'number'},
reply_count: {name: 'reply_count', type: 'number'},
unread_mentions: {name: 'unread_mentions', type: 'number'},
unread_replies: {name: 'unread_replies', type: 'number'},
viewed_at: {name: 'viewed_at', type: 'number'},
last_fetched_at: {name: 'last_fetched_at', type: 'number', isIndexed: true},
},
columnArray: [
{name: 'is_following', type: 'boolean'},
{name: 'last_reply_at', type: 'number'},
{name: 'last_viewed_at', type: 'number'},
{name: 'reply_count', type: 'number'},
{name: 'unread_mentions', type: 'number'},
{name: 'unread_replies', type: 'number'},
{name: 'viewed_at', type: 'number'},
{name: 'last_fetched_at', type: 'number', isIndexed: true},
],
},
[THREAD_PARTICIPANT]: {
name: THREAD_PARTICIPANT,
unsafeSql: undefined,
columns: {
thread_id: {name: 'thread_id', type: 'string', isIndexed: true},
user_id: {name: 'user_id', type: 'string', isIndexed: true},
},
columnArray: [
{name: 'thread_id', type: 'string', isIndexed: true},
{name: 'user_id', type: 'string', isIndexed: true},
],
},
[THREADS_IN_TEAM]: {
name: THREADS_IN_TEAM,
unsafeSql: undefined,
columns: {
team_id: {name: 'team_id', type: 'string', isIndexed: true},
thread_id: {name: 'thread_id', type: 'string', isIndexed: true},
},
columnArray: [
{name: 'team_id', type: 'string', isIndexed: true},
{name: 'thread_id', type: 'string', isIndexed: true},
],
},
[TEAM_THREADS_SYNC]: {
name: TEAM_THREADS_SYNC,
unsafeSql: undefined,
columns: {
earliest: {name: 'earliest', type: 'number'},
latest: {name: 'latest', type: 'number'},
},
columnArray: [
{name: 'earliest', type: 'number'},
{name: 'latest', type: 'number'},
],
},
[USER]: {
name: USER,
unsafeSql: undefined,
columns: {
auth_service: {name: 'auth_service', type: 'string'},
delete_at: {name: 'delete_at', type: 'number'},
email: {name: 'email', type: 'string'},
first_name: {name: 'first_name', type: 'string'},
is_bot: {name: 'is_bot', type: 'boolean'},
is_guest: {name: 'is_guest', type: 'boolean'},
last_name: {name: 'last_name', type: 'string'},
last_picture_update: {name: 'last_picture_update', type: 'number'},
locale: {name: 'locale', type: 'string'},
nickname: {name: 'nickname', type: 'string'},
notify_props: {name: 'notify_props', type: 'string'},
position: {name: 'position', type: 'string'},
props: {name: 'props', type: 'string'},
remote_id: {name: 'remote_id', type: 'string', isOptional: true},
roles: {name: 'roles', type: 'string'},
status: {name: 'status', type: 'string'},
timezone: {name: 'timezone', type: 'string'},
update_at: {name: 'update_at', type: 'number'},
username: {name: 'username', type: 'string'},
terms_of_service_create_at: {name: 'terms_of_service_create_at', type: 'number'},
terms_of_service_id: {name: 'terms_of_service_id', type: 'string'},
},
columnArray: [
{name: 'auth_service', type: 'string'},
{name: 'delete_at', type: 'number'},
{name: 'email', type: 'string'},
{name: 'first_name', type: 'string'},
{name: 'is_bot', type: 'boolean'},
{name: 'is_guest', type: 'boolean'},
{name: 'last_name', type: 'string'},
{name: 'last_picture_update', type: 'number'},
{name: 'locale', type: 'string'},
{name: 'nickname', type: 'string'},
{name: 'notify_props', type: 'string'},
{name: 'position', type: 'string'},
{name: 'props', type: 'string'},
{name: 'remote_id', type: 'string', isOptional: true},
{name: 'roles', type: 'string'},
{name: 'status', type: 'string'},
{name: 'timezone', type: 'string'},
{name: 'update_at', type: 'number'},
{name: 'username', type: 'string'},
{name: 'terms_of_service_id', type: 'string'},
{name: 'terms_of_service_create_at', type: 'number'},
],
},
},
});
});
});