Struct MySqlCache 

pub struct MySqlCache { /* private fields */ }

Available on crate feature mysql only.

MySqlCache is a cache using mysql to store data.

It uses sqlx::MySqlPool to connect to mysql. Feature mysql must be enabled.

Prepare

Create a table named cache with the following schema:

CREATE TABLE IF NOT EXISTS cache (
    name varchar(255) not null,
    val text not null,
    primary key (name)
);

Note:

1. You can change the table name and the field names.
2. The name field (or whatever you specify) is the primary key of the cache.

Build

Use MySqlCacheBuilder to build a MySqlCache. You need to specify the table name and the field names when building.

let pool = MySqlPool::connect("mysql://test:123456@127.0.0.1:3306/dev").await?;
let cache = MySqlCacheBuilder::new(pool)
    .table("cache")
    .key_field("name")
    .value_field("val")
    .finish();

Trait Implementations

impl Cache for MySqlCache

fn get<'life0, 'life1, 'async_trait, T>( &'life0 self, key: &'life1 str, ) -> Pin<Box<dyn Future<Output = Result<Option<T>>> + Send + 'async_trait>>

where T: 'async_trait + Cacheable + Send + Sync, Self: 'async_trait, 'life0: 'async_trait, 'life1: 'async_trait,

fn set<'life0, 'life1, 'async_trait, T>( &'life0 self, key: &'life1 str, value: T, ) -> Pin<Box<dyn Future<Output = Result<()>> + Send + 'async_trait>>

where T: 'async_trait + Cacheable + Send + Sync, Self: 'async_trait, 'life0: 'async_trait, 'life1: 'async_trait,

fn delete<'life0, 'life1, 'async_trait>( &'life0 self, key: &'life1 str, ) -> Pin<Box<dyn Future<Output = Result<()>> + Send + 'async_trait>>

where Self: 'async_trait, 'life0: 'async_trait, 'life1: 'async_trait,

fn len<'life0, 'async_trait>( &'life0 self, ) -> Pin<Box<dyn Future<Output = Result<usize>> + Send + 'async_trait>>

where Self: 'async_trait, 'life0: 'async_trait,

impl Clone for MySqlCache

fn clone(&self) -> MySqlCache

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for MySqlCache

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.