UPDATE `<TabellenName>` SET `<FeldName>` = <neuer Wert> WHERE <Bedingung>
UPDATE `item` SET `item` = duw. + 'item' WHERE 'item' = wp.*
SELECT * FROM `item` WHERE 'item' = wp.*
UPDATE `item` SET `item` = 'duw.' + `item` where `item` LIKE 'wp.%'
database_mysql:
plugin_name: Database
# instance: nas
precision: 2
driver: pymysql
connect:
- host: localhost
- user: smarthome
- passwd: smarthome
- db: smarthome
- port: 3306
wp:
plugin_name: aaeigwp2
instance: mydb
precision: 4
driver: pymysql
connect:
- host: localhost
- user: root
- passwd: smarthome
- db: solar
- port: 3306
2021-02-19 10:53:36 WARNING lib.smarthome.main -------------------- Init SmartHomeNG 1.8.1.master (84873f74) --------------------
2021-02-19 10:53:36 WARNING lib.smarthome.main Running in Python interpreter 'v3.8.6 final', from directory /usr/local/smarthome
2021-02-19 10:53:36 WARNING lib.smarthome.main - on Linux-5.10.11-v7l+-armv7l-with-glibc2.28 (pid=31361)
2021-02-19 10:53:36 WARNING lib.smarthome.main - Nutze Feiertage für Land 'DE', Provinz 'BY', 3 benutzerdefinierte(r) Feiertag(e) definiert
2021-02-19 10:53:43 ERROR lib.plugin Plugin 'database' from section 'database_mysql' exception: 'collections.OrderedDict' object [COLOR=#e74c3c]has no attribute 'partition'[/COLOR]
> Traceback (most recent call last):
> File "/usr/local/smarthome/lib/plugin.py", line 162, in __init__
> plugin_thread = PluginWrapper(smarthome, plugin, classname, classpath, args, instance, self.meta, self._configfile)
> File "/usr/local/smarthome/lib/plugin.py", line 629, in __init__
> exec("self.plugin.__init__(smarthome{0}{1})".format("," if len(arglist) else "", argstring))
> File "<string>", line 1, in <module>
> File "/usr/local/smarthome/plugins/database/__init__.py", line 118, in __init__
> self._db = lib.db.Database(("" if self._prefix == "" else self._prefix.capitalize()) + "Database", self.driver, self._connect)
> File "/usr/local/smarthome/lib/db.py", line 176, in __init__
> key, sep, value = arg.partition(':')
> AttributeError: 'collections.OrderedDict' object has no attribute 'partition'
2021-02-19 10:53:43 ERROR lib.plugin Plugin 'wp' exception during import of __init__.py: unindent does not match any outer indentation level (__init__.py, line 308)
> Traceback (most recent call last):
> File "/usr/local/smarthome/lib/plugin.py", line 548, in __init__
> exec("import {0}".format(classpath))
> File "<string>", line 1, in <module>
> File "/usr/local/smarthome/plugins/aaeigwp2/__init__.py", line 308
> cur = self._db.cursor()
> ^
> IndentationError: unindent does not match any outer indentation level
2021-03-23 19:03:52 ERROR plugins.database.Remove old Method plugins.database.Remove old exception: local variable 'item_id' referenced before assignment Traceback (most recent call last): File "/usr/local/smarthome/plugins/database/__init__.py", line 1149, in remove_older_than_maxage item_id = self.id(item, create=False) File "/usr/local/smarthome/plugins/database/__init__.py", line 316, in id if id is None and create == True: UnboundLocalError: local variable 'id' referenced before assignment During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/usr/local/smarthome/lib/scheduler.py", line 664, in _task obj() File "/usr/local/smarthome/plugins/database/__init__.py", line 1151, in remove_older_than_maxage if item_id is None: UnboundLocalError: local variable 'item_id' referenced before assignment
2021-03-23 19:05:23 ERROR lib.db Can not execute query: DELETE FROM log WHERE (item_id = ? ) AND (time = ? OR 1 = ? ) AND (time > ? OR 1 = ? ) AND (time < ? OR 1 = ? ) AND (changed = ? OR 1 = ? ) AND (changed > ? OR 1 = ?) AND (changed < ? OR 1 = ? ); (args [3, None, 1, None, 1, 1613844318276, 0, None, 1, None, 1, None, 1]): database is locked
2021-03-23 19:05:23 ERROR plugins.database Database: Error for query DELETE FROM log WHERE (item_id = 3 ) AND (time = None OR 1 = 1 ) AND (time > None OR 1 = 1 ) AND (time < 1613844318276 OR 1 = 0 ) AND (changed = None OR 1 = 1 ) AND (changed > None OR 1 = 1) AND (changed < None OR 1 = 1 ); : database is locked
2021-03-23 19:05:23 ERROR plugins.database.Remove old Method plugins.database.Remove old exception: database is locked
Traceback (most recent call last):
File "/usr/local/smarthome/lib/scheduler.py", line 664, in _task
obj()
File "/usr/local/smarthome/plugins/database/__init__.py", line 1161, in remove_older_than_maxage
self.deleteLog(item_id, time_end=timestamp_end, with_commit=False)
File "/usr/local/smarthome/plugins/database/__init__.py", line 624, in deleteLog
self._execute(self._prepare("DELETE FROM {log} WHERE " + condition), params, cur=cur)
File "/usr/local/smarthome/plugins/database/__init__.py", line 1227, in _execute
self._query(self._db.execute, query, params, cur)
File "/usr/local/smarthome/plugins/database/__init__.py", line 1257, in _query
raise e
File "/usr/local/smarthome/plugins/database/__init__.py", line 1254, in _query
tuples = func(self._prepare(query), params, cur=cur)
File "/usr/local/smarthome/lib/db.py", line 324, in execute
result = c.execute(stmt, args)
sqlite3.OperationalError: database is locked
schwellwert_ueberschritten:
type: bool
visu_acl: rw
knx_dpt: 1
knx_cache: 2/3/10
database: yes
database_maxage: 200
, war nur bei cleanup(), was ohne Parameter nat. nicht viel bringt.SELECT MIN(datefield) FROM yourtable
Kommentar