Link Search Menu Expand Document
⭐️ 1.8k 🌞 🌚

danog\MadelineProto\Settings\Database\Mysql

Back to index

Author: Daniil Gentili daniil@daniil.it

MySQL backend settings.

MariaDb 10.2+ or Mysql 5.6+ required.

Method list:

Methods:

getOrmSettings(): \danog\AsyncOrm\Settings

See also:

  • \danog\AsyncOrm\Settings

getMaxConnections(): positive-int

Get maximum connection limit.

See also:

  • positive-int

setMaxConnections(positive-int $maxConnections): static

Set maximum connection limit.

Parameters:

  • $maxConnections: positive-int Maximum connection limit.

See also:

  • positive-int

getIdleTimeout(): positive-int

Get idle timeout.

See also:

  • positive-int

setIdleTimeout(positive-int $idleTimeout): static

Set idle timeout.

Parameters:

  • $idleTimeout: positive-int Idle timeout.

See also:

  • positive-int

getDatabase(): string

Get database name.

setDatabase(string $database): static

Set database name.

Parameters:

  • $database: string Database name.

getUsername(): string

Get username.

setUsername(string $username): static

Set username.

Parameters:

  • $username: string Username.

getUri(): string

Get database URI.

setUri(string $uri): static

Set database URI.

Parameters:

  • $uri: string Database URI.

getEphemeralFilesystemPrefix(): ?string

If set, indicates that the filesystem is ephemeral, and thus session files will not be used to store persistent data.

Must contain a unique string, used as prefix for database tables, different for every session.
The prefix may be the same if different databases are used.

This is useful when running MadelineProto inside docker containers without volumes, using just a database.

Note that the session folder must still NEVER be deleted if MadelineProto is running,
or else the session will be dropped from the database due to AUTH_KEY_DUPLICATED errors.

Stopping the container and then deleting the session folder is 100% OK though.

setEphemeralFilesystemPrefix(?string $ephemeralFilesystemPrefix): static

If set, indicates that the filesystem is ephemeral, and thus session files will not be used to store persistent data.

Must contain a unique string, used as prefix for database tables, different for every session.
The prefix may be the same if different databases are used.

This is useful when running MadelineProto inside docker containers without volumes, using just a database.

Note that the session folder must still NEVER be deleted if MadelineProto is running,
or else the session will be dropped from the database due to AUTH_KEY_DUPLICATED errors.

Stopping the container and then deleting the session folder is 100% OK though.

Parameters:

  • $ephemeralFilesystemPrefix: ?string The database prefix

getCacheTtl(): int

Get for how long to keep records in memory after last read, for cached backends.

setCacheTtl((int|string) $cacheTtl): static

Set for how long to keep records in memory after last read, for cached backends.

The cache TTL identifier can be a string like ‘+5 minutes’.
When data is retrieved from a database it is stored in memory.
This helps to reduce latency, improve speed and reduce mysql/postgres/redis load.
Data will be removed from the cache if last access was more than this amount of time.
Clean up is done once per minute.

Parameters:

  • $cacheTtl: (int|string) For how long to keep records in memory after last read, for cached backends.

getPassword(): string

Get password.

setPassword(string $password): static

Set password.

Parameters:

  • $password: string Password.

getSerializer(): ?\danog\MadelineProto\Settings\Database\SerializerType

See also:

setSerializer(?\danog\MadelineProto\Settings\Database\SerializerType $serializer): static

Which serializer to use by default.

If null, the best serializer is chosen.

Parameters:

  • $serializer: ?\danog\MadelineProto\Settings\Database\SerializerType

See also:

getEnableFileReferenceDb(): bool

Get whether to enable the file reference database. If disabled, will break file downloads.

setEnableFileReferenceDb(bool $enableFileReferenceDb): static

Set whether to enable the file reference database. If disabled, will break file downloads.

Parameters:

  • $enableFileReferenceDb: bool Whether to enable the file reference database. If disabled, will break file downloads.

getEnableMinDb(): bool

Get whether to enable the min database. If disabled, will break sendMessage (and other methods) in certain conditions.

setEnableMinDb(bool $enableMinDb): static

Set whether to enable the min database. If disabled, will break sendMessage (and other methods) in certain conditions.

Parameters:

  • $enableMinDb: bool Whether to enable the min database. If disabled, will break sendMessage (and other methods) in certain conditions.

getEnableUsernameDb(): bool

Get whether to enable the username database. If disabled, will break sendMessage (and other methods) with usernames.

setEnableUsernameDb(bool $enableUsernameDb): static

Set whether to enable the username database. If disabled, will break sendMessage (and other methods) with usernames.

Parameters:

  • $enableUsernameDb: bool Whether to enable the username database. If disabled, will break sendMessage (and other methods) with usernames.

getEnableFullPeerDb(): bool

Get whether to enable the full peer info database. If disabled, will break getFullInfo.

setEnableFullPeerDb(bool $enableFullPeerDb): static

Set whether to enable the full peer info database. If disabled, will break getFullInfo.

Parameters:

  • $enableFullPeerDb: bool Whether to enable the full peer info database. If disabled, will break getFullInfo.

getEnablePeerInfoDb(): bool

Get whether to enable the peer info database. If disabled, will break getInfo.

setEnablePeerInfoDb(bool $enablePeerInfoDb): static

Set whether to enable the peer info database. If disabled, will break getInfo.

Parameters:

  • $enablePeerInfoDb: bool Whether to enable the peer info database. If disabled, will break getInfo.

Generated by danog/phpdoc