Handling Duplicates and Indexes in Structures

dodgerid

Hi,

Is it possible to add two or more column indexes to your database structure.php ? (To prevent duplicates)

Also if it is possible what would be the correct method in garden of handling the error returned for inserting a duplicates to prevent bonking ?

Can I have the Developer role please, so I can put these questions in the right place ?

sahotataran

patience is all it takes

sahotataran

patience is all it takes

dodgerid

Hehe, ok will extend Gdn_Model for my App and pass data through a duplicate check, I wonder if........ yep save allows duplicates.

Will have to save form data differently also.

dodgerid

Ok, very simple, very sweet solution:

public function IsDuplicate($table = '', $where) { $Duplicate = $this->SQL->Select('*')->From($table)->Where($where)->Get(); if ($Duplicate) { return True; } else { return False; } }

dodgerid

The Code Above Is Flawed.

It Should Be:

public function IsDuplicate($table = '', $where) { $Duplicate = $this->SQL->Select('*')->From($table)->Where($where)->Get(); if ($Duplicate->FirstRow() == false) { return False; } else { return True; } }

dodgerid

Ok version 3 of the above, this one seems to work flawlessly where as I kept getting errors with the above, although this version only allows you to compare one value against the values returned by a particular reference.

I.e If your looking for a message subject by a particular user your $CompareIndex would be 'User_ID' say, your $CompareIndexValue would be the users user_id and the $CompareValue would be the subject your looking for and would then return False if its not found and True if it is.

public function IsDuplicate($table = '', $CompareIndex, $CompareIndexValue, $CompareValue) {
        $Records = $this->SQL->Select('*')->From($table)->Where($CompareIndex . ' =', $CompareIndexValue)->Get();
        foreach ($Records as $Record)
        {
            foreach($Record as $Entry)
            {
                if ($Entry == $CompareValue)
                    return True;
            }
        }
        return False;
    }

Ok so still not perfect but closer.

Not being funny but I'm thinking that the prevention of duplicate entries or the handling of, really should be in the base functionality here.

Just an after thought, but part of the problem I have had is checking the value posted back from a form in the IsDuplicate check.

You cannot just go $userid = $this->Form->UserID; as the values posted back for obvious reasons are protected.

So instead, what you have to do is $userid = $this->Form->GetValue('UserID');

Viva la Vanilla!