Received: from mail.netlandish.com (mail.netlandish.com [174.136.98.166]) by code.netlandish.com (Postfix) with ESMTP id A58C193 for <~netlandish/links-dev@lists.code.netlandish.com>; Fri, 20 Jun 2025 15:17:51 +0000 (UTC) Received-SPF: Pass (mailfrom) identity=mailfrom; client-ip=209.85.214.169; helo=mail-pl1-f169.google.com; envelope-from=peter@netlandish.com; receiver= Authentication-Results: mail.netlandish.com; dkim=pass (1024-bit key; unprotected) header.d=netlandish.com header.i=@netlandish.com header.b=MirpAYwb Received: from mail-pl1-f169.google.com (mail-pl1-f169.google.com [209.85.214.169]) by mail.netlandish.com (Postfix) with ESMTP id AE5721D6434 for <~netlandish/links-dev@lists.code.netlandish.com>; Fri, 20 Jun 2025 15:18:23 +0000 (UTC) Received: by mail-pl1-f169.google.com with SMTP id d9443c01a7336-234f17910d8so18684435ad.3 for <~netlandish/links-dev@lists.code.netlandish.com>; Fri, 20 Jun 2025 08:18:23 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=netlandish.com; s=google; t=1750432702; x=1751037502; darn=lists.code.netlandish.com; h=content-transfer-encoding:mime-version:message-id:date:subject:cc :to:from:from:to:cc:subject:date:message-id:reply-to; bh=lkDwUyPDzxTrXS4Hz1l/Pck4G/gIK3vz2/FfIJ5ISkk=; b=MirpAYwbrmqW7r6xELDaL8YpiAJu4JUY2fvHkBh7oeE/OdsXFDOBoYQt6dAdjPVfGi 8sVm+kvAvQi2g6ASlMDwt0T00Mo9bWl6ED2ZkpnaqHoH0qeN5uo5DtHa470sBLZ+aYCa YnBRiaH7sPT6kJqFkeT3VcqbFjR/6n/9V1OQ0= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1750432702; x=1751037502; h=content-transfer-encoding:mime-version:message-id:date:subject:cc :to:from:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=lkDwUyPDzxTrXS4Hz1l/Pck4G/gIK3vz2/FfIJ5ISkk=; b=R/jIbYmeY2mDsNO1NAh9UlYSV70nhp7Th0hfOsFs9COkEEEkIq7jIpwsY90t4j/4HR JfYSwGwZtrM8nGUq/SMcxdy1JCVVhNoY4nwbIDm6Gq0pxgkduDBG8mQ6WJT5YHB3iHZh mdof6GPDBJC3QQ195aBoGfnPo8sUD5/g3Rp7u35/waR3W5rriV9b7U4oEF9XPCwCH9xV l8N2SsdUhdrGlhIuqlm8rSLrA77lDwEykEQcO+t/d7DiVgZJVOaRCMT0q3iTzppSu7+/ mkUndPjc820HY1FVhOW0hL0uwB0zfa/iy6/RLSV9N69LOmTsbXbYUdfotsyBPwpfU/m5 5PAQ== X-Gm-Message-State: AOJu0YyAlBs2yEWnlhVKyUlZQ4m+V8HQIEgVmGoQ3/8kXTqH0SGOoHgG GR3s5o+VzwOkO4aN9xr+b2edkwQXtw9t9gSN7Pmk8Xe7haRD7G+GC6en6YhmhlUnbPKUP04I/vJ XM/f9S0I= X-Gm-Gg: ASbGnctLJgRX8J92uSF/kUoOY4XscN5QVNZbLLTM6ULlI+N6KCZTzbx0gMwIZMbVt2q ylB6cmNsFJ079uMFLOSe9ABFpKlRzyDocdZ+ff7ClOqyr+GDwqMQgZZ2hfMRhcuVFOkPEvtNP5W m+D+xHpzSTCZ5SP1xv0d9t9z92wK1Kb8jIh0RNhVdjjpDvUb2CFWtk6Wl+JTsji8DpkfxVdKjZV aW9f2mqlyAeooX3reEgy8rUDIe1I8UbGHFQZAOzD2S0ic8JMSq5By2l1a4K7ZyUR17xuRDOKacT hfXI9gabFbixoZmk1040zkE0J4VJNuMgFbVRKrEHomMLU7uXlBHE8IosLxsE0Oi7 X-Google-Smtp-Source: AGHT+IEum7UFJIJKhgRx0EnJAnL5dx+eCTDPhvdGVfO+Z68jMpIOvajUNkeXZQIiGK7lhBqOqTIeJw== X-Received: by 2002:a17:902:d50d:b0:235:2403:779f with SMTP id d9443c01a7336-237d98f9c58mr58292965ad.29.1750432702378; Fri, 20 Jun 2025 08:18:22 -0700 (PDT) Received: from localhost ([2603:8000:97f0:46d0:b38c:aca2:4475:aa48]) by smtp.gmail.com with UTF8SMTPSA id d9443c01a7336-237d867ebe3sm20649285ad.180.2025.06.20.08.18.21 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 20 Jun 2025 08:18:21 -0700 (PDT) From: Peter Sanchez To: ~netlandish/links-dev@lists.code.netlandish.com Cc: Peter Sanchez Subject: [PATCH links] Fix issue when parsing base url metadata Date: Fri, 20 Jun 2025 09:18:17 -0600 Message-ID: <20250620151819.15841-1-peter@netlandish.com> X-Mailer: git-send-email 2.49.0 MIME-Version: 1.0 Content-Transfer-Encoding: 8bit --- models/base_url.go | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/models/base_url.go b/models/base_url.go index 5b1b484..5585804 100644 --- a/models/base_url.go +++ b/models/base_url.go @@ -161,14 +161,14 @@ func (b *BaseURL) Store(ctx context.Context) error { ON CONFLICT (url) DO UPDATE SET url = NULL WHERE FALSE - RETURNING id, url, public_ready, created_on + RETURNING id, url, public_ready, visibility, created_on ) - SELECT id, url, public_ready, created_on FROM ins + SELECT id, url, public_ready, visibility, created_on FROM ins UNION ALL - SELECT id, url, public_ready, created_on FROM base_urls + SELECT id, url, public_ready, visibility, created_on FROM base_urls WHERE url = $1 LIMIT 1;`, b.URL, b.Hash) - err := row.Scan(&b.ID, &b.URL, &b.PublicReady, &b.CreatedOn) + err := row.Scan(&b.ID, &b.URL, &b.PublicReady, &b.Visibility, &b.CreatedOn) if err != nil { return err } -- 2.49.0