Database Access - Revision history

Wayneh at 22:55, 17 December 2015

2015-12-17T22:55:10Z

← Older revision		Revision as of 22:55, 17 December 2015
Line 46:		Line 46:
	}		}
	</syntaxhighlight>		</syntaxhighlight>
	Other methods available include disconnect, escapeSQL, lock, unlock		Other methods available include disconnect, escapeSQL, lock, unlock, affected_rows, num_rows, nextid, tableexists, table_names, commit, savepoint and rollback



	= Prepared Statements =		= Prepared Statements =

Wayneh at 22:54, 17 December 2015

2015-12-17T22:54:00Z

← Older revision		Revision as of 22:54, 17 December 2015
Line 46:		Line 46:
	}		}
	</syntaxhighlight>		</syntaxhighlight>
			Other methods available include disconnect, escapeSQL, lock, unlock

	= Prepared Statements =		= Prepared Statements =

bahtiar: /* Direct SQL access */

2011-03-28T16:04:18Z

Direct SQL access

← Older revision		Revision as of 16:04, 28 March 2011
Line 19:		Line 19:
	<syntaxhighlight lang="php">		<syntaxhighlight lang="php">
	// Default database connection:		// Default database connection:
	$db = &atkGetDb();		$db = atkGetDb();
	$db->query("UPDATE employees SET name='ivo' WHERE login='ivo'");		$db->query("UPDATE employees SET name='ivo' WHERE login='ivo'");

Line 36:		Line 36:

	<syntaxhighlight lang="php">		<syntaxhighlight lang="php">
	$db = &atkGetDb();		$db = atkGetDb();

	$db->query("SELECT * FROM employee");		$db->query("SELECT * FROM employee");

Bahati at 15:20, 16 March 2011

2011-03-16T15:20:52Z

← Older revision		Revision as of 15:20, 16 March 2011
Line 102:		Line 102:
	* This also loads nodes which have custom loading logic (where select() is overridden for example)		* This also loads nodes which have custom loading logic (where select() is overridden for example)

	See the [http://www.~~ibuildings~~.com/docs/atk/trunk/atk/atkNode.html#select API docs] for more information.		See the [http://www.atk-framework.com/docs/atk/trunk/atk/atkNode.html#select API docs] for more information.

	== Including relations ==		== Including relations ==

bahtiar: /* Simple access */

2010-02-10T07:17:17Z

Simple access

← Older revision		Revision as of 07:17, 10 February 2010
Line 100:		Line 100:
	* This also loads relations! The node takes care of the joins, subqueries for one-to-many relations etc.		* This also loads relations! The node takes care of the joins, subqueries for one-to-many relations etc.
	* This also loads attributes that have custom loading mechanisms (file readers, calculated values etc.)		* This also loads attributes that have custom loading mechanisms (file readers, calculated values etc.)
	* This also loads nodes which have custom loading logic (where ~~selectDb~~ is overridden for example)		* This also loads nodes which have custom loading logic (where select() is overridden for example)

	See the [http://www.ibuildings.com/docs/atk/trunk/atk/atkNode.html#select API docs] for more information.		See the [http://www.ibuildings.com/docs/atk/trunk/atk/atkNode.html#select API docs] for more information.

bahtiar: /* Including relations */

2010-02-10T07:16:56Z

Including relations

← Older revision		Revision as of 07:16, 10 February 2010
Line 113:		Line 113:
	$node = newNode("track");		$node = newNode("track");
	$node->addFilter("t.album_id = 79");		$node->addFilter("t.album_id = 79");
	$res = $node->select();		$res = $node->select()->getAllRows();
	</syntaxhighlight>		</syntaxhighlight>

bahtiar: /* Simple access */

2010-02-10T07:15:59Z

Simple access

← Older revision		Revision as of 07:15, 10 February 2010
Line 87:		Line 87:

	<syntaxhighlight lang="php">		<syntaxhighlight lang="php">
	$emp = ~~&getNode~~("company.employee");		$emp = atkGetNode("company.employee");
	$~~result~~ = $emp->~~selectDb~~();		$records = $emp->select()->getAllRows();
	</syntaxhighlight>		</syntaxhighlight>

	The first line retrieves the 'employee' node from the 'company' module. The next line performs a select query on the node. It respects filters, so any filter already implemented in the node is reflected in the data that is retrieved. You can ofcourse add additional filters using the addFilter() method.		The first line retrieves the 'employee' node from the 'company' module. The next line performs a select query on the node. It respects filters, so any filter already implemented in the node is reflected in the data that is retrieved. You can ofcourse add additional filters using the addFilter() method.

	Furthermore, ~~selectDb~~ has a ~~set of paramaters~~ which you can use to influence the result. You can add a where-clause, specify which attributes you want to load, or the ones you want to exclude. The $mode ~~parameter~~ is interesting because you can set it to "edit" for example, at which point ~~selectDb~~ will retrieve all attributes that do not have an AF_HIDE_EDIT flag.		Furthermore, select() has a fluent interface which you can use to influence the result. You can add a where-clause, specify which attributes you want to load, or the ones you want to exclude. The ->mode($mode) method is interesting because you can set it to "edit" for example, at which point select() will retrieve all attributes that do not have an AF_HIDE_EDIT flag.

	There are more advantages to this approach:		There are more advantages to this approach:
Line 102:		Line 102:
	* This also loads nodes which have custom loading logic (where selectDb is overridden for example)		* This also loads nodes which have custom loading logic (where selectDb is overridden for example)

	See the [http://www.~~achievo~~.~~org~~/docs/atk/~~latest~~/atk/atkNode.html#~~selectDb~~ API docs] ~~for the selectDb~~ for more ~~parameters~~.		See the [http://www.ibuildings.com/docs/atk/trunk/atk/atkNode.html#select API docs] for more information.

	== Including relations ==		== Including relations ==

bahtiar: /* Direct SQL access */

2010-02-03T14:11:41Z

Direct SQL access

← Older revision		Revision as of 14:11, 3 February 2010
Line 46:		Line 46:
	}		}
	</syntaxhighlight>		</syntaxhighlight>

			= Prepared Statements =

			The prefered way to do the above direct SQL access is to use Prepared Statements, which add another layer of flexiblity on the DB api. There's a separate [[Prepared Statements]] howto explaining this in detail.

	= Using the query abstraction layer =		= Using the query abstraction layer =

Mjs: /* Direct SQL access */ fix heading level

2009-06-15T13:48:29Z

Direct SQL access: fix heading level

← Older revision		Revision as of 13:48, 15 June 2009
Line 7:		Line 7:
	There are multiple ways to accomplish this, each of which will be explained below.		There are multiple ways to accomplish this, each of which will be explained below.

	== Direct SQL access ==		= Direct SQL access =

	The quickest way to access the database, is to use the database connection directly. The advantage is that you can very quickly run any SQL statement you want.		The quickest way to access the database, is to use the database connection directly. The advantage is that you can very quickly run any SQL statement you want.

Vjromeo: /* Including relations */

2009-06-01T19:10:31Z

Including relations

← Older revision		Revision as of 19:10, 1 June 2009
Line 102:		Line 102:
	== Including relations ==		== Including relations ==

	If you want nested (multi-dimensional) arrays with all the relations followed (i.e. if you want an array of "tracks" where the value of the "album_id" keys are themselves arrays representing an album, and so on), then--because of all the work ATK has to do behind the scenes--you have less flexibility, and are only able to control the <code>WHERE</code> clause of the generated SQL. This is do with the <code>addFilter</code> method.		If you want nested (multi-dimensional) arrays with all the relations followed (i.e. if you want an array of "tracks" where the value of the "album_id" keys are themselves arrays representing an album, and so on), then--because of all the work ATK has to do behind the scenes--you have less flexibility, and are only able to control the <code>WHERE</code> clause of the generated SQL. This is done with the <code>addFilter</code> method.

	For example:		For example: