changelog | [dreamwidth/dreamwidth] 166efb: [#3029] allow listing of multiple accounts for a s...

Branch: refs/heads/main Home: https://github.com/dreamwidth/dreamwidth Commit: 166efb8bb203f420e5190152df53500ba21da6fa https://github.com/dreamwidth/dreamwidth/commit/166efb8bb203f420e5190152df53500ba21da6fa Author: Jen kareila@dreamwidth.org Date: 2023-09-30 (Sat, 30 Sep 2023)

Changed paths: M bin/dumpsql.pl M bin/upgrading/base-data.sql M bin/upgrading/en.dat M bin/upgrading/proplists.dat M bin/upgrading/update-db-general.pl A cgi-bin/DW/External/ProfileServices.pm M cgi-bin/DW/Logic/ProfilePage.pm M cgi-bin/LJ/DB.pm M doc/raw/memcache-keys.txt M htdocs/manage/profile/index.bml M htdocs/manage/profile/index.bml.text M views/profile/main.tt.text

Log Message:

[#3029] allow listing of multiple accounts for a service on user's profile (#3180)

update bin/dumpsql.pl

The schematables database table was dropped in b3bf367e8d, so the section of the dumpsql.pl script that used to regenerate the base-data.sql file doesn't do anything any more.

new global table profile_services

maps new database list of profile services to legacy userprops and incorporates additional data from the external_services function in DW/Logic/ProfilePage.pm and from /manage/profile

update DW/Logic/ProfilePage.pm to use data from profile_services table
move data list into new module DW::External::ProfileServices
Do I remember how to create a clustered table? Let's find out.
new user method load_profile_accts
new user method save_profile_accts
allow adding more than one of the same type of site
move text_trim up in the stack, use it for safer string truncation
use confess if there are database errors
bypass memcache when preparing to save
rewrite the entire database layer nbd