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

[github]

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