NAME

Zing::Store::Mysql - Mysql Storage

ABSTRACT

Mysql Storage Abstraction

SYNOPSIS

use Test::DB::Mysql;
use Zing::Encoder::Dump;
use Zing::Store::Mysql;

my $testdb = Test::DB::Mysql->new;
my $store = Zing::Store::Mysql->new(
  client => $testdb->create->dbh,
  encoder => Zing::Encoder::Dump->new
);

# $store->drop;

DESCRIPTION

This package provides a MySQL-specific storage adapter for use with data persistence abstractions. The "client" attribute accepts a DBI object configured to connect to a DBD::mysql backend. The ZING_DBNAME environment variable can be used to specify the database name (defaults to "zing"). The ZING_DBHOST environment variable can be used to specify the database host (defaults to "localhost"). The ZING_DBPORT environment variable can be used to specify the database port (defaults to "3306"). The ZING_DBUSER environment variable can be used to specify the database username (defaults to "root"). The ZING_DBPASS environment variable can be used to specify the database password. The ZING_DBZONE environment variable can be used to specify the database table name (defaults to "entities").

INHERITS

This package inherits behaviors from:

Zing::Store

LIBRARIES

This package uses type constraints from:

Zing::Types

ATTRIBUTES

This package has the following attributes:

client

client(InstanceOf["DBI::db"])

This attribute is read-only, accepts (InstanceOf["DBI::db"]) values, and is optional.

METHODS

This package implements the following methods:

decode

decode(Str $data) : HashRef

The decode method decodes the JSON data provided and returns the data as a hashref.

decode example #1
# given: synopsis

$store->decode('{"status"=>"ok"}');

drop

drop(Str $key) : Int

The drop method removes (drops) the item from the datastore.

drop example #1
# given: synopsis

$store->drop('zing:main:global:model:temp');

encode

encode(HashRef $data) : Str

The encode method encodes and returns the data provided as JSON.

encode example #1
# given: synopsis

$store->encode({ status => 'ok' });

keys

keys(Str @keys) : ArrayRef[Str]

The keys method returns a list of keys under the namespace of the datastore or provided key.

keys example #1
# given: synopsis

my $keys = $store->keys('zing:main:global:model:temp');
keys example #2
# given: synopsis

$store->send('zing:main:global:model:temp', { status => 'ok' });

my $keys = $store->keys('zing:main:global:model:temp');

lpull

lpull(Str $key) : Maybe[HashRef]

The lpull method pops data off of the top of a list in the datastore.

lpull example #1
# given: synopsis

$store->lpull('zing:main:global:model:items');
lpull example #2
# given: synopsis

$store->rpush('zing:main:global:model:items', { status => 'ok' });

$store->lpull('zing:main:global:model:items');

lpush

lpush(Str $key, HashRef $val) : Int

The lpush method pushed data onto the top of a list in the datastore.

lpush example #1
# given: synopsis

$store->lpush('zing:main:global:model:items', { status => '1' });
lpush example #2
# given: synopsis

$store->lpush('zing:main:global:model:items', { status => '0' });

$store->lpush('zing:main:global:model:items', { status => '0' });

recv

recv(Str $key) : Maybe[HashRef]

The recv method fetches and returns data from the datastore by its key.

recv example #1
# given: synopsis

$store->recv('zing:main:global:model:temp');
recv example #2
# given: synopsis

$store->send('zing:main:global:model:temp', { status => 'ok' });

$store->recv('zing:main:global:model:temp');

rpull

rpull(Str $key) : Maybe[HashRef]

The rpull method pops data off of the bottom of a list in the datastore.

rpull example #1
# given: synopsis

$store->rpull('zing:main:global:model:items');
rpull example #2
# given: synopsis

$store->rpush('zing:main:global:model:items', { status => 1 });
$store->rpush('zing:main:global:model:items', { status => 2 });

$store->rpull('zing:main:global:model:items');

rpush

rpush(Str $key, HashRef $val) : Int

The rpush method pushed data onto the bottom of a list in the datastore.

rpush example #1
# given: synopsis

$store->rpush('zing:main:global:model:items', { status => 'ok' });
rpush example #2
# given: synopsis

$store->rpush('zing:main:global:model:items', { status => 'ok' });

$store->rpush('zing:main:global:model:items', { status => 'ok' });

send

send(Str $key, HashRef $val) : Str

The send method commits data to the datastore with its key and returns truthy.

send example #1
# given: synopsis

$store->send('zing:main:global:model:temp', { status => 'ok' });

size

size(Str $key) : Int

The size method returns the size of a list in the datastore.

size example #1
# given: synopsis

my $size = $store->size('zing:main:global:model:items');
size example #2
# given: synopsis

$store->rpush('zing:main:global:model:items', { status => 'ok' });

my $size = $store->size('zing:main:global:model:items');

slot

slot(Str $key, Int $pos) : Maybe[HashRef]

The slot method returns the data from a list in the datastore by its index.

slot example #1
# given: synopsis

my $model = $store->slot('zing:main:global:model:items', 0);
slot example #2
# given: synopsis

$store->rpush('zing:main:global:model:items', { status => 'ok' });

my $model = $store->slot('zing:main:global:model:items', 0);

test

test(Str $key) : Int

The test method returns truthy if the specific key (or datastore) exists.

test example #1
# given: synopsis

$store->rpush('zing:main:global:model:items', { status => 'ok' });

$store->test('zing:main:global:model:items');
test example #2
# given: synopsis

$store->drop('zing:main:global:model:items');

$store->test('zing:main:global:model:items');

AUTHOR

Al Newkirk, awncorp@cpan.org

LICENSE

Copyright (C) 2011-2019, Al Newkirk, et al.

This is free software; you can redistribute it and/or modify it under the terms of the The Apache License, Version 2.0, as elucidated in the "license file".

PROJECT

Wiki

Project

Initiatives

Milestones

Contributing

Issues