chillerlan\Database\Query\Dialects\Postgres\CreateDatabase::sql()

Complexity

Conditions	6
Paths	10

Size

Total Lines	30
Code Lines	15

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
	public function sql():string{

		if(empty($this->name)){
			throw new QueryException('no name specified');
		}

		$sql = 'CREATE DATABASE ';
		$sql .= $this->quote($this->name);

		if($this->collate){
			$charset = explode(',', $this->collate, 3);

			$count = count($charset);

			if($count > 0){
				$sql .= ' ENCODING \''.strtoupper($charset[0]).'\'';
			}

			if($count > 1){
				$sql .= ' LC_COLLATE=\''.$charset[1].'\'';
			}

			if($count > 2){
				$sql .= ' LC_CTYPE=\''.$charset[2].'\'';
			}

		}

		return $sql;
	}