sbyx
/ wake-up-light-alarm-with-sunrise-effect.yaml
Last active
January 6, 2025 09:59
Home Assistant Blueprint: Wake-up light alarm with sunrise effect
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| blueprint: | |
| name: Wake-up light alarm with sunrise effect | |
| description: 'A wake-up light alarm with a brightness and color temperature sunrise | |
| effect. Note: Requires date_time_iso sensor in configuration, not manually executable!' | |
| domain: automation | |
| input: | |
| light_entity: | |
| name: Wake-up light entity | |
| description: The light to control. Turning it off during the sunrise will keep | |
| it off. Color temperature range is auto-detected. |
markasoftware
/ enterprise_token.rb
Last active
January 14, 2025 12:06
OpenProject Enterprise mode for free
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ############ REPLACE app/models/enterprise_token.rb in the source code with this file! ################ | |
| ############ also be sure to RESTART OpenProject after replacing the file. ################ | |
| ############ it doesn't show that enterprise mode is enabled in the settings, but all ################ | |
| ############ enterprise mode features, such as KanBan boards, are enabled. ################ | |
| #-- copyright | |
| # OpenProject is an open source project management software. | |
| # Copyright (C) 2012-2023 the OpenProject GmbH | |
| # | |
| # This program is free software; you can redistribute it and/or | |
| # modify it under the terms of the GNU General Public License version 3. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- original source: https://medium.com/adhawk-engineering/using-postgresql-to-generate-slugs-5ec9dd759e88 | |
| -- https://www.postgresql.org/docs/9.6/unaccent.html | |
| CREATE EXTENSION IF NOT EXISTS unaccent; | |
| -- create the function in the public schema | |
| CREATE OR REPLACE FUNCTION public.slugify( | |
| v TEXT | |
| ) RETURNS TEXT | |
| LANGUAGE plpgsql |