a place to share my thoughts

Traits:

As we all know PHP doesn’t support multiple inheritance. However, PHP implements the support to have classes with multiple interfaces since v5.

You can define a trait practically the same way you define a class or interface with functions you need.

Traits do not provide state in the form of properties, but only an interpreter-assisted copy & paste of methods.

Traits have a conflict resolution mechanism, multiple traits can be used in the same class even if some method names are overlapping.

example:

Its not a rocket science or something like that but may help some one to work with date iterations in PostgreSQL.

My requirement was to insert the back dated data into a table for days between two dates, the dates were fix eg. 05/01/2011 to 09/19/2011 so I decided to write a SQL Function. Well in my case there was specific reason to do this in SQL only one can do it using PHP Script also.

CREATE FUNCTION date_iterator() RETURNS SETOF typ_error_msg AS
$body$
DECLARE
lStartDate DATE;
lEndDate DATE;
lDays INTEGER;
BEGIN

lStartDate := TO_DATE(’05/01/2011′,’mm/dd/YYYY’);
lEndDate := TO_DATE(’08/01/2011′,’mm/dd/YYYY’);

FOR lDays IN 0..lToDate – lStartDate
LOOP
RAISE INFO ‘%’, lStartDate;
lStartDate := lStartDate + INTERVAL ’1 days’;
END LOOP;

END;
$body$
LANGUAGE ‘plpgsql’ VOLATILE CALLED ON NULL INPUT SECURITY DEFINER;

– TO CALL FUNCTION
SELECT * FROM date_iterator();
DROP FUNCTION date_iterator();

In PHP one can do it like this:

$dateStart = strtotime( ’05/01/2011′ );
$dateEnd = strtotime( ’08/01/2011′ );

do{

print_r( date( ‘m/d/Y’, $dateStart ) );

//code to manipulate

$dateStart = strtotime( “+1 day”, $dateStart );
}while( $dateStart <= $dateEnd );