Editing Databases and Symfony

[[Category:Symfony]] [[category:PHP]] [[Category:Web Development]]

== Overview ==

Notes on how to access data in a Symfony project.

== Entity classes ==

=== Configuring entity classes ===

Classes that represent table data go in the `Entity` directory inside of `AppBundle`.<ref>[http://symfony.com/doc/current/book/doctrine.html Doctrine Documentation], Symfony Documentation, "The Book"</ref>

Columns are represented by properties of the class. Typically these are `protected` and accessed with `public` "getter" and "setter" functions. The getter and setter routines can be generated with

<syntaxhighlight lang="bash">
$ php app/console doctrine:generate:entities AppBundle/Entity/Product
</syntaxhighlight>

<syntaxhighlight lang="php" highlight="6-8,10,15">
// src/AppBundle/Entity/Product.php
namespace AppBundle\Entity;

class Product
{
	protected $id;
	protected $name;
	protected $description;

	public function getId()
	{
		return ($this->id);
	}

	public function setID($id)
	{
		$this->id = $id;
	}

	/* etc... */ 
}
</syntaxhighlight>

=== Mapping information ===

Mapping metadata can be specified with YAML, XML, or directly in the entity class via annotations:<ref>[http://docs.doctrine-project.org/projects/doctrine-orm/en/latest/reference/basic-mapping.html#property-mapping Doctrine Property Mapping]</ref>,<ref>[http://symfony.com/doc/current/book/doctrine.html#book-doctrine-field-types Doctrine Field Types Reference]</ref>

<syntaxhighlight lang="php" highlight="4,7-8,13-15,20">
// src/AppBundle/Entity/Product.php
namespace AppBundle\Entity;

use Doctrine\ORM\Mapping as ORM;

/**
 * @ORM\Entity
 * @ORM\Table(name="product")
 */
class Product
{
	/**
	 * @ORM\Column(type="integer")
	 * @ORM\Id
	 * @ORM\GeneratedValue(strategy="AUTO")
	 */
	protected $id;

	/**
	 * @ORM\Column(type="string")
	 */
	protected $name;

	/* etc... */
}
</syntaxhighlight>
== Notes ==
<references/>