30 Commits

Author SHA1 Message Date
Franck Nijhof
404fdb53a6
2023.5: Sync with codebase 2023-05-03 19:28:11 +02:00
G Johansson
cad5e4e75b
Fix incorrect default for db_url in SQL (#26913) 2023-04-13 00:07:34 +02:00
J. Nick Koston
691c673ebb
Update SQL query examples for schema 40 (#26591) 2023-03-14 10:04:06 +01:00
G Johansson
11a8e776c1
Change SQL integration to use HA recorder db as default (#25643)
Co-authored-by: J. Nick Koston <nick@koston.org>
2023-03-13 17:41:55 -10:00
G Johansson
c2a25c2677
device_class and state_class (#25742)
Co-authored-by: Franck Nijhof <frenck@frenck.nl>
2023-03-05 20:30:51 +01:00
boomam
b77ca9421e
Update sql.markdown (#25925) 2023-02-03 19:37:55 +01:00
G Johansson
d6589bf86d
Add back yaml support (#24293)
Co-authored-by: Franck Nijhof <frenck@frenck.nl>
Co-authored-by: J. Nick Koston <nick@koston.org>
2023-01-09 11:46:27 +01:00
G Johansson
596c8432b5
SQL add text on pyodbc for MSSQL (#24748)
Co-authored-by: Franck Nijhof <frenck@frenck.nl>
2022-11-29 13:04:34 +01:00
Colin
701cf2d7c4
Documentation: Update default table_scheme from "hass" to "homeassistant" (#24858) 2022-11-09 14:17:42 +01:00
nickrout
9300c6fbc0
Update sql.markdown (#23076)
Co-authored-by: G Johansson <goran.johansson@shiftit.se>
2022-07-18 22:54:23 +02:00
G Johansson
30097b38df
Update sql for config flow (#22162) 2022-04-24 08:52:33 -10:00
Franck Nijhof
5d72c2a03c
Sync codebase with docs for 2022.4.0b0 2022-03-30 21:50:39 +02:00
nordeep
4b8ea3ed53
Fix "Previous state of an entity" YAML example (#21268) 2022-01-21 09:46:23 +01:00
jugla
a4ba5c934a
Add SQL example to get former value (#19105)
Co-authored-by: Paulus Schoutsen <paulus@home-assistant.io>
Co-authored-by: Franck Nijhof <frenck@frenck.nl>
2021-10-26 13:34:06 +02:00
David Zidar
b74d8f28ef
Fix MS SQL connection string examples (#17801)
pyodbc parameters passed via a connection string to sqlalchemy should be
passed as query string parameters and must be lower case.

sqlalchemy includes the following note in their source code:

Note that in order for the dialect to recognize these keywords
(including the ``driver`` keyword above) they must be all lowercase.
Multiple additional keyword arguments must be separated by an
ampersand (``&``), not a semicolon::

13d01a03c5/lib/sqlalchemy/dialects/mssql/pyodbc.py (L56-L59)
2021-05-11 18:58:51 -05:00
Pieter Rautenbach
9b3bcc5b2c
Clarifying how attributes are set (#17473)
See #17443 for more details.
2021-04-15 16:09:10 +02:00
Franck Nijhof
8f82a159f9
Add integration platforms to integration frontmatter (#16525) 2021-02-12 11:59:20 +01:00
Franck Nijhof
09759662a1
Bunch of YAML styling improvements - part 3 (#16394) 2021-02-04 03:00:11 +01:00
Dmitry Vasilyev
154dbfa37a
Added the sample of DB size sensor for MS SQL. (#15529)
Co-authored-by: Franck Nijhof <frenck@frenck.nl>
2021-01-25 16:34:19 +01:00
Klaas Schoute
d99252f613
👕 Markdown style changes (#15861) 2020-12-09 18:48:17 +01:00
Jenny
d366f71f79
Add IOT class for SQL (#14775) 2020-10-02 18:34:27 +02:00
Fabian Affolter
93312671e9
Add SQLite db size example (fixes #13715) (#14295) 2020-08-23 11:23:18 +02:00
mdegat01
19bc48a2fb
Adding sensor and binary sensor categories to utility integrations (#14282) 2020-08-21 12:49:30 +02:00
Franck Nijhof
bdade863c6
Migrate logos from documentation website to brands (#12287) 2020-03-06 16:29:57 +01:00
Franck Nijhof
c81de1d658
Add ha_domain to integrations frontmatter (#12277) 2020-03-05 17:28:39 -08:00
Franck Nijhof
2311a9fed6
Initial sync codeowners with codebase integration manifests (#11673) 2020-01-08 13:25:21 +01:00
Franck Nijhof
2c2cd0305f
Sync title/names with codebase (I-S) 2020-01-07 14:50:24 +01:00
Franck Nijhof
b983082cb9
Frontmatter formatting (#11654) 2020-01-07 14:43:49 +01:00
Franck Nijhof
dcc7c10ce4
Rewrites all URLs in our website from components -> integrations 2019-10-02 00:35:28 +02:00
Franck Nijhof
57c6dec6c2
Rename components folders to integrations 2019-10-02 00:04:39 +02:00