View Issue Details

IDProjectCategoryView StatusLast Update
0000218My infrastructureGeneralpublic2025-01-25 17:28
Reporterdvl Assigned Todvl  
PrioritynormalSeverityminorReproducibilityhave not tried
Status assignedResolutionopen 
Summary0000218: Archive PGCon schedules generated by pgeu
DescriptionI don't want to continue maintaining the pgeu deployment.

* Generate a static schedule for 2021-2023
* Previous years are from Pentabarf and are already static
TagsNo tags attached.

Activities

dvl

2025-01-22 00:57

manager   ~0000355

Last edited: 2025-01-22 01:01

Need to add nginx redirects from

https://www.pgcon.org/events/pgcon_2023/schedule/session/514-placeholder-for-tutorial-session-please-read-details/
to
https://beta.pgcon.org/2023/schedule/session/514-placeholder-for-tutorial-session-please-read-details/

events/pgcon_2023 => 2023

and

https://www.pgcon.org/events/pgcon_2023/schedule/speaker/1-dan-langille/
https://beta.pgcon.org/2023/schedule/speaker/1-dan-langille/index.html

dvl

2025-01-22 00:59

manager   ~0000356

Last edited: 2025-01-25 14:41

sed -i '' 's|<li class="nav-item p-2">https://www.pgcon.org/|<li class="nav-item p-2">/|g' */index.html

sed -i '' 's|<li class="nav-item p-2">https://www.pgcon.org/events/||g' */index.html

sed -i '' 's|                 <li class="nav-item p-2">https://www.pgcon.org/account/||g' */index.html

dvl

2025-01-25 14:43

manager   ~0000357

Last edited: 2025-01-25 15:18

[14:35 beta dvl /usr/local/www/pgcon.org/2022/content/schedule] % sed -i '' 's|../../../media/css/pgeu.css|media/css/pgeu.css|' index.html
[14:39 beta dvl /usr/local/www/pgcon.org/2022/content/schedule/session] % sed -i '' 's|<li class="nav-item p-2">https://www.pgcon.org/|<li class="nav-item p-2">/|g' */index.html

[14:39 beta dvl /usr/local/www/pgcon.org/2022/content/schedule/session] % sed -i '' 's|li class="nav-item p-2"><a href="https://www.pgcon.org|/|g' */index.html

[14:40 beta dvl /usr/local/www/pgcon.org/2022/content/schedule/session] % sed -i '' 's|<li class="nav-item p-2">https://www.pgcon.org/events/||g' */index.html

[14:43 beta dvl /usr/local/www/pgcon.org/2022/content/schedule/session] % sed -i '' 's|                 <li class="nav-item p-2">https://www.pgcon.org/account/||g' */index.html

[15:16 beta dvl /usr/local/www/pgcon.org/2022/content/schedule/speaker] % sed -i '' 's|../../../../../media/css/pgeu.css|../../media/css/pgeu.css|' */index.html   
[15:17 beta dvl /usr/local/www/pgcon.org/2022/content/schedule/speaker] % sed -i '' 's|img class="speaker-photo" src="../../../../speaker|img class="speaker-photo" src="../|' */index.html
[15:05 beta dvl /usr/local/www/pgcon.org/2022/content/schedule/speaker] % sed -i '' 's|https://www.pgcon.org/" title="Home"|/" title="Home"|' */index.html 

[15:06 beta dvl /usr/local/www/pgcon.org/2022/content/schedule/speaker] % sed -i '' 's|                 <li class="nav-item p-2">https://www.pgcon.org/events/||' */index.html

[15:07 beta dvl /usr/local/www/pgcon.org/2022/content/schedule/speaker] % sed -i '' 's|                 <li class="nav-item p-2">https://www.pgcon.org/account/||' */index.html


dvl

2025-01-25 16:07

manager   ~0000358

Last edited: 2025-01-25 16:08

The conversion to HTML involves two parts:

* fetch the data
* adjust links

First, fetch the website:

[15:40 beta dvl /usr/local/www/pgcon.org/2020/content/schedule] % wget -m -p -k -r -np --reject-regex='/\/\//' https://www.pgcon.org/events/pgcon_2020/schedule/

Move the index over:

[15:41 beta dvl /usr/local/www/pgcon.org/2020/content/schedule] % mv -i www.pgcon.org/events/pgcon_2020/schedule/index.html .

Move session and speaker information:
[15:38 beta dvl /usr/local/www/pgcon.org/2020/content/schedule/www.pgcon.org/events/pgcon_2020/schedule] % mv session speaker /usr/local/www/pgcon.org/2020/content/schedule

Move speaker photos into the speaker directory:

[15:39 beta dvl /usr/local/www/pgcon.org/2020/content/schedule/www.pgcon.org/events/speaker] % mv * /usr/local/www/pgcon.org/2020/content/schedule/speaker 

At this point, I saved what I had into my repo, so I have a fallback position when updating links.

Now we update the links:

NOTE: your version of sed may not want the '-i ''' option. Perhaps it only needs '-i'

These consists of three areas:

* schedule home directory
* speakers
* sessions

With more fancy sed, you might be able to combine these steps.

Adjust css link
[15:43 beta dvl /usr/local/www/pgcon.org/2020/content/schedule] % sed -i '' 's|../../../media/css/pgeu.css|media/css/pgeu.css|' index.html            

Make the home directory link to the website (be it your beta or production, no need to mention the hostname when it may vary)
[15:43 beta dvl /usr/local/www/pgcon.org/2020/content/schedule] %  sed -i '' 's|li class="nav-item p-2"><a href="https://www.pgcon.org/" title="Home">|li class="nav-item p-2"><a href="/" title="Home">|g' index.html

Remove the link for events
[15:45 beta dvl /usr/local/www/pgcon.org/2020/content/schedule] % sed -i '' 's|                 <li class="nav-item p-2">https://www.pgcon.org/events/||' index.html

Remove the link for your account
[15:46 beta dvl /usr/local/www/pgcon.org/2020/content/schedule] % sed -i '' 's|                 <li class="nav-item p-2">https://www.pgcon.org/account/||' index.html

Repeat for speakers:

[15:46 beta dvl /usr/local/www/pgcon.org/2020/content/schedule/speaker] % sed -i '' 's|../../../../../media/css/pgeu.css|../../media/css/pgeu.css|' */index.html   
[15:46 beta dvl /usr/local/www/pgcon.org/2020/content/schedule/speaker] % sed -i '' 's|img class="speaker-photo" src="../../../../speaker|img class="speaker-photo" src="../|' */index.html
[15:46 beta dvl /usr/local/www/pgcon.org/2020/content/schedule/speaker] % sed -i '' 's|li class="nav-item p-2"><a href="https://www.pgcon.org/" title="Home">|li class="nav-item p-2"><a href="/" title="Home">|g' */index.html
[15:47 beta dvl /usr/local/www/pgcon.org/2020/content/schedule/speaker] % sed -i '' 's|                 <li class="nav-item p-2">https://www.pgcon.org/account/||' */index.html
[15:47 beta dvl /usr/local/www/pgcon.org/2020/content/schedule/speaker] % sed -i '' 's|                 <li class="nav-item p-2">https://www.pgcon.org/events/||' */index.html

And then for sessions:
[15:49 beta dvl /usr/local/www/pgcon.org/2020/content/schedule/session] % sed -i '' 's|../../../../../media/css/pgeu.css|../../media/css/pgeu.css|' */index.html   
[15:49 beta dvl /usr/local/www/pgcon.org/2020/content/schedule/session] % sed -i '' 's|                 <li class="nav-item p-2">https://www.pgcon.org/events/||' */index.html
[15:49 beta dvl /usr/local/www/pgcon.org/2020/content/schedule/session] %  sed -i '' 's|li class="nav-item p-2"><a href="https://www.pgcon.org/" title="Home">|li class="nav-item p-2"><a href="/" title="Home">|g' */index.html
[15:50 beta dvl /usr/local/www/pgcon.org/2020/content/schedule/session] % sed -i '' 's|                 <li class="nav-item p-2">https://www.pgcon.org/account/||' */index.html

dvl

2025-01-25 17:28

manager   ~0000359

And these redirects:

   # handle the conversion from pgeu to static files
   rewrite ^/events/pgcon_2020/schedule/(.*)$ /2020/schedule/$1 permanent;
   rewrite ^/events/pgcon_2021/schedule/(.*)$ /2021/schedule/$1 permanent;
   rewrite ^/events/pgcon_2022/schedule/(.*)$ /2022/schedule/$1 permanent;
   rewrite ^/events/pgcon_2023/schedule/(.*)$ /2023/schedule/$1 permanent;

Issue History

Date Modified Username Field Change
2024-05-02 11:34 dvl New Issue
2024-07-01 21:53 dvl Status new => assigned
2024-07-01 21:53 dvl Assigned To => dvl
2025-01-22 00:57 dvl Note Added: 0000355
2025-01-22 00:59 dvl Note Added: 0000356
2025-01-22 01:01 dvl Note Edited: 0000355
2025-01-25 14:41 dvl Note Edited: 0000356
2025-01-25 14:43 dvl Note Added: 0000357
2025-01-25 15:11 dvl Note Edited: 0000357
2025-01-25 15:17 dvl Note Edited: 0000357
2025-01-25 15:18 dvl Note Edited: 0000357
2025-01-25 16:07 dvl Note Added: 0000358
2025-01-25 16:08 dvl Note Edited: 0000358
2025-01-25 17:28 dvl Note Added: 0000359