Hi guys,
Was there an idea to wrap all select/insert/update queries into different generic
functions like:
query_insert(Table *table, String *select_item, String *where_item, String *extra_item)
query_select(*same*)
query_update(*same*)
(brainstorming )
AFAIK there can be generic solution for mysql and pgsql, the way to do that is to
eliminate the use of most of the built in functions which doesn't exist on both
databases, also this approach brings not only portability but easy modifications in
the future, instead of modifying all the queries which do INSERT/../.. we can just modify
these, i find it quite nice ;) and for sure it will save time.
this thing just came to mind while i was trying to merge the sequence generator,
modifying each query function was a big pain.
db_query() and so are nice but it can be done better...
I'm willing to change the structure to the one above, but i'll need some more time to
finish the research.
does anyone have anything against this idea or any comments?
cheers
-lou
Was there an idea to wrap all select/insert/update queries into different generic
functions like:
query_insert(Table *table, String *select_item, String *where_item, String *extra_item)
query_select(*same*)
query_update(*same*)
(brainstorming )
AFAIK there can be generic solution for mysql and pgsql, the way to do that is to
eliminate the use of most of the built in functions which doesn't exist on both
databases, also this approach brings not only portability but easy modifications in
the future, instead of modifying all the queries which do INSERT/../.. we can just modify
these, i find it quite nice ;) and for sure it will save time.
this thing just came to mind while i was trying to merge the sequence generator,
modifying each query function was a big pain.
db_query() and so are nice but it can be done better...
I'm willing to change the structure to the one above, but i'll need some more time to
finish the research.
does anyone have anything against this idea or any comments?
cheers
-lou