parsav  Diff

Differences From Artifact [b916bb0a63]:

• File backend/schema/pgsql-views.sql — part of check-in [3f080eded4] at 2021-01-25 13:24:48 on branch trunk — finish up LP support for user outbox views (user: lexi, size: 6642) [annotate] [blame] [check-ins using]

To Artifact [a4ebd0c2e8]:

• File backend/schema/pgsql-views.sql — part of check-in [c774e2c5a9] at 2021-01-28 00:51:21 on branch trunk — wrote mimelib, continued iterating on litepub support; tweets can now be imported into honk (user: lexi, size: 6671) [annotate] [blame] [check-ins using]

   106    106   	body		text,
   107    107   	posted		bigint,
   108    108   	discovered	bigint,
   109    109   	edited		bigint,
   110    110   	parent		bigint,
   111    111   	convoheaduri text,
   112    112   	chgcount	integer,
          113  +	uri         text,
   113    114   -- ephemeral
   114    115   	accent		smallint,
   115    116   	rtdby		bigint, -- note that these must be 0 if the record
   116    117   	rtdat		bigint, -- in question does not represent an RT!
   117    118   	rtid		bigint, -- (this one too)
   118    119   	n_likes		integer,
   119    120   	n_rts		integer,
................................................................................
   124    125   pg_temp.parsavpg_translate_post(parsav_posts,bigint,bigint,bigint)
   125    126   returns pg_temp.parsavpg_intern_post as $$
   126    127   	select a.origin is null,
   127    128   		($1).id,     ($1).author,
   128    129   		($1).subject,($1).acl,         ($1).body,
   129    130   		($1).posted, ($1).discovered,  ($1).edited,
   130    131   		($1).parent, ($1).convoheaduri,($1).chgcount,
   131         -		coalesce(c.value, -1)::smallint,
          132  +		($1).uri, coalesce(c.value, -1)::smallint,
   132    133   		$2 as rtdby, $3 as rtdat, $4 as rtid,
   133    134   		re.likes, re.rts,
   134    135   		($1).parent in (select id from parsav_posts)
   135    136   	from parsav_actors as a 
   136    137   		left join parsav_actor_conf_ints as c
   137    138   		          on c.key = 'ui-accent' and
   138    139   		             c.uid = a.id