Page MenuHomePhabricator
Differential D9014

[Commtest] Remove backup gRPC tests
AbandonedPublic
Actions

Authored by • jon on Aug 29 2023, 1:41 PM.
Tags
None
Referenced Files
Unknown Object (File)
Sun, Mar 9, 10:03 AM
Unknown Object (File)
Thu, Mar 6, 5:41 AM
Unknown Object (File)
Mar 1 2025, 3:24 PM
Unknown Object (File)
Mar 1 2025, 3:23 PM
Unknown Object (File)
Mar 1 2025, 3:01 PM
Unknown Object (File)
Feb 27 2025, 11:40 PM
Unknown Object (File)
Feb 19 2025, 1:06 PM
Unknown Object (File)
Feb 3 2025, 6:28 AM
View All 81 Files
Subscribers
ashoat
tomek

Details

Reviewers
bartek
varun
kamil
michal
Summary

Follow to https://phab.comm.dev/D8796. Since the tests in commtest
all interacted with the gRPC endpoints, decided to drop all tests related to
blob.

Test Plan
cd services/commtest
cargo build

Diff Detail

Repository
rCOMM Comm
Lint
No Lint Coverage
Unit
No Test Coverage

Event Timeline

• jon created this revision.Aug 29 2023, 1:41 PM
Herald added subscribers: tomek, ashoat. · View Herald TranscriptAug 29 2023, 1:41 PM
Harbormaster completed remote builds in B22235: Diff 30521.Aug 29 2023, 2:00 PM
• jon requested review of this revision.Aug 29 2023, 2:00 PM
• jon mentioned this in D9015: [shared/grpc_clients] Add verify_user_access_token().Aug 29 2023, 6:28 PM
bartek added a reviewer: michal.Aug 29 2023, 10:41 PM

I realized that this will conflict with D8966, depending on which one is landed first

michal accepted this revision.Aug 29 2023, 11:10 PM

I'm probably going to land the test improvements this morning, but accepting if it's blocking someone. I will rebase over this diff if required. If I land first we cancel this

This revision is now accepted and ready to land.Aug 29 2023, 11:10 PM
michal requested changes to this revision.Aug 30 2023, 1:28 AM

Landed D8966 so we can cancel this

This revision now requires changes to proceed.Aug 30 2023, 1:28 AM
• jon abandoned this revision.Aug 30 2023, 7:41 AM

https://phab.comm.dev/D8966 seems like the right approach. Closing

• jon mentioned this in rCOMM8a4af7fd5fb7: [shared/grpc_clients] Add verify_user_access_token().Aug 30 2023, 1:22 PM

Revision Contents
Changeset List

Diff 30521

View Options

services/commtest/src/backup/add_attachments.rs

Show First 20 Lines • Show All 130 Lines • ▼ Show 20 Lines SQL`
CREATE TABLE sessions ( CREATE TABLE sessions (
id bigint(20) NOT NULL, id bigint(20) NOT NULL,
user bigint(20) NOT NULL, user bigint(20) NOT NULL,
cookie bigint(20) NOT NULL, cookie bigint(20) NOT NULL,
query json NOT NULL, query json NOT NULL,
creation_time bigint(20) NOT NULL, creation_time bigint(20) NOT NULL,
last_update bigint(20) NOT NULL, last_update bigint(20) NOT NULL,
last_validated bigint(20) NOT NULL last_validated bigint(20) NOT NULL,
public_key char(116) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1; ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE threads ( CREATE TABLE threads (
id bigint(20) NOT NULL, id bigint(20) NOT NULL,
type tinyint(3) NOT NULL, type tinyint(3) NOT NULL,
name varchar(191) COLLATE utf8mb4_bin DEFAULT NULL, name varchar(191) COLLATE utf8mb4_bin DEFAULT NULL,
description mediumtext COLLATE utf8mb4_bin, description mediumtext COLLATE utf8mb4_bin,
parent_thread_id bigint(20) DEFAULT NULL, parent_thread_id bigint(20) DEFAULT NULL,
Show All 30 Lines SQL`
secret varchar(255) NOT NULL, secret varchar(255) NOT NULL,
creation_time bigint(20) NOT NULL, creation_time bigint(20) NOT NULL,
extra json DEFAULT NULL extra json DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8; ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE users ( CREATE TABLE users (
id bigint(20) NOT NULL, id bigint(20) NOT NULL,
username varchar(${usernameMaxLength}) COLLATE utf8mb4_bin NOT NULL, username varchar(${usernameMaxLength}) COLLATE utf8mb4_bin NOT NULL,
hash char(60) COLLATE utf8mb4_bin DEFAULT NULL, hash char(60) COLLATE utf8mb4_bin NOT NULL,
avatar varchar(191) COLLATE utf8mb4_bin DEFAULT NULL, avatar varchar(191) COLLATE utf8mb4_bin DEFAULT NULL,
creation_time bigint(20) NOT NULL creation_time bigint(20) NOT NULL,
public_key char(116) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
CREATE TABLE relationships_undirected ( CREATE TABLE relationships_undirected (
user1 bigint(20) NOT NULL, user1 bigint(20) NOT NULL,
user2 bigint(20) NOT NULL, user2 bigint(20) NOT NULL,
status tinyint(1) UNSIGNED NOT NULL status tinyint(1) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1; ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
▲ Show 20 Lines • Show All 85 Lines • ▼ Show 20 Lines SQL`
ADD KEY entry (entry); ADD KEY entry (entry);
ALTER TABLE roles ALTER TABLE roles
ADD PRIMARY KEY (id), ADD PRIMARY KEY (id),
ADD KEY thread (thread); ADD KEY thread (thread);
ALTER TABLE sessions ALTER TABLE sessions
ADD PRIMARY KEY (id), ADD PRIMARY KEY (id),
ADD KEY user (user); ADD KEY user (user),
ADD UNIQUE INDEX public_key (public_key);
ALTER TABLE threads ALTER TABLE threads
ADD PRIMARY KEY (id), ADD PRIMARY KEY (id),
ADD INDEX parent_thread_id (parent_thread_id), ADD INDEX parent_thread_id (parent_thread_id),
ADD INDEX containing_thread_id (containing_thread_id), ADD INDEX containing_thread_id (containing_thread_id),
ADD INDEX community (community); ADD INDEX community (community);
ALTER TABLE updates ALTER TABLE updates
ADD PRIMARY KEY (id), ADD PRIMARY KEY (id),
ADD INDEX user_time (user,time), ADD INDEX user_time (user,time),
ADD INDEX target_time (target, time), ADD INDEX target_time (target, time),
ADD INDEX user_key_target_type_time (user, \`key\`, target, type, time), ADD INDEX user_key_target_type_time (user, \`key\`, target, type, time),
ADD INDEX user_key_type_time (user, \`key\`, type, time), ADD INDEX user_key_type_time (user, \`key\`, type, time),
ADD INDEX user_key_time (user, \`key\`, time); ADD INDEX user_key_time (user, \`key\`, time);
ALTER TABLE uploads ALTER TABLE uploads
ADD PRIMARY KEY (id), ADD PRIMARY KEY (id),
ADD INDEX container (container); ADD INDEX container (container);
ALTER TABLE users ALTER TABLE users
ADD PRIMARY KEY (id), ADD PRIMARY KEY (id),
ADD UNIQUE KEY username (username); ADD UNIQUE KEY username (username),
ADD UNIQUE INDEX public_key (public_key);
ALTER TABLE relationships_undirected ALTER TABLE relationships_undirected
ADD UNIQUE KEY user1_user2 (user1,user2), ADD UNIQUE KEY user1_user2 (user1,user2),
ADD UNIQUE KEY user2_user1 (user2,user1); ADD UNIQUE KEY user2_user1 (user2,user1);
ALTER TABLE relationships_directed ALTER TABLE relationships_directed
ADD UNIQUE KEY user1_user2 (user1,user2), ADD UNIQUE KEY user1_user2 (user1,user2),
ADD UNIQUE KEY user2_user1 (user2,user1); ADD UNIQUE KEY user2_user1 (user2,user1);
▲ Show 20 Lines • Show All 87 Lines • Show Last 20 Lines
View Options

services/commtest/src/backup/backup_utils.rs

Show First 20 Lines • Show All 130 Lines • ▼ Show 20 Lines SQL`
CREATE TABLE sessions ( CREATE TABLE sessions (
id bigint(20) NOT NULL, id bigint(20) NOT NULL,
user bigint(20) NOT NULL, user bigint(20) NOT NULL,
cookie bigint(20) NOT NULL, cookie bigint(20) NOT NULL,
query json NOT NULL, query json NOT NULL,
creation_time bigint(20) NOT NULL, creation_time bigint(20) NOT NULL,
last_update bigint(20) NOT NULL, last_update bigint(20) NOT NULL,
last_validated bigint(20) NOT NULL last_validated bigint(20) NOT NULL,
public_key char(116) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1; ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE threads ( CREATE TABLE threads (
id bigint(20) NOT NULL, id bigint(20) NOT NULL,
type tinyint(3) NOT NULL, type tinyint(3) NOT NULL,
name varchar(191) COLLATE utf8mb4_bin DEFAULT NULL, name varchar(191) COLLATE utf8mb4_bin DEFAULT NULL,
description mediumtext COLLATE utf8mb4_bin, description mediumtext COLLATE utf8mb4_bin,
parent_thread_id bigint(20) DEFAULT NULL, parent_thread_id bigint(20) DEFAULT NULL,
Show All 30 Lines SQL`
secret varchar(255) NOT NULL, secret varchar(255) NOT NULL,
creation_time bigint(20) NOT NULL, creation_time bigint(20) NOT NULL,
extra json DEFAULT NULL extra json DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8; ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE users ( CREATE TABLE users (
id bigint(20) NOT NULL, id bigint(20) NOT NULL,
username varchar(${usernameMaxLength}) COLLATE utf8mb4_bin NOT NULL, username varchar(${usernameMaxLength}) COLLATE utf8mb4_bin NOT NULL,
hash char(60) COLLATE utf8mb4_bin DEFAULT NULL, hash char(60) COLLATE utf8mb4_bin NOT NULL,
avatar varchar(191) COLLATE utf8mb4_bin DEFAULT NULL, avatar varchar(191) COLLATE utf8mb4_bin DEFAULT NULL,
creation_time bigint(20) NOT NULL creation_time bigint(20) NOT NULL,
public_key char(116) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
CREATE TABLE relationships_undirected ( CREATE TABLE relationships_undirected (
user1 bigint(20) NOT NULL, user1 bigint(20) NOT NULL,
user2 bigint(20) NOT NULL, user2 bigint(20) NOT NULL,
status tinyint(1) UNSIGNED NOT NULL status tinyint(1) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1; ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
▲ Show 20 Lines • Show All 85 Lines • ▼ Show 20 Lines SQL`
ADD KEY entry (entry); ADD KEY entry (entry);
ALTER TABLE roles ALTER TABLE roles
ADD PRIMARY KEY (id), ADD PRIMARY KEY (id),
ADD KEY thread (thread); ADD KEY thread (thread);
ALTER TABLE sessions ALTER TABLE sessions
ADD PRIMARY KEY (id), ADD PRIMARY KEY (id),
ADD KEY user (user); ADD KEY user (user),
ADD UNIQUE INDEX public_key (public_key);
ALTER TABLE threads ALTER TABLE threads
ADD PRIMARY KEY (id), ADD PRIMARY KEY (id),
ADD INDEX parent_thread_id (parent_thread_id), ADD INDEX parent_thread_id (parent_thread_id),
ADD INDEX containing_thread_id (containing_thread_id), ADD INDEX containing_thread_id (containing_thread_id),
ADD INDEX community (community); ADD INDEX community (community);
ALTER TABLE updates ALTER TABLE updates
ADD PRIMARY KEY (id), ADD PRIMARY KEY (id),
ADD INDEX user_time (user,time), ADD INDEX user_time (user,time),
ADD INDEX target_time (target, time), ADD INDEX target_time (target, time),
ADD INDEX user_key_target_type_time (user, \`key\`, target, type, time), ADD INDEX user_key_target_type_time (user, \`key\`, target, type, time),
ADD INDEX user_key_type_time (user, \`key\`, type, time), ADD INDEX user_key_type_time (user, \`key\`, type, time),
ADD INDEX user_key_time (user, \`key\`, time); ADD INDEX user_key_time (user, \`key\`, time);
ALTER TABLE uploads ALTER TABLE uploads
ADD PRIMARY KEY (id), ADD PRIMARY KEY (id),
ADD INDEX container (container); ADD INDEX container (container);
ALTER TABLE users ALTER TABLE users
ADD PRIMARY KEY (id), ADD PRIMARY KEY (id),
ADD UNIQUE KEY username (username); ADD UNIQUE KEY username (username),
ADD UNIQUE INDEX public_key (public_key);
ALTER TABLE relationships_undirected ALTER TABLE relationships_undirected
ADD UNIQUE KEY user1_user2 (user1,user2), ADD UNIQUE KEY user1_user2 (user1,user2),
ADD UNIQUE KEY user2_user1 (user2,user1); ADD UNIQUE KEY user2_user1 (user2,user1);
ALTER TABLE relationships_directed ALTER TABLE relationships_directed
ADD UNIQUE KEY user1_user2 (user1,user2), ADD UNIQUE KEY user1_user2 (user1,user2),
ADD UNIQUE KEY user2_user1 (user2,user1); ADD UNIQUE KEY user2_user1 (user2,user1);
▲ Show 20 Lines • Show All 87 Lines • Show Last 20 Lines
View Options

services/commtest/src/backup/create_new_backup.rs

Show First 20 Lines • Show All 130 Lines • ▼ Show 20 Lines SQL`
CREATE TABLE sessions ( CREATE TABLE sessions (
id bigint(20) NOT NULL, id bigint(20) NOT NULL,
user bigint(20) NOT NULL, user bigint(20) NOT NULL,
cookie bigint(20) NOT NULL, cookie bigint(20) NOT NULL,
query json NOT NULL, query json NOT NULL,
creation_time bigint(20) NOT NULL, creation_time bigint(20) NOT NULL,
last_update bigint(20) NOT NULL, last_update bigint(20) NOT NULL,
last_validated bigint(20) NOT NULL last_validated bigint(20) NOT NULL,
public_key char(116) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1; ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE threads ( CREATE TABLE threads (
id bigint(20) NOT NULL, id bigint(20) NOT NULL,
type tinyint(3) NOT NULL, type tinyint(3) NOT NULL,
name varchar(191) COLLATE utf8mb4_bin DEFAULT NULL, name varchar(191) COLLATE utf8mb4_bin DEFAULT NULL,
description mediumtext COLLATE utf8mb4_bin, description mediumtext COLLATE utf8mb4_bin,
parent_thread_id bigint(20) DEFAULT NULL, parent_thread_id bigint(20) DEFAULT NULL,
Show All 30 Lines SQL`
secret varchar(255) NOT NULL, secret varchar(255) NOT NULL,
creation_time bigint(20) NOT NULL, creation_time bigint(20) NOT NULL,
extra json DEFAULT NULL extra json DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8; ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE users ( CREATE TABLE users (
id bigint(20) NOT NULL, id bigint(20) NOT NULL,
username varchar(${usernameMaxLength}) COLLATE utf8mb4_bin NOT NULL, username varchar(${usernameMaxLength}) COLLATE utf8mb4_bin NOT NULL,
hash char(60) COLLATE utf8mb4_bin DEFAULT NULL, hash char(60) COLLATE utf8mb4_bin NOT NULL,
avatar varchar(191) COLLATE utf8mb4_bin DEFAULT NULL, avatar varchar(191) COLLATE utf8mb4_bin DEFAULT NULL,
creation_time bigint(20) NOT NULL creation_time bigint(20) NOT NULL,
public_key char(116) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
CREATE TABLE relationships_undirected ( CREATE TABLE relationships_undirected (
user1 bigint(20) NOT NULL, user1 bigint(20) NOT NULL,
user2 bigint(20) NOT NULL, user2 bigint(20) NOT NULL,
status tinyint(1) UNSIGNED NOT NULL status tinyint(1) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1; ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
▲ Show 20 Lines • Show All 85 Lines • ▼ Show 20 Lines SQL`
ADD KEY entry (entry); ADD KEY entry (entry);
ALTER TABLE roles ALTER TABLE roles
ADD PRIMARY KEY (id), ADD PRIMARY KEY (id),
ADD KEY thread (thread); ADD KEY thread (thread);
ALTER TABLE sessions ALTER TABLE sessions
ADD PRIMARY KEY (id), ADD PRIMARY KEY (id),
ADD KEY user (user); ADD KEY user (user),
ADD UNIQUE INDEX public_key (public_key);
ALTER TABLE threads ALTER TABLE threads
ADD PRIMARY KEY (id), ADD PRIMARY KEY (id),
ADD INDEX parent_thread_id (parent_thread_id), ADD INDEX parent_thread_id (parent_thread_id),
ADD INDEX containing_thread_id (containing_thread_id), ADD INDEX containing_thread_id (containing_thread_id),
ADD INDEX community (community); ADD INDEX community (community);
ALTER TABLE updates ALTER TABLE updates
ADD PRIMARY KEY (id), ADD PRIMARY KEY (id),
ADD INDEX user_time (user,time), ADD INDEX user_time (user,time),
ADD INDEX target_time (target, time), ADD INDEX target_time (target, time),
ADD INDEX user_key_target_type_time (user, \`key\`, target, type, time), ADD INDEX user_key_target_type_time (user, \`key\`, target, type, time),
ADD INDEX user_key_type_time (user, \`key\`, type, time), ADD INDEX user_key_type_time (user, \`key\`, type, time),
ADD INDEX user_key_time (user, \`key\`, time); ADD INDEX user_key_time (user, \`key\`, time);
ALTER TABLE uploads ALTER TABLE uploads
ADD PRIMARY KEY (id), ADD PRIMARY KEY (id),
ADD INDEX container (container); ADD INDEX container (container);
ALTER TABLE users ALTER TABLE users
ADD PRIMARY KEY (id), ADD PRIMARY KEY (id),
ADD UNIQUE KEY username (username); ADD UNIQUE KEY username (username),
ADD UNIQUE INDEX public_key (public_key);
ALTER TABLE relationships_undirected ALTER TABLE relationships_undirected
ADD UNIQUE KEY user1_user2 (user1,user2), ADD UNIQUE KEY user1_user2 (user1,user2),
ADD UNIQUE KEY user2_user1 (user2,user1); ADD UNIQUE KEY user2_user1 (user2,user1);
ALTER TABLE relationships_directed ALTER TABLE relationships_directed
ADD UNIQUE KEY user1_user2 (user1,user2), ADD UNIQUE KEY user1_user2 (user1,user2),
ADD UNIQUE KEY user2_user1 (user2,user1); ADD UNIQUE KEY user2_user1 (user2,user1);
▲ Show 20 Lines • Show All 87 Lines • Show Last 20 Lines
View Options

services/commtest/src/backup/mod.rs

Show First 20 Lines • Show All 130 Lines • ▼ Show 20 Lines SQL`
CREATE TABLE sessions ( CREATE TABLE sessions (
id bigint(20) NOT NULL, id bigint(20) NOT NULL,
user bigint(20) NOT NULL, user bigint(20) NOT NULL,
cookie bigint(20) NOT NULL, cookie bigint(20) NOT NULL,
query json NOT NULL, query json NOT NULL,
creation_time bigint(20) NOT NULL, creation_time bigint(20) NOT NULL,
last_update bigint(20) NOT NULL, last_update bigint(20) NOT NULL,
last_validated bigint(20) NOT NULL last_validated bigint(20) NOT NULL,
public_key char(116) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1; ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE threads ( CREATE TABLE threads (
id bigint(20) NOT NULL, id bigint(20) NOT NULL,
type tinyint(3) NOT NULL, type tinyint(3) NOT NULL,
name varchar(191) COLLATE utf8mb4_bin DEFAULT NULL, name varchar(191) COLLATE utf8mb4_bin DEFAULT NULL,
description mediumtext COLLATE utf8mb4_bin, description mediumtext COLLATE utf8mb4_bin,
parent_thread_id bigint(20) DEFAULT NULL, parent_thread_id bigint(20) DEFAULT NULL,
Show All 30 Lines SQL`
secret varchar(255) NOT NULL, secret varchar(255) NOT NULL,
creation_time bigint(20) NOT NULL, creation_time bigint(20) NOT NULL,
extra json DEFAULT NULL extra json DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8; ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE users ( CREATE TABLE users (
id bigint(20) NOT NULL, id bigint(20) NOT NULL,
username varchar(${usernameMaxLength}) COLLATE utf8mb4_bin NOT NULL, username varchar(${usernameMaxLength}) COLLATE utf8mb4_bin NOT NULL,
hash char(60) COLLATE utf8mb4_bin DEFAULT NULL, hash char(60) COLLATE utf8mb4_bin NOT NULL,
avatar varchar(191) COLLATE utf8mb4_bin DEFAULT NULL, avatar varchar(191) COLLATE utf8mb4_bin DEFAULT NULL,
creation_time bigint(20) NOT NULL creation_time bigint(20) NOT NULL,
public_key char(116) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
CREATE TABLE relationships_undirected ( CREATE TABLE relationships_undirected (
user1 bigint(20) NOT NULL, user1 bigint(20) NOT NULL,
user2 bigint(20) NOT NULL, user2 bigint(20) NOT NULL,
status tinyint(1) UNSIGNED NOT NULL status tinyint(1) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1; ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
▲ Show 20 Lines • Show All 85 Lines • ▼ Show 20 Lines SQL`
ADD KEY entry (entry); ADD KEY entry (entry);
ALTER TABLE roles ALTER TABLE roles
ADD PRIMARY KEY (id), ADD PRIMARY KEY (id),
ADD KEY thread (thread); ADD KEY thread (thread);
ALTER TABLE sessions ALTER TABLE sessions
ADD PRIMARY KEY (id), ADD PRIMARY KEY (id),
ADD KEY user (user); ADD KEY user (user),
ADD UNIQUE INDEX public_key (public_key);
ALTER TABLE threads ALTER TABLE threads
ADD PRIMARY KEY (id), ADD PRIMARY KEY (id),
ADD INDEX parent_thread_id (parent_thread_id), ADD INDEX parent_thread_id (parent_thread_id),
ADD INDEX containing_thread_id (containing_thread_id), ADD INDEX containing_thread_id (containing_thread_id),
ADD INDEX community (community); ADD INDEX community (community);
ALTER TABLE updates ALTER TABLE updates
ADD PRIMARY KEY (id), ADD PRIMARY KEY (id),
ADD INDEX user_time (user,time), ADD INDEX user_time (user,time),
ADD INDEX target_time (target, time), ADD INDEX target_time (target, time),
ADD INDEX user_key_target_type_time (user, \`key\`, target, type, time), ADD INDEX user_key_target_type_time (user, \`key\`, target, type, time),
ADD INDEX user_key_type_time (user, \`key\`, type, time), ADD INDEX user_key_type_time (user, \`key\`, type, time),
ADD INDEX user_key_time (user, \`key\`, time); ADD INDEX user_key_time (user, \`key\`, time);
ALTER TABLE uploads ALTER TABLE uploads
ADD PRIMARY KEY (id), ADD PRIMARY KEY (id),
ADD INDEX container (container); ADD INDEX container (container);
ALTER TABLE users ALTER TABLE users
ADD PRIMARY KEY (id), ADD PRIMARY KEY (id),
ADD UNIQUE KEY username (username); ADD UNIQUE KEY username (username),
ADD UNIQUE INDEX public_key (public_key);
ALTER TABLE relationships_undirected ALTER TABLE relationships_undirected
ADD UNIQUE KEY user1_user2 (user1,user2), ADD UNIQUE KEY user1_user2 (user1,user2),
ADD UNIQUE KEY user2_user1 (user2,user1); ADD UNIQUE KEY user2_user1 (user2,user1);
ALTER TABLE relationships_directed ALTER TABLE relationships_directed
ADD UNIQUE KEY user1_user2 (user1,user2), ADD UNIQUE KEY user1_user2 (user1,user2),
ADD UNIQUE KEY user2_user1 (user2,user1); ADD UNIQUE KEY user2_user1 (user2,user1);
▲ Show 20 Lines • Show All 87 Lines • Show Last 20 Lines
View Options

services/commtest/src/backup/pull_backup.rs

Show First 20 Lines • Show All 130 Lines • ▼ Show 20 Lines SQL`
CREATE TABLE sessions ( CREATE TABLE sessions (
id bigint(20) NOT NULL, id bigint(20) NOT NULL,
user bigint(20) NOT NULL, user bigint(20) NOT NULL,
cookie bigint(20) NOT NULL, cookie bigint(20) NOT NULL,
query json NOT NULL, query json NOT NULL,
creation_time bigint(20) NOT NULL, creation_time bigint(20) NOT NULL,
last_update bigint(20) NOT NULL, last_update bigint(20) NOT NULL,
last_validated bigint(20) NOT NULL last_validated bigint(20) NOT NULL,
public_key char(116) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1; ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE threads ( CREATE TABLE threads (
id bigint(20) NOT NULL, id bigint(20) NOT NULL,
type tinyint(3) NOT NULL, type tinyint(3) NOT NULL,
name varchar(191) COLLATE utf8mb4_bin DEFAULT NULL, name varchar(191) COLLATE utf8mb4_bin DEFAULT NULL,
description mediumtext COLLATE utf8mb4_bin, description mediumtext COLLATE utf8mb4_bin,
parent_thread_id bigint(20) DEFAULT NULL, parent_thread_id bigint(20) DEFAULT NULL,
Show All 30 Lines SQL`
secret varchar(255) NOT NULL, secret varchar(255) NOT NULL,
creation_time bigint(20) NOT NULL, creation_time bigint(20) NOT NULL,
extra json DEFAULT NULL extra json DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8; ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE users ( CREATE TABLE users (
id bigint(20) NOT NULL, id bigint(20) NOT NULL,
username varchar(${usernameMaxLength}) COLLATE utf8mb4_bin NOT NULL, username varchar(${usernameMaxLength}) COLLATE utf8mb4_bin NOT NULL,
hash char(60) COLLATE utf8mb4_bin DEFAULT NULL, hash char(60) COLLATE utf8mb4_bin NOT NULL,
avatar varchar(191) COLLATE utf8mb4_bin DEFAULT NULL, avatar varchar(191) COLLATE utf8mb4_bin DEFAULT NULL,
creation_time bigint(20) NOT NULL creation_time bigint(20) NOT NULL,
public_key char(116) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
CREATE TABLE relationships_undirected ( CREATE TABLE relationships_undirected (
user1 bigint(20) NOT NULL, user1 bigint(20) NOT NULL,
user2 bigint(20) NOT NULL, user2 bigint(20) NOT NULL,
status tinyint(1) UNSIGNED NOT NULL status tinyint(1) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1; ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
▲ Show 20 Lines • Show All 85 Lines • ▼ Show 20 Lines SQL`
ADD KEY entry (entry); ADD KEY entry (entry);
ALTER TABLE roles ALTER TABLE roles
ADD PRIMARY KEY (id), ADD PRIMARY KEY (id),
ADD KEY thread (thread); ADD KEY thread (thread);
ALTER TABLE sessions ALTER TABLE sessions
ADD PRIMARY KEY (id), ADD PRIMARY KEY (id),
ADD KEY user (user); ADD KEY user (user),
ADD UNIQUE INDEX public_key (public_key);
ALTER TABLE threads ALTER TABLE threads
ADD PRIMARY KEY (id), ADD PRIMARY KEY (id),
ADD INDEX parent_thread_id (parent_thread_id), ADD INDEX parent_thread_id (parent_thread_id),
ADD INDEX containing_thread_id (containing_thread_id), ADD INDEX containing_thread_id (containing_thread_id),
ADD INDEX community (community); ADD INDEX community (community);
ALTER TABLE updates ALTER TABLE updates
ADD PRIMARY KEY (id), ADD PRIMARY KEY (id),
ADD INDEX user_time (user,time), ADD INDEX user_time (user,time),
ADD INDEX target_time (target, time), ADD INDEX target_time (target, time),
ADD INDEX user_key_target_type_time (user, \`key\`, target, type, time), ADD INDEX user_key_target_type_time (user, \`key\`, target, type, time),
ADD INDEX user_key_type_time (user, \`key\`, type, time), ADD INDEX user_key_type_time (user, \`key\`, type, time),
ADD INDEX user_key_time (user, \`key\`, time); ADD INDEX user_key_time (user, \`key\`, time);
ALTER TABLE uploads ALTER TABLE uploads
ADD PRIMARY KEY (id), ADD PRIMARY KEY (id),
ADD INDEX container (container); ADD INDEX container (container);
ALTER TABLE users ALTER TABLE users
ADD PRIMARY KEY (id), ADD PRIMARY KEY (id),
ADD UNIQUE KEY username (username); ADD UNIQUE KEY username (username),
ADD UNIQUE INDEX public_key (public_key);
ALTER TABLE relationships_undirected ALTER TABLE relationships_undirected
ADD UNIQUE KEY user1_user2 (user1,user2), ADD UNIQUE KEY user1_user2 (user1,user2),
ADD UNIQUE KEY user2_user1 (user2,user1); ADD UNIQUE KEY user2_user1 (user2,user1);
ALTER TABLE relationships_directed ALTER TABLE relationships_directed
ADD UNIQUE KEY user1_user2 (user1,user2), ADD UNIQUE KEY user1_user2 (user1,user2),
ADD UNIQUE KEY user2_user1 (user2,user1); ADD UNIQUE KEY user2_user1 (user2,user1);
▲ Show 20 Lines • Show All 87 Lines • Show Last 20 Lines
View Options

services/commtest/src/backup/send_log.rs

Loading...
View Options

services/commtest/src/lib.rs

Loading...
View Options

services/commtest/tests/backup_integration_test.rs

Loading...
View Options

services/commtest/tests/backup_performance_test.rs

Loading...