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: Frigate - Telegram Notification | |
description: Create automations to receive Snapshots and Clips from Frigate | |
domain: automation | |
input: | |
camera: | |
name: Frigate Camera | |
description: The name of the camera as defined in your frigate configuration (/conf.yml). | |
target_chat: | |
name: Target |
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
--- | |
main: | |
data_types_map: | |
citext: String | |
inet: IPv4 | |
int2: Int8 | |
int4: Int8 | |
int8: Int8 | |
varchar: String | |
timestamp: DateTime |
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
34044024;1104934;5875;24;78;34044;691;124;2018;19951;2;2;2;5;107;10139;1149;108857;5875;3;1343;"5099627306164";2.5512;2.5512;;15.0000;0.0000;0.0000;5.8400;5.8400;0.0000;2.3400;18;4;2.3400;3.5000;0.0000;5.8400;0.0300;414840864;;39977;5845;;;;1;;341628;0.0015;f;839;3.5000;5620;"39977";2.3415;12;0.0300;15.0000;2 | |
34044024;1104932;5875;24;78;34044;461;197;472;23399;2;2;2;18;271;10139;1149;108857;5875;1;1343;"5099627025263";0.9510;0.9510;;30.0000;0.0000;0.0000;4.3700;4.3700;0.0000;0.8700;18;4;0.8700;3.5000;0.0000;4.3700;0.3000;414840864;;77364;5845;;;;1;;341628;0.0030;f;491;3.5000;5620;"77364";0.8730;12;0.3000;30.0000;2 | |
34044024;1104933;5875;24;78;34044;461;197;993;55412;2;2;2;18;271;10139;1149;108857;5875;2;1343;"5099627031363";0.6120;0.6120;;40.0000;0.0000;0.0000;4.0600;4.0600;0.0000;0.5600;18;4;0.5600;3.5000;0.0000;4.0600;0.4000;414840864;;40878;5845;;;;1;;341628;0.0000;f;1235;3.5000;5620;"40878";0.5600;12;0.4000;40.0000; |
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
postgres@andy-tp:~$ psql -d postgres -U postgres -c "select * from pazzan where name like 'Semen%' and room = 434;" | |
id | name | room | salary | is_test_passed | is_norm_pazzan | hobby | |
----+----------------------+------+--------------------------+----------------+----------------+---------------------------- | |
1 | Semen Molokanov | 434 | Need moar since 2014 | t | t | Making babies | |
2 | Semen Movchan | 434 | Ok | f | t | Sql optimizimg | |
(2 rows) | |
postgres@andy-tp:~$ |