mirror of
https://github.com/immich-app/immich.git
synced 2025-07-07 10:14:08 -04:00
7855974a29
* add full image provider and refactor thumb providers * photo_view updates * wip: asset-viewer * fix controller dispose on page change * wip: bottom sheet * fix interactions * more bottomsheet changes * generate schema * PR feedback * refactor asset viewer * never rotate and fix background on page change * use photoview as the loading builder * precache after delay * claude: optimizing rebuild of image provider * claude: optimizing image decoding and caching * use proper cache for new full size image providers * chore: load local HEIC fullsize for iOS * make controller callbacks nullable * remove imageprovider cache * do not handle drag gestures when zoomed * use loadOriginal setting for HEIC / larger images * preload assets outside timer * never use same controllers in photo-view gallery * fix: cannot scroll down once swipe with bottom sheet --------- Co-authored-by: shenlong-tanwen <139912620+shalong-tanwen@users.noreply.github.com> Co-authored-by: Alex <alex.tran1502@gmail.com>
82 lines
1.6 KiB
Plaintext
82 lines
1.6 KiB
Plaintext
import 'remote_asset.entity.dart';
|
|
import 'local_asset.entity.dart';
|
|
|
|
mergedAsset: SELECT * FROM
|
|
(
|
|
SELECT
|
|
rae.id as remote_id,
|
|
lae.id as local_id,
|
|
rae.name,
|
|
rae."type",
|
|
rae.created_at,
|
|
rae.updated_at,
|
|
rae.width,
|
|
rae.height,
|
|
rae.duration_in_seconds,
|
|
rae.is_favorite,
|
|
rae.thumb_hash,
|
|
rae.checksum,
|
|
rae.owner_id
|
|
FROM
|
|
remote_asset_entity rae
|
|
LEFT JOIN
|
|
local_asset_entity lae ON rae.checksum = lae.checksum
|
|
WHERE
|
|
rae.deleted_at IS NULL AND rae.visibility = 0 AND rae.owner_id in ?
|
|
UNION ALL
|
|
SELECT
|
|
NULL as remote_id,
|
|
lae.id as local_id,
|
|
lae.name,
|
|
lae."type",
|
|
lae.created_at,
|
|
lae.updated_at,
|
|
lae.width,
|
|
lae.height,
|
|
lae.duration_in_seconds,
|
|
lae.is_favorite,
|
|
NULL as thumb_hash,
|
|
lae.checksum,
|
|
NULL as owner_id
|
|
FROM
|
|
local_asset_entity lae
|
|
LEFT JOIN
|
|
remote_asset_entity rae ON rae.checksum = lae.checksum
|
|
WHERE
|
|
rae.id IS NULL
|
|
)
|
|
ORDER BY created_at DESC
|
|
LIMIT $limit;
|
|
|
|
mergedBucket(:group_by AS INTEGER):
|
|
SELECT
|
|
COUNT(*) as asset_count,
|
|
CASE
|
|
WHEN :group_by = 0 THEN STRFTIME('%Y-%m-%d', created_at, 'localtime') -- day
|
|
WHEN :group_by = 1 THEN STRFTIME('%Y-%m', created_at, 'localtime') -- month
|
|
END AS bucket_date
|
|
FROM
|
|
(
|
|
SELECT
|
|
rae.name,
|
|
rae.created_at
|
|
FROM
|
|
remote_asset_entity rae
|
|
LEFT JOIN
|
|
local_asset_entity lae ON rae.checksum = lae.checksum
|
|
WHERE
|
|
rae.deleted_at IS NULL AND rae.visibility = 0 AND rae.owner_id in ?
|
|
UNION ALL
|
|
SELECT
|
|
lae.name,
|
|
lae.created_at
|
|
FROM
|
|
local_asset_entity lae
|
|
LEFT JOIN
|
|
remote_asset_entity rae ON rae.checksum = lae.checksum
|
|
WHERE
|
|
rae.id IS NULL
|
|
)
|
|
GROUP BY bucket_date
|
|
ORDER BY bucket_date DESC;
|