{
    "content": [
        {
            "type": "text",
            "text": "# Class::DBI::Test::SQLite (perldoc)\n\n## NAME\n\nClass::DBI::Test::SQLite - Base class for Class::DBI tests\n\n## SYNOPSIS\n\nuse base 'Class::DBI::Test::SQLite';\nPACKAGE->settable('test');\nPACKAGE->columns(All => qw/id name film salary/);\nsub createsql {\nreturn q{\nid     INTEGER PRIMARY KEY,\nname   CHAR(40),\nfilm   VARCHAR(255),\nsalary INT\n}\n}\n\n## DESCRIPTION\n\nThis provides a simple base class for Class::DBI tests using SQLite. Each class for the test\nshould inherit from this, provide a createsql() method which returns a string representing the\nSQL used to create the table for the class, and then call settable() to create the table, and\ntie it to the class.\n\n## Sections\n\n- **NAME**\n- **SYNOPSIS**\n- **DESCRIPTION**\n- **METHODS**\n\nUse structuredContent.sections for detailed options, examples, and full documentation.\n"
        }
    ],
    "structuredContent": {
        "command": "Class::DBI::Test::SQLite",
        "section": "",
        "mode": "perldoc",
        "summary": "Class::DBI::Test::SQLite - Base class for Class::DBI tests",
        "synopsis": "use base 'Class::DBI::Test::SQLite';\nPACKAGE->settable('test');\nPACKAGE->columns(All => qw/id name film salary/);\nsub createsql {\nreturn q{\nid     INTEGER PRIMARY KEY,\nname   CHAR(40),\nfilm   VARCHAR(255),\nsalary INT\n}\n}",
        "tldr_summary": null,
        "tldr_examples": [],
        "tldr_source": null,
        "flags": [],
        "examples": [],
        "see_also": [],
        "section_outline": [
            {
                "name": "NAME",
                "lines": 2,
                "subsections": []
            },
            {
                "name": "SYNOPSIS",
                "lines": 14,
                "subsections": []
            },
            {
                "name": "DESCRIPTION",
                "lines": 5,
                "subsections": []
            },
            {
                "name": "METHODS",
                "lines": 17,
                "subsections": []
            }
        ],
        "sections": {
            "NAME": {
                "content": "Class::DBI::Test::SQLite - Base class for Class::DBI tests\n",
                "subsections": []
            },
            "SYNOPSIS": {
                "content": "use base 'Class::DBI::Test::SQLite';\n\nPACKAGE->settable('test');\nPACKAGE->columns(All => qw/id name film salary/);\n\nsub createsql {\nreturn q{\nid     INTEGER PRIMARY KEY,\nname   CHAR(40),\nfilm   VARCHAR(255),\nsalary INT\n}\n}\n",
                "subsections": []
            },
            "DESCRIPTION": {
                "content": "This provides a simple base class for Class::DBI tests using SQLite. Each class for the test\nshould inherit from this, provide a createsql() method which returns a string representing the\nSQL used to create the table for the class, and then call settable() to create the table, and\ntie it to the class.\n",
                "subsections": []
            },
            "METHODS": {
                "content": "settable\nPACKAGE->settable('test');\n\nThis combines creating the table with the normal Class::DBI table() call.\n\ncreatesql (abstract)\nsub createsql {\nreturn q{\nid     INTEGER PRIMARY KEY,\nname   CHAR(40),\nfilm   VARCHAR(255),\nsalary INT\n}\n}\n\nThis should return, as a text string, the schema for the table represented by this class.\n",
                "subsections": []
            }
        }
    }
}