man > Apache::Session::Store::Sybase

man perldoc info pydoc3 ri search

Apache::Session::Store::Sybase(3pm)         User Contributed Perl Documentation

📋 NAME

Apache::Session::Store::Sybase - Store persistent data in a Sybase database

🚀 Quick Reference

Use Case	Command	Description
📦 Create store object	my $store = new Apache::Session::Store::Sybase;	🆕 Create a new Sybase session store instance
➕ Insert session	$store->insert($ref);	💾 Insert a new session record into the database
🔄 Update session	$store->update($ref);	♻️ Update an existing session record
📂 Retrieve session	$store->materialize($ref);	📤 Retrieve session data from the database
🗑️ Remove session	$store->remove($ref);	❌ Delete a session record from the database
🔗 Tie with config	tie %hash, 'Apache::Session::Sybase', $id, { DataSource => '...', UserName => '...', Password => '...' };	🔐 Connect and manage sessions with database credentials
🔗 Tie with handle	tie %hash, 'Apache::Session::Sybase', $id, { Handle => $dbh };	🔌 Connect and manage sessions using an existing DBI handle
🗄️ Create schema	CREATE TABLE sessions ( id CHAR(32) not null primary key, a_session TEXT )	🏗️ Create the required sessions table in Sybase

📝 SYNOPSIS

use Apache::Session::Store::Sybase;

my $store = new Apache::Session::Store::MySQL;

$store->insert( $ref );
$store->update( $ref );
$store->materialize( $ref );
$store->remove( $ref );

📖 DESCRIPTION

Apache::Session::Store::Sybase fulfills the storage interface of Apache::Session. Session data is stored in a Sybase database.

🗄️ SCHEMA

To use this module, you will need at least these columns in a table called 'sessions':

• id CHAR(32) — 🔑 or however long your session IDs are.
• a_session IMAGE — 📦 stores the serialized session data

To create this schema, you can execute this command using the isql or sqsh programs:

CREATE TABLE sessions (
   id         CHAR(32) not null primary key,
   a_session  TEXT
)
go

If you use some other command, ensure that there is a unique index on the id column of the table.

⚙️ CONFIGURATION

The module must know what datasource, username, and password to use when connecting to the database. These values can be set using the options hash (see Apache::Session documentation). The options are:

• DataSource — 🗄️ DBI connection string (e.g. dbi:Sybase:database=db;server=server)
• UserName — 👤 database username
• Password — 🔑 database password

Example:

tie %hash, 'Apache::Session::Sybase', $id, {
    DataSource => 'dbi:Sybase:database=db;server=server',
    UserName   => 'database_user',
    Password   => 'K00l',
    Commit     => 1,
};

Instead, you may pass in an already-opened DBI handle to your database.

tie %hash, 'Apache::Session::Sybase', $id, {
    Handle => $dbh
};

Additional arguments you can pass to the backing store are:

• Commit — 💾 whether we should commit any changes; if you pass in an already-open database handle that has AutoCommit set to a true value, you do not need to set this. If you let Apache::Session::Store::Sybase create your database handle, you must set this to a true value, otherwise your changes will not be saved.
• textsize — 📏 the value we should pass to the set textsize command that sets the max size of the IMAGE field. Default is 32K (at least in Sybase ASE 11.9.2).

👤 AUTHOR

This module was based on Apache::Session::Store::Oracle which was written by Jeffrey William Baker <jwbaker AT acm.org>; it was modified by Chris Winters <chris AT cwinters.com> to work with Apache::Session 1.5+ with changes from earlier version of Apache::Session::DBI::Sybase from Mark Landry <mdlandry AT lincoln.com>.

🔗 SEE ALSO

Apache::Session

---

perl v5.30.3   2020-09-20   Apache::Session::Store::Sybase(3pm)

📋 NAME 🚀 Quick Reference 📝 SYNOPSIS 📖 DESCRIPTION 🗄️ SCHEMA ⚙️ CONFIGURATION 👤 AUTHOR 🔗 SEE ALSO