SQLite::Work::CGI SQLite::Work::CGI is a Perl module to report and update a SQLite database using CGI.
Download

SQLite::Work::CGI Ranking & Summary

SQLite::Work::CGI Tags

database SQLite database SQLite Perl module cgi database report

SQLite::Work::CGI Description

SQLite::Work::CGI is a Perl module to report and update a SQLite database using CGI. SQLite::Work::CGI is a Perl module to report and update a SQLite database using CGI.CLASS METHODSnewmy $obj = SQLite::Work->new( database=>$database_file, row_ids=>{ episodes=>'title_id', }, join_cols=>{ 'episodes+recordings'=>'title_id', } }, report_template=>$report_template, default_format=>{ 'episodes' => { 'title'=>'title', 'series_title'=>'title', } }, input_format=>{ 'reviews' => { 'Review'=>{ type=>'textarea', cols=>60, rows=>4, } } }, max_sort_fields=>10, sort_label=>'Zsort', sort_reversed_prefix=>'Zsort_reversed_', headers_label=>'Zheader_', show_label=>'Zshow', where_prefix=>'Zwhere_', not_prefix=>'Znot_', );Make a new report object.Takes the same arguments as SQLite::Work::new() plus the following additions:input_formatThis contains information about what style of input field should be used for this particular column in this table. This is used for the Edit and Add forms.max_sort_fieldsThe maximum number of sort fields required (default: 10)sort_labelName of the sort parameter.sort_reversed_prefixPrefix of the sort-reversed parameters.headers_labelName of the headers parameter.show_labelName of the columns-to-show parameter.where_prefixPrefix of the 'where' parameters.not_prefixPrefix of the not-where parameters.OBJECT METHODSdo_select$obj->do_select($table, command=>'Search');Select data from a table in the database. Uses CGI to get most of the parameters.The 'command' is 'Search' by default; if it is something else, then the result generated has edit fields and buttons in it.do_single_updateUpdate a single column in a single row, or all columns in a single row.do_add_form$obj->do_add_form($table);Set up for adding a row to the database.do_addAdd a row to a table.do_single_deleteDelete a single row.make_search_formCreate the search form for the given table.my $form = $obj->make_search_form($table, %args);do_search_formDisplay the search form for the given table.make_table_formMake the table selection form.do_table_formDisplay the table selection form.Requirements:· Perl Requirements: · Perl

SQLite::Work::CGI Related Software