{
    "content": [
        {
            "type": "text",
            "text": "# Apache::Session::Store::MySQL (perldoc)\n\n## NAME\n\nApache::Session::Store::MySQL - Store persistent data in a MySQL database\n\n## SYNOPSIS\n\nuse Apache::Session::Store::MySQL;\nmy $store = new Apache::Session::Store::MySQL;\n$store->insert($ref);\n$store->update($ref);\n$store->materialize($ref);\n$store->remove($ref);\n\n## DESCRIPTION\n\nApache::Session::Store::MySQL fulfills the storage interface of Apache::Session. Session data is\nstored in a MySQL database.\n\n## Sections\n\n- **NAME**\n- **SYNOPSIS**\n- **DESCRIPTION**\n- **SCHEMA**\n- **CONFIGURATION**\n- **AUTHOR**\n- **SEE ALSO**\n\nUse structuredContent.sections for detailed options, examples, and full documentation.\n"
        }
    ],
    "structuredContent": {
        "command": "Apache::Session::Store::MySQL",
        "section": "",
        "mode": "perldoc",
        "summary": "Apache::Session::Store::MySQL - Store persistent data in a MySQL database",
        "synopsis": "use Apache::Session::Store::MySQL;\nmy $store = new Apache::Session::Store::MySQL;\n$store->insert($ref);\n$store->update($ref);\n$store->materialize($ref);\n$store->remove($ref);",
        "tldr_summary": null,
        "tldr_examples": [],
        "tldr_source": null,
        "flags": [],
        "examples": [],
        "see_also": [],
        "section_outline": [
            {
                "name": "NAME",
                "lines": 2,
                "subsections": []
            },
            {
                "name": "SYNOPSIS",
                "lines": 9,
                "subsections": []
            },
            {
                "name": "DESCRIPTION",
                "lines": 3,
                "subsections": []
            },
            {
                "name": "SCHEMA",
                "lines": 15,
                "subsections": []
            },
            {
                "name": "CONFIGURATION",
                "lines": 25,
                "subsections": []
            },
            {
                "name": "AUTHOR",
                "lines": 2,
                "subsections": []
            },
            {
                "name": "SEE ALSO",
                "lines": 2,
                "subsections": []
            }
        ],
        "sections": {
            "NAME": {
                "content": "Apache::Session::Store::MySQL - Store persistent data in a MySQL database\n",
                "subsections": []
            },
            "SYNOPSIS": {
                "content": "use Apache::Session::Store::MySQL;\n\nmy $store = new Apache::Session::Store::MySQL;\n\n$store->insert($ref);\n$store->update($ref);\n$store->materialize($ref);\n$store->remove($ref);\n",
                "subsections": []
            },
            "DESCRIPTION": {
                "content": "Apache::Session::Store::MySQL fulfills the storage interface of Apache::Session. Session data is\nstored in a MySQL database.\n",
                "subsections": []
            },
            "SCHEMA": {
                "content": "To use this module, you will need at least these columns in a table called 'sessions', or\nanother table name if you provide the TableName argument:\n\nid char(32)     # or however long your session IDs are.\nasession blob  # or varbinary if you plan to use a big session (>64k after serialization)\n\nTo create this schema, you can execute this command using the mysql program:\n\nCREATE TABLE sessions (\nid char(32) not null primary key,\nasession blob\n);\n\nIf you use some other command, ensure that there is a unique index on the table's id column.\n",
                "subsections": []
            },
            "CONFIGURATION": {
                "content": "The module must know what datasource, username, and password to use when connecting to the\ndatabase. These values can be set using the options hash (see Apache::Session documentation).\nThe options are:\n\nDataSource\nUserName\nPassword\nTableName\nHandle\n\nExample:\n\ntie %hash, 'Apache::Session::MySQL', $id, {\nDataSource => 'dbi:mysql:database',\nUserName   => 'databaseuser',\nPassword   => 'K00l',\nTableName  => 'sessions'\n};\n\nInstead, you may pass in an already-opened DBI handle to your database.\n\ntie %hash, 'Apache::Session::MySQL', $id, {\nHandle => $dbh\n};\n",
                "subsections": []
            },
            "AUTHOR": {
                "content": "This modules was written by Jeffrey William Baker <jwbaker@acm.org>\n",
                "subsections": []
            },
            "SEE ALSO": {
                "content": "Apache::Session\n",
                "subsections": []
            }
        }
    }
}