Re: [Mysql-cocoa-users] MCPQuery

[Serge C. <ser...@us...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi;=0D
=0D
Do people feel like it would be nice to have a repository of code =0D
contributed by SMySQL users?=0D
How many people on this list would be interested in sharing some of =0D
there code, so that there's a place to look for some examples =0D
sources...=0D
=0D
Serge.=0D
=0D
PS: Note that I'm developping some kind of enterprise layer on top of =0D=

SMySQL. This is a way to easily use a MySQL DB server to ensure =0D
persistence of your data, providing an easy way to map an object (of a =0D=

given class) to a row (of a precise table, depending on the class of =0D
the object).=0D
Then the MCPQuery you're developping can become some how (in EOF =0D
parlance) a FetchSpecification... But I'm not there yet!=0D
=0D
=0D
Le 13 ao=FBt 04, =E0 17:51, Aaron Jacobs a =E9crit :=0D
=0D
> Sounds like an interesting idea.  Based on your method declarations, =0D=

> this seems to really just be a collection of functions - there's =0D
> nothing object oriented about it.  I recommend making this into an =0D
> actual object, and modifying the SMySQL methods to take MCPQuery =0D
> objects instead of NSStrings.  That might open up some more =0D
> interesting possibilities.=0D
>=0D
> Aaron=0D
>=0D
>=0D
>=0D
> On Aug 13, 2004, at 4:39 PM, Camille GOUREAU-SUIGNARD wrote:=0D
>=0D
>> Hi,=0D
>>=0D
>> I've created (part of) a classe I called MCPQuery.=0D
>> It provides me query (NSString*) when feeded with information.=0D
>> Has one of you already worked on such a thing ?=0D
>> Is it a non sense ?=0D
>> Is there a better way to avoid re-writing the sames lines of code ?=0D=

>>=0D
>> Here are the functions I implemented :=0D
>>=0D
>> + (NSString*) selectQueryWithSelect: (NSDictionary*) fields andWhere: =
=0D
>> (NSString*) where ;=0D
>> 	// returns a "select from xhere" string with the fields =
extracted =0D
>> from fields and the from also=0D
>> + (NSString*) fromStringWithFields: (NSDictionary*) fields ;=0D
>> + (NSString*) queryEmptyInsertInTable: (NSString*) table ;=0D
>> + (NSString*) queryShowColumnsFromTable: (NSString*) table ;=0D
>> + (NSString*) queryUpdateFields: (NSDictionary*) fields inTable: =0D
>> (NSString*) table where: (NSString*) where ;=0D
>> + (NSString*) queryInsertFields: (NSDictionary*) fields inTable: =0D
>> (NSString*) table ;=0D
>>=0D
>>=0D
>>=0D
>> -------------------------------------------------------=0D
>> SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank =
Media=0D
>> 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33=0D
>> Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.=0D
>> http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285=0D
>> _______________________________________________=0D
>> Mysql-cocoa-users mailing list=0D
>> Mys...@li...=0D
>> https://lists.sourceforge.net/lists/listinfo/mysql-cocoa-users=0D
>>=0D
*******************************************=0D
Serge Cohen=0D
=0D
GPG Key ID: 9CBB58FB=0D
*******************************************=0D
=0D
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (Darwin)

iD8DBQFBHVBk5EPeG5y7WPsRAnlpAKC/dXhR3e+0W653LDYtET5n59zCyACg7+Bk
NqLQQRRIT14oy1HzDxSpdkE=3D
=3DMeoT
-----END PGP SIGNATURE-----