Hi all,
I was working with facebook apps and sapphire and normal Int field out of space.
Question how make ID type bigint auto increament.
I traced mysqldatabyse class added new function
public function bigint($values){
//For reference, this is what typically gets passed to this function:
//$parts=Array('datatype'=>'int', 'precision'=>11, 'null'=>'not null', 'default'=>(int)$this->default);
//DB::requireField($this->tableName, $this->name, "int(11) not null default '{$this->defaultVal}'");
return 'bigint(26) not null auto_increment';
}
and created bigint class
class BigInt extends DBField {
function __construct($name, $defaultVal = 0) {
$this->defaultVal = is_int($defaultVal) ? $defaultVal : 0;
parent::__construct($name);
}
/**
* Returns the number, with commas added as appropriate, eg “1,000”.
*/
function Formatted() {
return number_format($this->value);
}
function nullValue() {
return "0";
}
function requireField() {
$parts=Array('datatype'=>'bigint', 'precision'=>26, 'null'=>'not null', 'default'=>$this->defaultVal, 'arrayValue'=>$this->arrayValue);
$values=Array('type'=>'bigint', 'parts'=>$parts);
DB::requireField($this->tableName, $this->name, $values);
}
function Times() {
$output = new DataObjectSet();
for( $i = 0; $i < $this->value; $i++ )
$output->push( new ArrayData( array( 'Number' => $i + 1 ) ) );
return $output;
}
function Nice() {
return sprintf( '%d', $this->value );
}
public function scaffoldFormField($title = null, $params = null) {
return new NumericField($this->name, $title);
}
/**
* Return an encoding of the given value suitable for inclusion in a SQL statement.
* If necessary, this should include quotes.
*/
function prepValueForDB($value) {
if($value === true) {
return 1;
} if(!$value || !is_numeric($value)) {
if(strpos($value, '[')===false)
return '0';
else
return addslashes($value);
} else {
return addslashes($value);
}
}
}
But problem is when i run DB build in dataobject overloading ID => 'BigInt' its goes some complicated.
Maybe some had intructions? :)
P.S. sorry for my English.