request

//獲取request    原有的方法$this->getRequest()已經(jīng)廢棄硼啤；
$request = $this->container->get('request_stack')->getCurrentRequest();

//獲取get參數(shù)用(方法參數(shù)中注入了參數(shù)Request $request時(shí))
$request->query->get();

//獲取post參數(shù)用
$request->request->get();

創(chuàng)建Bundle

php app/console generate:bundle --namespace=Acme/StoreBundle

從數(shù)據(jù)庫中生成orm.entity實(shí)體

//1.生成了orm.yml
app/console doctrine:mapping:import --force WebBundle yml  

//2.生成了entities
php app/console doctrine:mapping:convert annotation ./src

//3.生成了get set方法
app/console doctrine:generate:entities WebBundle --no-backup

# notice 如果要生成EntityRepository.php,需要更改Entity\User.php中
@ORM\Entity(repositoryClass="WebBundle\Entity\UserRepository")

數(shù)據(jù)庫具體操作

查詢

1.使用Doctrine’s Query Builder查詢對(duì)象

$repository = $this->getDoctrine()
    ->getRepository('AppBundle:Product');
 


# more 更多查詢語法
//通過主鍵查詢（一般為"id")
$product=$repository->find($id);

//動(dòng)態(tài)方法名基于列值查找
$product=$repository->findOneById($id);
$product=$repository->findOneByProductName('chocolate');

//查詢所有產(chǎn)品
$products=$repository->findAall();
//基于任意列值查找一組產(chǎn)品
$products = $repository->findByPrice(19.99);

//按照名字和價(jià)格來獲取一個(gè)匹配的對(duì)象(查詢條件數(shù)組傳入)
$product=$repository->findOneBy(array('name'=>'foo','price'=>19.99));

//查詢匹配名字的所有產(chǎn)品并按照價(jià)格排序
$products = $repository->findBy(
        array('name'=> 'foo'),
        array('price'=>'ASC')
);

$query = $repository->createQueryBuilder('p')
    ->where('p.price > :price')
    ->setParameter('price', '19.99')
    ->orderBy('p.price', 'ASC')
    ->getQuery();
 
$products = $query->getResult();
//該getResult()方法返回一個(gè)結(jié)果數(shù)組

2.使用DQL查詢對(duì)象

$em = $this->getDoctrine()->getManager();
$query = $em->createQuery(
    'SELECT p
    FROM AppBundle:Product p
    WHERE p.price > :price
    ORDER BY p.price ASC'
)->setParameter('price', '19.99');
 
$products = $query->getResult();

新增

$category = new Category();
$category->setName('Main Products');

$product = new Product();
$product->setName('Foo');
$product->setPrice(19.99);
$product->setDescription('Lorem ipsum dolor');
// relate this product to the category
$product->setCategory($category);

$em = $this->getDoctrine()->getManager();
$em->persist($category);
$em->persist($product);
$em->flush();

更新

$em = $this->getDoctrine()->getManager();
$product = $em->getRepository('AppBundle:Product')->find($id);
if (!$product) {
    throw $this->createNotFoundException(
        'No product found for id '.$id
    );
}

$product->setName('New product name!');
$em->flush();

刪除

$em = $this->getDoctrine()->getManager();
$product = $em->getRepository('AppBundle:Product')->find($id);
$em->remove($product);
$em->flush();