DBCRUD#

NAME#

Kernel::System::UnitTest::DBCRUD - DBCRUD test lib

SYNOPSIS#

All DBCRUD functions

PUBLIC INTERFACE#

new()#

create an object

my $DBCRUDTestObject = $Kernel::OM->Get('Kernel::System::UnitTest::DBCRUD');

DataAdd()#

add data to table

my $Success = $DBCRUDTestObject->DataAdd(
    ID          => '...',
    Name        => '...', # optional
    Age         => '...', # optional
    Description => '...', # optional
    ContentJSON => '...', # optional
    CreateTime  => '...', # optional
    ChangeTime  => '...', # optional
);

Returns:

my $Success = 1;

DataGet()#

get data attributes

my %Data = $DBCRUDTestObject->DataGet(
    ID          => '...', # optional
    Name        => '...', # optional
    Age         => '...', # optional
    Description => '...', # optional
    ContentJSON => '...', # optional
    CreateTime  => '...', # optional
    ChangeTime  => '...', # optional
);

Returns:

my %Data = (
    ID          => '...',
    Name        => '...',
    Age         => '...',
    Description => '...',
    ContentJSON => '...',
    CreateTime  => '...',
    ChangeTime  => '...',
);

DataListGet()#

get list data with attributes

my @Data = $DBCRUDTestObject->DataListGet(
    ID          => '...', # optional
    Name        => '...', # optional
    Age         => '...', # optional
    Description => '...', # optional
    ContentJSON => '...', # optional
    CreateTime  => '...', # optional
    ChangeTime  => '...', # optional
);

Returns:

my @Data = (
    {
        ID          => '...',
        Name        => '...',
        Age         => '...',
        Description => '...',
        ContentJSON => '...',
        CreateTime  => '...',
        ChangeTime  => '...',
    },
    # ...
);

DataSearch()#

search for value in defined attributes

my %Data = $DBCRUDTestObject->DataSearch(
    Search      => 'test*test',
    ID          => '...', # optional
    Name        => '...', # optional
    Age         => '...', # optional
    Description => '...', # optional
    ContentJSON => '...', # optional
    CreateTime  => '...', # optional
    ChangeTime  => '...', # optional
);

Returns:

my %Data = (
    '1' => {
        ID          => '...',
        Name        => '...',
        Age         => '...',
        Description => '...',
        ContentJSON => '...',
        CreateTime  => '...',
        ChangeTime  => '...',
    },
    # ...
);

DataDelete()#

remove data from table

my $Success = $DBCRUDTestObject->DataDelete(
    ID          => '...', # optional
    Name        => '...', # optional
    Age         => '...', # optional
    Description => '...', # optional
    ContentJSON => '...', # optional
    CreateTime  => '...', # optional
    ChangeTime  => '...', # optional
);

Returns:

my $Success = 1;

DataExport()#

exports data.

my $Export = $DBCRUDTestObject->DataExport(
    Format => 'yml',
    Cache  => 0,
);

Returns:

my $Export = 'STRING';

DataImport()#

imports data.

my $Success = $DBCRUDTestObject->DataImport(
    Content   => $ContentString,
    Format    => 'yml',                 # optional - default
    Overwrite => 1,                     # optional to overwrite existing data
    Data      => {                      # additional data if not all needed data exists
        ValidID => 1,
    }
);

Returns:

my $Success = 1;

InitConfig()#

init config for object

my $Success = $DBCRUDTestObject->InitConfig();

Returns:

my $Success = 1;