SqliteStatementImpl.php

Go to the documentation of this file.

<?php

/*
 * libasynql
 *
 * Copyright (C) 2018 SOFe
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

declare(strict_types=1);

namespace poggit\libasynql\generic;

use RuntimeException;
use SQLite3;
use function array_map;
use function assert;
use function implode;
use function is_array;
use function is_bool;
use function is_float;
use function is_int;
use function is_string;

class SqliteStatementImpl extends GenericStatementImpl{
    public function getDialect() : string{
        return "sqlite";
    }

    protected function formatVariable(GenericVariable $variable, $value, ?string $placeHolder, array &$outArgs) : string{
        if($variable->isList()){
            assert(is_array($value));

            // IN () works with SQLite3.
            $unlist = $variable->unlist();
            return "(" . implode(",", array_map(function($value) use ($placeHolder, $unlist, &$outArgs){
                    return $this->formatVariable($unlist, $value, $placeHolder, $outArgs);
                }, $value)) . ")";
        }

        switch($variable->getType()){
            case GenericVariable::TYPE_BOOL:
                assert(is_bool($value));
                return $value ? "1" : "0";

            case GenericVariable::TYPE_INT:
                assert(is_int($value));
                return (string) $value;

            case GenericVariable::TYPE_FLOAT:
                assert(is_int($value) || is_float($value));
                return (string) $value;

            case GenericVariable::TYPE_STRING:
                assert(is_string($value));
                return "'" . SQLite3::escapeString($value) . "'";
        }

        throw new RuntimeException("Unsupported variable type");
    }
}