mysql-cocoa-users

[Mysql-cocoa-users] SMySQL-Xcode example?

[John M. <joh...@ad...>]

I didn't get any responses from the previous post, so I'll assume that I was
asking too much.  Alternatively, could someone be so kind as to point me to
an XCode example project that uses the SMySQL Framework to bridge a MySQL
table and a visual representation of that table?  I just need to get an idea
of how the methods of the framework are utilized in .h and .m files.

Thanks,

John

Previous Post:

I am trying to integrate some Obj-C into my XCode app, which is currently
exclusively written in Applescript.  I use a MySQL database to supply the
app with data for outlines and tables.  With applescript I use the following
to return a matrix of database entries:

set theData to do shell script "/usr/local/mysql/bin/mysql -h localhost -u
theUser -pthePassword -D 'theDatabase' -N -e \"SELECT columnOne, columnTwo,
columnThree FROM theTable WHERE columnFour = '"&aVariable&"'\""

I then use applescript's text item delimiters to convert the matrix into a
list of lists.

Could someone give me an idea where to start, using the SMySQL framework, in
issuing the same query in Obj-C?  Some questions:

1. I am not sure I understand which header file(s) I need to #import at the
top of my populateOutline.m file, if any?

2. Do I need to be using methods in the "MCPConnection.m" file to first
connect to the database, or is that taken care of some other way?  If "yes",
then do I call that/those method(s) each time I issue a query?

3. How do I know if the matrix I am returning is an NSDictionary or
NSArray...and how do choose the proper method out of the plethora in
"MPCFastQueries.m" and "MPCResult.m" that will return the same list of lists
as in the applescript example?

I know there is a lot I am asking here, but if I could get guidance on these
issues then I will be able to use deductive reasoning to solve the rest of
my issues in the future...

Thanks!

-John Mistler

Re: [Mysql-cocoa-users] SMySQL-Xcode example?

[Aaron J. <aj...@ed...>]

John,

There's a VERY simple description of how to connect and do queries in 
the API documentation here:

http://mysql-cocoa.sourceforge.net/SMySQL_doc/MCPConnection.html

Then there's a description of how to use MCPResult here:

http://mysql-cocoa.sourceforge.net/SMySQL_doc/MCPResult.html

I think there's also a CLI_test program that comes with the framework.

Aaron Jacobs


On Feb 23, 2005, at 4:49 PM, John Mistler wrote:

> I didn't get any responses from the previous post, so I'll assume that 
> I was
> asking too much.  Alternatively, could someone be so kind as to point 
> me to
> an XCode example project that uses the SMySQL Framework to bridge a 
> MySQL
> table and a visual representation of that table?  I just need to get 
> an idea
> of how the methods of the framework are utilized in .h and .m files.
>
> Thanks,
>
> John
>
> Previous Post:
>
> I am trying to integrate some Obj-C into my XCode app, which is 
> currently
> exclusively written in Applescript.  I use a MySQL database to supply 
> the
> app with data for outlines and tables.  With applescript I use the 
> following
> to return a matrix of database entries:
>
> set theData to do shell script "/usr/local/mysql/bin/mysql -h 
> localhost -u
> theUser -pthePassword -D 'theDatabase' -N -e \"SELECT columnOne, 
> columnTwo,
> columnThree FROM theTable WHERE columnFour = '"&aVariable&"'\""
>
> I then use applescript's text item delimiters to convert the matrix 
> into a
> list of lists.
>
> Could someone give me an idea where to start, using the SMySQL 
> framework, in
> issuing the same query in Obj-C?  Some questions:
>
> 1. I am not sure I understand which header file(s) I need to #import 
> at the
> top of my populateOutline.m file, if any?
>
> 2. Do I need to be using methods in the "MCPConnection.m" file to first
> connect to the database, or is that taken care of some other way?  If 
> "yes",
> then do I call that/those method(s) each time I issue a query?
>
> 3. How do I know if the matrix I am returning is an NSDictionary or
> NSArray...and how do choose the proper method out of the plethora in
> "MPCFastQueries.m" and "MPCResult.m" that will return the same list of 
> lists
> as in the applescript example?
>
> I know there is a lot I am asking here, but if I could get guidance on 
> these
> issues then I will be able to use deductive reasoning to solve the 
> rest of
> my issues in the future...
>
> Thanks!
>
> -John Mistler
>
>
>
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real 
> users.
> Discover which products truly live up to the hype. Start reading now.
> http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
> _______________________________________________
> Mysql-cocoa-users mailing list
> Mys...@li...
> https://lists.sourceforge.net/lists/listinfo/mysql-cocoa-users
>