Level 32
it fails even providing valide date?
Oct 3, 2016
11
Level 2
Date uniqueness validation fails
I am having a date field in DB, the date is a Carbon instance. Now I need to have uniqueness validation on this date column.
My Migration
public function up()
{
Schema::create('holidays', function (Blueprint $table) {
$table->increments('id');
$table->date('date')->unique()->nullable();
$table->string('day', 16)->nullable();
$table->string('description', 100)->nullable();
$table->timestamps();
});
}
My Model
protected $dates = ['date'];
public function setDateAttribute($date)
{
if ($date) {
$this->attributes['date'] = Carbon::parse($date);
} else {
$date = null;
}
}
My FormRequest
return [
'date' => 'unique:holidays,date',
'description' => 'required',
];
The issue is that the validation is getting failed. How do I make date unique. As an alternative, I can save it as a string where the uniqueness is working but I need to sort is on basis of date.
Update: The date format that is saved in DB is d-m-Y
Level 2
yes, the validation fails and I get error at database level. Duplicate Entry
Level 2
@tomi You can have null values in unique column. http://stackoverflow.com/questions/1346765/unique-constraint-that-allows-empty-values-in-mysql. I am getting this error when I am adding the same date again.
Level 1
Try replacing comma with '|' :
return [
'date' => 'unique:holidays|date',
'description' => 'required',
];
Level 2
the date is the column name in holidays table.
Refer Laravel Docs
@a23mer still I tried but its not working.
Update: The error is as follows.
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2016-10-05' for key 'holidays_date_unique'
(SQL: insert into `holidays` (`day`, `date`, `description`, `updated_at`, `created_at`)
values (, 2016-10-05 00:00:00, Testing, 2016-10-04 12:50:24, 2016-10-04 12:50:24))
Level 1
My mistake, I thought "date" was for validating the data type. I can't figure out what's wrong. I usually use a Validator::make with the input fields and the rules as parameters, then redirect it back with errors if the validator fails.
Level 2
Even if I use the validator the same issue occurs, for time being I have changed the date type to string and the uniqueness is working, I wanted to keep the date as a Carbon instance.
Level 56
Strange. Dates are mutated so a carbon instance is transformed into a suitable value when saving to the database. Maybe the mutator are not used for uniqueness validation? Did you put the 'date' field into the $dates array of the model?
Level 2
@pmall
yes, Should I use the getDateAttribute method. I had used it since the date can be nullable.
public function setDateAttribute($date)
{
if ($date) {
$this->attributes['date'] = Carbon::parse($date);
} else {
$date = null;
}
}
Level 56
Why dont you just put it in the $dates array?
Level 2
@pmall I tried is as per your suggestion still the same issue.
My Model
protected $dates = ['date'];
My controller
public function store(HolidayFormRequest $request)
{
$newHoliday = new Holiday();
$newHoliday->day = $request->input('day') == "" ? null : $request->input('day');
$newHoliday->date = $request->input('date') == "" ? null : Carbon::parse($request->input('date'));
$newHoliday->description = $request->input('description');
$newHoliday->save();
Flash::success(trans('webresponse.insertSuccess'));
return redirect()->route('holiday.index');
}
My Form Request
public function rules()
{
return [
'date' => 'unique:holidays',date, // even tried 'unique:holidays',
'description' => 'required',
];
}
Please or to participate in this conversation.