<?php

/**

* This file is part of the sshilko/php-sql-mydb package.

*

* (c) Sergei Shilko <contact@sshilko.com>

*

* MIT License

*

* For the full copyright and license information, please view the LICENSE

* file that was distributed with this source code.

* @license https://opensource.org/licenses/mit-license.php MIT

*/

declare(strict_types = 1);

namespace sql;

/**

* @author Sergei Shilko <contact@sshilko.com>

* @license https://opensource.org/licenses/mit-license.php MIT

* @see https://github.com/sshilko/php-sql-mydb

*/

interface MydbOptionsInterface

{

/**

* @see https://dev.mysql.com/doc/refman/8.0/en/innodb-transaction-isolation-levels.html

*/

public const TRANSACTION_ISOLATION_LEVEL_DEFAULT = 'REPEATABLE READ';

public const TRANSACTION_ISOLATION_LEVEL_REPEATABLE_READ = 'REPEATABLE READ';

public const TRANSACTION_ISOLATION_LEVEL_READ_COMMITTED = 'READ COMMITTED';

public const TRANSACTION_ISOLATION_LEVEL_READ_UNCOMMITTED = 'READ UNCOMMITTED';

public const TRANSACTION_ISOLATION_LEVEL_SERIALIZABLE = 'SERIALIZABLE';

public function getNonInteractiveTimeout(): int;

public function setNonInteractiveTimeout(int $nonInteractiveTimeout): void;

public function getServerSideSelectTimeout(): int;

public function setServerSideSelectTimeout(int $seconds): void;

public function getConnectTimeout(): int;

public function setConnectTimeout(int $seconds): void;

public function getErrorReporting(): int;

public function setErrorReporting(int $errorReporting): void;

public function getReadTimeout(): int;

public function setReadTimeout(int $seconds): void;

public function getNetworkBufferSize(): int;

public function setNetworkBufferSize(int $bytes): void;

public function getNetworkReadBuffer(): int;

public function setNetworkReadBuffer(int $bytes): void;

public function getClientErrorLevel(): int;

public function setClientErrorLevel(int $mysqliReport): void;

public function getTimeZone(): string;

public function setTimeZone(string $timeZone): void;

public function isAutocommit(): bool;

public function setAutocommit(bool $autocommit): void;

public function getCharset(): string;

public function getTransactionIsolationLevel(): ?string;

public function setTransactionIsolationLevel(string $isolationLevel): void;

public function setCharset(string $charset): void;

public function isPersistent(): bool;

public function setPersistent(bool $persistent): void;

public function isReadonly(): bool;

public function setReadonly(bool $readonly): void;

}