Frank Tsao wrote:
Hi, everyone,
I am a beginner in ruby programming and I have a minor question about
data checking, if someone who could give me a suggestion that would be
great.
The system needs to prevent a duplicated record happened in database,
the record is consisted of two fields which are column A and column B.
Supposing a record has been saved in database that the A=1, B=1.
Afterward, the same set of record can not be accepted again, for
example, record: A=1, B=2 and A=2, B=1 both are acceptable. In other
words, record: A=1, B=1 can not be saved in database.
So how to check and prevent a new record that has the same columns with
same values tend to be saved in database?
Most database systems can handle that, be defining a UNIQUE constraint
on columns.
However, that means that A = 1 and B = 2 won't work.
Different methods to access databases have different ways to handle
these kinds of collisions, or at least different ways to implement the
collision detection.
(For example, you can fetch all records, and check if they are already
set, but that is rather bad for memory consumption and speed, but might
be enough in your case.)
So, if you can tell us how you access your database (and what it is), we
can help you out much better.
- --
Phillip Gawlowski
Twitter: twitter.com/cynicalryan
~ - You know you've been hacking too long when...
...your brain keeps hallucinating random "system error: collision with
stack heap" or "Guru Meditation Mode # Three billion and fifty-two,
press left button to continue" or even "This is not a DOS disk." error
messages.