[gnome-db] Studying the posibility to add parametrized statements



I've been studying the posibility to add parametrized statements to 
libgda, but the modifications needed are important, so I'd need some
advise :-).

These are the steps i thought:

1. Set gda_command text with the parametrized statement.
2. Somehow, prepare the statement to let the provider get parameters
    info (like parameters data type), and construct a list with
    "parameter objects".
3. Set parameter values (using some gda_command method).
4. Finally execute gda_command.

This method would need:

1. gda_command_prepare (), gda_command_get_parameter (),
    gda_command_parameter_count (), gda_command_get_parameter_list (),
    some execute method form parametrized statements and so no.
2. A new class named sql_parameter, command_parameter, cmd_parameter,
    or any other name :-), to manage parameters.
3. A set of functions to let providers process parametrized statements.
4. To add GDA_CONNECTION_FEATURE_PARAMETRIZED_SQL or similar.

Is this right ?

Seems like a lot of work :-D.
I would really apreciate any comment.
Thanks

-- 
Jeronimo Albi
Linux User #345522

Jabber ID: gtk_jeronimo jabber org
ICQ UIN:   136196282

-- 
Jeronimo Albi
Linux User #345522

Jabber ID: gtk_jeronimo jabber org
ICQ UIN:   136196282




[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]