[Koha-bugs] [Bug 10454] Duplicate card numbers may be generated

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10454

--- Comment #6 from M. Tompsett <mtompset at hotmail.com> ---
Adding another dependency is undesirable. This is why my random string is based
on String::Random, which is already a dependency. I use Time::HiRes for the
microsecond time, which is already a dependency. I use CGI::Cookie to read the
session number, which is already a dependency. And I use $$, which is already
built into Perl. No dependencies added, and at 74 characters long, some of
which are padding (1-5 for $$ and about 4 for the microsecond time), I'm pretty
confident on it's random uniqueness.

I have been playing with last_insert_id to try to get it to generate a bad
result, and it would seem that DBI's last_insert_id is keyed to the database
handle's connection, so it would be good enough to use. It would certainly
simplify the code I'm working on. :)

Any comments on what to put for the parameters to be as generic and forward
compatible as possible? The DBI cpan pages gives the example:
    $rv = $dbh->last_insert_id($catalog, $schema, $table, $field);
What should the $catalog and $schema be?

I looked in information_schema for clues. I suspect 'def', 'kohadata' (or
whatever you called your database). The schema then should be easily
determined, but then I don't know of a good way to determine catalog.

-- 
You are receiving this mail because:
You are watching all bug changes.