Change Log for Long Projects

Overview

Total Changes

8

First Change

16th Apr 2024

Last Change

17th Apr 2024

Log

Date Time User Type Name Attribute
1 17th April 2024 06:01:43 remus - - list_description
Before
Some examples of ascents that have taken many sessions.
After
Some examples of ascents that have taken (or are taking) many sessions.
Diff
--- before

+++ after

@@ -1 +1 @@

-Some examples of ascents that have taken many sessions.
+Some examples of ascents that have taken (or are taking) many sessions.
2 17th April 2024 06:01:43 remus - - list_description_pretty
Before
<p>Some examples of ascents that have taken many sessions.</p>
After
<p>Some examples of ascents that have taken (or are taking) many sessions.</p>
3 17th April 2024 06:01:06 remus - - list_definition
Before
select '<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a>' as Climber ,'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as Climb ,g.grade as Grade ,case when am.ascent_meta_key_id = 5 then am.value when am.ascent_meta_key_id = 8 then '>' || am.value when am.ascent_meta_key_id = 9 then am.value || ' (approx)' else '' end as Sessions from ascents a inner join ascent_meta am on a.ascent_id = am.ascent_id and am.ascent_meta_key_id in (5, 8, 9) and a.deleted_on is null inner join climbs c on a.climb_id = c.climb_id and c.deleted_on is null inner join climbers cl on a.climber_id = cl.climber_id and cl.deleted_on is null inner join grades g on c.grade_id = g.grade_id where am.value::int > 50 order by am.value::int desc
After
select '<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a>' as Climber ,case when asty.ascent_successful = true then '<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' else '<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a> (unfinished)' end as Climb ,g.grade as Grade ,case when am.ascent_meta_key_id = 5 then am.value when am.ascent_meta_key_id = 8 then '>' || am.value when am.ascent_meta_key_id = 9 then am.value || ' (approx)' else '' end as Sessions from ascents a inner join ascent_meta am on a.ascent_id = am.ascent_id and am.ascent_meta_key_id in (5, 8, 9) and a.deleted_on is null inner join climbs c on a.climb_id = c.climb_id and c.deleted_on is null inner join climbers cl on a.climber_id = cl.climber_id and cl.deleted_on is null inner join grades g on c.grade_id = g.grade_id inner join ascent_styles asty on a.ascent_style_id = asty.ascent_style_id where am.value::int > 50 order by am.value::int desc
Diff
--- before

+++ after

@@ -1,6 +1,9 @@

select
'' || cl.climber_name || '' as Climber
- ,'' || c.climb_name || '' as Climb
+ ,case
+ when asty.ascent_successful = true then '' || c.climb_name || ''
+ else '' || c.climb_name || ' (unfinished)'
+ end as Climb
,g.grade as Grade
,case
when am.ascent_meta_key_id = 5 then am.value
@@ -23,6 +26,8 @@

and cl.deleted_on is null
inner join grades g
on c.grade_id = g.grade_id
+ inner join ascent_styles asty
+ on a.ascent_style_id = asty.ascent_style_id

where
am.value::int > 50
4 16th April 2024 15:20:27 remus - - list_definition
Before
select '< a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a>' as Climber ,'< a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as Climb ,g.grade as Grade ,case when am.ascent_meta_key_id = 5 then am.value when am.ascent_meta_key_id = 8 then '>' || am.value when am.ascent_meta_key_id = 9 then am.value || ' (approx)' else '' end as Sessions from ascents a inner join ascent_meta am on a.ascent_id = am.ascent_id and am.ascent_meta_key_id in (5, 8, 9) and a.deleted_on is null inner join climbs c on a.climb_id = c.climb_id and c.deleted_on is null inner join climbers cl on a.climber_id = cl.climber_id and cl.deleted_on is null inner join grades g on c.grade_id = g.grade_id where am.value::int > 50 order by am.value::int desc
After
select '<a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a>' as Climber ,'<a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as Climb ,g.grade as Grade ,case when am.ascent_meta_key_id = 5 then am.value when am.ascent_meta_key_id = 8 then '>' || am.value when am.ascent_meta_key_id = 9 then am.value || ' (approx)' else '' end as Sessions from ascents a inner join ascent_meta am on a.ascent_id = am.ascent_id and am.ascent_meta_key_id in (5, 8, 9) and a.deleted_on is null inner join climbs c on a.climb_id = c.climb_id and c.deleted_on is null inner join climbers cl on a.climber_id = cl.climber_id and cl.deleted_on is null inner join grades g on c.grade_id = g.grade_id where am.value::int > 50 order by am.value::int desc
Diff
--- before

+++ after

@@ -1,6 +1,6 @@

select
- '< a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '' as Climber
- ,'< a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '' as Climb
+ '' || cl.climber_name || '' as Climber
+ ,'' || c.climb_name || '' as Climb
,g.grade as Grade
,case
when am.ascent_meta_key_id = 5 then am.value
5 16th April 2024 15:19:27 remus - - list_definition
Before
None
After
select '< a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '</a>' as Climber ,'< a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '</a>' as Climb ,g.grade as Grade ,case when am.ascent_meta_key_id = 5 then am.value when am.ascent_meta_key_id = 8 then '>' || am.value when am.ascent_meta_key_id = 9 then am.value || ' (approx)' else '' end as Sessions from ascents a inner join ascent_meta am on a.ascent_id = am.ascent_id and am.ascent_meta_key_id in (5, 8, 9) and a.deleted_on is null inner join climbs c on a.climb_id = c.climb_id and c.deleted_on is null inner join climbers cl on a.climber_id = cl.climber_id and cl.deleted_on is null inner join grades g on c.grade_id = g.grade_id where am.value::int > 50 order by am.value::int desc
Diff
--- before

+++ after

@@ -1 +1,31 @@

-
+select
+ '< a href="/climber/' || cl.climber_id::varchar || '/a">' || cl.climber_name || '' as Climber
+ ,'< a href="/climb/' || c.climb_id::varchar || '/a">' || c.climb_name || '' as Climb
+ ,g.grade as Grade
+ ,case
+ when am.ascent_meta_key_id = 5 then am.value
+ when am.ascent_meta_key_id = 8 then '>' || am.value
+ when am.ascent_meta_key_id = 9 then am.value || ' (approx)'
+ else ''
+ end as Sessions
+
+from
+ ascents a
+ inner join ascent_meta am
+ on a.ascent_id = am.ascent_id
+ and am.ascent_meta_key_id in (5, 8, 9)
+ and a.deleted_on is null
+ inner join climbs c
+ on a.climb_id = c.climb_id
+ and c.deleted_on is null
+ inner join climbers cl
+ on a.climber_id = cl.climber_id
+ and cl.deleted_on is null
+ inner join grades g
+ on c.grade_id = g.grade_id
+
+where
+ am.value::int > 50
+
+order by
+ am.value::int desc
6 16th April 2024 15:19:27 remus - - list_description
Before
None
After
Some examples of ascents that have taken many sessions.
Diff
--- before

+++ after

@@ -1 +1 @@

-
+Some examples of ascents that have taken many sessions.
7 16th April 2024 15:19:27 remus - - list_name
Before
None
After
Long Projects
8 16th April 2024 15:19:27 remus - - list_description_pretty
Before
None
After
<p>Some examples of ascents that have taken many sessions.</p>

Page 1