kobsu

<?xml version="1.0" encoding="UTF-8"?>
<!-- phing build file to create database -->
<project name="myproject" default="build">
    <property name="db.host" value="localhost" />
    <property name="db.name" value="myproject_test" />
    <property name="db.user" value="development" />
    <property name="db.pass" value="passwd" />
    <property name="db.dir.create" value="./schema/create" />
    <property name="db.dir.insert" value="./schema/insert" />

    <!-- nothing here yet -->
    <target name="prepare"></target>
    <target name="build" depends="prepare"></target>

    <target name="createdb">
        <exec command="mysql -u${db.user} -p${db.pass} -h ${db.host} -e 'CREATE DATABASE IF NOT EXISTS `${db.name}` CHARSET=utf8 COLLATE=utf8_swedish_ci;'" />
        <!-- there is an error in phing docs... this is pdo, not pdosqlexec as mentioned in docs -->
        <pdo url="mysql:host=${db.host};dbname=${db.name}" userid="${db.user}" password="${db.pass}" encoding="utf8">
            <transaction src="${db.dir.create}/create_table1.sql" />
            <transaction src="${db.dir.create}/create_table2.sql" />
            <transaction src="${db.dir.create}/create_table3.sql" />

            <transaction src="${db.dir.insert}/insert_table1.sql" />
        </pdo>
    </target>

    <target name="testdata" depends="createdb">
        <pdo url="mysql:host=${db.host};dbname=${db.name}" userid="${db.user}" password="${db.pass}" encoding="utf8">
            <transaction src="${db.dir.insert}/set_encoding.sql" /> <!-- set encoding here, because attribute above didn't work -->
            <transaction src="${db.dir.insert}/test/insert_test_table1.sql" />
            <transaction src="${db.dir.insert}/test/insert_test_table2.sql" />
            <transaction src="${db.dir.insert}/test/insert_test_table3.sql" />
        </pdo>
    </target>
</project>