Automotive

1[{category: vehicles, modelYear: 2008 }, {category: motorcycles, modelYear: 2012}]
2
3    const [results, setResults] = useState([])
4
5     useEffect(() => {
6           if(vehicles === true){
7            db.collection("automotive")
8            .orderBy("category == Vehicles")
9            .limit(5)
10            .get()
11            .then((collections) =>{
12              const auto = collections.docs.map((res) => res.data())
13              setResult(auto)
14             })
15           }
16      }, [])
17db.collection("automotive")
18    .where("category == Vehicles")
19    .orderBy("modelYear")
20    .limit(5)
21    .get()
22    .then((collections) =>{
23        const auto = collections.docs.map((res) => res.data())
24        setResult(auto)
25     });
26

1SELECT d.division, COUNT (first_name) 
2FROM departments d, employees
3GROUP BY d.division
4SELECT department, COUNT (first_name) 
5FROM employees
6GROUP BY department
7SELECT d.division, COUNT (e.first_name) 
8 FROM departments d 
9 JOIN employees e on d.id=e.department_id
10GROUP BY d.division
11

1ApplicationWindow {
2id: appWindow
3
4//various properties and stuff
5
6Item {
7    id: clientHolder
8    property Data_Client client
9}
10
11ColumnLayout {
12    id: mainLayout
13    anchors.fill: parent
14    layoutDirection: Qt.LeftToRight
15//And so on...
16Connections {
17        target: client 
18    onNew_status_port_data:
19        {
20            textStatusPort.text = qdata;
21        }
22        onNew_status_data_act_on:
23        {
24            imageStatusData.source = "../imagine-assets/ledGoodRim.png";
25        }
26    //and so on...
27Item {
28    id: channelStatusObject
29
30    property int channel
31    property int enabled    //Using the EnabledState enum 
32    property string mode
33    property int bitrate
34    property int dataActivity   //Using the LedState enum
35//and more...
36    property int packetCount
37}
38property ChannelStatusObject statusObject
39
40    onStatusObjectChanged: { 
41//..do the stuff
42QQmlComponent component(&engine, "ChannelStatusObject.qml");
43QObject *statObj= component.create();
44
45QQmlProperty::write(statObj, "channel", 1)
46QQmlProperty::write(statObj, "bitrate", 5000);
47QQmlProperty::write(statObj, "enabled", 0);
48
49//Then something like using the pointer from #1, above, to set the Panel property
50//QObject *channelPanel;
51QQmlProperty::write(channelPanel, "statusObject", statObj)
52class ChannelStatus : public QObject
53{
54    Q_OBJECT
55public:
56    Q_PROPERTY(int channel READ channel CONSTANT)
57    Q_PROPERTY(int enabled READ enabled WRITE setEnabled NOTIFY enabledChanged)
58    // etc.
59};
60
61class Data_Client : public QObject
62{
63    Q_OBJECT
64public:
65    Q_PROPERTY(QList<ChannelStatus*> statusList READ statusList NOTIFY statusListChanged)
66    // ...
67};
68

1ApplicationWindow {
2id: appWindow
3
4//various properties and stuff
5
6Item {
7    id: clientHolder
8    property Data_Client client
9}
10
11ColumnLayout {
12    id: mainLayout
13    anchors.fill: parent
14    layoutDirection: Qt.LeftToRight
15//And so on...
16Connections {
17        target: client 
18    onNew_status_port_data:
19        {
20            textStatusPort.text = qdata;
21        }
22        onNew_status_data_act_on:
23        {
24            imageStatusData.source = "../imagine-assets/ledGoodRim.png";
25        }
26    //and so on...
27Item {
28    id: channelStatusObject
29
30    property int channel
31    property int enabled    //Using the EnabledState enum 
32    property string mode
33    property int bitrate
34    property int dataActivity   //Using the LedState enum
35//and more...
36    property int packetCount
37}
38property ChannelStatusObject statusObject
39
40    onStatusObjectChanged: { 
41//..do the stuff
42QQmlComponent component(&engine, "ChannelStatusObject.qml");
43QObject *statObj= component.create();
44
45QQmlProperty::write(statObj, "channel", 1)
46QQmlProperty::write(statObj, "bitrate", 5000);
47QQmlProperty::write(statObj, "enabled", 0);
48
49//Then something like using the pointer from #1, above, to set the Panel property
50//QObject *channelPanel;
51QQmlProperty::write(channelPanel, "statusObject", statObj)
52class ChannelStatus : public QObject
53{
54    Q_OBJECT
55public:
56    Q_PROPERTY(int channel READ channel CONSTANT)
57    Q_PROPERTY(int enabled READ enabled WRITE setEnabled NOTIFY enabledChanged)
58    // etc.
59};
60
61class Data_Client : public QObject
62{
63    Q_OBJECT
64public:
65    Q_PROPERTY(QList<ChannelStatus*> statusList READ statusList NOTIFY statusListChanged)
66    // ...
67};
68qmlRegisterUncreatableType<ChannelStatus>("LibraryName", 1, 0, 
69    "ChannelStatus", "Property access only.");
70qRegisterMetaType<QList<ChannelStatus*>>();
71

1ApplicationWindow {
2id: appWindow
3
4//various properties and stuff
5
6Item {
7    id: clientHolder
8    property Data_Client client
9}
10
11ColumnLayout {
12    id: mainLayout
13    anchors.fill: parent
14    layoutDirection: Qt.LeftToRight
15//And so on...
16Connections {
17        target: client 
18    onNew_status_port_data:
19        {
20            textStatusPort.text = qdata;
21        }
22        onNew_status_data_act_on:
23        {
24            imageStatusData.source = "../imagine-assets/ledGoodRim.png";
25        }
26    //and so on...
27Item {
28    id: channelStatusObject
29
30    property int channel
31    property int enabled    //Using the EnabledState enum 
32    property string mode
33    property int bitrate
34    property int dataActivity   //Using the LedState enum
35//and more...
36    property int packetCount
37}
38property ChannelStatusObject statusObject
39
40    onStatusObjectChanged: { 
41//..do the stuff
42QQmlComponent component(&engine, "ChannelStatusObject.qml");
43QObject *statObj= component.create();
44
45QQmlProperty::write(statObj, "channel", 1)
46QQmlProperty::write(statObj, "bitrate", 5000);
47QQmlProperty::write(statObj, "enabled", 0);
48
49//Then something like using the pointer from #1, above, to set the Panel property
50//QObject *channelPanel;
51QQmlProperty::write(channelPanel, "statusObject", statObj)
52class ChannelStatus : public QObject
53{
54    Q_OBJECT
55public:
56    Q_PROPERTY(int channel READ channel CONSTANT)
57    Q_PROPERTY(int enabled READ enabled WRITE setEnabled NOTIFY enabledChanged)
58    // etc.
59};
60
61class Data_Client : public QObject
62{
63    Q_OBJECT
64public:
65    Q_PROPERTY(QList<ChannelStatus*> statusList READ statusList NOTIFY statusListChanged)
66    // ...
67};
68qmlRegisterUncreatableType<ChannelStatus>("LibraryName", 1, 0, 
69    "ChannelStatus", "Property access only.");
70qRegisterMetaType<QList<ChannelStatus*>>();
71import LibraryName 1.0
72ListView {
73    model: client.statusList
74    delegate: Column {
75        Label { text: modelData.channel }
76        Image { source: modelData.enabled ? "foo" : "bar" }
77        // ...
78    }
79}
80

1SELECT
2    product.id,
3    product.product_name,
4    CASE WHEN categories.level = '3' THEN (
5           SELECT c2.name
6           FROM categories c2
7           WHERE c2.id = categories.parent_id )
8    END AS level_2_cat_name
9FROM product
10    JOIN categories ON categories.ext_id = product.ext_category_id
11WITH RECURSIVE cte1 (id, name, cid, cname, level, parent_id) AS (
12        SELECT p.id, p.product_name, c.id, c.name, level, parent_id
13          FROM product     AS p
14          JOIN categories  AS c
15            ON p.ext_category_id = c.ext_id
16         UNION ALL
17        SELECT p.id, p.name, c.id AS cid, c.name AS cname, c.level, c.parent_id
18          FROM cte1        AS p
19          JOIN categories  AS c
20            ON c.id = p.parent_id
21     )
22SELECT id, name, cname
23  FROM cte1
24 WHERE level = 1
25 ORDER BY id
26;
27

1SELECT
2    product.id,
3    product.product_name,
4    CASE WHEN categories.level = '3' THEN (
5           SELECT c2.name
6           FROM categories c2
7           WHERE c2.id = categories.parent_id )
8    END AS level_2_cat_name
9FROM product
10    JOIN categories ON categories.ext_id = product.ext_category_id
11WITH RECURSIVE cte1 (id, name, cid, cname, level, parent_id) AS (
12        SELECT p.id, p.product_name, c.id, c.name, level, parent_id
13          FROM product     AS p
14          JOIN categories  AS c
15            ON p.ext_category_id = c.ext_id
16         UNION ALL
17        SELECT p.id, p.name, c.id AS cid, c.name AS cname, c.level, c.parent_id
18          FROM cte1        AS p
19          JOIN categories  AS c
20            ON c.id = p.parent_id
21     )
22SELECT id, name, cname
23  FROM cte1
24 WHERE level = 1
25 ORDER BY id
26;
27+------+--------------+------------------------------+
28| id   | name         | cname                        |
29+------+--------------+------------------------------+
30|    1 | Strawberries | Fruit & Vegetable department |
31|    2 | Bananas      | Fruit & Vegetable department |
32|    3 | Potatoes     | Fruit & Vegetable department |
33|    4 | Car Battery  | Automotive department        |
34|    5 | Chips        | Junk Food Department         |
35+------+--------------+------------------------------+
36

1SELECT
2    product.id,
3    product.product_name,
4    CASE WHEN categories.level = '3' THEN (
5           SELECT c2.name
6           FROM categories c2
7           WHERE c2.id = categories.parent_id )
8    END AS level_2_cat_name
9FROM product
10    JOIN categories ON categories.ext_id = product.ext_category_id
11WITH RECURSIVE cte1 (id, name, cid, cname, level, parent_id) AS (
12        SELECT p.id, p.product_name, c.id, c.name, level, parent_id
13          FROM product     AS p
14          JOIN categories  AS c
15            ON p.ext_category_id = c.ext_id
16         UNION ALL
17        SELECT p.id, p.name, c.id AS cid, c.name AS cname, c.level, c.parent_id
18          FROM cte1        AS p
19          JOIN categories  AS c
20            ON c.id = p.parent_id
21     )
22SELECT id, name, cname
23  FROM cte1
24 WHERE level = 1
25 ORDER BY id
26;
27+------+--------------+------------------------------+
28| id   | name         | cname                        |
29+------+--------------+------------------------------+
30|    1 | Strawberries | Fruit & Vegetable department |
31|    2 | Bananas      | Fruit & Vegetable department |
32|    3 | Potatoes     | Fruit & Vegetable department |
33|    4 | Car Battery  | Automotive department        |
34|    5 | Chips        | Junk Food Department         |
35+------+--------------+------------------------------+
36CREATE TABLE product (
37    id               int
38  , product_name     varchar(40)
39  , ext_category_id  int
40);
41
42INSERT INTO product VALUES
43  ( 1, 'Strawberries' , 101)
44, ( 2, 'Bananas'      , 102)
45, ( 3, 'Potatoes'     , 103)
46, ( 4, 'Car Battery'  , 104)
47, ( 5, 'Chips'        , 105)
48;
49
50CREATE TABLE categories (
51    id           int
52  , ext_id       int
53  , name         varchar(40)
54  , level        int
55  , parent_id    int
56);
57
58-- id   ext_id  name    level   parent_id
59INSERT INTO categories VALUES
60  (1001, 101, 'Fruit'                , 2, 2000)
61, (1002, 102, 'Fruit'                , 2, 2000)
62, (1003, 103, 'Vegetables'           , 2, 2000)
63, (1004, 104, 'Car Parts'            , 3, 2500)
64, (1005, 105, 'FoodParts'            , 2, 2001)
65, (2001, 209, 'Junk Food Department' , 1, Null)
66, (2000, 205, 'Fruit & Vegetable department', 1, Null)
67, (2500, 309, 'Cars & Trucks'               , 2, 2002)
68, (2002, 209, 'Automotive department'       , 1, Null)
69;
70