See https://github.com/shosca/django-sorcery/blob/master/Makefil... for example
Run that target as part of the test
39 karma · joined February 11, 2008
Run that target as part of the test
>>> document.getElementsByTagName('font').length 348
echo low | sudo tee -a /sys/class/drm/card0/device/power_profile
ymmvYou can disable the main menu bar by removing the appmenu-gtk package.
Comments:
/-----------------------------\
| ID | ParentID | etc |
|-----------------------------|
| 1 | Null | etc |
| 2 | Null | etc |
| 3 | 1 | etc |
| 4 | 1 | etc |
| 5 | 4 | etc |
\-----------------------------/
You then use a Common Table Expressions query, like this: WITH CommentTree (ParentID, ID, Level)
AS
(
SELECT ParentID, ID, 0 as [Level],
FROM Comments
WHERE ParentID = [ROOT COMMENT ID] OR ParentID IS NULL
UNION ALL
SELECT c.ParentID, c.ID, ct.Level + 1
FROM Comments c
JOIN CommentTree ct ON ct.ID = c.ParentID
)
-- Now actually query the data from the CTE Expression
SELECT ParentID, ID, Level FROM CommentTree
ORDER BY ParentID, Level, ID
This returns a table with a calculated column called Level. /---------------------------\
| ParentID | Level | ID |
|---------------------------|
| Null | 0 | 1 |
| Null | 0 | 2 |
| 1 | 1 | 3 |
| 1 | 1 | 4 |
| 4 | 2 | 5 |
\---------------------------/
Which of course, would represent this tree: Root
/ \
2 1
/ \
3 4
\
5