Page MenuHomePhabricator
Differential D8565

[web] remove `sql.js` dependency
ClosedPublic
Actions

Authored by kamil on Jul 19 2023, 7:55 AM.
Tags
None
Referenced Files
Unknown Object (File)
Sun, Mar 23, 6:50 AM
Unknown Object (File)
Sat, Mar 15, 6:10 PM
Unknown Object (File)
Thu, Mar 13, 6:35 PM
Unknown Object (File)
Thu, Mar 13, 6:35 PM
Unknown Object (File)
Thu, Mar 13, 6:34 PM
Unknown Object (File)
Thu, Mar 13, 6:31 PM
Unknown Object (File)
Tue, Mar 11, 9:34 AM
Unknown Object (File)
Tue, Mar 11, 12:28 AM
View All Files
Subscribers
ashoat

Details

Reviewers
michal
tomek
Commits
rCOMM9cd81259b02d: [web] remove `sql.js` dependency
Summary

Now we are using .wasm database module with logic from native

Depends on D8563

Test Plan

Flow

Diff Detail

Repository
rCOMM Comm
Branch
wasm-publish
Lint
No Lint Coverage
Unit
No Test Coverage

Revision Contents
Changeset List

PathSize
web/
flow-typed/
npm/
1 line
5 lines

Diff 28841

View Options

web/flow-typed/npm/sql.js_vx.x.x.js

Show First 20 Lines • Show All 591 Lines • ▼ Show 20 Lines [
48, 48,
async () => { async () => {
const visibleExtractString = `$.${threadPermissions.VISIBLE}.value`; const visibleExtractString = `$.${threadPermissions.VISIBLE}.value`;
const query = SQL` const query = SQL`
UPDATE memberships mm UPDATE memberships mm
LEFT JOIN ( LEFT JOIN (
SELECT m.thread, MAX(m.id) AS message FROM messages m SELECT m.thread, MAX(m.id) AS message FROM messages m
WHERE m.type != ${messageTypes.CREATE_SUB_THREAD} WHERE m.type != ${messageTypes.CREATE_SUB_THREAD}
AND m.thread = ${genesis.id} AND m.thread = ${genesis().id}
GROUP BY m.thread GROUP BY m.thread
) all_users_query ON mm.thread = all_users_query.thread ) all_users_query ON mm.thread = all_users_query.thread
LEFT JOIN ( LEFT JOIN (
SELECT m.thread, stm.user, MAX(m.id) AS message FROM messages m SELECT m.thread, stm.user, MAX(m.id) AS message FROM messages m
LEFT JOIN memberships stm ON m.type = ${messageTypes.CREATE_SUB_THREAD} LEFT JOIN memberships stm ON m.type = ${
messageTypes.CREATE_SUB_THREAD
}
tomekUnsubmitted
Not Done
Inline Actions

Why was the formatting changed?

tomek: Why was the formatting changed?
inkaAuthorUnsubmitted
Done
Inline Actions

This code was over 80 characters

inka: This code was over 80 characters
AND stm.thread = m.content AND stm.thread = m.content
WHERE JSON_EXTRACT(stm.permissions, ${visibleExtractString}) IS TRUE WHERE JSON_EXTRACT(stm.permissions, ${visibleExtractString}) IS TRUE
AND m.thread = ${genesis.id} AND m.thread = ${genesis().id}
GROUP BY m.thread, stm.user GROUP BY m.thread, stm.user
) last_subthread_message_for_user_query ) last_subthread_message_for_user_query
ON mm.thread = last_subthread_message_for_user_query.thread ON mm.thread = last_subthread_message_for_user_query.thread
AND mm.user = last_subthread_message_for_user_query.user AND mm.user = last_subthread_message_for_user_query.user
SET SET
mm.last_message = GREATEST(COALESCE(all_users_query.message, 0), mm.last_message = GREATEST(COALESCE(all_users_query.message, 0),
COALESCE(last_subthread_message_for_user_query.message, 0)) COALESCE(last_subthread_message_for_user_query.message, 0))
WHERE mm.thread = ${genesis.id}; WHERE mm.thread = ${genesis().id};
`; `;
await dbQuery(query); await dbQuery(query);
}, },
], ],
[ [
49, 49,
async () => { async () => {
if (isDockerEnvironment()) { if (isDockerEnvironment()) {
▲ Show 20 Lines • Show All 234 Lines • Show Last 20 Lines
View Options

web/package.json

Show First 20 Lines • Show All 591 Lines • ▼ Show 20 Lines [
48, 48,
async () => { async () => {
const visibleExtractString = `$.${threadPermissions.VISIBLE}.value`; const visibleExtractString = `$.${threadPermissions.VISIBLE}.value`;
const query = SQL` const query = SQL`
UPDATE memberships mm UPDATE memberships mm
LEFT JOIN ( LEFT JOIN (
SELECT m.thread, MAX(m.id) AS message FROM messages m SELECT m.thread, MAX(m.id) AS message FROM messages m
WHERE m.type != ${messageTypes.CREATE_SUB_THREAD} WHERE m.type != ${messageTypes.CREATE_SUB_THREAD}
AND m.thread = ${genesis.id} AND m.thread = ${genesis().id}
GROUP BY m.thread GROUP BY m.thread
) all_users_query ON mm.thread = all_users_query.thread ) all_users_query ON mm.thread = all_users_query.thread
LEFT JOIN ( LEFT JOIN (
SELECT m.thread, stm.user, MAX(m.id) AS message FROM messages m SELECT m.thread, stm.user, MAX(m.id) AS message FROM messages m
LEFT JOIN memberships stm ON m.type = ${messageTypes.CREATE_SUB_THREAD} LEFT JOIN memberships stm ON m.type = ${
messageTypes.CREATE_SUB_THREAD
}
tomekUnsubmitted
Not Done
Inline Actions

Why was the formatting changed?

tomek: Why was the formatting changed?
inkaAuthorUnsubmitted
Done
Inline Actions

This code was over 80 characters

inka: This code was over 80 characters
AND stm.thread = m.content AND stm.thread = m.content
WHERE JSON_EXTRACT(stm.permissions, ${visibleExtractString}) IS TRUE WHERE JSON_EXTRACT(stm.permissions, ${visibleExtractString}) IS TRUE
AND m.thread = ${genesis.id} AND m.thread = ${genesis().id}
GROUP BY m.thread, stm.user GROUP BY m.thread, stm.user
) last_subthread_message_for_user_query ) last_subthread_message_for_user_query
ON mm.thread = last_subthread_message_for_user_query.thread ON mm.thread = last_subthread_message_for_user_query.thread
AND mm.user = last_subthread_message_for_user_query.user AND mm.user = last_subthread_message_for_user_query.user
SET SET
mm.last_message = GREATEST(COALESCE(all_users_query.message, 0), mm.last_message = GREATEST(COALESCE(all_users_query.message, 0),
COALESCE(last_subthread_message_for_user_query.message, 0)) COALESCE(last_subthread_message_for_user_query.message, 0))
WHERE mm.thread = ${genesis.id}; WHERE mm.thread = ${genesis().id};
`; `;
await dbQuery(query); await dbQuery(query);
}, },
], ],
[ [
49, 49,
async () => { async () => {
if (isDockerEnvironment()) { if (isDockerEnvironment()) {
▲ Show 20 Lines • Show All 234 Lines • Show Last 20 Lines
View Options

yarn.lock

Show First 20 Lines • Show All 591 Lines • ▼ Show 20 Lines [
48, 48,
async () => { async () => {
const visibleExtractString = `$.${threadPermissions.VISIBLE}.value`; const visibleExtractString = `$.${threadPermissions.VISIBLE}.value`;
const query = SQL` const query = SQL`
UPDATE memberships mm UPDATE memberships mm
LEFT JOIN ( LEFT JOIN (
SELECT m.thread, MAX(m.id) AS message FROM messages m SELECT m.thread, MAX(m.id) AS message FROM messages m
WHERE m.type != ${messageTypes.CREATE_SUB_THREAD} WHERE m.type != ${messageTypes.CREATE_SUB_THREAD}
AND m.thread = ${genesis.id} AND m.thread = ${genesis().id}
GROUP BY m.thread GROUP BY m.thread
) all_users_query ON mm.thread = all_users_query.thread ) all_users_query ON mm.thread = all_users_query.thread
LEFT JOIN ( LEFT JOIN (
SELECT m.thread, stm.user, MAX(m.id) AS message FROM messages m SELECT m.thread, stm.user, MAX(m.id) AS message FROM messages m
LEFT JOIN memberships stm ON m.type = ${messageTypes.CREATE_SUB_THREAD} LEFT JOIN memberships stm ON m.type = ${
messageTypes.CREATE_SUB_THREAD
}
tomekUnsubmitted
Not Done
Inline Actions

Why was the formatting changed?

tomek: Why was the formatting changed?
inkaAuthorUnsubmitted
Done
Inline Actions

This code was over 80 characters

inka: This code was over 80 characters
AND stm.thread = m.content AND stm.thread = m.content
WHERE JSON_EXTRACT(stm.permissions, ${visibleExtractString}) IS TRUE WHERE JSON_EXTRACT(stm.permissions, ${visibleExtractString}) IS TRUE
AND m.thread = ${genesis.id} AND m.thread = ${genesis().id}
GROUP BY m.thread, stm.user GROUP BY m.thread, stm.user
) last_subthread_message_for_user_query ) last_subthread_message_for_user_query
ON mm.thread = last_subthread_message_for_user_query.thread ON mm.thread = last_subthread_message_for_user_query.thread
AND mm.user = last_subthread_message_for_user_query.user AND mm.user = last_subthread_message_for_user_query.user
SET SET
mm.last_message = GREATEST(COALESCE(all_users_query.message, 0), mm.last_message = GREATEST(COALESCE(all_users_query.message, 0),
COALESCE(last_subthread_message_for_user_query.message, 0)) COALESCE(last_subthread_message_for_user_query.message, 0))
WHERE mm.thread = ${genesis.id}; WHERE mm.thread = ${genesis().id};
`; `;
await dbQuery(query); await dbQuery(query);
}, },
], ],
[ [
49, 49,
async () => { async () => {
if (isDockerEnvironment()) { if (isDockerEnvironment()) {
▲ Show 20 Lines • Show All 234 Lines • Show Last 20 Lines