danielgp /
common-lib
| @@ 570-576 (lines=7) @@ | ||
| 567 | protected function setFieldNumbers($fieldDetails, $outputFormated = false) |
|
| 568 | { |
|
| 569 | switch ($fieldDetails['DATA_TYPE']) { |
|
| 570 | case 'bigint': |
|
| 571 | if (strpos($fieldDetails['COLUMN_TYPE'], 'unsigned') !== false) { |
|
| 572 | $aReturn = ['m' => 0, 'M' => 18446744072705500000, 'l' => 20]; |
|
| 573 | } else { |
|
| 574 | $aReturn = ['m' => -9223372036854770000, 'M' => 9223372036854770000, 'l' => 20]; |
|
| 575 | } |
|
| 576 | break; |
|
| 577 | case 'char': |
|
| 578 | case 'varchar': |
|
| 579 | case 'tinytext': |
|
| @@ 587-593 (lines=7) @@ | ||
| 584 | case 'numeric': |
|
| 585 | $aReturn = ['l' => $fieldDetails['NUMERIC_PRECISION'], 'd' => $fieldDetails['NUMERIC_SCALE']]; |
|
| 586 | break; |
|
| 587 | case 'int': |
|
| 588 | if (strpos($fieldDetails['COLUMN_TYPE'], 'unsigned') !== false) { |
|
| 589 | $aReturn = ['m' => 0, 'M' => 4294967295, 'l' => 10]; |
|
| 590 | } else { |
|
| 591 | $aReturn = ['m' => -2147483648, 'M' => 2147483647, 'l' => 11]; |
|
| 592 | } |
|
| 593 | break; |
|
| 594 | case 'mediumint': |
|
| 595 | if (strpos($fieldDetails['COLUMN_TYPE'], 'unsigned') !== false) { |
|
| 596 | $aReturn = ['m' => 0, 'M' => 16777215, 'l' => 8]; |
|
| @@ 594-600 (lines=7) @@ | ||
| 591 | $aReturn = ['m' => -2147483648, 'M' => 2147483647, 'l' => 11]; |
|
| 592 | } |
|
| 593 | break; |
|
| 594 | case 'mediumint': |
|
| 595 | if (strpos($fieldDetails['COLUMN_TYPE'], 'unsigned') !== false) { |
|
| 596 | $aReturn = ['m' => 0, 'M' => 16777215, 'l' => 8]; |
|
| 597 | } else { |
|
| 598 | $aReturn = ['m' => -8388608, 'M' => 8388607, 'l' => 8]; |
|
| 599 | } |
|
| 600 | break; |
|
| 601 | case 'smallint': |
|
| 602 | if (strpos($fieldDetails['COLUMN_TYPE'], 'unsigned') !== false) { |
|
| 603 | $aReturn = ['m' => 0, 'M' => 65535, 'l' => 5]; |
|
| @@ 601-607 (lines=7) @@ | ||
| 598 | $aReturn = ['m' => -8388608, 'M' => 8388607, 'l' => 8]; |
|
| 599 | } |
|
| 600 | break; |
|
| 601 | case 'smallint': |
|
| 602 | if (strpos($fieldDetails['COLUMN_TYPE'], 'unsigned') !== false) { |
|
| 603 | $aReturn = ['m' => 0, 'M' => 65535, 'l' => 5]; |
|
| 604 | } else { |
|
| 605 | $aReturn = ['m' => -32768, 'M' => 32767, 'l' => 6]; |
|
| 606 | } |
|
| 607 | break; |
|
| 608 | case 'tinyint': |
|
| 609 | if (strpos($fieldDetails['COLUMN_TYPE'], 'unsigned') !== false) { |
|
| 610 | $aReturn = ['m' => 0, 'M' => 255, 'l' => 3]; |
|
| @@ 608-614 (lines=7) @@ | ||
| 605 | $aReturn = ['m' => -32768, 'M' => 32767, 'l' => 6]; |
|
| 606 | } |
|
| 607 | break; |
|
| 608 | case 'tinyint': |
|
| 609 | if (strpos($fieldDetails['COLUMN_TYPE'], 'unsigned') !== false) { |
|
| 610 | $aReturn = ['m' => 0, 'M' => 255, 'l' => 3]; |
|
| 611 | } else { |
|
| 612 | $aReturn = ['m' => -128, 'M' => 127, 'l' => 4]; |
|
| 613 | } |
|
| 614 | break; |
|
| 615 | default: |
|
| 616 | $aReturn = null; |
|
| 617 | break; |
|
