parsav  Diff

Differences From Artifact [dc07991d31]:

• File backend/pgsql.t — part of check-in [03ea3dffe7] at 2021-01-14 01:11:51 on branch trunk — more work on UI and circles (user: lexi, size: 62728) [annotate] [blame] [check-ins using]

To Artifact [4517a951a0]:

• File backend/pgsql.t — part of check-in [c43a1b6e9d] at 2021-01-14 17:37:19 on branch trunk — circle management complete (user: lexi, size: 63418) [annotate] [blame] [check-ins using]

   329    329   	circle_members_fetch_name = {
   330    330   		params = {uint64, pstring}, sql = [[
   331    331   			select unnest(members) from parsav_circles where
   332    332   				($1::bigint = 0 or owner = $1::bigint) and
   333    333   				name = $2::text
   334    334   		]];
   335    335   	};
          336  +
          337  +	circle_members_add_uid = {
          338  +		params = {uint64, uint64}, cmd = true, sql = [[
          339  +			update parsav_circles set
          340  +				members = members || $2::bigint
          341  +			where id = $1::bigint
          342  +		]];
          343  +	};
          344  +
          345  +	circle_members_del_uid = {
          346  +		params = {uint64, uint64}, cmd = true, sql = [[
          347  +			update parsav_circles set
          348  +				members = array_remove(members, $2::bigint)
          349  +			where id = $1::bigint
          350  +		]];
          351  +	};
   336    352   
   337    353   	auth_sigtime_user_fetch = {
   338    354   		params = {uint64}, sql = [[
   339    355   			select authtime::bigint
   340    356   			from parsav_actors where id = $1::bigint
   341    357   		]];
   342    358   	};
................................................................................
  2202   2218   
  2203   2219   		var rt = pool:alloc(uint64, res.sz)
  2204   2220   		for i = 0, res.sz do rt(i) = res:int(uint64,i,0) end
  2205   2221   
  2206   2222   		return rt
  2207   2223   	end];
  2208   2224   
         2225  +	circle_members_add_uid = [terra(
         2226  +		src: &lib.store.source, owner: uint64, subject: uint64
         2227  +	): {} queries.circle_members_add_uid.exec(src,owner,subject) end];
         2228  +
         2229  +	circle_members_del_uid = [terra(
         2230  +		src: &lib.store.source, owner: uint64, subject: uint64
         2231  +	): {} queries.circle_members_del_uid.exec(src,owner,subject) end];
         2232  +
  2209   2233   	actor_auth_register_uid = nil; -- TODO better support non-view based auth
  2210   2234   }
  2211   2235   
  2212   2236   return b