Docs For Class atki5db
Atk API home Class tree Element index

Todo list

Packages: » atk Classes: general » AllTests » atkConfig » atkController » atkDataNode » atkErrorHandlerBase » atkFileEditor » atkLanguage » atkMailErrorHandler » atkMetaNode » atkMockNode » atkNode » atkNodeValidator » atkOneToManyRelationSessionGridHandler » atkPHPView » atkSessionStore » atkStatementIterator » atkTreeNode » atkWizardBase » atkZendPlatformErrorHandler » clsTbsDataSource » clsTbsLocator » clsTinyButStrong » clsTinyButStrongOOo » FCKeditor » getSupportedLanguagesCollector » layout » node » sql_whereclause_blacklist_checker » test » tree utils » atkAbstractFrame » atkActionListener » atkClassFinder » atkClassLoader » atkCompatSelector » atkDataHolder » atkDebugger » atkDirectoryTraverser » atkEventLog » atkFileUtils » atkFrame » atkFrameSet » atkIpUtils » atkJSON » atkMail » atkMailer » atkMessageQueue » atkMLSelector » atkmlsplitter » atkRootFrameset » atkSelector » atkSelectorIterator » atkString » atkStringParser » atkTableRenderer » atkTableRendererGrouped » atkTextMarker » atkTmpFile » atkTriggerListener » atkYAML » atkZip » browserInfo fixture » atkAbstractFixtureLoader » atkFixtureManager » atkPHPFixtureLoader » atkYAMLFixtureLoader testcases » atkAbstractSearchHandler ui » atkActionBoxBuilder » atkDialog » atkIndexPage » atkOutput » atkPage » atkPageBuilder » atkTheme » atkThemeCompiler » atkUI handlers » atkActionHandler » atkAddHandler » atkAddOrCopyHandler » atkAdminHandler » atkAttributeEditHandler » atkCopyHandler » atkDeleteHandler » atkDocumentHandler » atkEditCopyHandler » atkEditHandler » atkExportHandler » atkFeedbackHandler » atkFileExport » atkImportHandler » atkMultiSelectHandler » atkMultiUpdatehandler » atkSaveHandler » atkSearchHandler » atkSelectHandler » atkSmartSearchHandler » atkUpdatehandler » atkViewEditBase » atkViewHandler » atkXmlHandler attributes » atkAggregatedColumn » atkAttribute » atkBoolAttribute » atkCalculatorAttribute » atkCaptchaAttribute » atkColorPickerAttribute » atkCountryAttribute » atkCreatedByAttribute » atkCreateStampAttribute » atkCurrencyAttribute » atkDateAttribute » atkDateTimeAttribute » atkDocumentAttribute » atkDummyAttribute » atkDurationAttribute » atkEmailAttribute » atkExpressionAttribute » atkFckAttribute » atkFieldSet » atkFileAttribute » atkFileWriterAttribute » atkFlagAttribute » atkFormatAttribute » atkFuzzySearchAttribute » atkHiddenAttribute » atkHtmlAttribute » atkIpAttribute » atkListAttribute » atkLiveTextPreview » atkMlAttribute » atkMlFckAttribute » atkMlHtmlAttribute » atkMlNumberAttribute » atkMlSelectorAttribute » atkMlTextAttribute » atkMlWrapper » atkMultipleFileAttribute » atkMultiSelectAttribute » atkNumberAttribute » atkParserAttribute » atkPasswordAttribute » atkProfileAttribute » atkRadioAttribute » atkRadioDetailsAttribute » atkRowCounter » atkStateAttribute » atkTabbedPane » atkTagAttribute » atkTextAttribute » atkTimeAttribute » atkTimeZoneAttribute » atkToolbar » atkUpdatedByAttribute » atkUpdateStampAttribute » atkUrlAttribute » atkWeekdayAttribute » atkWysiwygAttribute datatypes » atkArrayDt » atkDataType » atkStringDt » atkTime subpackage » atkAttributeTestCase security » atkBajusEncryption » atkBase64Encryption » atkEncryption » atkMockSecurityManager » atkOpenSSLEncryption » atkSecurityListener » atkSecurityManager » atkUrlVault » auth_config » auth_db » auth_imap » auth_interface » auth_ldap » auth_none » auth_pop3 » auth_saml » auth_server » auth_sspi cache » atkCache » atkCache_apc » atkCache_eaccelerator » atkCache_file » atkCache_memcache » atkCache_var » atkCache_xcache » atkCache_zp_disk » atkCache_zp_output » atkCache_zp_shm test » atkCacheTestCase » atkPluginTestCase » atkTestCase » test_sql_whereclause_blacklist_checker db » atkClusterDb » atkClusterDDL » atkClusterQuery » atkDb » atkdb2db » atkDb2DDL » atkDb2Query » atkDDL » atki5db » atki5DDL » atki5query » atkMockDb » atkMockDDL » atkMockQuery » atkMsSqlDb » atkMsSqlDDL » atkMssqlQuery » atkMysqlDb » atkMysqlDDL » atkMysqliDb » atkMysqliDDL » atkMysqliQuery » atkMysqlQuery » atkOci8Db » atkOci8DDL » atkOci8Query » atkOci9Db » atkOci9DDL » atkOci9Query » atkOci805Db » atkOci805Query » atkPgsqlDb » atkPgsqlDDL » atkPgsqlQuery » atkQuery recordlist » atkColumnConfig » atkCSVRecordList » atkCustomRecordList » atkExcelCSVRecordList » atkHTMLRecordList » atkPrintableRecordList » atkRecordList » atkRecordlistCache » atkTotalizer db-statement » atkCompatStatement » atkMySQLiStatement » atkStatement » atkStatementException » atkStatementParser console » atkConsoleController menu » atkcookmenu » atkDhtmlMenu » atkDropdownMenu » atkFramesMenu » atkMenu » atkmenuinterface » atkModernMenu » atkOutlookMenu » atkPlainMenu datagrid » atkDataGrid » atkDGComponent » atkDGEditControl » atkDGEvent » atkDGIndex » atkDGLimit » atkDGList » atkDGNoRecordsFound » atkDGPaginator » atkDGRenderer » atkDGSummary lock » atkDbLock » atkLock filters » atkDistinctFilter » atkFilter » atkGroupByFilter document » atkDocumentWriter » atkDocxWriter » atkOpenDocumentWriter meta » atkDutchMetaGrammar » atkMetaAttributeModifier » atkMetaCompiler » atkMetaGrammar » atkMetaPolicy » mod_meta relations » atkExtendableShuttleRelation » atkManyBoolRelation » atkManyToManyListRelation » atkManyToManyRelation » atkManyToManySelectRelation » atkManyToOneRelation » atkManyToOneTreeRelation » atkMatrixRelation » atkOneToManyRelation » atkOneToOneRelation » atkPolymorphicOneToOneRelation » atkRelation » atkSecureRelation » atkShuttleControl » atkShuttleFilter » atkShuttleRelation front » atkFrontController » atkFrontControllerBridge keyboard » atkKeyboard meta-relations » atkMetaExtendableShuttleRelation » atkMetaManyBoolRelation » atkMetaManyToManyListRelation » atkMetaManyToManySelectRelation » atkMetaManyToOneRelation » atkMetaOneToManyRelation » atkMetaOneToOneRelation » atkMetaShuttleRelation session » atkMockSessionManager » atkSessionManager » atkState modules » atkModule » mod_test listeners » atkRecycleBin interface » atkServer » atkSoapServer wizard » atkWizard » AtkWizardActionLoader » atkWizardPanel
Interfaces: datagrid » atkDGListener interface » atkServerInterface
Files: general » adodb-time.inc.php » AllTests.php » atknodetools.inc » atktools.inc » atktreetools.inc » basexml.php » bootstrap.inc » bootstrap.php » class.atkconfig.inc » class.atkcontroller.inc » class.atkdatanode.inc » class.atkerrorhandlerbase.inc » class.atkfileeditor.inc » class.atki5db.inc » class.atki5ddl.inc » class.atki5query.inc » class.atklanguage.inc » class.atkmailerrorhandler.inc » class.atkmetanode.inc » class.atkmocknode.inc » class.atkmocksessionmanager.inc » class.atknode.inc » class.atknodevalidator.inc » class.atkonetomanyrelationsessiongridhandler.inc » class.atkphpview.inc » class.atkpolymorphiconetoonerelation.inc » class.atksessionstore.inc » class.atkstatementiterator.inc » class.atktreenode.inc » class.atkwizardbase.inc » class.atkzendplatformerrorhandler.inc » class.layout.inc » class.nodename.inc » class.sql_whereclause_blacklist_checker.inc » class.test.inc » class.test_sql_whereclause_blacklist_checker.inc » commands.php » config.modules.inc » config.php » connector.php » console.php » db2yaml.php » defaultconfig.inc.php » fckeditor.php » fckeditor_php4.php » fckeditor_php5.php » io.php » module.inc » phpcompat.php » server.php » spellchecker.php » table2yaml.php » tbsooo_class.php » tbs_class.php » tooltip.tpl.php » upload.php » util.php » version.inc attributes » class.atkaggregatedcolumn.inc » class.atkattribute.inc » class.atkboolattribute.inc » class.atkcalculatorattribute.inc » class.atkcaptchaattribute.inc » class.atkcolorpickerattribute.inc » class.atkcountryattribute.inc » class.atkcreatedbyattribute.inc » class.atkcreatestampattribute.inc » class.atkcurrencyattribute.inc » class.atkdateattribute.inc » class.atkdatetimeattribute.inc » class.atkdocumentattribute.inc » class.atkdummyattribute.inc » class.atkdurationattribute.inc » class.atkemailattribute.inc » class.atkexpressionattribute.inc » class.atkfckattribute.inc » class.atkfieldset.inc » class.atkfileattribute.inc » class.atkfilewriterattribute.inc » class.atkflagattribute.inc » class.atkformatattribute.inc » class.atkfuzzysearchattribute.inc » class.atkhiddenattribute.inc » class.atkhtmlattribute.inc » class.atkipattribute.inc » class.atklistattribute.inc » class.atklivetextpreview.inc » class.atkmlattribute.inc » class.atkmlfckattribute.inc » class.atkmlhtmlattribute.inc » class.atkmlnumberattribute.inc » class.atkmlselectorattribute.inc » class.atkmltextattribute.inc » class.atkmlwrapper.inc » class.atkmultiplefileattribute.inc » class.atkmultiselectattribute.inc » class.atknumberattribute.inc » class.atkparserattribute.inc » class.atkpasswordattribute.inc » class.atkprofileattribute.inc » class.atkradioattribute.inc » class.atkradiodetailsattribute.inc » class.atkrowcounter.inc » class.atkstateattribute.inc » class.atktabbedpane.inc » class.atktagattribute.inc » class.atktextattribute.inc » class.atktimeattribute.inc » class.atktimezoneattribute.inc » class.atktoolbar.inc » class.atkupdatedbyattribute.inc » class.atkupdatestampattribute.inc » class.atkurlattribute.inc » class.atkweekdayattribute.inc » class.atkwysiwygattribute.inc attributes-- » property_accessor.php cache » class.atkcache.inc » class.atkcache_apc.inc » class.atkcache_eaccelerator.inc » class.atkcache_file.inc » class.atkcache_memcache.inc » class.atkcache_var.inc » class.atkcache_xcache.inc » class.atkcache_zp_disk.inc » class.atkcache_zp_output.inc » class.atkcache_zp_shm.inc console » class.atkconsolecontroller.inc datagrid » class.atkdatagrid.inc » class.atkdgcomponent.inc » class.atkdgeditcontrol.inc » class.atkdgevent.inc » class.atkdgindex.inc » class.atkdglimit.inc » class.atkdglist.inc » class.atkdglistener.inc » class.atkdgnorecordsfound.inc » class.atkdgpaginator.inc » class.atkdgrenderer.inc » class.atkdgsummary.inc datatypes » class.atkarraydt.inc » class.atkdatatype.inc » class.atkstringdt.inc » class.atktimedt.inc db » class.atkclusterdb.inc » class.atkclusterddl.inc » class.atkclusterquery.inc » class.atkdb.inc » class.atkdb2db.inc » class.atkdb2ddl.inc » class.atkdb2query.inc » class.atkddl.inc » class.atkmockdb.inc » class.atkmockddl.inc » class.atkmockquery.inc » class.atkmssqldb.inc » class.atkmssqlddl.inc » class.atkmssqlquery.inc » class.atkmysqldb.inc » class.atkmysqlddl.inc » class.atkmysqlidb.inc » class.atkmysqliddl.inc » class.atkmysqliquery.inc » class.atkmysqlquery.inc » class.atkoci8db.inc » class.atkoci8ddl.inc » class.atkoci8query.inc » class.atkoci9db.inc » class.atkoci9ddl.inc » class.atkoci9query.inc » class.atkoci805db.inc » class.atkoci805query.inc » class.atkpgsqldb.inc » class.atkpgsqlddl.inc » class.atkpgsqlquery.inc » class.atkquery.inc db-statement » class.atkcompatstatement.inc » class.atkmysqlistatement.inc » class.atkstatement.inc » class.atkstatementexception.inc » class.atkstatementparser.inc document » class.atkdocumentwriter.inc » class.atkdocxwriter.inc » class.atkopendocumentwriter.inc filters » class.atkdistinctfilter.inc » class.atkfilter.inc » class.atkgroupbyfilter.inc fixture » class.atkabstractfixtureloader.inc » class.atkfixturemanager.inc » class.atkphpfixtureloader.inc » class.atkyamlfixtureloader.inc front » class.atkfrontcontroller.inc » class.atkfrontcontrollerbridge.inc handlers » class.atkactionhandler.inc » class.atkaddhandler.inc » class.atkaddorcopyhandler.inc » class.atkadminhandler.inc » class.atkattributeedithandler.inc » class.atkcopyhandler.inc » class.atkdeletehandler.inc » class.atkdocumenthandler.inc » class.atkeditcopyhandler.inc » class.atkedithandler.inc » class.atkexporthandler.inc » class.atkfeedbackhandler.inc » class.atkfileexport.inc » class.atkimporthandler.inc » class.atkmultiselecthandler.inc » class.atkmultiupdatehandler.inc » class.atksavehandler.inc » class.atksearchhandler.inc » class.atkselecthandler.inc » class.atksmartsearchhandler.inc » class.atkupdatehandler.inc » class.atkvieweditbase.inc » class.atkviewhandler.inc » class.atkxmlhandler.inc include » autoload.inc » basics.inc » compatibility.inc » configs.inc » debugging.inc » errorhandler.inc » globals.inc » initial.inc » security.inc interface » class.atkserver.inc » class.atksoapserver.inc » interface.atkserverinterface.inc javascript » class.atkmultilanguage.js.php » class.atkprofileattribute.js.php » dhtml_tabs.js.php keyboard » class.atkkeyboard.inc listeners » class.atkrecyclebin.inc lock » class.atkdblock.inc » class.atklock.inc » lock.php lock-- » lock.js.php menu » atkmenutools.inc » class.atkcookmenu.inc » class.atkdhtmlmenu.inc » class.atkdropdownmenu.inc » class.atkframesmenu.inc » class.atkmenu.inc » class.atkmenuinterface.inc » class.atkmodernmenu.inc » class.atkoutlookmenu.inc » class.atkplainmenu.inc meta » class.atkdutchmetagrammar.inc » class.atkmetaattributemodifier.inc » class.atkmetacompiler.inc » class.atkmetagrammar.inc » class.atkmetapolicy.inc » module.inc meta-relations » class.atkmetaextendableshuttlerelation.inc » class.atkmetamanyboolrelation.inc » class.atkmetamanytomanylistrelation.inc » class.atkmetamanytomanyselectrelation.inc » class.atkmetamanytoonerelation.inc » class.atkmetaonetomanyrelation.inc » class.atkmetaonetoonerelation.inc » class.atkmetashuttlerelation.inc modules » class.atkmodule.inc modules-- » atkmoduletools.inc popups » colorpicker.inc recordlist » class.atkcolumnconfig.inc » class.atkcsvrecordlist.inc » class.atkcustomrecordlist.inc » class.atkexcelcsvrecordlist.inc » class.atkhtmlrecordlist.inc » class.atkprintablerecordlist.inc » class.atkrecordlist.inc » class.atkrecordlistcache.inc » class.atktotalizer.inc relations » class.atkextendableshuttlerelation.inc » class.atkmanyboolrelation.inc » class.atkmanytomanylistrelation.inc » class.atkmanytomanyrelation.inc » class.atkmanytomanyselectrelation.inc » class.atkmanytoonerelation.inc » class.atkmanytoonetreerelation.inc » class.atkmatrixrelation.inc » class.atkonetomanyrelation.inc » class.atkonetoonerelation.inc » class.atkrelation.inc » class.atksecurerelation.inc » class.atkshuttlecontrol.inc » class.atkshuttlefilter.inc » class.atkshuttlerelation.inc security » class.atkbajusencryption.inc » class.atkbase64encryption.inc » class.atkencryption.inc » class.atkmocksecuritymanager.inc » class.atkmocksecuritymanager.inc » class.atkopensslencryption.inc » class.atksecuritylistener.inc » class.atksecuritymanager.inc » class.atkurlvault.inc » class.auth_config.inc » class.auth_db.inc » class.auth_imap.inc » class.auth_interface.inc » class.auth_ldap.inc » class.auth_none.inc » class.auth_pop3.inc » class.auth_saml.inc » class.auth_server.inc » class.auth_sspi.inc session » class.atksessionmanager.inc » class.atkstate.inc skel » app.php » atk.inc » config.inc.php » debugger.php » dispatch.php » include.php » index.php » menu.php » top.php » welcome.php subpackage » class.atkattributetestcase.inc test » class.atkcachetestcase.inc » class.atkplugintestcase.inc » class.atktestcase.inc testcases » class.atkabstractsearchhandler.inc themes » themedef.inc » themedef.inc » themedef.inc » themedef.inc » themedef.inc » themedef.inc » themedef.inc » themedef.inc » themedef.inc » themedef.inc » themedef.inc » themedef.inc ui » block.atknavigator.php » block.atknavigatorinfo.php » class.atkactionboxbuilder.inc » class.atkdialog.inc » class.atkindexpage.inc » class.atkoutput.inc » class.atkpage.inc » class.atkpagebuilder.inc » class.atktheme.inc » class.atkthemecompiler.inc » class.atkui.inc » function.atkconf.php » function.atkconfig.php » function.atkdatefield.php » function.atkdispatchfile.php » function.atkfrontcontroller.php » function.atkloadscript.php » function.atkmessages.php » function.atkmoduledir.php » function.atkscript.php » function.atkstyle.php » function.atktext.php » function.atkthemeicon.php » function.atkthemeimg.php » function.stacktrace.php » modifier.atkjson.php » modifier.atkvardump.php » resource.string.php » resource.theme.php » resource.ui.php utils » atkbrowsertools.inc » class.atkactionlistener.inc » class.atkclassloader.inc » class.atkcompatselector.inc » class.atkdataholder.inc » class.atkdebugger.inc » class.atkdirectorytraverser.inc » class.atkeventlog.inc » class.atkfileutils.inc » class.atkframeset.inc » class.atkiputils.inc » class.atkjson.inc » class.atkmail.inc » class.atkmailer.inc » class.atkmessagequeue.inc » class.atkmlselector.inc » class.atkmlsplitter.inc » class.atkselector.inc » class.atkselectoriterator.inc » class.atkstring.inc » class.atkstringparser.inc » class.atktablerenderer.inc » class.atktablerenderergrouped.inc » class.atktextmarker.inc » class.atktmpfile.inc » class.atktriggerlistener.inc » class.atkyaml.inc » class.atkzip.inc » help.inc wizard » class.atkwizard.inc » class.atkwizardactionloader.inc » class.atkwizardpanel.inc
Home  ->  Documentation home  ->  Atk index  ->  Docs For Class atki5db [ package: atk ]

Class: atki5db

Source Location: /db/class.atki5db.inc

Class atki5db

Class Overview

IBM i5-specific databasedriver. This driver is based on the db2 driver but uses the i5_ library instead of the db2_ library. This allows us not just execute queries, but also to run some commands on the i5 machine. This is used to set the librarylist on-the-fly, for example.

You can supply a librarylist in your database configuration by adding librarylist to your database configuration:

$db['default']['librarylist'] = array('MYLIBL', 'HISLIBL');

Located in /db/class.atki5db.inc [line 17]

Wiki documentation

atkDb
   |
   --atkdb2db
      |
      --atki5db
Author(s): Information Tags:

Methods

[ Top ]

Inherited from parent

Inherited Properties Inherited Methods

Inherited From atkdb2db

atkdb2db::$m_seq_field
atkdb2db::$m_seq_namefield
atkdb2db::$m_seq_table
atkdb2db::$m_type

Inherited From atkDb

atkDb::$m_affected_rows
atkDb::$m_auto_free
atkDb::$m_charset
atkDb::$m_collate
atkDb::$m_connection
atkDb::$m_database
atkDb::$m_errno
atkDb::$m_error
atkDb::$m_errorLookup
atkDb::$m_haltonerror
atkDb::$m_host
atkDb::$m_identifierQuoting
atkDb::$m_link_id
atkDb::$m_mode
atkDb::$m_password
atkDb::$m_port
atkDb::$m_query_id
atkDb::$m_record
atkDb::$m_row
atkDb::$m_tableMeta
atkDb::$m_user
atkDb::$m_user_error
atkDb::$m_vendor

Inherited From atkdb2db

atkdb2db::atkdb2db()
Base constructor
atkdb2db::affected_rows()
Evaluate the result; which rows were affected by the query.
atkdb2db::disconnect()
Disconnect from database
atkdb2db::doConnect()
Connect to the database
atkdb2db::func_datetimetochar()
Get TO_CHAR() equivalent for the current database.
atkdb2db::func_datetochar()
Get TO_CHAR() equivalent for the current database.
atkdb2db::getEbcdicFields()
Sometimes, when certain database functions are used, DB2 returns EBCDIC instead of ASCII. Figure out what fields need to get a special treatment.
atkdb2db::getrows()
Get all rows that are the result of a certain specified query
atkdb2db::getSearchModes()
This function indicates what searchmodes the database supports.
atkdb2db::lock()
Lock a certain table in the database
atkdb2db::metadata()
Return the meta data of a certain table
atkdb2db::metadataToFlags()
We need to reconstruct the flags array ourselves based on the fields we obtained from INFORMATION_SCHEMA.COLUMNS. Get properties from the row provided and return an array based on these properties.
atkdb2db::nextid()
Get the next sequence number of a certain sequence.
atkdb2db::next_record()
Goto the next record in the result set
atkdb2db::num_fields()
Evaluatie the result; how many fields where affected by the query.
atkdb2db::num_rows()
Evaluate the result; how many rows were affected by the query.
atkdb2db::query()
Performs a query
atkdb2db::seek()
Goto a certain position in result set.
atkdb2db::setSequenceValue()
Set database sequence value.
atkdb2db::tableExists()
This function checks the database for a table with the provide name
atkdb2db::table_names()
Return the available table names
atkdb2db::unlock()
Unlock table(s) in the database
atkdb2db::vendorDateFormat()
Convert a php date() format specifier to a mysql specific format specifier.
atkdb2db::_getTableType()
Returns the table type.
atkdb2db::_setErrorVariables()
Store MySQL errors in internal variables
atkdb2db::_translateError()
Translates known database errors to developer-friendly messages

Inherited From atkDb

atkDb::affected_rows()
Retrieve the number of rows affected by the last query.
atkDb::clearMapping()
Clear the current database mapping.
atkDb::cloneAll()
Clones the database structure of the given database to this database. This also means the complete database is emptied beforehand.
atkDb::commit()
Commit the current transaction.
atkDb::connect()
Connect to the database.
atkDb::createDDL()
Create an atkDDL object for constructing ddl queries.
atkDb::createQuery()
Create an atkQuery object for constructing queries.
atkDb::deleteAll()
Empty all database tables.
atkDb::disconnect()
Disconnect from database
atkDb::doConnect()
Connect to the database
atkDb::dropAll()
Drop all database tables.
atkDb::errorLookup()
Looks up the error
atkDb::escapeSQL()
escapes quotes for use in SQL: ' -> '' (and sometimes % -> %%)
atkDb::func_concat()
Get CONCAT() equivalent for the current database.
atkDb::func_concat_ws()
Get CONCAT_WS() equivalent for the current database.
atkDb::func_datetimetochar()
Get TO_CHAR() equivalent for the current database.
atkDb::func_datetochar()
Get TO_CHAR() equivalent for the current database.
atkDb::func_now()
get NOW() or SYSDATE() equivalent for the current database
atkDb::func_substring()
get SUBSTRING() equivalent for the current database.
atkDb::getAtkDbErrno()
Get generic atk errorccode
atkDb::getDbErrno()
Get vendor-dependent database error number.
atkDb::getDbError()
Get vendor-dependent database error message.
atkDb::getDbStatus()
Check if current db is present and acceptable for current user
atkDb::getErrorMsg()
Get localized error message (for display in the application)
atkDb::getErrorType()
Determine whether an error that occurred is a recoverable (user) error or a system error.
atkDb::getHaltOnError()
Halt on error?
atkDb::getInstance()
Get database instance.
atkDb::getMapping()
Returns the current database mapping.
atkDb::getQueryId()
Returns the current query resource.
atkDb::getQueryMode()
Returns the query mode
atkDb::getRow()
Returns the first row for the given query.
atkDb::getRows()
Get all rows for the given query.
atkDb::getRowsAssoc()
Get rows in an associative array with the given column used as key for the rows.
atkDb::getSearchModes()
This function indicates what searchmodes the database supports.
atkDb::getTranslatedDatabaseName()
Returns the real database name. If a mapping
atkDb::getType()
Get the database driver type.
atkDb::getValue()
Get a single value from a certain specified query
atkDb::getValues()
Get an array with all the values in the specified column.
atkDb::getValuesAssoc()
Get rows in an associative array with the given key column used as key and the given value column used as value.
atkDb::halt()
If haltonerror is set, this will raise an atkerror. If not, it will place the error in atkdebug and continue.
atkDb::hasError()
Has error?
atkDb::hasMode()
Check if the current instance has the given mode
atkDb::init()
(Re)Initialise a database driver with a connection
atkDb::link_id()
Get the current connection.
atkDb::lock()
Lock a table in the database.
atkDb::maxIdentifierLength()
Returns the maximum length an identifier (tablename, columnname, etc) may have
atkDb::metadata()
Return the meta data of a certain table HIE GEBLEVEN
atkDb::nextid()
Get the next sequence number of a certain sequence.
atkDb::next_record()
Retrieve the next record in the resultset.
atkDb::prepare()
Creates a new statement for the given query.
atkDb::query()
Parse and execute a query.
atkDb::query_id()
Get the current query statement resource id.
atkDb::quoteIdentifier()
Quote Indentifier
atkDb::resetQueryId()
Rests the query resource.
atkDb::rollback()
Rollback the current transaction.
atkDb::savepoint()
Set savepoint with the given name.
atkDb::setHaltOnError()
Halt on error or not?
atkDb::setInstance()
Replace the current instance of a named connection at runtime with a different connection. This is useful for example for replacing a named database instance with a mock object for testing purposes.
atkDb::setQueryId()
Sets the current query identifier used for next_record() etc.
atkDb::setSequenceValue()
Set database sequence value.
atkDb::setUserError()
Define custom user error codes.
atkDb::tableExists()
This function checks the database for a table with the provide name
atkDb::tableMeta()
Fetches table meta data from database
atkDb::table_names()
Return the available table names
atkDb::toggleForeignKeys()
Enable/disable all foreign key constraints.
atkDb::unlock()
Relieve all locks.
atkDb::useMapping()
Use the given mapping to translate database requests from one database to another database. This can be used for test purposes.
atkDb::vendorDateFormat()
Convert a php date() format specifier to a vendor specific format specifier.
atkDb::_getOrUseMapping()
Get or set the database mapping
atkDb::_getTableMetaFromCache()
If cached it'll return the table metadata from cache.
atkDb::_getTableMetaFromDb()
Returns the tablemetadata directly from db
atkDb::_translateError()
Translate database-vendor dependent error messages into an ATK generic error code.

[ Top ]

Method Summary

atki5db   atki5db()  
void   add_to_librarylist()  
affected   affected_rows()   Evaluate the result; which rows were affected by the query.
void   disconnect()   Disconnect from i5 machine
mixed   doConnect()   Connect to the i5 machine
array   metadata()   Return the meta data of a certain table
void   nextid()  
result   next_record()   Goto the next record in the result set
number   num_fields()   Evaluatie the result; how many fields where affected by the query.
number   num_rows()   Evaluate the result; how many rows were affected by the query.
boolean   query()   Performs a query
void   seek()  
result   unlock()   Unlock table(s) in the database
void   _setErrorVariables()   Get errornumber and errormessage from the i5 machine and store them

[ Top ]

Methods

Constructor atki5db  [line 19]

  atki5db atki5db( )



[ Top ]
add_to_librarylist  [line 58]

  void add_to_librarylist( $libraries  )

Parameters:
   $libraries: 


[ Top ]
affected_rows  [line 213]

  affected affected_rows( )

Evaluate the result; which rows were affected by the query.


API Tags:
Return:  rows


Redefinition of:
atkdb2db::affected_rows()
Evaluate the result; which rows were affected by the query.

[ Top ]
disconnect  [line 104]

  void disconnect( )

Disconnect from i5 machine



Redefinition of:
atkdb2db::disconnect()
Disconnect from database

[ Top ]
doConnect  [line 34]

  mixed doConnect( string $host, string $user, string $password, $database, $port, $charset  )

Connect to the i5 machine

Parameters:
string   $host:  Hostname
string   $user:  Username
string   $password:  Password
   $database: 
   $port: 
   $charset: 

API Tags:
Return:  Connection status


Redefinition of:
atkdb2db::doConnect()
Connect to the database

[ Top ]
metadata  [line 245]

  array metadata( String $table, [boolean $full = false]  )

Return the meta data of a certain table

Parameters:
String   $table:  the table name (optionally in 'database.tablename' format)
boolean   $full:  all meta data or not

API Tags:
Return:  with meta data


Redefinition of:
atkdb2db::metadata()
Return the meta data of a certain table

[ Top ]
nextid  [line 285]

  void nextid( $sequence  )

Parameters:
   $sequence: 


Redefinition of:
atkdb2db::nextid()
Get the next sequence number of a certain sequence.

[ Top ]
next_record  [line 163]

  result next_record( [ $row_number = null]  )

Goto the next record in the result set

Parameters:
   $row_number: 

API Tags:
Return:  of going to the next record


Redefinition of:
atkdb2db::next_record()
Goto the next record in the result set

[ Top ]
num_fields  [line 233]

  number num_fields( )

Evaluatie the result; how many fields where affected by the query.


API Tags:
Return:  of affected fields


Redefinition of:
atkdb2db::num_fields()
Evaluatie the result; how many fields where affected by the query.

[ Top ]
num_rows  [line 223]

  number num_rows( )

Evaluate the result; how many rows were affected by the query.


API Tags:
Return:  of affected rows


Redefinition of:
atkdb2db::num_rows()
Evaluate the result; how many rows were affected by the query.

[ Top ]
query  [line 121]

  boolean query( $query $query, [$offset $offset = -1], [$limit $limit = -1]  )

Performs a query

Parameters:
$query   $query:  the query
$offset   $offset:  offset in record list
$limit   $limit:  maximum number of records

API Tags:
Return:  True on success, false on failure


Redefinition of:
atkdb2db::query()
Performs a query

[ Top ]
seek  [line 203]

  void seek( [ $row_number = 0]  )

Parameters:
   $row_number: 


Redefinition of:
atkdb2db::seek()
Goto a certain position in result set.

[ Top ]
unlock  [line 334]

  result unlock( )

Unlock table(s) in the database


API Tags:
Return:  of unlocking


Redefinition of:
atkdb2db::unlock()
Unlock table(s) in the database

[ Top ]
_setErrorVariables  [line 81]

  void _setErrorVariables( )

Get errornumber and errormessage from the i5 machine and store them

in the errno and error member variables



Redefinition of:
atkdb2db::_setErrorVariables()
Store MySQL errors in internal variables

[ Top ]
Home | About | Contact