[binarycloud-dev] Datasources, Queries

[Andreas A. <a.a...@th...>]

Hi All,

i've made some changes to the datasources/qry format (to match each other
and with lang)as well as implementing proper query loading. If you all
concur I'll commit the files.

Andi

--

===================================================
Datasources.php.xml
---------------------------------------------------
<datasources>
	<datasource>
		<name>dummy</name>
		<default>false</default>
		<database>test</database>
	</datasource>
	<datasource>
		<name>query_example</name>
		<default>true</default>
		<database>test</database>
		<Type>mysql</Type>
		<Host>localhost</Host>
		<User>root</User>
		<Password>sql</Password>
		<IncludePath>BC_PATH."ext/metabase"</IncludePath>
		<Persistent>true</Persistent>
	</datasource>
</datasources>

---------------------------------------------------
will result in Datasources.php
---------------------------------------------------
<?php
global $QueryManager;
$QueryManager->datasources = array(
	array(
		'name' => "dummy",
		'default' => false,
		'database' => "test",
	),
	array(
		'name' => "query_example",
		'default' => true,
		'database' => "test",
		'Type' => "mysql",
		'Host' => "localhost",
		'User' => "root",
		'Password' => "sql",
		'IncludePath' => BC_PATH."ext/metabase",
		'Persistent' => true,
	),
);

===================================================
Something.qry.xml
---------------------------------------------------
<queries>
	<query>
		<name>user.news.tinylist</name>
		<sql>SELECT newsid, date, title FROM news ORDER BY date DESC</sql>
	</query>
	<query>
		<name>user.news.newsbyid</name>
		<sql>SELECT a.title, b.login, a.date, a.news FROM news a, users b WHERE
a.userId = b.userId AND newsId = ?</sql>
		<argtypes>
			<type>integer</type>
		</argtypes>
	</query>
</queries>

---------------------------------------------------
will result in "Something.php", I guess:
---------------------------------------------------
<?php
global $QueryManager;
$queries = array(
	array(
		'name' => "user.news.tinylist",
		'sql' => "SELECT newsid, date, title FROM news ORDER BY date DESC",
	),
	array(
		'name' => "user.news.newsbyid",
		'sql' => "SELECT a.title, b.login, a.date, a.news FROM news a, users b
WHERE a.userId = b.userId AND newsId = ?",
		'argtypes' => array('integer'),
	),
);

$QueryManager->LoadQueries($queries);
unset($queries);
?>