2021-06-01, 23:19
Yeah, I know about the backslashes, I use them sometimes in Linux bash files as well. It doesn't mean I'm very committed to keeping lines to 80 chars, especially with SQL queries. I prefer those to be very clear, and prefer to write them out as much as possible. But, that may be a problem in Python with its much more stringent indentation rules.
Just as an example:
Just as an example:
sql:# Check if episode exists in Kodi DB under parent path
SELECT
idFile, playcount, idPath, lastPlayed
FROM
files
INNER JOIN episode USING (idFile)
INNER JOIN path USING (idPath)
INNER JOIN tvshow USING (idshow)
WHERE
tvshow.c00=?
AND idParentPath=?
AND episode.c12=?
AND episode.c13=?
COLLATE NOCASE