Questions tagged [check-constraints]
CHECK constraints enforce domain integrity by limiting the values that are accepted by one or more columns.
check-constraints
640
questions
1
vote
2
answers
46
views
Model field "null together or not at all" constraint
I need a way to create either a validator or a constraint at model level to evaluate two or more fields to be able to be null/blank only if all of them are null/blank at the same time.
For example, in ...
0
votes
1
answer
24
views
Django test a custom field in a test model using SqlLite3; cannot disable constraint checking to create database table
I need to write test for a custom field with access to the database.
The code is the following :
class TestMyField (TestCase):
def SetUpClass(cls):
super().setUpClass()
class MyModel(...
- 43
1
vote
4
answers
53
views
Create CHECK constraint based on complex algorithm
A personal identity codes consist of a string of numbers that indicates the individual’s date of birth, an individualized string, and a control character.
Example: 150600A905P
• 150600 = Date of birth ...
- 21
0
votes
0
answers
15
views
binary variable assignement in lingo
Scheduling output# binary variable assignement in lingo
binary variable assignement in lingo
the schedule is not continuous rather my period start and end time is influencing the batch start and ...
2
votes
1
answer
218
views
Stata: How do I check whether the value of one variable exists somewhere in the column of another variable?
I have two variables in Stata which are string (MAIDCW1 and strboth).
I would like to check for each observation whether the value of MAIDCW1 exists somewhere in the whole of strboth. If this value ...
- 21
0
votes
0
answers
45
views
How to check the type of *all* elements in a JSONArray within SQLite CHECK-constraint?
This is the Table in SQlite:
CREATE TABLE document(
id TEXT NOT NULL,
data TEXT NOT NULL,
CHECK ( json_type(data, '$.documentLines.title') IN ('text') ),
PRIMARY KEY (id)
) STRICT;
This ...
- 33
1
vote
1
answer
38
views
Check Constraint in Django
I want to include a check constraint for my model in my members app where the sex field should be male, female or null. Here is my code:
from django.db import models
from django.db.models import ...
-1
votes
1
answer
83
views
Without check constraint how Bigquery validate data?
We don't have application running on server,
so all the logic need to be done on Bigquery.
I know Microsoft SQL Server have check constraint like:
CREATE TABLE MyCleanJapanClient (
Phone varchar(...
- 47
0
votes
1
answer
52
views
CPlex: "No value" for all decision variables and how to solve conflicts
I run the code and the results is always "no value " for all decision variables. In the conflicts tab it shows:"ct20#1#10#4, ct21#1#10#4,ct22#1#10#4)", but I stuck and do not know ...
0
votes
1
answer
63
views
CPLEX: CP Optimizer took forever to run with no solution
I run my model in CPLEX using Constraint Programming for quite a long time, but it still has no solution so I have to stop the model.
Is there something wrong with my model? I tried to run the model ...
0
votes
1
answer
89
views
How to code nonlinear constraints in CPlex opl?
This is a part of my Cplex code. I want to code the constraint below but it seems nonlinear constraints and can not run in CPlex opl. Can anyone help me deal with it?
Here is the constraint
...
int ...
0
votes
0
answers
46
views
Non linear constraints in Cplex opl
``Can anyone help me check this Cplex code, it has many errors that can not extract the expression for many constraints, especially 15 and 18 . Many others have the same problem but I move the ...
0
votes
2
answers
66
views
sql constraint in a check in
When creating a constraint for a hierarchy I get an error, it doesn't let me make inserts
I leave the code in case someone can give me a hand:
CREATE TABLE JUGADORES (
Id_jugador NUMBER (4) ...
- 21
-1
votes
1
answer
235
views
how can i put a check constraint to the phone number in mysql? [duplicate]
to check the phone number that it should be of the 10 digits , so how can i put the check constraint so that it will be validated
i try using the simple technique but i guess it will check only the ...
1
vote
1
answer
126
views
Creating a check constraint using liquibase
What are the options for adding check constraints to columns in tables when using Liquibase?
I have tried using the Liquibase checkConstraint attribute, but it doesn't seem to work, possibly because ...
- 21