import QtQuick 2.0

Rectangle {
    Component {
        id: squareComponent
        Rectangle {
            property int sideLenght: 500
            width: sideLenght
            height: sideLenght
            color: "orange"
            MouseArea {
                anchors.fill: parent
                onClicked: {
                    var first = squareComponent.createObject(parent)
                    var second = squareComponent.createObject(parent)
                    var third = squareComponent.createObject(parent)
                    var fourth = squareComponent.createObject(parent)

                    var sideLenght = parent.sideLenght / 2

                    first.sideLenght = sideLenght
                    second.sideLenght = sideLenght
                    third.sideLenght = sideLenght
                    fourth.sideLenght = sideLenght

                    var x = parent.x
                    var y = parent.y
                    console.log(x, y)

                    first.x = x
                    first.y = y
                    first.color = "red"
                    console.log("first", first.x, first.y)

                    second.x = first.x + sideLenght
                    second.y = first.y
                    second.color = "orange"
                    console.log("second", second.x, second.y)

                    third.x = first.x
                    third.y = first.y + sideLenght
                    third.color = "blue"
                    console.log("third", third.x, third.y)

                    fourth.x = first.x + sideLenght
                    fourth.y = first.y + sideLenght
                    fourth.color = "black"
                    console.log("fourth", fourth.x, fourth.y, "\n\n")

                    parent.sideLenght = 0
                }
            }
        }
    }

    Component.onCompleted: squareComponent.createObject(parent)
}

int main()
{
#ifdef UNIT_TEST
    return RUN_ALL_TESTS();
#else
    run_useful_code();
    return 0;
#endif
}

CREATE OR REPLACE FUNCTION getSensorValues(firstTime integer, lastTime integer, step integer, insensorid integer)
returns setof getSensorType as --table(otime_t integer, ovalue float8) as
$$
declare
firstTime integer := $1;
counter integer := 0;
localStep integer := $3/10 + 1;
getSens getSensorType;
occ record;
begin
  while firstTime < $2 + 1 
  loop
  for occ in select time_t, value from sensors
  where sensorsid = $4 and time_t = (select min(time_t) from sensors
  where sensorsid = $4 and time_t >= (firstTime - (localStep/2) + (localStep*counter))
  and time_t < (firstTime + (localStep/2) + (localStep*counter)))
  loop
  getSens.otime_t := occ.time_t;
  getSens.ovalue := occ.value;
  return next getSens;
  end loop;
  firstTime := firstTime + $3;

  if (getSens.otime_t is NULL) then
    if (getSens.ovalue is NULL) then
      if (counter < 9) then
    firstTime := firstTime - $3;
    counter := counter + 1;
      end if;
    end if;
  end if;

  end loop;
return;
end;
$$
language 'plpgsql';

------------------------------------------------

create type getSensorType as
(
otime_t integer,
ovalue float8
);