{
    "mode": "perldoc",
    "parameter": "Class::DBI::Test::SQLite",
    "section": "",
    "url": "https://www.chedong.com/phpMan.php/perldoc/Class%3A%3ADBI%3A%3ATest%3A%3ASQLite/json",
    "generated": "2026-08-22T17:53:27Z",
    "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}",
    "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": []
        }
    },
    "summary": "Class::DBI::Test::SQLite - Base class for Class::DBI tests",
    "flags": [],
    "examples": [],
    "see_also": []
}