diff options
| author | MeiMei <30769358+mei23@users.noreply.github.com> | 2021-05-30 13:48:23 +0900 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-05-30 13:48:23 +0900 |
| commit | 0263539202d16eb6a03484e0ead6d184be90de89 (patch) | |
| tree | a6f4a969d3eb9666ec8d966802d6ee0db42f3846 /src/models | |
| parent | refactor (diff) | |
| download | sharkey-0263539202d16eb6a03484e0ead6d184be90de89.tar.gz sharkey-0263539202d16eb6a03484e0ead6d184be90de89.tar.bz2 sharkey-0263539202d16eb6a03484e0ead6d184be90de89.zip | |
Fix remote drive expire (#7543)
Diffstat (limited to 'src/models')
| -rw-r--r-- | src/models/repositories/drive-file.ts | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/src/models/repositories/drive-file.ts b/src/models/repositories/drive-file.ts index 590079fe4a..92bf12a4e0 100644 --- a/src/models/repositories/drive-file.ts +++ b/src/models/repositories/drive-file.ts @@ -59,6 +59,7 @@ export class DriveFileRepository extends Repository<DriveFile> { const { sum } = await this .createQueryBuilder('file') .where('file.userId = :id', { id: id }) + .andWhere('file.isLink = FALSE') .select('SUM(file.size)', 'sum') .getRawOne(); @@ -69,6 +70,7 @@ export class DriveFileRepository extends Repository<DriveFile> { const { sum } = await this .createQueryBuilder('file') .where('file.userHost = :host', { host: toPuny(host) }) + .andWhere('file.isLink = FALSE') .select('SUM(file.size)', 'sum') .getRawOne(); @@ -79,6 +81,7 @@ export class DriveFileRepository extends Repository<DriveFile> { const { sum } = await this .createQueryBuilder('file') .where('file.userHost IS NULL') + .andWhere('file.isLink = FALSE') .select('SUM(file.size)', 'sum') .getRawOne(); @@ -89,6 +92,7 @@ export class DriveFileRepository extends Repository<DriveFile> { const { sum } = await this .createQueryBuilder('file') .where('file.userHost IS NOT NULL') + .andWhere('file.isLink = FALSE') .select('SUM(file.size)', 'sum') .getRawOne(); |