MysqlOutputter class - Documentation for Pelzini

Info Page:

Page options:

class MysqlOutputter

Outputs the tree as MySQL

File: /processor/mysql_outputter.php
Namespace: processor
Extends: DatabaseOutputter
Available since:

Authors

Josh

Variables

Name	Visibility	Description
`$database`
`$db`
`$extra_insert_data`
`$password`
`$server`
`$since_versions`	(static)
`$username`

Functions

Name	Visibility	Description
__construct	public	Connects to the db
__destruct	public	Closes connection to the db
addSinceVersion	public (static)	Adds a @since version to from a CodeParserItem to the internal list
affected_rows	protected	Returns the number of rows affected in the last query
check_layout	public	Updates the database layout to match the layout file
commit_transaction	protected	The database engine should commit a transaction. If transactions are not supported, it should do nothing.
connect	protected	Connects to the MySQL database
create_table	protected	Creates a table
do_insert	protected	Executes an insert query for the data provided.
do_multiple_insert	protected	Executes an insert query for the data provided.
do_update	protected	Executes an update query for the data provided.
fetch_assoc	protected	Fetches a row from the database (assoc)
fetch_row	protected	Fetches a row from the database (numerical)
getSinceVersionId	private	Gets the database id of a record for a specific @since version
get_alter_column_query	protected	Gets the query that alters a column to match the new SQL definition
get_column_details	protected	Should return a multi-dimentional array of the column details
get_index_details	protected	Should return a multi-dimentional array of the index details
get_sql_type	protected	Converts an internal type into the database-specific SQL type.
get_table_list	protected	Returns an array of the tables in this database
insert_id	protected	Returns the autogenerated id created in the last query
output	public	Does the actual outputting of the file objects (and theihttps://www.nationalcrimecheck.com.au/r sub-objects) to the database
query	protected	Executes a MySQL query
rollback_transaction	protected	The database engine should rollback a transaction. If transactions are not supported, it should do nothing.
save_author_items	private	Saves author information about an item
save_class	private	Saves a class to the database
save_constant	private	Saves a constant to the database
save_enumeration	private	Saves a enumeration to the database
save_example_items	private	Saves 'example' information about an item
save_function	private	Saves a function to the database
save_info_tag_items	private	Saves info tags for an item
save_interface	private	Saves an interface to the database
save_see_items	private	Saves 'see also' information about an item
save_table_items	private	Saves table usage information about an item
save_variable	private	Saves a variable to the database
sql_safen	protected	Safens some input
start_transaction	protected	The database engine should start a transaction. If transactions are not supported, it should do nothing.

public __construct

void $MysqlOutputter->__construct ( mixed $username , mixed $password , mixed $server , mixed $database );

Connects to the db

public __destruct

void $MysqlOutputter->__destruct ( );

Closes connection to the db

public addSinceVersion (from DatabaseOutputter)

void DatabaseOutputter::addSinceVersion ( CodeParserItem $parser_item , mixed $parent );

Adds a @since version to from a CodeParserItem to the internal list
This list is used to fill a table with all of the versions of the program in existance

protected affected_rows

unknown $MysqlOutputter->affected_rows ( mixed $res );

Returns the number of rows affected in the last query

public check_layout (from DatabaseOutputter)

unknown $DatabaseOutputter->check_layout ( string $layout_filename );

Updates the database layout to match the layout file
NOTE: currently only supports column and table adding and updating, not removal.

protected commit_transaction

void $MysqlOutputter->commit_transaction ( );

The database engine should commit a transaction. If transactions are not supported, it should do nothing.

protected connect

unknown $MysqlOutputter->connect ( );

Connects to the MySQL database

protected create_table

void $MysqlOutputter->create_table ( mixed $table_name , mixed $dest_table );

Creates a table

protected do_insert (from DatabaseOutputter)

void $DatabaseOutputter->do_insert ( mixed $table , mixed $data );

Executes an insert query for the data provided.

protected do_multiple_insert (from DatabaseOutputter)

void $DatabaseOutputter->do_multiple_insert ( mixed $table , mixed $data );

Executes an insert query for the data provided.

protected do_update (from DatabaseOutputter)

void $DatabaseOutputter->do_update ( mixed $table , mixed $data , mixed $where );

Executes an update query for the data provided.

protected fetch_assoc

unknown $MysqlOutputter->fetch_assoc ( mixed $res );

Fetches a row from the database (assoc)

protected fetch_row

unknown $MysqlOutputter->fetch_row ( mixed $res );

Fetches a row from the database (numerical)

private getSinceVersionId (from DatabaseOutputter)

unknown $DatabaseOutputter->getSinceVersionId ( mixed $since_version );

Gets the database id of a record for a specific @since version

protected get_alter_column_query

unknown $MysqlOutputter->get_alter_column_query ( mixed $table , mixed $column_name , mixed $new_type , mixed $not_null );

Gets the query that alters a column to match the new SQL definition

protected get_column_details

unknown $MysqlOutputter->get_column_details ( mixed $table_name );

Should return a multi-dimentional array of the column details
Format:
Array [
  [0] => Array [
     'Field' => field name
     'Type' => field type, (e.g. 'serial', 'smallnum' or 'identifier')
     'NotNull' => nullable?, (true or false)
     'Key' => indexed?, ('PRI' for primary key)
     ]
   [1] => ...
   [n] => ...

protected get_index_details

unknown $MysqlOutputter->get_index_details ( mixed $table_name );

Should return a multi-dimentional array of the index details
Format:
Array [
  [0] => Array [
     'Fields' => array of field names
     ]
  [1] => ...
  [n] => ...

protected get_sql_type

string $MysqlOutputter->get_sql_type ( string $internal_type_name );

Converts an internal type into the database-specific SQL type.
The defined internal types are:
  - serial: a number that automatically increments whenever a record is added
  - smallnum: a small number. needs to be able to hold at least 32,767 possible values (e.g. a 16-bit signed integer)
  - largenum: a large number. needs to be the same size or larger than a serial type
  - string: a character field long enough to hold identifiers of objects (e.g. function names)
  - text: a field that can hold arbitary pieces of text larger than 65536 chars in length.

protected get_table_list

unknown $MysqlOutputter->get_table_list ( );

Returns an array of the tables in this database

protected insert_id

unknown $MysqlOutputter->insert_id ( );

Returns the autogenerated id created in the last query

public output (from DatabaseOutputter)

unknown $DatabaseOutputter->output ( array $files , Config $config );

Does the actual outputting of the file objects (and theihttps://www.nationalcrimecheck.com.au/r sub-objects) to the database

protected query

unknown $MysqlOutputter->query ( mixed $query );

Executes a MySQL query

protected rollback_transaction

void $MysqlOutputter->rollback_transaction ( );

The database engine should rollback a transaction. If transactions are not supported, it should do nothing.

private save_author_items (from DatabaseOutputter)

void $DatabaseOutputter->save_author_items ( mixed $link_type , mixed $link_id , mixed $items );

Saves author information about an item

private save_class (from DatabaseOutputter)

void $DatabaseOutputter->save_class ( mixed $class , mixed $file_id , mixed $file_namespace );

Saves a class to the database

private save_constant (from DatabaseOutputter)

void $DatabaseOutputter->save_constant ( mixed $constant [, mixed $file_id [, mixed $enumeration_id ]] );

Saves a constant to the database

private save_enumeration (from DatabaseOutputter)

void $DatabaseOutputter->save_enumeration ( mixed $enumeration [, mixed $file_id ] );

Saves a enumeration to the database

private save_example_items (from DatabaseOutputter)

void $DatabaseOutputter->save_example_items ( mixed $link_type , mixed $link_id , mixed $items );

Saves 'example' information about an item

private save_function (from DatabaseOutputter)

void $DatabaseOutputter->save_function ( mixed $function , mixed $file_id , mixed $class_id , mixed $interface_id , mixed $file_namespace );

Saves a function to the database

private save_info_tag_items (from DatabaseOutputter)

void $DatabaseOutputter->save_info_tag_items ( mixed $link_type , mixed $link_id , mixed $items );

Saves info tags for an item

private save_interface (from DatabaseOutputter)

void $DatabaseOutputter->save_interface ( mixed $interface , mixed $file_id , mixed $file_namespace );

Saves an interface to the database

private save_see_items (from DatabaseOutputter)

void $DatabaseOutputter->save_see_items ( mixed $link_type , mixed $link_id , mixed $items );

Saves 'see also' information about an item

private save_table_items (from DatabaseOutputter)

void $DatabaseOutputter->save_table_items ( mixed $link_type , mixed $link_id , mixed $items );

Saves table usage information about an item

private save_variable (from DatabaseOutputter)

void $DatabaseOutputter->save_variable ( mixed $variable [, mixed $class_id [, mixed $interface_id ]] );

Saves a variable to the database

protected sql_safen

unknown $MysqlOutputter->sql_safen ( string $input );

Safens some input

protected start_transaction

void $MysqlOutputter->start_transaction ( );

The database engine should start a transaction. If transactions are not supported, it should do nothing.

Pelzini

Search documentation