+
+function searchAttribute (sourceField?: string, targetField?: string) {
+ if (!sourceField) return {}
+
+ return {
+ [targetField]: {
+ [Op.iLike]: `%${sourceField}%`
+ }
+ }
+}
+
+// ---------------------------------------------------------------------------
+
+export {
+ buildBlockedAccountSQL,
+ buildBlockedAccountSQLOptimized,
+ buildLocalActorIdsIn,
+ getPlaylistSort,
+ SortType,
+ buildLocalAccountIdsIn,
+ getSort,
+ getCommentSort,
+ getVideoSort,
+ getBlacklistSort,
+ createSimilarityAttribute,
+ throwIfNotValid,
+ buildServerIdsFollowedBy,
+ buildTrigramSearchIndex,
+ buildWhereIdOrUUID,
+ isOutdated,
+ parseAggregateResult,
+ getFollowsSort,
+ buildDirectionAndField,
+ createSafeIn,
+ searchAttribute
+}
+
+// ---------------------------------------------------------------------------
+
+function searchTrigramNormalizeValue (value: string) {
+ return Sequelize.fn('lower', Sequelize.fn('immutable_unaccent', value))
+}
+
+function searchTrigramNormalizeCol (col: string) {
+ return Sequelize.fn('lower', Sequelize.fn('immutable_unaccent', Sequelize.col(col)))
+}