On 1/4/07, Ammar Ibrahim <[EMAIL PROTECTED]> wrote:
...... What I would do, is create an abstract validation class, and have some sort of a factory for every rule.$colDelimiter = ','; $recordDelimiter = "\n"; $escapeChar = '\\'; $cols = 5; $col[0] = new CsvValidator('int', array('min'=>1, 'max' => 10) );//min & max are optional $col[1] = new CsvValidator('string', array('minLength' => 10, 'maxLength' => 20) ); $col[2] = new CsvValidator('alphanum'); //e.g. Alphanumeric $col[3] = new CsvValidator('date', array('MM/DD/YY') );//Supply the mask $col[4] = new CsvValidator('regex', array('[a-zA-Z0-9]{,5}') ); //etc
very flexible, but over complicates things for my tiny program, I'll probably use a more flexible design later, maybe when I get it to work with all the data types I want.
You could also simplify the API by not supplying the arguments to the actual driver as an array, instead have a function that receives arbitrary number of arguments and works on them (This is supported in PHP, check http://php.net/func_get_args).
Let me remind you that I'm using perl :). I think perl sees all arguments as elements of one array: @array = (1, 2, 3); $arrayRef = [EMAIL PROTECTED]; func( $arrayRef, @array); the Argument array (@_) will look like this: ($arrayRef, 1, 2, 3) So their is no problem with variable number of arguments.
A gotcha: what if a string contained the delimiter? you need to do a bit of checking on that, unless you have a nice library that removes this headache.
This is solved by the CSV files specification witch states that if a field contains the delimiting character it should be quoted. in perl their is a module (TEXT::CSV) that handles these issues, but of course doesn't provide validation.
Auto generating SQL should be very easy. You can as well use the factory strategy to generate SQL for different RDBMS. Depending on your target database, you would generate the desired SQL. e.g. A SQL generator for MySQL, Postgres, Oracle ..etc In PHP, some really advanced SQL abstraction layers exist that would make generating SQL for dozens of databases rather easy.
I'm not using any abstraction layer, Although I should be using one. but I don't really know if perl has one. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Jolug" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups-beta.google.com/group/Jolug?hl=en-GB -~----------~----~----~----~------~----~------~--~---
