Sorry again I missed the file (its the time :-) 2008/12/28 Daniel Espinosa <[email protected]>
> For GType to String and String to GType I found the following: > > gda_g_type_from_string > > This function doesn't use the standard g_type_from_name and the name of the > string it checks doesn't correspond with the standard g_type_name retuning > string > > gda_g_type_to_string > > This function use the standard g_type_name, but the above don't. > > But even after applying the attached PATCH (its a mix with the > GdaBatchStatement) the error doesn't desapear: > > > *Could not determine GType for parameter '2+:string:N' > > *Is the "2+:string:N" a correct strin to create a paramenter using > 'gda_sql_param_spec_new'? > > > > 2008/12/27 Daniel Espinosa <[email protected]> > >> Sorry here is the PATCH. >> >> 2008/12/27 Daniel Espinosa <[email protected]> >> >> I have almost finished. I have added a propoused GdaBatchStatement new >>> object to manage one GdaStatement and the GdaSet objects with the values to >>> use when execute that statement, and added a new >>> gda_connection_batch_statement_execute in order to run this new Batch type. >>> Attached you will find the PATH for it. >>> >>> >>> To test it I'm working in the GdaEasy functions to easy construct and add >>> new values to a GdaBatchStatement, but I have a problem with parameters >>> type. For the moment you need to prepare (create the GdaBatchStatement) with >>> the column name and GType, but when convert this GType to string using >>> g_type_string the LibGDA returns an error for G_TYPE_STRING ones: >>> >>> Could not determine GType for parameter '2+:gchararray:N' >>> >>> In documentation for strings LibGda use 'string' to detemine the type of >>> the parameter, are there any way to get this names used by libgda using a >>> GType? if not, where can I found the names used by libgda in order to make >>> this 'translation'? >>> >>> 2008/12/24 Vivien Malerba <[email protected]> >>> >>> >>>> >>>> 2008/12/24 Daniel Espinosa <[email protected]> >>>> >>>> >>>>>> >>>>>> 2008/12/23 Vivien Malerba <[email protected]> >>>>>> >>>>>>> >>>>>>> >>>>>>> 2008/12/21 Daniel Espinosa <[email protected]> >>>>>>> >>>>>>>> Hi all >>>>>>>> >>>>>>>> I'm working in gda_insert_row_into_table but have some troubles: >>>>>>>> >>>>>>>> I'm creating the SQL usin GdaSqlStatement structs, with success but >>>>>>>> strings are renderer with out quotes ("") can any help me to know how >>>>>>>> can I >>>>>>>> do this to work. >>>>>>>> >>>>>>>> I'm adding a GdaSqlExpr to values GList in the >>>>>>>> GdaSqlStatementInsert, when render the GdaSqlStatement I get: >>>>>>>> >>>>>>>> INTO test (q, number, a) VALUES (NEW TEXT, 1000, NUEVO NOMBRE) >>>>>>>> >>>>>>>> it is an invalid SQL, how can I get quoted strings. This must be >>>>>>>> >>>>>>>> INTO test (q, number, a) VALUES ('NEW TEXT', 1000, 'NUEVO NOMBRE') >>>>>>>> >>>>>>>> for a PostgreSQL database. >>>>>>> >>>>>>> >>>>>>> It's up to you to add quotes where they are needed (because the >>>>>>> GdaSqlStatement is just a tree representation of an SQL statement). >>>>>>> Anyway, >>>>>>> what you should do is use GdaSqlParamSpec (which are variables or >>>>>>> parameters), this will have the following benefits: >>>>>>> * avoid you the job of adding quotes when needed >>>>>>> * avoid any SQL injection problems >>>>>>> >>>>>>> >>>>>> >>>>> Coul you help me on how create a GdaSqlParamSpec? >>>>> >>>>> >>>>> As Far As I Undertand for the code in gda_sql_param_spec_new (GValue >>>>> *value), the value paramenter must be a string with the following syntax: >>>>> >>>>> "PARAM_NAME:G_TYPE_INT:N" >>>>> >>>>> >>>>> As a collateral efect all functions in sql-parser directory doesn't >>>>> have any documentation, then may is time to work on them, I'll try to help >>>>> on them. >>>> >>>> >>>> This API is the one exposed from the SQL parser, but as simple >>>> structures are used, they can be created using g_new() as well. This is >>>> what >>>> is done in the rest of Libgda. For examples, see the >>>> gda_compute_unique_table_row_condition() function in the gda-util.c file. >>>> >>>> For a real "user" level API I had the idea that maybe we could create an >>>> API similar to SQLBuilder (http://openhms.sourceforge.net/sqlbuilder/), >>>> but I haven't yet had the time to investigate... >>>> >>>> Regards, >>>> >>>> Vivien >>>> >>>> >>>> >>> >>> >>> -- >>> Trabajar, la mejor arma para tu superación >>> "de grano en grano, se hace la arena" (R) (en trámite, pero para los >>> cuates: LIBRE) >>> >> >> >> >> -- >> Trabajar, la mejor arma para tu superación >> "de grano en grano, se hace la arena" (R) (en trámite, pero para los >> cuates: LIBRE) >> > > > > -- > Trabajar, la mejor arma para tu superación > "de grano en grano, se hace la arena" (R) (en trámite, pero para los > cuates: LIBRE) > -- Trabajar, la mejor arma para tu superación "de grano en grano, se hace la arena" (R) (en trámite, pero para los cuates: LIBRE)
PATCH-GdaBatchStatement-gda_gtype_to_string.diff.bz2
Description: BZip2 compressed data
_______________________________________________ gnome-db-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnome-db-list
