Search Results | SymfonyCasts

1000 search results

Sort By

Code

Learn Symfony 5

Go Pro with Doctrine Queries (Legacy)

Filters

            Copy Code

                        8 lines
            |
            src/AppBundle/Doctrine/DiscontinuedFilter.php
        
            <?php
        
            namespace AppBundle\Doctrine;
        
            class DiscontinuedFilter
        
            {
        
            }

See Code Block in Script

Code

Learn Symfony 5

Go Pro with Doctrine Queries (Legacy)

Filters

            Copy Code

                            Show All Lines

                        23 lines
            |
            src/AppBundle/Doctrine/DiscontinuedFilter.php
        
                Show Lines

                                                    // ... lines 1 - 2
                            
            namespace AppBundle\Doctrine;
        
            use Doctrine\ORM\Mapping\ClassMetadata;
        
            use Doctrine\ORM\Query\Filter\SQLFilter;
        
            class DiscontinuedFilter extends SQLFilter
        
            {
        
                /**
        
                 * Gets the SQL query part to add to a query.
        
                 *
        
                 * @param ClassMetaData $targetEntity
        
                 * @param string $targetTableAlias
        
                 *
        
                 * @return string The constraint SQL if there is available, empty string otherwise.
        
                 */
        
                public function addFilterConstraint(ClassMetadata $targetEntity, $targetTableAlias)
        
                {
        
                    // ...
        
                }
        
            }

See Code Block in Script

Code

Learn Symfony 5

Go Pro with Doctrine Queries (Legacy)

Filters

            Copy Code

                            Show All Lines

                        23 lines
            |
            src/AppBundle/Doctrine/DiscontinuedFilter.php
        
                Show Lines

                                                    // ... lines 1 - 7
                            
            class DiscontinuedFilter extends SQLFilter
        
            {
        
                Show Lines

                                                    // ... lines 10 - 17
                            
                public function addFilterConstraint(ClassMetadata $targetEntity, $targetTableAlias)
        
                {
        
                    var_dump($targetEntity);die;
        
                }
        
            }

See Code Block in Script

Code

Learn Symfony 5

Go Pro with Doctrine Queries (Legacy)

Filters

            Copy Code

                            Show All Lines

                        27 lines
            |
            src/AppBundle/Doctrine/DiscontinuedFilter.php
        
                Show Lines

                                                    // ... lines 1 - 7
                            
            class DiscontinuedFilter extends SQLFilter
        
            {
        
                Show Lines

                                                    // ... lines 10 - 17
                            
                public function addFilterConstraint(ClassMetadata $targetEntity, $targetTableAlias)
        
                {
        
                    if ($targetEntity->getReflectionClass()->name != 'AppBundle\Entity\FortuneCookie') {
        
                        return '';
        
                    }
        
                Show Lines

                                                    // ... lines 23 - 24
                            
                }
        
            }

See Code Block in Script

Code

Learn Symfony 5

Go Pro with Doctrine Queries (Legacy)

Filters

            Copy Code

                            Show All Lines

                        27 lines
            |
            src/AppBundle/Doctrine/DiscontinuedFilter.php
        
                Show Lines

                                                    // ... lines 1 - 17
                            
                public function addFilterConstraint(ClassMetadata $targetEntity, $targetTableAlias)
        
                {
        
                    if ($targetEntity->getReflectionClass()->name != 'AppBundle\Entity\FortuneCookie') {
        
                        return '';
        
                    }
        
                    return sprintf('%s.discontinued = false', $targetTableAlias);
        
                }
        
                Show Lines

                                                    // ... lines 26 - 27

See Code Block in Script

Code

Learn Symfony 5

Go Pro with Doctrine Queries (Legacy)

Filters

            Copy Code

                            Show All Lines

                        27 lines
            |
            src/AppBundle/Doctrine/DiscontinuedFilter.php
        
                Show Lines

                                                    // ... lines 1 - 17
                            
                public function addFilterConstraint(ClassMetadata $targetEntity, $targetTableAlias)
        
                {
        
                Show Lines

                                                    // ... lines 20 - 23
                            
                    return sprintf('%s.discontinued = %s', $targetTableAlias, $this->getParameter('discontinued'));
        
                }
        
                Show Lines

                                                    // ... lines 26 - 27

See Code Block in Script

Code

Learn Symfony 4

Doctrine & the Database in Symfony 4

Installing Doctrine

            Copy Code

                            Show All Lines

                        31 lines
            |
            config/packages/doctrine.yaml
        
            parameters:
        
                # Adds a fallback DATABASE_URL if the env var is not set.
        
                # This allows you to run cache:warmup even if your
        
                # environment variables are not available yet.
        
                # You should not need to change this value.
        
                env(DATABASE_URL): ''
        
            doctrine:
        
                dbal:
        
                Show Lines

                                                    // ... lines 10 - 17
                            
                    # With Symfony 3.3, remove the `resolve:` prefix
        
                    url: '%env(resolve:DATABASE_URL)%'
        
                Show Lines

                                                    // ... lines 20 - 31

See Code Block in Script

Code

Learn Symfony 4

Doctrine & the Database in Symfony 4

Sluggable & other Wonderful Behaviors

            Copy Code

                        5 lines
            |
            config/packages/stof_doctrine_extensions.yaml
        
            # Read the documentation: https://symfony.com/doc/current/bundles/StofDoctrineExtensionsBundle/index.html
        
            # See the official DoctrineExtensions documentation for more details: https://github.com/Atlantic18/DoctrineExtensions/tree/master/doc/
        
            stof_doctrine_extensions:
        
                default_locale: en_US

See Code Block in Script

Code

Learn Symfony 4

Doctrine & the Database in Symfony 4

Sluggable & other Wonderful Behaviors

            Copy Code

                        8 lines
            |
            config/packages/stof_doctrine_extensions.yaml
        
            # Read the documentation: https://symfony.com/doc/current/bundles/StofDoctrineExtensionsBundle/index.html
        
            # See the official DoctrineExtensions documentation for more details: https://github.com/Atlantic18/DoctrineExtensions/tree/master/doc/
        
            stof_doctrine_extensions:
        
                default_locale: en_US
        
                orm:
        
                    default:
        
                        sluggable: true

See Code Block in Script

Comment

Learn Symfony 4

Mastering Doctrine Relations in Symfony 4!

Pagination

"Doctrine itself doesn't come with any pagination features." "Doctrine\ORM\Tools\Pagination\Paginator" is there at least from 2013 (version 2.4). It is very simple to compare with KnpPagination Bundle, but it is there. This pure doctrine paginator is also used in the…

Peter L.

Read Full Comment

Comment

Learn Symfony 4

Doctrine & the Database in Symfony 4

Sluggable & other Wonderful Behaviors

Doctrine Behaviors 2 is out! https://www.tomasvotruba.cz/blog/2019/12/30/doctrine-behaviors-2-0-reloaded/

Tomáš Votruba

Read Full Comment

Code

Developer Tools

Animated Deployment with Ansistrano

Optimizing with Cache

            Copy Code

                            Show All Lines

                        26 lines
            |
            app/config/config_prod.yml
        
                Show Lines

                                                    // ... lines 1 - 3
                            
            #doctrine:
        
            #    orm:
        
            #        metadata_cache_driver: apc
        
            #        result_cache_driver: apc
        
            #        query_cache_driver: apc
        
                Show Lines

                                                    // ... lines 9 - 26

See Code Block in Script

Code

Developer Tools

Animated Deployment with Ansistrano

Optimizing with Cache

            Copy Code

                            Show All Lines

                        26 lines
            |
            app/config/config_prod.yml
        
                Show Lines

                                                    // ... lines 1 - 3
                            
            doctrine:
        
                orm:
        
                    metadata_cache_driver: apcu
        
            #        result_cache_driver: apc
        
                    query_cache_driver: apcu
        
                Show Lines

                                                    // ... lines 9 - 26

See Code Block in Script

Code

PHPUnit (Legacy): Testing with a Bite

Clearing the Database

            Copy Code

                            Show All Lines

                        28 lines
            |
            app/config/config_test.yml
        
                Show Lines

                                                    // ... lines 1 - 23
                            
            doctrine:
        
                dbal:
        
                    url: 'sqlite:///%kernel.project_dir%/var/data/test.sqlite'
        
                Show Lines

                                                    // ... lines 27 - 28

See Code Block in Script

Code

Learn Symfony 3

Upgrade to Symfony4 and Flex!

Upgrade to Symfony 3.4

            Copy Code

                            Show All Lines

                        80 lines
            |
            app/config/config.yml
        
                Show Lines

                                                    // ... lines 1 - 67
                            
            doctrine_cache:
        
                providers:
        
                    my_markdown_cache:
        
                        type: '%cache_type%'
        
                        file_system:
        
                            directory: '%kernel.cache_dir%/markdown_cache'
        
                Show Lines

                                                    // ... lines 74 - 80

See Code Block in Script

Code

Learn Symfony 3

Symfony 3: Doctrine & the Database

Database Config and Automatic Table Creation

            Copy Code

                            Show All Lines

                        72 lines
            |
            app/config/config.yml
        
                Show Lines

                                                    // ... lines 1 - 43
                            
            # Doctrine Configuration
        
            doctrine:
        
                dbal:
        
                    driver:   pdo_mysql
        
                    host:     "%database_host%"
        
                    port:     "%database_port%"
        
                    dbname:   "%database_name%"
        
                    user:     "%database_user%"
        
                    password: "%database_password%"
        
                    charset:  UTF8
        
                    # if using pdo_sqlite as your database driver:
        
                    #   1. add the path in parameters.yml
        
                    #     e.g. database_path: "%kernel.root_dir%/data/data.db3"
        
                    #   2. Uncomment database_path in parameters.yml.dist
        
                    #   3. Uncomment next line:
        
                    #     path:     "%database_path%"
        
                Show Lines

                                                    // ... lines 60 - 72

See Code Block in Script

Code

Learn Symfony 3

Symfony 3 Fundamentals: Bundles, Configuration & Environments

Adding a Cache Service

77 lines | app/config/config.yml

Show Lines	// ... lines 1 - 72
	doctrine_cache:
	providers:
Show Lines	// ... lines 75 - 77

See Code Block in Script

Code

Learn Symfony 3

Symfony 3 Fundamentals: Bundles, Configuration & Environments

Adding a Cache Service

            Copy Code

                            Show All Lines

                        77 lines
            |
            app/config/config.yml
        
                Show Lines

                                                    // ... lines 1 - 72
                            
            doctrine_cache:
        
                providers:
        
                    my_markdown_cache:
        
                Show Lines

                                                    // ... lines 76 - 77

See Code Block in Script

Code

Learn Symfony 3

Symfony 3 Fundamentals: Bundles, Configuration & Environments

Adding a Cache Service

            Copy Code

                            Show All Lines

                        77 lines
            |
            app/config/config.yml
        
                Show Lines

                                                    // ... lines 1 - 72
                            
            doctrine_cache:
        
                providers:
        
                    my_markdown_cache:
        
                        type: file_system

See Code Block in Script

Code

Learn Symfony 3

Symfony 3 Fundamentals: Bundles, Configuration & Environments

Caching in the prod Environment Only

            Copy Code

                            Show All Lines

                        51 lines
            |
            app/config/config_dev.yml
        
                Show Lines

                                                    // ... lines 1 - 46
                            
            doctrine_cache:
        
                providers:
        
                    my_markdown_cache:
        
                        type: array

See Code Block in Script

	<?php

	namespace AppBundle\Doctrine;

	class DiscontinuedFilter
	{
	}

Show Lines	// ... lines 1 - 2
	namespace AppBundle\Doctrine;

	use Doctrine\ORM\Mapping\ClassMetadata;
	use Doctrine\ORM\Query\Filter\SQLFilter;

	class DiscontinuedFilter extends SQLFilter
	{
	/**
	* Gets the SQL query part to add to a query.
	*
	* @param ClassMetaData $targetEntity
	* @param string $targetTableAlias
	*
	* @return string The constraint SQL if there is available, empty string otherwise.
	*/
	public function addFilterConstraint(ClassMetadata $targetEntity, $targetTableAlias)
	{
	// ...
	}
	}

Show Lines	// ... lines 1 - 7
	class DiscontinuedFilter extends SQLFilter
	{
Show Lines	// ... lines 10 - 17
	public function addFilterConstraint(ClassMetadata $targetEntity, $targetTableAlias)
	{
	var_dump($targetEntity);die;
	}
	}

Show Lines	// ... lines 1 - 17
	public function addFilterConstraint(ClassMetadata $targetEntity, $targetTableAlias)
	{
	if ($targetEntity->getReflectionClass()->name != 'AppBundle\Entity\FortuneCookie') {
	return '';
	}

	return sprintf('%s.discontinued = false', $targetTableAlias);
	}
Show Lines	// ... lines 26 - 27

	parameters:
	# Adds a fallback DATABASE_URL if the env var is not set.
	# This allows you to run cache:warmup even if your
	# environment variables are not available yet.
	# You should not need to change this value.
	env(DATABASE_URL): ''

	doctrine:
	dbal:
Show Lines	// ... lines 10 - 17
	# With Symfony 3.3, remove the `resolve:` prefix
	url: '%env(resolve:DATABASE_URL)%'
Show Lines	// ... lines 20 - 31

	# Read the documentation: https://symfony.com/doc/current/bundles/StofDoctrineExtensionsBundle/index.html
	# See the official DoctrineExtensions documentation for more details: https://github.com/Atlantic18/DoctrineExtensions/tree/master/doc/
	stof_doctrine_extensions:
	default_locale: en_US

Show Lines	// ... lines 1 - 3
	#doctrine:
	# orm:
	# metadata_cache_driver: apc
	# result_cache_driver: apc
	# query_cache_driver: apc
Show Lines	// ... lines 9 - 26

Show Lines	// ... lines 1 - 23
	doctrine:
	dbal:
	url: 'sqlite:///%kernel.project_dir%/var/data/test.sqlite'
Show Lines	// ... lines 27 - 28

Show Lines	// ... lines 1 - 67
	doctrine_cache:
	providers:
	my_markdown_cache:
	type: '%cache_type%'
	file_system:
	directory: '%kernel.cache_dir%/markdown_cache'
Show Lines	// ... lines 74 - 80

Show Lines	// ... lines 1 - 43
	# Doctrine Configuration
	doctrine:
	dbal:
	driver: pdo_mysql
	host: "%database_host%"
	port: "%database_port%"
	dbname: "%database_name%"
	user: "%database_user%"
	password: "%database_password%"
	charset: UTF8
	# if using pdo_sqlite as your database driver:
	# 1. add the path in parameters.yml
	# e.g. database_path: "%kernel.root_dir%/data/data.db3"
	# 2. Uncomment database_path in parameters.yml.dist
	# 3. Uncomment next line:
	# path: "%database_path%"
Show Lines	// ... lines 60 - 72

Show Lines	// ... lines 1 - 46
	doctrine_cache:
	providers:
	my_markdown_cache:
	type: array