Kir\MySQL\Builder\Helpers\FieldTypeProvider

Complexity

Total Complexity

14

Size/Duplication

Total Lines	36
Duplicated Lines	0 %

Importance

Changes	2
Bugs	0	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	getFieldTypes()	0	10	4
B	getTypeFromNativeType()	0	15	10

<?php
namespace Kir\MySQL\Builder\Helpers;

use Kir\MySQL\Builder\QueryStatement;

abstract class FieldTypeProvider {
	/**
	 * @param QueryStatement $statement
	 * @return array<string, string>
	 */
	public static function getFieldTypes(QueryStatement $statement): array {
		$fieldTypes = [];
		for($i = 0; $column = $statement->getColumnMeta($i); $i++) {
			$name = $column['name'] ?? null;
			$nativeType = $column['native_type'] ?? null;
			if(is_string($name) && is_string($nativeType)) {
				$fieldTypes[$name] = self::getTypeFromNativeType($nativeType);
			}
		}
		return $fieldTypes;
	}

	/**
	 * @param string $type
	 * @return string
	 */
	private static function getTypeFromNativeType(string $type): string {
		switch ($type) {
			case 'NEWDECIMAL':
			case 'DECIMAL':
			case 'FLOAT':
			case 'DOUBLE':
				return 'f';
			case 'TINY':
			case 'SHORT':
			case 'LONG':
			case 'LONGLONG':
			case 'INT24':
				return 'i';
		}
		return $type;
	}
}