Comments (6)
@webysther Please help test out #73 and give feedback if possible. It is based on version 3.0.0, so you need to upgrade (Usually only thing necessary is to update the service provider class in your config/app.php
, which has been renamed)
from uniquewith-validator.
Hi @felixkiss works partially, the problem of SQL is fine, but now search works but dont check all columns, example:
For rule:
unique_with:search_filters,search.name = name, search.user_id = user_id
Return the message:
This combination of search.name, search.user id already exists.
And the SQL executed is by validation:
select count(*) as aggregate from `search_filters` where `name` = 'teste'
My create statment:
CREATE TABLE `search_filters` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`name` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`filter` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`deleted_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`created_by` int(10) unsigned DEFAULT NULL,
`updated_by` int(10) unsigned DEFAULT NULL,
`deleted_by` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `uk_search_filters` (`user_id`,`name`,`deleted_at`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
Rows in table:
# id, user_id, name, filter, created_at, updated_at, deleted_at, created_by, updated_by, deleted_by
'2', '20', 'teste', 'action-search=&period=&product_id=&requester_auto_complete=&requester_id=&search_term=&status=pending', '2017-02-22 17:55:10', '2017-02-22 17:55:19', '2017-02-22 17:55:19', '20', '20', NULL
'3', '20', 'teste', 'action-search=&period=&product_id=&requester_auto_complete=&requester_id=&search_term=&status=pending', '2017-02-22 18:05:41', '2017-02-22 18:05:41', '0000-00-00 00:00:00', '20', '20', NULL
from uniquewith-validator.
@felixkiss maybe is related to laravel/framework#1820
On my case check null not work, i need set value '0000-00-00 00:00:00'
from uniquewith-validator.
I just tried it myself. I had the exact same problem as you until I noticed that I wasn't using the dot-validation
branch. What does your composer.json
look like? Should be something like
{
"require": {
"felixkiss/uniquewith-validator": "dev-dot-validation"
}
}
from uniquewith-validator.
As for the deleted_at
problem: Just set the value to ignore (in your case 0000-00-00 00:00:00
) in the validator data array like so:
$data = [
'search' => [
'name' => 'foo',
'user_id' => 2,
],
'deleted_at' => '0000-00-00 00:00:00',
];
$rules = [
'search.name' => 'required|unique_with:search_filters, search.name = name, search.user_id = user_id, deleted_at',
'search.user_id' => 'required',
];
$validator = Validator::make($data, $rules);
from uniquewith-validator.
Now works! 👍
from uniquewith-validator.
Related Issues (20)
- It only works for the current request HOT 4
- Bad method call HOT 1
- Validation fails when updating composite keys with ignore HOT 1
- Using that validation rule with renamed fileds
- Update for Laravel 6.0 HOT 1
- Can't seem to get it working for Polymorph fields HOT 2
- How to add deleted_at, NULL HOT 2
- Update for Laravel 8.0 HOT 10
- Please add support for PHP 8 HOT 1
- Ignore is not working in array validation HOT 1
- unique_with can't validation on multiple column
- Migrate test suite from Travis to Github Actions HOT 1
- Wrong locale set on app
- Compatibility Issue with laravel 9 php 8.X HOT 11
- Counter-intuitive deleted_at in rules
- Ignoring deleted items not working properly
- Laravel 5.4 : doesn't work on updating ! HOT 5
- its not working with database connection HOT 1
- Giving duplicate entry in every new entry HOT 2
- Is there a possibility of a validator plugin for exist_with? HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from uniquewith-validator.