o í·Çi—ã@s–UdZddlmZmZddlmZddlZdZe e d<dZee dfe d<dZee ee dfe d <dZ ee ee dfe d <ddd „Zddd„ZdS)z}deduplicate model_providers by name Revision ID: b3c4d5e6f7a8 Revises: f6e5d4c3b2a1 Create Date: 2026-03-28 18:30:00+08:00 é)ÚSequenceÚUnion)ÚopNÚb3c4d5e6f7a8ÚrevisionÚf6e5d4c3b2a1Ú down_revisionÚ branch_labelsÚ depends_onÚreturncs|t ¡}| t d¡¡}| ¡}|D])}|\}‰}‡fdd„|Dƒ}|r;| t d¡ˆ|dœ¡| t d¡d|i¡qdS)Nz© SELECT name, MIN(id) as keep_id, ARRAY_AGG(id ORDER BY id) as all_ids FROM public.model_providers GROUP BY name HAVING COUNT(*) > 1 csg|]}|ˆkr|‘qS©r)Ú.0Úid©Úkeep_idrú2alembic/versions/20260328_1830_dedupe_providers.pyÚ #szupgrade..z¢ UPDATE public.models SET provider_id = :keep_id WHERE provider_id = ANY(:remove_ids) )rÚ remove_idszx DELETE FROM public.model_providers WHERE id = ANY(:remove_ids) r)rÚget_bindÚexecuteÚsaÚtextÚfetchall)ÚconnÚresultÚ duplicatesÚrowÚnameÚall_idsrrrrÚupgrades" ú û€ðrcCsdS)NrrrrrÚ downgrade:sr )rN)Ú__doc__ÚtypingrrÚalembicrÚ sqlalchemyrrÚstrÚ__annotations__rr r rr rrrrÚs &