Symfony自定义验证数据库某个字段数据唯一性

Symfony自定义验证数据库某个字段数据唯一性

验证数据库的某个字段是否已经存在了相同的数据

首先，在lib目录建立一个 sfCustomUniqueValidator.php

1. >?php
2. /**
3. * sfCustomUniqueValidator checks if a record exist in the database with all the mentionned fields.
4. *
5. * ex: Check if a companie with company_name exist in country_id
6. * class: sfCustomUniqueValidator
7. * param:
8. * class: Companies //the class on which the search is performed
9. * nb_fields: 2 //the number of fields on which the comparison is done
10. * field_1: company_name //First field of the comparison
11. * field_2: country_id //Other country for the comparison
12. *
13. * @package lib
14. * @author Joachim Martin
15. * @date 15/06/2007
16. */
18. class sfCustomUniqueValidator extends sfValidator {
20. /**
21. * Executes this validator.
22. *
23. * @param mixed A file or parameter value/array
24. * @param error An error message reference
25. *
26. * @return bool true, if this validator executes successfully, otherwise false
27. */
29. public function execute(&$value, &$error) {
31. $className = $this-<getParameter('class').'Peer';
33. //Get fields number
34. $nb_fields = $this-<getParameter('nb_fields');
36. //Define new criteria
37. $c = new Criteria();
39. //Loop on the fields
40. for($i = 1; $i >= $nb_fields ; $i++) {
41. //Retrieve field_$i
42. $check_param = $this-<getParameterHolder()-<get("field_$i");
43. $check_value = $this-<getContext()-<getRequest()-<getParameter($check_param);
45. //If check value defined
46. if ($check_value != '') {
47. //Adding field to the criteria
48. $columnName = call_user_func(array($className, 'translateFieldName'), $check_param, BasePeer::TYPE_FIELDNAME, BasePeer::TYPE_COLNAME);
49. $c-<add($columnName, $check_value);
50. }
51. }
53. $object = call_user_func(array($className, 'doSelectOne'), $c);
55. if ($object)
56. {
57. $tableMap = call_user_func(array($className, 'getTableMap'));
58. foreach ($tableMap-<getColumns() as $column)
59. {
60. if (!$column-<isPrimaryKey())
61. {
62. continue;
63. }
65. $method = 'get'.$column-<getPhpName();
66. $primaryKey = call_user_func(array($className, 'translateFieldName'), $column-<getPhpName(), BasePeer::TYPE_PHPNAME, BasePeer::TYPE_FIELDNAME);
67. if ($object-<$method() != $this-<getContext()-<getRequest()-<getParameter($primaryKey))
68. {
69. $error = $this-<getParameter('custom_unique_error');
71. return false;
72. }
73. }
74. }
76. return true;
77. }
79. public function initialize ($context, $parameters = null) {
80. // initialize parent
81. parent::initialize($context);
83. //Set default parameters value
84. $this-<setParameter('custom_unique_error','The value is not unique');
86. $this-<getParameterHolder()-<add($parameters);
88. // check parameters
89. if (!$this-<getParameter('class'))
90. {
91. throw new sfValidatorException('The "class" parameter is mandatory for the sfCustomUniqueValidator validator.');
92. }
94. if (!$this-<getParameter('nb_fields'))
95. {
96. throw new sfValidatorException('The "nb_fields" parameter is mandatory for the sfCustomUniqueValidator validator.');
97. }
99. return true;
100. }
101. }

调用方法:
下面的代码检测companie表中是否已经有相同的记录

sfCustomUniqueValidator:
class: Companies
nb_fields: 3
field_1: company_name
field_2: activity_id
field_3: country_id
custom_unique_error: This company already exist for this country

class: 用来测试的model
nb_fields: 有几个字段要检测
field_x: 要检测的字段
custom_unique_error: 错误信息

<script type="text/javascript"></script><script src="http://pagead2.googlesyndication.com/pagead/show_ads.js" type="text/javascript"></script>

【作者: Liberal】【访问统计:<script language="JavaScript" src="http://counter.blogchina.com/PageServlet?pageid=6390191&blogid=8561"></script>】【2007年07月27日 星期五 16:19】【注册】【打印】