styleguide

Action: means the sub is called from GUI.pm via do('tables.pl'); eval('sub()');

sometimes it is possible that there also parameters used instead of param('table') values.

For example SaveNewTable() call ShowNewTable( 'table', 'column count' )

again if CREATE TABLE failed.

ShowNewTable($tbl,$count)

Action:

Shows a form to create a new table.

SaveNewTable()

Action: Dont call direct.

ShowDumpTable()

Action:

DumpTable($table)

Action: table will be appen to $m_sContent

in void context param('table') will be used.

ShowDumpDatabase()

Action

Export the Database.

DumpDatabase($database)

In void context the current db will be used.

HighlightSQl()

$formated_string = HighlightSQl();

In the past i used Syntax::Highlight::Kate,

i has some problems with this modul (installation failed on some host).

todo: HighlightSQl as html and link to mysql documentation.

AddFulltext($table,$indexName)

Action:

In void context param('table') and param('column') will be used.

DropFulltext($table,$indexName)

Action:

In void context param('table') and param('column') will be used.

AddIndex($table,$indexName)

Action:

In void context param('table') and param('column') will be used.

DropIndex($table,$indexName)

Action:

In void context param('table') and param('column') will be used.

AddUnique($table,$indexName))

Action:

In void context param('table') and param('column') will be used.

DropUnique($table,$indexName)

Action:

In void context param('table') and param('column') will be used.

ExecSql($sql,$boolShowSQL)

this is the 'main' sub to excute sql within this system.

If you write your own sub write something like this:

sub foo{

$m_sContent .= qq(

  #requestURI( url,id,txt )

  <a href="javascript:requestURI('$ENV{SCRIPT_NAME}?action=bar&foo=true','bar','bar');">
  bar
  </a>);

}

sub bar{

  ExecSql('select * from bar') if param('foo');
  

}

SQL()

Action: Excute SQL with the "SQL Editor".

ShowTable($table)

Action:

Call this to show the table overview.

MultipleAction()

Action:

Multiple Table Actions.

MultipleDbAction()

Action:

Multiple Database Actions

EditEntry()

Action:

     EditEntry( $table, $id )
     
     In void context param('table') and param('edit') will be used.

EditAction()

Action:

EditAction()

ShowNewEntry($table)

Action:

In void context param('table') will be used.

SaveEntry()

Action:

NewEntry()

Action:

DeleteEntry()

Action:

In void context param('table') will ne used.

round()

private

ShowTables()

Action:

DropTable()

Action:

ShowTableDetails($table)

Action:

AddPrimaryKey($table,$col)

action:

DropCol($table,$column)

Action:

TruncateTable($table)

Action:

EditTable($table)

Action:

ShowEditIndex()

Action:

SaveNewIndex()

Action:

SaveEditTable()

Action:

SaveNewColumn()

Action:

RenameTable($table,$newtable)

Action:

ChangeEngine($table,$engine)

Action:

ChangeAutoInCrementValue($table,$autoInCrement)

Action:

ShowDbHeader()

create the Table Menu and CreateDatabase CreateUser CreateTable ChangeCurrentDb SqlEditor SqlSearch forms.

_insertTables()

Action:

AnalyzeTable($table)

Action:

RepairTable($table)

Action:

OptimizeTable($table)

Action:

ShowUsers()

Action:

ShowRights()

Action:

initRights($user,$host)

the rights for $m_hUserRights will be initialized

HasRight()

private

GetTables()

Auswahliste (select) wird zurueck gegeben

       GetTables(name)
       todo nach Database.pm verschieben

GetDatabases()

Auswahliste (select) wird zurueck gegeben

       GetDatabases(name)
       todo nach Database.pm verschieben

GetUsers()

Auswahliste (select) wird zurueck gegeben

       GetUsers(name)
todo nach Database.pm verschieben
       

SaveRights()

Action:

CreateUser()

Action;

DeleteUser()

Action:

ShowDatabases()

Action:

DropDatabase($databaseName)

Action:

CreateDatabase($databaseName)

Action:

ShowProcesslist()

Action:

ShowVariables()

Action:

ChangeCharset()

Action:

searchForm()

Action:

searchDatabase()

Action:

cpanm MySQL::Admin

perl -MCPAN -e shell
install MySQL::Admin