Background

Imagine it is mother’s day and we need to fetch our Mother of the Church.

Yes, just do a simple select against your congregation table.

But, was exploring something similar in PowerShell.

Here is what our code line looks like.

Script

Outline

1. 1. Class
      • Create a simple class structure
      • In our case we our class name is person
   2. List
      • Instantiate a collection class
        • The name of the class is System.Collections.ArrayList
   3. Add persons to the collection
   4. Display Output
      • List all persons
        • List all persons ordered by name
      • Fetch oldest person
        • Sort
          • Sort by dob ( in ascending order )
        • Fetch first element post sorting using “select -first 1“
        • Project attributes
          • name:-

            name 

          • date of birth:-

            @{Name = "date of birth"; Expression = { "{0:yyyy-MMM-dd}" -f ($_.dob ) } } 

          • gender:-

            gender

          • Age:-

             @{Name = "age"; Expression = { ( $_.age) } } 

      • Fetch oldest living person
        • Filter out records that have valid dateofLeaving date
          • Use where-object to review dateofLeaving

             Where-Object { ( $_.dateofLeaving -eq $null ) } 

      • Fetch mothers only
        • Leave in only records whose gender is Female
          • Use where-object to review gender

             Where-Object gender -eq "F" 

Code

Output

Output – Image

Output – Text

>powershell ./person.ps1
Persons
-------

name           dob                    gender
----           ---                    ------
John Lewis     2/21/1940 12:00:00 AM       M
Lauren Lake    7/12/1969 12:00:00 AM       F
Mae Jemison    10/17/1956 12:00:00 AM      F
Ricki Lake     12/21/1968 12:00:00 AM      F
Sidney Portier 2/20/1927 12:00:00 AM       M




Oldest Person
--------------

name           date of birth gender age
----           ------------- ------ ---
Sidney Portier 1927-Feb-20        M




Oldest Person - Leave out departed
-----------------------------------

name        date of birth date of leaving gender age
----        ------------- --------------- ------ ---
Mae Jemison 1956-Oct-17                        F  65




Oldest Person - Leave out departed, Gender has to be female
------------------------------------------------------------

name        date of birth date of leaving gender age
----        ------------- --------------- ------ ---
Mae Jemison 1956-Oct-17                        F  65



>

Source Code

1. GitHub
   • Gist
     • DanielAdeniji/personListSortedByAge.ps1
       Link
2. GitLab
   • Snippets
     • PowerShell:- Grouping and Sorting
       • listPersonOrderBy.ps1
         Link

Listening

Just like that, I am back on these streets.

Saweetie – Back to the Streets (feat. Jhené Aiko)
Link

Dedication

Always in dedication to those that care and lift up the people of God.

Sidney Poitier ( 1968 )

Mae Jamison ( 1992 )

John Lewis ( 1992 )

Referenced Work

1. Sidney Poitier
   Link
2. Mae Jamison
   Link
3. John Lewis ( Congress Man – The Good Fight )
   Link