The London Perl and Raku Workshop takes place on 26th Oct 2024. If your company depends on Perl, please consider sponsoring and/or attending.

NAME

Business::BancaSella::Ris::Mysql - Check the existance of One-Time-Password from a mysql database

SYNOPSIS

  use Business::BancaSella::Ris;
  
  my $ric = new Business::BancaSella::Ris::Mysql(
                                dbh             => $DBI_handle,
                                tableName       => $table_with_otp,
                                fieldName       => $field_with_otp
                                );
  my $ok = $ris->check($otp);
  if ($ok) {$ris->remove($otp));

DESCRIPTION

This module check if One-Time-Password is present in a mysql database and it could remove it.

METHODS

dbh()

Set or get and active DBI handle to Mysql database where OTP are stored.

fieldName()

Set or get the field name of the table where OTP are stored.

tableName()

Set or get the table name where OTP are stored

extract(otp)

Check password and return false if not found, else remove password from table.

check(otp)

Return TRUE or FALSE if the OTP is present in mysql database.

remove(otp)

Remove the OTP if present in the mysql database. Raise an error if not present.

prepare(source_file)

Insert into database passwords from $source_file that have one password on each row.

AUTHOR

Bruni Emiliano, info@ebruni.it

SEE ALSO

Business::BancaSella::Ric::File