Agavi database overrides for Propel + MySQL (other databases)
Once you generated your myproject-conf.php and myproject-classmap.php, you'll notice and copy and paste them into your app/config-folder you'll maybe want to set user and password for a specific AgaviPropelDatabase.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
<?xml version="1.0" encoding="UTF-8"?>
<configurations xmlns="http://agavi.org/agavi/1.0/config">
<configuration environment="development">
<databases default="mydb">
<database name="mydb" class="AgaviPropelDatabase">
<parameter name="config">
%core.app_dir%/config/myproject-conf.php
</parameter>
<parameter name="overrides">
<parameter name="connection">
<dsn>mysql:dbname=mydb;host=localhost</dsn>
<parameter name="user">root</parameter>
<parameter name="password"></parameter>
</parameter>
</parameter>
</database>
</databases>
</configuration>
</configurations>
<configurations xmlns="http://agavi.org/agavi/1.0/config">
<configuration environment="development">
<databases default="mydb">
<database name="mydb" class="AgaviPropelDatabase">
<parameter name="config">
%core.app_dir%/config/myproject-conf.php
</parameter>
<parameter name="overrides">
<parameter name="connection">
<dsn>mysql:dbname=mydb;host=localhost</dsn>
<parameter name="user">root</parameter>
<parameter name="password"></parameter>
</parameter>
</parameter>
</database>
</databases>
</configuration>
</configurations>
Here you also can change the dns-entry to match different sql servers!
Your runtime-conf.xml for propel looks like that:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
<?xml version="1.0" encoding="UTF-8"?>
<config>
<propel>
<datasources default="mydb">
<datasource id="mydb">
<!--
this ID must match <database name="">
in schema.xml
-->
<adapter>mysql</adapter>
<!--
sqlite, mysql, myssql, oracle, or pgsql
-->
<connection>
<dsn>mysql:dbname=mydb;host=localhost</dsn>
</connection>
</datasource>
</datasources>
</propel>
</config>
<config>
<propel>
<datasources default="mydb">
<datasource id="mydb">
<!--
this ID must match <database name="">
in schema.xml
-->
<adapter>mysql</adapter>
<!--
sqlite, mysql, myssql, oracle, or pgsql
-->
<connection>
<dsn>mysql:dbname=mydb;host=localhost</dsn>
</connection>
</datasource>
</datasources>
</propel>
</config>


