perldoc > Apache::Session::Store::Sybase

man perldoc info pydoc3 ri search

📖 NAME

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

🚀 Quick Reference

Use Case	Command	Description
🔗 Initialize session store (datasource)	tie %hash, 'Apache::Session::Sybase', $id, { DataSource => '...', UserName => '...', Password => '...' };	Create a new session tied hash with database credentials
🔗 Initialize session store (existing handle)	tie %hash, 'Apache::Session::Sybase', $id, { Handle => $dbh };	Use an already-opened DBI handle
💾 Insert session	$store->insert( $ref );	Store a new session data reference
🔄 Update session	$store->update( $ref );	Update existing session data
📥 Retrieve session	$store->materialize( $ref );	Load session data from the database
🗑️ Delete session	$store->remove( $ref );	Remove session data from the database
✅ Commit changes	Commit => 1	Force commit after each write (required if not using AutoCommit)
📏 Set textsize	textsize => 65536	Override default TEXT/IMAGE field size (default 32K)

📝 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

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
• 👤 UserName
• 🔑 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

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