A proplem!! All fields need to set up?（create or save）

Question

A proplem!! All fields need to set up?（create or save）

BaiYulong Dec '14

Created Dec '14	Last Reply Dec '14	Replies 5	Views 1243	Votes 0

BaiYulong 15.6k

Dec '14

<?php
                    $user = new User();
                    $user->email = $postData['email'];
                    $user->password = md5($postData['password']);
                    $user->yy = $postData['yy'];
                    $user->mobil = $postData['mobil'];
                    if ($user->save() == false) {
                        foreach ($user->getMessages() as $message) {
                            echo $message . '<br>';
                        }
                    } else {
                        echo 'ok';
                    }

When I insert a record. I will get message:

name is required

nickname is required

idcard is required

alipay is required

vip is required

ww is required

qq is required

addtime is required

updatetime is required

status is required

But these fields are not need!!! Please help me ...

BaiYulong
15.6k

Accepted
answer

Dec '14

Thank U!!! U are right.

I see these page

https://github.com/phalcon/cphalcon/issues/440

https://forum.phalcon.io/discussion/283/created-at-and-validation

And understand how to solve the proplem.

Paste my code

<?php
// use Phalcon\Db\RawValue;
// in model
    public function beforeValidationOnCreate()
    {
        $notNullAttributes = $this->getModelsMetaData()->getNotNullAttributes($this);
        foreach ($notNullAttributes as $field) {
            if (!isset($this->$field)) {
                $this->$field = new RawValue('default');
            }
        }
    }

Vladimir Khramov · Answer 1 · 2014-12-08T21:03:53-07:00

Which version u use?

if 1.3 try:

\Phalcon\Mvc\Model::setup(array(    
    'notNullValidations' => false
));

on app init

Vladimir Khramov · Answer 2 · 2014-12-09T01:24:55-07:00

it is not enough: u need something like this:

    public function beforeValidationOnCreate()
    {
        $notNullAttributes = $this->getModelsMetaData()->getNotNullAttributes($this);
        foreach ($notNullAttributes as $field) {
            if (is_null($this->$field)) {
                $this->$field = new RawValue('default');
            } elseif($this->$field=="") {
                $this->$field = new RawValue("''");
            }
        }
    }

    public function beforeValidationOnUpdate()
    {
        $notNullAttributes = $this->getModelsMetaData()->getNotNullAttributes($this);
        foreach ($notNullAttributes as $field) {
            if(!is_null($this->$field) && $this->$field=="") {
                $this->$field = new RawValue("''");
            }
        }
    }

Niclas Günther · Answer 3 · 2014-12-09T05:17:13-07:00

Or you can simply skip the Attributes on create

Put this in your model:

    public function initialize()
    {
        $this->skipAttributesOnCreate(array('field1', 'field2'));
    }

For on Update use this:

    public function initialize()
    {
        $this->skipAttributesOnUpdate(array('field1', 'field2'));
    }

Vladimir Khramov · Answer 4 · 2014-12-09T06:31:22-07:00

Bad advice

Or you can simply skip the Attributes on create

Put this in your model:
  public function initialize()
  {
      $this->skipAttributesOnCreate(array('field1', 'field2'));
  }
For on Update use this:
  public function initialize()
  {
      $this->skipAttributesOnUpdate(array('field1', 'field2'));
  }

Niclas Günther · Answer 5 · 2014-12-09T07:43:30-07:00

Bad advice
Or you can simply skip the Attributes on create

Put this in your model:
 public function initialize()
 {
     $this->skipAttributesOnCreate(array('field1', 'field2'));
 }
For on Update use this:
 public function initialize()
 {
     $this->skipAttributesOnUpdate(array('field1', 'field2'));
 }

Why?

BaiYulong · Answer 6 · 2014-12-10T22:45:41-07:00

Very good!! 3Q. And I have another question about the model's validation.

How to differentiate between create and update the validation?

it is not enough: u need something like this:

   public function beforeValidationOnCreate()
   {
       $notNullAttributes = $this->getModelsMetaData()->getNotNullAttributes($this);
       foreach ($notNullAttributes as $field) {
           if (is_null($this->$field)) {
               $this->$field = new RawValue('default');
           } elseif($this->$field=="") {
              $this->$field = new RawValue("''");
          }
       }
   }

   public function beforeValidationOnUpdate()
   {
       $notNullAttributes = $this->getModelsMetaData()->getNotNullAttributes($this);
       foreach ($notNullAttributes as $field) {
           if(!is_null($this->$field) && $this->$field=="") {
              $this->$field = new RawValue("''");
          }
       }
   }

BaiYulong · Answer 7 · 2014-12-10T23:04:30-07:00

Your answer is right too.

But I think Vladimir Khramov's answer is better. Because these functions(like beforeValidationOnCreate<Update>) can writen in BaseModel. But skipAttribute need setup in every model.

My english is poor. Hope U understand!

Bad advice
Or you can simply skip the Attributes on create

Put this in your model:
public function initialize()
{
    $this->skipAttributesOnCreate(array('field1', 'field2'));
}
For on Update use this:
public function initialize()
{
    $this->skipAttributesOnUpdate(array('field1', 'field2'));
}
Why?