Changeset View
Changeset View
Standalone View
Standalone View
keyserver/src/fetchers/message-fetchers.js
| Show First 20 Lines • Show All 913 Lines • ▼ Show 20 Lines | async function searchMessagesInSingleChat( | ||||
| cursor?: string, | cursor?: string, | ||||
| ): Promise<SearchMessagesResponse> { | ): Promise<SearchMessagesResponse> { | ||||
| if (inputQuery === '') { | if (inputQuery === '') { | ||||
| console.warn('received empty search query'); | console.warn('received empty search query'); | ||||
| return { messages: [], endReached: true }; | return { messages: [], endReached: true }; | ||||
| } | } | ||||
| const pattern = processQueryForSearch(inputQuery); | const pattern = processQueryForSearch(inputQuery); | ||||
| if (pattern === '') { | |||||
| return { | |||||
| endReached: true, | |||||
| messages: [], | |||||
| }; | |||||
| } | |||||
| const query = SQL` | const query = SQL` | ||||
| SELECT m.id, m.thread AS threadID, m.content, m.time, m.type, m.creation, | SELECT m.id, m.thread AS threadID, m.content, m.time, m.type, m.creation, | ||||
| m.user AS creatorID, m.target_message as targetMessageID, | m.user AS creatorID, m.target_message as targetMessageID, | ||||
| stm.permissions AS subthread_permissions, up.id AS uploadID, | stm.permissions AS subthread_permissions, up.id AS uploadID, | ||||
| up.type AS uploadType, up.secret AS uploadSecret, up.extra AS uploadExtra | up.type AS uploadType, up.secret AS uploadSecret, up.extra AS uploadExtra | ||||
| FROM message_search s | FROM message_search s | ||||
| LEFT JOIN messages m ON m.id = s.original_message_id | LEFT JOIN messages m ON m.id = s.original_message_id | ||||
| LEFT JOIN memberships stm ON m.type = ${messageTypes.CREATE_SUB_THREAD} | LEFT JOIN memberships stm ON m.type = ${messageTypes.CREATE_SUB_THREAD} | ||||
| ▲ Show 20 Lines • Show All 54 Lines • Show Last 20 Lines | |||||