need a table dump for thimble's publishd URLs

RESOLVED FIXED

Status

Infrastructure & Operations
WebOps: Other
RESOLVED FIXED
6 years ago
5 years ago

People

(Reporter: pomax, Assigned: cturra)

Tracking

Details

Attachments

(1 attachment)

(Reporter)

Description

6 years ago
For reporting/vetting purposes, we would like a mysqldump for Thimble's table of published URLs on the production server.

This should be the table "api_page" for the playdoh_app database associated with Thimble.

(If too big, an export for a subtable select on just the columns (id, original_url, short_url_id) would still be useful)
(Assignee)

Updated

6 years ago
Assignee: server-ops → cturra
(Assignee)

Comment 1

6 years ago
attached you will find a copy of the id, original_url and short_url_id columns of the api_page table from thimble. as discussed on irc, there is a number of original_url[s] that are returned blank.

  mysql> select count(id) from api_page\G
  *************************** 1. row ***************************
  count(id): 19529
  1 row in set (0.01 sec)


  mysql> select count(id) from api_page where original_url<>""\G
  *************************** 1. row ***************************
  count(id): 16718
  1 row in set (0.01 sec)
Status: NEW → RESOLVED
Last Resolved: 6 years ago
Resolution: --- → FIXED
(Assignee)

Comment 2

6 years ago
Created attachment 637174 [details]
thimble api_page columns
Component: Server Operations: Web Operations → WebOps: Other
Product: mozilla.org → Infrastructure & Operations
You need to log in before you can comment on or make changes to this bug.