Generate a graph with nodes of working days and weekends.

omgc-may-1-1.cypher

WITH date({ year: 2019, month: 12, day: 31 }) as lastDay
UNWIND range(1, lastDay.ordinalDay) as iterator
WITH date(toString(lastDay.year) + CASE WHEN iterator <= 9 THEN "00" WHEN iterator > 9 AND iterator <= 99 THEN "0" ELSE "" END + toString(iterator)) as day
FOREACH(day IN CASE WHEN (day.dayOfWeek > 5) THEN [day] ELSE [] END | 
    CREATE (:Weekend { day: day, workingHours: 0 })
)
FOREACH(day IN CASE WHEN (day.dayOfWeek < 6) THEN [day] ELSE [] END | 
    CREATE (:WorkingDay { day: day, workingHours: 8 })
)