Sorry for the mistake about the images.
The current version is: http://img15.imageshack.us/img15/7747/44037591.png
About the problem, many thanks for all the explanations about the way SQLITE
deals with Regular Expressions.
It worked perfectly. If interested to anyone (as part of PHP routine):
>> private function extend() {
>>
>> if( ! method_exists( $this -> dbh, 'sqliteCreateFunction' ) ) {
>> throw new RouterException( 'PDO::sqliteCreateFunction() doesn\'t
exist in current >> Database Handler so you are not able to use Standard
Router' );
>> }
>>
>> $this -> dbh
>> -> sqliteCreateFunction(
>>
>> 'REGEXP',
>>
>> function( $regex, $string ) {
>>
>> if( preg_match( sprintf( '@%s@', $regex ), $string ) !=
0 ) {
>> return TRUE;
>> }
>>
>> return FALSE;
>> },
>>
>> 2
>> );
>> }
Using:
>> 'SELECT `RouteID`, `Application`, `Class`, `Method`,
>> `RequiredParams`, `OptionalParams`
>> FROM `Routes` WHERE `RequestMethod` = "GET"
>> AND "STRING_HERE" REGEXP `URI`'
I hope this helps someone else.
--
Best Regards
Bruno Augusto
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
