[Typo3-dev] tstamp

[Elmar Hinz]

Dmitry Dulepov wrote:
> Hi!
> 
> Elmar Hinz wrote:
> 
>>is there any guidline about proper usage of the tstamp field in the
>>tables available.
> 
> 
> Yes. Read Typo3 Core APIs, about "ctrl" section of TCA.
> 
> Dmitry.

Thank you Dmitry,

good documentation, but doesn't tell all. It tells that tstamp is set 
"automatically" on each record update.

The "Project Coding Guidlines"

http://typo3.org/documentation/document-library/doc_core_cgl/Using_the_wrapper_cl/

propose usage of MySQL wrapper functions. Example.

// INSERT:
$insertArray = array(
     'pid' => 123,
     'title' => "My Title"
);

$res = $GLOBALS['TYPO3_DB']->exec_INSERTquery('mytable', $insertArray);

How does this correlate. Don't I have to set tstamp, crdate, ( cruser_id 
) in this query? Is it added by DB-Layer automatically?

I wouldn't expect it. I need to test it. "Project Coding Guidlines" 
should tell something about best practice of "ctrl" section fields here.

Elmar



















-- 
Climate change 2005: Mexico, Guatemala, New Orleans, Sahel, Bangladesh,
Spain, Portugal, Austria, Swiss, France, ...
Production of CO2 is killing people.
Production of CO2 just for fun is killing people just for fun.