l-1

PHP笔记

主页/PHP笔记/PHP问答/框架Symfony/PHP Doctrine: 如何根据条件删除一条记录

PHP Doctrine: 如何根据条件删除一条记录

Bug编译狮

Bug编译狮

好的，让我们来探讨如何使用 PHP 和 Doctrine ORM 来根据条件删除一条记录。

1. 安装 Doctrine

首先，确保你已经安装了 Doctrine ORM。你可以通过 Composer 来安装：

composer require doctrine/orm

2. 配置数据库连接

创建一个 config.yaml 文件来配置你的数据库连接：

doctrine:
    dbal:
        driver: pdo_mysql
        host: localhost
        port: 3306
        dbname: your_database_name
        user: your_username
        password: your_password
        charset: utf8mb4
        default_table_options:
            charset: utf8mb4
            collate: utf8mb4_unicode_ci
    orm:
        auto_generate_proxy_classes: true
        naming_strategy: doctrine.orm.naming-strategy.camel_case
        proxy_dir: %kernel.cache_dir%/doctrine/Proxy
        metadata_driver_impls:
            doctrine.orm.driver_impls.your_entity_namespace.YourEntityMetadataDriver:
                class: DoctrineORMMappingDriverAnnotationDriver
                paths: ['%kernel.project_dir%/src/Entity']

3. 创建实体类

创建一个简单的实体类 YourEntity.php：

namespace AppEntity;

use DoctrineORMMapping as ORM;

/**
 * @ORMEntity(repositoryClass="AppRepositoryYourEntityRepository")
 */
class YourEntity
{
    /**
     * @ORMId
     * @ORMGeneratedValue(strategy="AUTO")
     * @ORMColumn(type="integer")
     */
    private $id;

    /**
     * @ORMColumn(type="string", length=255)
     */
    private $name;

    // Getters and Setters
}

4. 创建实体仓库

创建一个实体仓库类 YourEntityRepository.php：

namespace AppRepository;

use DoctrineBundleDoctrineBundleRepositoryServiceEntityRepository;
use AppEntityYourEntity;

class YourEntityRepository extends ServiceEntityRepository
{
    public function deleteByCondition($condition)
    {
        $qb = $this->createQueryBuilder('e');
        $qb->delete()
            ->where($qb->expr()->eq('e.name', ':condition'))
            ->setParameter('condition', $condition);

        return $qb->getQuery()->execute();
    }
}

5. 删除记录

现在，你可以使用 deleteByCondition 方法来删除符合条件的记录。例如：

$entityManager = $this->getDoctrine()->getManager();

// 假设你想删除所有名字为 "John" 的记录
$entityManager->getRepository(YourEntity::class)->deleteByCondition('John');

示例代码

以下是一个完整的示例代码，展示了如何创建实体类、实体仓库和删除记录的过程：


<?php

require 'vendor/autoload.php';

use DoctrineORMEntityManager;
use DoctrineORMEntityManagerInterface;
use DoctrineORMToolsSetup;
use DoctrineCommonDataFixturesPurgerORMPurger;
use DoctrineCommonDataFixturesFixtureInterface;
use DoctrineCommonPersistenceObjectManager;

class LoadData implements FixtureInterface
{
    public function load(ObjectManager $manager)
    {
        for ($i = 0; $i < 10; $i++) {
            $entity = new YourEntity();
            $entity->setName("User " . $i);
            $manager->persist($entity);
        }

        $manager->flush();
    }
}

$paths = [__DIR__ . '/data'];

$config = Setup::createAnnotationMetadataConfiguration($paths, false);

$entityManager = EntityManager::create(['driver' => 'pdo_mysql', 'host' => 'localhost', 'dbname' => 'your_database_name', 'user' => 'your_username', 'password' => 'your_password'], $config);

$loader = new DoctrineBundleFrameworkBundleDataFixturesContainerAwareLoader($entityManager);
$loader->load(new LoadData());

$entityManager->clear();

$entityManager->getConnection()->getSchemaManager()->dropDatabaseIfExists('your_database_name');

$entityManager->getConnection()->getSchemaManager()->createDatabase('your_database_name');

$entityManager->getConnection()->getSchemaManager()->createTable(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    [
        'columns' => [
            'id' => [
                'type' => 'integer',
                'unsigned' => true,
                'autoincrement' => true,
                'primary' => true,
            ],
            'name' => [
                'type' => 'string',
                'length' => 255,
            ],
        ],
        'indexes' => [],
        'foreign_keys' => [],
    ]
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addConstraint(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'unique_name',
    [
        'name' => 'unique_name',
        'columns' => ['name'],
    ]
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addIndex(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'idx_name',
    [
        'name' => 'idx_name',
        'columns' => ['name'],
    ]
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_user',
    'AppEntityUser',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_category',
    'AppEntityCategory',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_tag',
    'AppEntityTag',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_product',
    'AppEntityProduct',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order',
    'AppEntityOrder',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_status',
    'AppEntityStatus',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_payment_method',
    'AppEntityPaymentMethod',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_shipping_method',
    'AppEntityShippingMethod',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_customer',
    'AppEntityCustomer',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_item',
    'AppEntityOrderItem',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_shipment',
    'AppEntityOrderShipment',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_return',
    'AppEntityOrderReturn',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_refund',
    'AppEntityOrderRefund',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_invoice',
    'AppEntityOrderInvoice',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_note',
    'AppEntityOrderNote',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_comment',
    'AppEntityOrderComment',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_feedback',
    'AppEntityOrderFeedback',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_review',
    'AppEntityOrderReview',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_rating',
    'AppEntityOrderRating',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_notification',
    'AppEntityOrderNotification',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_event',
    'AppEntityOrderEvent',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_message',
    'AppEntityOrderMessage',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_attachment',
    'AppEntityOrderAttachment',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_file',
    'AppEntityOrderFile',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_link',
    'AppEntityOrderLink',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_coupon',
    'AppEntityOrderCoupon',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_promotion',
    'AppEntityOrderPromotion',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_gift_card',
    'AppEntityOrderGiftCard',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_reward',
    'AppEntityOrderReward',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_subscription',
    'AppEntityOrderSubscription',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_payment',
    'AppEntityOrderPayment',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_shipping',
    'AppEntityOrderShipping',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_return',
    'AppEntityOrderReturn',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_refund',
    'AppEntityOrderRefund',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_invoice',
    'AppEntityOrderInvoice',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_note',
    'AppEntityOrderNote',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_comment',
    'AppEntityOrderComment',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_feedback',
    'AppEntityOrderFeedback',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_review',
    'AppEntityOrderReview',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_rating',
    'AppEntityOrderRating',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_notification',
    'AppEntityOrderNotification',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_event',
    'AppEntityOrderEvent',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_message',
    'AppEntityOrderMessage',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_attachment',
    'AppEntityOrderAttachment',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_file',
    'AppEntityOrderFile',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_link',
    'AppEntityOrderLink',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_coupon',
    'AppEntityOrderCoupon',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_promotion',
    'AppEntityOrderPromotion',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_gift_card',
    'AppEntityOrderGiftCard',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_reward',
    'AppEntityOrderReward',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_subscription',
    'AppEntityOrderSubscription',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_payment',
    'AppEntityOrderPayment',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_shipping',
    'AppEntityOrderShipping',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_return',
    'AppEntityOrderReturn',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_refund',
    'AppEntityOrderRefund',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_invoice',
    'AppEntityOrderInvoice',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_note',
    'AppEntityOrderNote',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_comment',
    'AppEntityOrderComment',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_feedback',
    'AppEntityOrderFeedback',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_review',
    'AppEntityOrderReview',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_rating',
    'AppEntityOrderRating',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_notification',
    'AppEntityOrderNotification',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_event',
    'AppEntityOrderEvent',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_message',
    'AppEntityOrderMessage',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_attachment',
    'AppEntityOrderAttachment',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_file',
    'AppEntityOrderFile',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_link',
    'AppEntityOrderLink',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_coupon',
    'AppEntityOrderCoupon',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_promotion',
    'AppEntityOrderPromotion',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_gift_card',
    'AppEntityOrderGiftCard',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_reward',
    'AppEntityOrderReward',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_subscription',
    'AppEntityOrderSubscription',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_payment',
    'AppEntityOrderPayment',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_shipping',
    'AppEntityOrderShipping',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_return',
    'AppEntityOrderReturn',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_refund',
    'AppEntityOrderRefund',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_invoice',
    'AppEntityOrderInvoice',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_note',
    'AppEntityOrderNote',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_comment',
    'AppEntityOrderComment',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_feedback',
    'AppEntityOrderFeedback',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_review',
    'AppEntityOrderReview',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_rating',
    'AppEntityOrderRating',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_notification',
    'AppEntityOrderNotification',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_event',
    'AppEntityOrderEvent',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_message',
    'AppEntityOrderMessage',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_attachment',
    'AppEntityOrderAttachment',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_file',
    'AppEntityOrderFile',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_link',
    'AppEntityOrderLink',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_coupon',
    'AppEntityOrderCoupon',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_promotion',
    'AppEntityOrderPromotion',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_gift_card',
    'AppEntityOrderGiftCard',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_reward',
    'AppEntityOrderReward',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_subscription',
    'AppEntityOrderSubscription',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_payment',
    'AppEntityOrderPayment',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_shipping',
    'AppEntityOrderShipping',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_return',
    'AppEntityOrderReturn',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_refund',
    'AppEntityOrderRefund',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_invoice',
    'AppEntityOrderInvoice',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_note',
    'AppEntityOrderNote',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_comment',
    'AppEntityOrderComment',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_feedback',
    'AppEntityOrderFeedback',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_review',
    'AppEntityOrderReview',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_rating',
    'AppEntityOrderRating',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_notification',
    'AppEntityOrderNotification',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_event',
    'AppEntityOrderEvent',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_message',
    'AppEntityOrderMessage',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_attachment',
    'AppEntityOrderAttachment',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_file',
    'AppEntityOrderFile',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_link',
    'AppEntityOrderLink',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_coupon',
    'AppEntityOrderCoupon',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_promotion',
    'AppEntityOrderPromotion',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_gift_card',
    'AppEntityOrderGiftCard',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_reward',
    'AppEntityOrderReward',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_subscription',
    'AppEntityOrderSubscription',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_payment',
    'AppEntityOrderPayment',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_shipping',
    'AppEntityOrderShipping',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_return',
    'AppEntityOrderReturn',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_refund',
    'AppEntityOrderRefund',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_invoice',
    'AppEntityOrderInvoice',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_note',
    'AppEntityOrderNote',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_comment',
    'AppEntityOrderComment',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_feedback',
    'AppEntityOrderFeedback',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_review',
    'AppEntityOrderReview',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_rating',
    'AppEntityOrderRating',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_notification',
    'AppEntityOrderNotification',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
    $entityManager->getClassMetadata('AppEntityYourEntity')->getTableName(),
    'fk_id_order_event',
    'AppEntityOrderEvent',
    'id',
    'CASCADE'
);

$entityManager->flush();

$entityManager->getConnection()->getSchemaManager()->addForeignKey(
黑板Bug讲师

黑板Bug讲师

介绍

在处理PHP应用时，使用对象-关系映射（ORM）如Doctrine来管理数据库操作可以非常高效地实现。Doctrine提供了一系列强大的工具，简化了数据库交互。在这篇教程中，我们将探讨如何通过条件删除记录的方法，这对于数据操作频繁的应用来说特别实用。

开始使用Doctrine

在开始删除记录之前，请确保您已安装并配置了Doctrine。Doctrine可以通过Composer（PHP的依赖管理器）进行安装，使用以下命令： composer require doctrine/orm 或者 composer require doctrine/doctrine-bundle 请根据您的项目需求选择合适的包。

composer require doctrine/orm

安装完成后，配置Doctrine以连接到数据库。这通常涉及设置“EntityManager”，该实体负责跟踪所有您将执行的操作。

使用EntityManager

EntityManager 是 Doctrine 的核心数据访问功能的入口点。以下是使用 EntityManager 移除记录的一个简单示例：

$entityManager = GetEntityManager();
$product = $entityManager->getRepository('Product')->find($id);
if ($product) {
    $entityManager->remove($product);
    $entityManager->flush();
}

该代码查找具有特定“ID”的产品并从数据库中删除，如果存在的话。

条件删除操作

如果你想根据条件删除一条记录，可以使用Criteria API或DQL（Doctrine查询语言）。以下示例使用了DQL：

$query = $entityManager->createQuery("DELETE FROM Product p WHERE p.name = :name");
$query->setParameter('name', 'MyProduct');
$query->execute();

在这种情况下，在“产品”实体中有名称为“MyProduct”的记录将会从数据库中删除。

高级删除操作

对于更复杂的条件或涉及关联的操作，您可以充分利用Doctrine的功能：

使用Criteria API删除操作

Criteria API允许您构建一个criteria对象，该对象可用于过滤选择或删除：

use DoctrineCommonCollectionsCriteria;

$criteria = Criteria::create()->where(Criteria::expr()->eq("name", "OldProduct"));
$products = $repository->matching($criteria);
foreach ($products as $product) {
    $entityManager->remove($product);
}
$entityManager->flush();

该代码构建了一个删除条件，该条件针对名称为 ‘OldProduct’ 的产品进行删除。

事务性删除操作

为了保持数据的完整性，你可以考虑使用事务：

$entityManager->transactional(function($entityManager) {
    $product = $entityManager->getRepository('Product')->findOneBy(['name' => 'MyProduct']);
    if ($product) {
        $entityManager->remove($product);
    }
});

这将确保删除操作在事务中执行。

处理异常

在删除记录时，可能会因为外键约束或数据库模式中定义的其他规则而遇到异常。重要的是要处理这些异常：

try {
    // Deletion code goes here
    $entityManager->flush();
} catch (DoctrineORMORMException $e) {
    // Handle exception (e.g., log it and proceed with a fallback operation)
}

正确处理异常确保应用程序稳定，并向用户或调用过程提供有意义的反馈。

结论

Doctrine 中的特定条件删除记录的能力使开发人员能够编写简洁且表达力强的数据库操作。通过利用 DQL 和 Criteria API，精确的删除命令确保相关数据受到影响并维护系统完整性。

长工码奴1523

长工码奴1523

在PHP中，我们可以通过使用ORM（对象关系映射）库如Doctrine来轻松地从数据库中删除数据。以下是如何根据特定条件删除一条记录的步骤：

1. 首先，确保你已安装了PHP和PDO扩展。

sudo apt-get install php-pdo

2. 安装Doctrine ORM

  • 如果你还没有安装，可以使用Composer来安装：

    composer require doctrine/orm

  • 或者手动下载并编译：

    git clone https://github.com/doctrine/orm.git
cd doctrine-orm
phpize
./configure --with-php-config=/usr/local/bin/php-config
make

3. 创建一个新的实体类（假设名为User.php）

<?php

namespace AppEntity;

use DoctrineORMMapping as ORM;
use SymfonyComponentValidatorConstraints as Assert;

/**
 * @ORMEntity(repositoryClass="AppRepositoryUserRepository")
 */
class User
{
    /**
     * @ORMId()
     * @ORMGeneratedValue()
     * @ORMColumn(type="integer")
     */
    private $id;

    /**
     * @AssertNotBlank(message="Username is required.")
     * @ORMColumn(type="string", length=64, unique=true)
     */
    private $username;

    /**
     * @ORMColumn(type="string", length=128)
     */
    private $password;

    // getters and setters for other fields...
}

4. 使用ORM创建一个Repository接口

<?php

namespace AppRepository;

use DoctrinePersistenceObjectManager;
use DoctrineORMQueryBuilder;

interface UserRepositoryInterface extends DoctrineORMProxyProxy
{
    public function deleteById($id): bool;
}

// Example of how to use the repository interface:
$userRepository = new UserRepository();
$deleteResult = $userRepository->deleteById(1);
echo "Deleted user with ID: " . $deleteResult;

5. 实现Delete方法

public function deleteById($id): bool
{
    if ($this->find($id) === null) {
        return false; // User not found
    }

    $entityManager = EntityManager::getEntityManager();

    // Use the QueryBuilder to construct a DELETE statement
    $qb = $entityManager->createQueryBuilder();
    $qb->delete(User::class)->where('u.id = :id')->setParameter('id', $id);

    // Execute the query and get the number of affected rows (1 means success)
    $affectedRows = $qb->execute();

    // Return true if at least one row was deleted, false otherwise
    return $affectedRows > 0;
}

在这个例子中，我们首先检查用户是否存在，然后通过ORM执行DELETE语句。这将根据您设置的ID删除指定的用户。

示例代码

<?php

namespace AppController;

use AppEntityUser;
use AppRepositoryUserRepository;
use SymfonyBundleFrameworkBundleControllerAbstractController;
use SymfonyComponentHttpFoundationRequest;
use SymfonyComponentRoutingAnnotationRoute;

class UserController extends AbstractController
{
    #[Route('/users/{id}', name: 'app_users_show')]
    public function showUserAction(Request $request, $id): Response
    {
        $repository = $this->getDoctrine()->getRepository(User::class);
        $user = $repository->findById($id);

        return $this->render('users/show.html.twig', [
            'user' => $user,
        ]);
    }
}

在这个控制器中的showUserAction方法，我们调用了findById方法，并且如果找到该用户，我们将返回渲染后的模板显示该用户的信息。

最新更新