Sync-in · Sovereign platform for file storage, sharing, synchronization, and collaboration.
TypeScript cloud-alternativecollaborationcollaborative-editingdropboxfile-serverfile-sharingfile-storagefile-syncfull-text-searchhomelabnextcloudon-premiseopen-sourceprivacy-firstprivate-cloudrealtimesecureself-hostedstorage-serverwebdav
import { NestFastifyApplication } from '@nestjs/platform-fastify'
import { TestingModule } from '@nestjs/testing'
import { Column, eq, inArray, isNull, SQL, sql, SQLWrapper } from 'drizzle-orm'
import { MySqlDatabase, MySqlTableWithColumns } from 'drizzle-orm/mysql-core'
import { MySqlQueryResult } from 'drizzle-orm/mysql2'
import { DB_TOKEN_PROVIDER } from './constants.js'
import * as schema from './schema.js'
async function dbGetConnection(app: NestFastifyApplication | TestingModule, mode: 'pool' | 'client' = 'pool') {
const db: MySqlDatabase<any, any> = await app.resolve(DB_TOKEN_PROVIDER)
let connection: any = (db as any)['session'].client
if (mode === 'pool') {
connection = connection.pool
}
return { db, connection }
}
export async function dbCloseConnection(app: NestFastifyApplication | TestingModule, mode: 'pool' | 'client' = 'pool') {
const connection = (await dbGetConnection(app, mode)).connection
await connection.end()
}
export async function dbCheckConnection(app: NestFastifyApplication | TestingModule, mode: 'pool' | 'client' = 'pool') {
const db = (await dbGetConnection(app, mode)).db
return Array.isArray(await db.execute(sql`select 1`))
}
export function dbCheckAffectedRows(queryResult: MySqlQueryResult, expected: number, throwError = true): boolean {
const affectedRows = queryResult.at(0).affectedRows
if (affectedRows !== expected) {
if (throwError) {
throw new Error(`The number of rows affected does not match : ${affectedRows}`)
}
return false
}
return true
}
export function dbGetInsertedId(queryResult: MySqlQueryResult): number {
const insertedId = queryResult.at(0).insertId
if (!insertedId) {
throw new Error(`Record was not inserted : ${insertedId}`)
}
return insertedId
}
export function convertToSelect<T, K extends keyof T>(table: T, fields: readonly K[]): Pick<T, K> {
const select = {} as Pick<T, K>
for (const f of fields) {
select[f] = table[f]
}
return select
}
export function convertToWhere<T>(table: T, filters: Partial<Record<keyof T, any>>): SQL[] {
// only handles AND operator
return (Object.entries(filters) as [keyof T, unknown][]).map(([k, v]) => {
if (v === null) return isNull((table as any)[k])
if (Array.isArray(v)) return inArray((table as any)[k], v)
return eq((table as any)[k], v)
})
}
export const dateTimeUTC = (dateField: Column): SQL<string> => sql`CONCAT(${sql`${dateField}`}, 'Z')`
export function dbParseJson(value: unknown): any {
return typeof value === 'string' ? JSON.parse(value) : value
}
export function concatDistinctObjectsInArray(mustBeNotNull: SQLWrapper, object: Record<string, SQLWrapper | Record<string, SQLWrapper>>): SQL<any> {
/* Concat json objects in array (only one nesting level is supported) */
const expr: SQL<any> = sql`IFNULL(CONCAT('[', GROUP_CONCAT(DISTINCT IF(${mustBeNotNull} IS NULL, NULL, JSON_OBJECT(`
const keys = Object.keys(object)
keys.forEach((k, index) => {
if ((object[k] as SQLWrapper).constructor.name === 'Object') {
expr.append(sql`${k},JSON_OBJECT(`)
const subKeys = Object.keys(object[k] as Record<string, SQLWrapper>)
subKeys.forEach((subK, subIndex) => {
expr.append(sql`${subK},${sql`${(object[k] as Record<string, SQLWrapper>)[subK]}`}${subIndex === subKeys.length - 1 ? sql`)` : sql`,`}`)
})
} else {
expr.append(sql`${k},${sql`${object[k]}`}`)
}
if (index !== keys.length - 1) {
expr.append(sql`,`)
}
})
expr.append(sql`))), ']'), JSON_ARRAY())`)
expr.mapWith(dbParseJson)
return expr
}
export function getTablesWithFileIdColumn(): MySqlTableWithColumns<any>[] {
return Object.entries(schema)
.filter(([_table, columns]) => 'fileId' in columns)
.map(([_table, columns]) => columns as MySqlTableWithColumns<any>)
}