NOW() + CONCAT(:dev_duration::INT,' MINUTES ', :index_{$index}::INT * :offset::INT, ' SECONDS')::INTERVAL

public static function deleteMany($ants) {

    // If objects are passed, search for uuid only

    if(is_object($ants[0])) {

        // If no uuid are presents in the array, throw an error

        if(!isset($ants[0]->uuid)) {

            throw new ErrorException('No uuid present in the array of object.');

        }



        $ants = array_map(static function($ant) {

            return $ant->uuid;

        }, $ants);

    }



    // Create the in statement

    $in = str_repeat('?,', count($ants) - 1) . '?';



    return DB::deleteReturn("DELETE FROM ants WHERE uuid IN ({$in}) RETURNING uuid", $ants);

}

public static function createMany(City $city, Array $ants)

{

    // Data shared by all the inserts

    $data['city_uuid'] = $city->uuid;

    $data['position'] = DB:anitizePoint($city->position);

    $data['dev_duration'] = $bindings = $city->buildings->royal_room->nurseryDevelopmentTimes()['end'];

    $data['offset'] = $city->buildings->royal_room->getLevelFor('born_time_offset');



    $sql = '';

    foreach ($ants as $index => $ant) {

        $data["caste_{$index}"] = $ant['caste'];

        $data["index_{$index}"] = $index;

        $will_die_statement = isset($ant['will_die']) && $ant['will_die'] ? "NOW() + CONCAT(FLOOR(RANDOM() * {$data['dev_duration']})::INT, ' MINUTES')::INTERVAL" : 'NULL';



        $sql .= "(:city_uuid, ST_GeomFromText(:position, 4326), NOW() + CONCAT(:dev_duration::INT,' MINUTES ', :index_{$index}::INT * :offset::INT, ' SECONDS')::INTERVAL, :caste_{$index}, {$will_die_statement}),";

    }



    // Create the full SQL Statement

    $sql = 'INSERT INTO ants (city_uuid, position, born_time, caste, dead_time) VALUES ' . substr($sql, 0, -1) . ' RETURNING *, ST_X(position) as x, ST_Y(position) as y';



    $insertion = DB::insertReturn($sql, $data);

Maz a écrit :(updated_at IS NULL OR updated_at < NOW() - CONCAT(:hunt_speed::INT, ' minutes')::INTERVAL)

Maz a écrit :NOW() + CONCAT(:dev_duration::INT,' MINUTES ', :index_{$index}::INT * :offset::INT, ' SECONDS')::INTERVAL

(06-04-2020, 07:39 PM)Meraxes a écrit : Tu peux utiliser la fonction make_interval() :

Code :

SELECT NOW() - make_interval(mins := :hunt_speed) FROM ...

Code :

SELECT NOW() + make_interval(0,0,0,0,0,:dev_duration,  :index_{$index} * :offset) FROM ...

CREATE OR REPLACE FUNCTION public.random_between(low integer, high integer)

RETURNS integer

    LANGUAGE plpgsql

    STRICT

    AS $function$

BEGIN

    RETURN floor(random()* (high-low + 1) + low);

END;

$function$

;



CREATE OR REPLACE FUNCTION public.random_point_around(target_point geometry, expand_size integer)

    RETURNS geometry

    LANGUAGE plpgsql

AS $function$

    DECLARE

    point_x  INTEGER := ST_X(target_point);

    point_y  INTEGER := ST_Y(target_point);

    random_x INTEGER := random_between(point_x - expand_size, point_x + expand_size);

    random_y INTEGER := random_between(point_y - expand_size, point_y + expand_size);

    begin

    RETURN ST_GeomFromText(CONCAT('POINT(', random_x, ' ',  random_y, ')'), 4326);

    END; $function$

;