{
    "content": [
        {
            "type": "text",
            "text": "# DBD::Sponge (perldoc)\n\n## NAME\n\nDBD::Sponge - Create a DBI statement handle from Perl data\n\n## SYNOPSIS\n\nmy $sponge = DBI->connect(\"dbi:Sponge:\",\"\",\"\",{ RaiseError => 1 });\nmy $sth = $sponge->prepare($statement, {\nrows => $data,\nNAME => $names,\n%attr\n}\n);\n\n## DESCRIPTION\n\nDBD::Sponge is useful for making a Perl data structure accessible through a standard DBI\nstatement handle. This may be useful to DBD module authors who need to transform data in this\nway.\n\n## Sections\n\n- **NAME**\n- **SYNOPSIS**\n- **DESCRIPTION**\n- **METHODS**\n- **BUGS**\n- **AUTHOR AND COPYRIGHT**\n- **SEE ALSO**\n\nUse structuredContent.sections for detailed options, examples, and full documentation.\n"
        }
    ],
    "structuredContent": {
        "command": "DBD::Sponge",
        "section": "",
        "mode": "perldoc",
        "summary": "DBD::Sponge - Create a DBI statement handle from Perl data",
        "synopsis": "my $sponge = DBI->connect(\"dbi:Sponge:\",\"\",\"\",{ RaiseError => 1 });\nmy $sth = $sponge->prepare($statement, {\nrows => $data,\nNAME => $names,\n%attr\n}\n);",
        "tldr_summary": null,
        "tldr_examples": [],
        "tldr_source": null,
        "flags": [],
        "examples": [],
        "see_also": [],
        "section_outline": [
            {
                "name": "NAME",
                "lines": 2,
                "subsections": []
            },
            {
                "name": "SYNOPSIS",
                "lines": 8,
                "subsections": []
            },
            {
                "name": "DESCRIPTION",
                "lines": 4,
                "subsections": []
            },
            {
                "name": "METHODS",
                "lines": 29,
                "subsections": []
            },
            {
                "name": "BUGS",
                "lines": 2,
                "subsections": []
            },
            {
                "name": "AUTHOR AND COPYRIGHT",
                "lines": 8,
                "subsections": []
            },
            {
                "name": "SEE ALSO",
                "lines": 2,
                "subsections": []
            }
        ],
        "sections": {
            "NAME": {
                "content": "DBD::Sponge - Create a DBI statement handle from Perl data\n",
                "subsections": []
            },
            "SYNOPSIS": {
                "content": "my $sponge = DBI->connect(\"dbi:Sponge:\",\"\",\"\",{ RaiseError => 1 });\nmy $sth = $sponge->prepare($statement, {\nrows => $data,\nNAME => $names,\n%attr\n}\n);\n",
                "subsections": []
            },
            "DESCRIPTION": {
                "content": "DBD::Sponge is useful for making a Perl data structure accessible through a standard DBI\nstatement handle. This may be useful to DBD module authors who need to transform data in this\nway.\n",
                "subsections": []
            },
            "METHODS": {
                "content": "connect()\nmy $sponge = DBI->connect(\"dbi:Sponge:\",\"\",\"\",{ RaiseError => 1 });\n\nHere's a sample syntax for creating a database handle for the Sponge driver. No username and\npassword are needed.\n\nprepare()\nmy $sth = $sponge->prepare($statement, {\nrows => $data,\nNAME => $names,\n%attr\n}\n);\n\n*   The $statement here is an arbitrary statement or name you want to provide as identity of\nyour data. If you're using DBI::Profile it will appear in the profile data.\n\nGenerally it's expected that you are preparing a statement handle as if a \"select\" statement\nhappened.\n\n*   $data is a reference to the data you are providing, given as an array of arrays.\n\n*   $names is a reference an array of column names for the $data you are providing. The number\nand order should match the number and ordering of the $data columns.\n\n*   %attr is a hash of other standard DBI attributes that you might pass to a prepare statement.\n\nCurrently only NAME, TYPE, and PRECISION are supported.\n",
                "subsections": []
            },
            "BUGS": {
                "content": "Using this module to prepare INSERT-like statements is not currently documented.\n",
                "subsections": []
            },
            "AUTHOR AND COPYRIGHT": {
                "content": "This module is Copyright (c) 2003 Tim Bunce\n\nDocumentation initially written by Mark Stosberg\n\nThe DBD::Sponge module is free software; you can redistribute it and/or modify it under the same\nterms as Perl itself. In particular permission is granted to Tim Bunce for distributing this as\na part of the DBI.\n",
                "subsections": []
            },
            "SEE ALSO": {
                "content": "DBI\n",
                "subsections": []
            }
        }
    }
}