mysql-cocoa-commits Mailing List for MySQL Objective C API for Cocoa (Page 6)
Brought to you by:
sergecohen
Menu
▾
▴
mysql-cocoa-commits
You can subscribe to this list here.
| 2002 |
Jan
(2) |
Feb
(6) |
Mar
(11) |
Apr
(2) |
May
(40) |
Jun
(17) |
Jul
(2) |
Aug
(2) |
Sep
|
Oct
|
Nov
(4) |
Dec
(11) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2003 |
Jan
(4) |
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
(44) |
Sep
|
Oct
(14) |
Nov
|
Dec
|
| 2004 |
Jan
|
Feb
|
Mar
(7) |
Apr
|
May
(4) |
Jun
|
Jul
|
Aug
(12) |
Sep
|
Oct
|
Nov
|
Dec
|
| 2009 |
Jan
|
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Serge C. <ser...@us...> - 2002-05-15 13:11:29
|
Update of /cvsroot/mysql-cocoa/Documentation
In directory usw-pr-cvs1:/tmp/cvs-serv10966
Added Files:
website_update.txt
Log Message:
Added a description of haow updating website from the CVS.
Serge Cohen; MySQL Cocoa Project, May 15th 2002.
--- NEW FILE: website_update.txt ---
# Do a SSH connection to shell1 :
ssh ser...@sh...
# There update the website (from CVS), remove CVS directory ...
cd /home/groups/m/my/mysql-cocoa/
mv htdocs old_htdocs
cvs -dsergecohen@cvs1:/cvsroot/mysql-cocoa co website
cd website
find . -name "CVS" -exec rm -rf {} \;
cd ..
mv website htdocs
# Check for differences:
diff -R old_htdocs htdocs
# Delete the old version
rm -rf old_htdocs
|
|
From: Serge C. <ser...@us...> - 2002-05-15 12:52:40
|
Update of /cvsroot/mysql-cocoa/Documentation/website In directory usw-pr-cvs1:/tmp/cvs-serv4158 Modified Files: index.html Log Message: Added a pointer to the new directory containing the doc of the framework. Updated index.html of SMySQL and Display. Serge Cohen; MySQL Cocoa Project, May 15th 2002. Index: index.html =================================================================== RCS file: /cvsroot/mysql-cocoa/Documentation/website/index.html,v retrieving revision 1.12 retrieving revision 1.13 diff -C2 -d -r1.12 -r1.13 *** index.html 8 May 2002 16:46:10 -0000 1.12 --- index.html 15 May 2002 12:52:37 -0000 1.13 *************** *** 17,26 **** <div class="center"> ! <img src="img/mysql-cocoa-logo.png" alt="MySQL Cocoa Logo" width=256 height=256> </div> <!--Updates--> <a name="updates"><h2>Updates</h2></a> <p><em>7 May 2002:</em> Cleaned up the methods from May 3rd, (databases, tables, fields list). Finished the proper encoding of the character sets (should run Ok with latin1, latin2, win1250, cp1251, euc_kr, sjis). Added methods to check the version of the protocole, the client library, the server, and to get info on the database server the host. The framework has been promoted to version 0.6.0. It's under CVS, but also on the <a href="#sources">File Release</a>.</p> <p><em>3 May 2002:</em> After suggestion from Bertrand Mansion I added a couple of method to get databases, tables, and fields (of a table) list. They works they way they should from the C API recommandation (specific function for DBs, and tables, standard query for fields). I also started to enhance the handling of the charset encoding (suggestion by John Guy). This feature is not yet fully implemented. The new version (0.5.4) is only available through CVS so far (see information from the <a href="http://sourceforge.net/cvs/?group_id=42424">sourceforge project page</a>).</p> --- 17,30 ---- <div class="center"> ! <!-- <img src="img/mysql-cocoa-logo.png" alt="MySQL Cocoa Logo" width=256 height=256> --> </div> + <!--Documentation--> + <a name="documentation"><h2>Documentation</h2></a> + <p><em>Documentation of the latest verison of the framework can be found <a href="SMySQL_doc/">here</a></em></p> <!--Updates--> <a name="updates"><h2>Updates</h2></a> + <p><em>15 May 2002:</em> Important changes to the framework: The two connect (<code>connectToHost:.. connectToSocket:..</code>) method have been replaced by a single method (<code>connectWithLogin:password:host:port:socket:</code>). In the mean time the syntax of the list methods (<code>listDBs ...</code>) have been changed to look more like the SQL <code>SHOW</code> statments. Some shortcuts to such methods have been added. Any one using the framework should port to the new version, the interface will be kept until version 1.0 (with maybe adding method, but no removing nor renaming). This version is available on CVS and <a href="#sources">File Release</a>. At last a new binary of <a href="Display">MySQL Display</a> contain the last version of the framework.</p> <p><em>7 May 2002:</em> Cleaned up the methods from May 3rd, (databases, tables, fields list). Finished the proper encoding of the character sets (should run Ok with latin1, latin2, win1250, cp1251, euc_kr, sjis). Added methods to check the version of the protocole, the client library, the server, and to get info on the database server the host. The framework has been promoted to version 0.6.0. It's under CVS, but also on the <a href="#sources">File Release</a>.</p> <p><em>3 May 2002:</em> After suggestion from Bertrand Mansion I added a couple of method to get databases, tables, and fields (of a table) list. They works they way they should from the C API recommandation (specific function for DBs, and tables, standard query for fields). I also started to enhance the handling of the charset encoding (suggestion by John Guy). This feature is not yet fully implemented. The new version (0.5.4) is only available through CVS so far (see information from the <a href="http://sourceforge.net/cvs/?group_id=42424">sourceforge project page</a>).</p> *************** *** 55,58 **** --- 59,63 ---- <li><a name="sources">Mac OS X 10.1 or higher sources, version 0.5.3 r1 </a><! (note: not up to date, see CVS for version 0.5.2) !></li> <ul> + <li><a href="http://ftp1.sourceforge.net/mysql-cocoa/SMySQL_0.7.0.tgz">SMySQL Framework v0.7.0r1</a>, MD5: a9480df166aae28fff56b79e205f4353</li> <li><a href="http://ftp1.sourceforge.net/mysql-cocoa/SMySQL_0.6.0.tgz">SMySQL Framework v0.6.0r1</a>, MD5: 685b6b4361936c4d9109d390686c6cdc</li> <li><a href="http://ftp1.sourceforge.net/mysql-cocoa/SMySQL_0.5.3.tgz">SMySQL Framework v0.5.3r1</a>, MD5: 536de45748d9db6218e7e4d3eecaea06</li> *************** *** 66,69 **** --- 71,75 ---- </ul> <ul> + <li><a href="http://ftp1.sourceforge.net/mysql-cocoa/SMySQL_test_0.7.0.tgz">SMySQL test application v0.7.0r1</a>, MD5: f10028eaa52a17425104274080eca413</li> <li><a href="http://ftp1.sourceforge.net/mysql-cocoa/SMySQL_test_0.6.0.tgz">SMySQL test application v0.6.0r1</a>, MD5: be4b368887698c2fd461d6df89423094</li> <li><a href="http://ftp1.sourceforge.net/mysql-cocoa/SMySQL_test_0.5.tgz">SMySQL test application v0.5.0r1</a>, MD5: 303fc130b0b6211283c2f3252c8dfd08</li> *************** *** 106,109 **** --- 112,116 ---- <ul> <li>Serge Cohen (<a href="mailto:ser...@us...">ser...@us...</a>)</li> + <li>Bertrand Mansion (<a href="mailto:ma...@us...">ma...@us...</a>)</li> </ul> <a name="links"><h2>Links</h2></a> |
|
From: Serge C. <ser...@us...> - 2002-05-15 12:52:40
|
Update of /cvsroot/mysql-cocoa/Documentation/website/Display In directory usw-pr-cvs1:/tmp/cvs-serv4158/Display Modified Files: index.html Log Message: Added a pointer to the new directory containing the doc of the framework. Updated index.html of SMySQL and Display. Serge Cohen; MySQL Cocoa Project, May 15th 2002. Index: index.html =================================================================== RCS file: /cvsroot/mysql-cocoa/Documentation/website/Display/index.html,v retrieving revision 1.8 retrieving revision 1.9 diff -C2 -d -r1.8 -r1.9 *** index.html 8 May 2002 16:46:12 -0000 1.8 --- index.html 15 May 2002 12:52:37 -0000 1.9 *************** *** 24,27 **** --- 24,28 ---- <a name="updates"><h2>Updates</h2></a> + <p><em>15 May 2002:</em> A new binary, including the latest version (0.7.0) of the framework is available for <a href="#binaries">download</a>.</p> <p><em>8 May 2002:</em> The new <a href="../index.html">framework</a> (with better character set encoding) is included. Few bugs of the applications have been fixed. You can find either the <a href="../index.html#sources">source</a> (in which case you have to compile one of the embeded version of the framework). A binary is also released <a href="#binaries">here</a>; it's a disk image (dmg) which contain the licence (GPL) and the application.</p> <p><em>14 March 2002:</em> The new version of the <a href="../index.html">SMySQL frameworks</a> includes directly the libmysqlclient in the framework. Now you don't need any more to install the MySQL client side library to run MySQL Display. Just <a href="http://ftp1.sourceforge.net/mysql-cocoa/MySQL_Display_0.1.2.dmg.gz">download</a> it from sourceforge, expand, mount the disk image and launch the application (this should be done in three double-click).</p> *************** *** 44,48 **** <li><a name="binaries">Binaries to install fast..</a></li> <ul> ! <li>Getting the MySQL Display application (alone): <a href="http://ftp1.sourceforge.net/mysql-cocoa/MySQL_Display_0.1.3.dmg.gz">Disk image</a>, MD5: 462f2cff5cc57c463418cb8af10b9f5d</li> <li>Installing the complete Client side of MySQL, and getting the MySQL Display application (as a free bonus): <a href="http://ftp1.sourceforge.net/mysql-cocoa/MySQL_Cocoa_installers_0.5.2.dmg.gz">Disk image</a>, MD5: fc88e839717d3a478fa44c56387da908</li> </ul> --- 45,49 ---- <li><a name="binaries">Binaries to install fast..</a></li> <ul> ! <li>Getting the MySQL Display application (alone): <a href="http://ftp1.sourceforge.net/mysql-cocoa/MySQL_Display_0.1.3_F0.7.0.dmg.gz">Disk image</a>, MD5: 85d0c86212f677240a14813b031ccda8 (NB:this is a stand alone application which <em>does not need</em> the libmysqlclient library).</li> <li>Installing the complete Client side of MySQL, and getting the MySQL Display application (as a free bonus): <a href="http://ftp1.sourceforge.net/mysql-cocoa/MySQL_Cocoa_installers_0.5.2.dmg.gz">Disk image</a>, MD5: fc88e839717d3a478fa44c56387da908</li> </ul> *************** *** 50,54 **** <a name="docs"><h2>Documentation</h2></a> ! <p>For documentation go to the <a href="../index.html">MySQL Project Homepage</a></p> <a name="lists"><h2>Mailing Lists</h2></a> --- 51,55 ---- <a name="docs"><h2>Documentation</h2></a> ! <p>For documentation go to the <a href="../index.html">MySQL Cocoa Project Homepage</a></p> <a name="lists"><h2>Mailing Lists</h2></a> *************** *** 65,68 **** --- 66,70 ---- <ul> <li>Serge Cohen (<a href="mailto:ser...@us...">ser...@us...</a>)</li> + <li>Bertrand Mansion (<a href="mailto:ma...@us...">ma...@us...</a>)</li> </ul> <a name="links"><h2>Links</h2></a> |
|
From: Serge C. <ser...@us...> - 2002-05-15 12:24:32
|
Update of /cvsroot/mysql-cocoa/Documentation/website/SMySQL_doc In directory usw-pr-cvs1:/tmp/cvs-serv26817 Added Files: SMySQLConnection.html SMySQLResult.html Log Message: Adding the html documentation of the framework to the web site. Serge Cohen; MySQL Cocoa project, May 15th 2002. --- NEW FILE: SMySQLConnection.html --- <HTML><HEAD><TITLE></TITLE></HEAD> <BODY BGCOLOR="#FFFFFF"> <BR><BR><FONT COLOR="#000066"><H1><A NAME="//apple_ref/occ/cl/SMySQLConnection">SMySQLConnection</A></H1></FONT><BR> <blockquote><DL><DT><B>Inherits From:</B></DT> <DD>NSObject</DD> </DL></blockquote> <blockquote><DL><DT><B>Declared In:</B></DT> <DD>SMySQLConnection.h</DD> </DL></blockquote> <BR><BR> <H2>Class Description</H2> This class is used to keep a connection with a MySQL server, it correspond to the MYSQL structure of the C API, or the database handle of the PERL DBI/DBD interface.<P> You have to start any work on a MySQL server by getting a working SMySQLConnection object.<P> Most likely you will use this kind of code:<P> <CODE> <BR> SMySQLConnection *theConnec = [SMySQLConnection alloc]; <BR> SMySQLResult *theRes;<BR> <BR> theConnec = [theConnec initToHost::albert.com withLogin:@"toto" password:@"albert" port:0]; <BR> [theConnec selectDB:@"db1"]; <BR> theRes = [theConnec queryString:@"select * from table1"]; <BR> ... <BR> </CODE> <P><HR WIDTH=50% ALIGN=LEFT> <H2>Symbolic Constants</H2> <blockquote> <H4>Synopsis:</H4> <CODE><B><A NAME="//apple_ref/c/econst/kSMySQL_default_option">kSMySQL_default_option</A></B> CLIENT_COMPRESS</CODE><BR> <CODE><B><A NAME="//apple_ref/c/econst/kSMySQLConnectionDefaultSocket">kSMySQLConnectionDefaultSocket</A></B> MYSQL_UNIX_ADDR</CODE><BR> <CODE><B><A NAME="//apple_ref/c/econst/kSMySQLConnection_error_not_inited">kSMySQLConnection_error_not_inited</A></B> 1000</CODE><BR> </blockquote> <P><HR WIDTH=50% ALIGN=LEFT> <H2>Instance Variables</H2> <blockquote> <CODE>MYSQL *<B>mConnection</B>;</CODE><BR> <CODE>BOOL <B>mConnected</B>;</CODE><BR> <CODE>NSStringEncoding <B>mEncoding</B>;</CODE><BR> <P><TABLE> <TR><TD>mConnection</TD><TD>The inited MySQL connection</TD></TR> <TR><TD>mConnected</TD><TD>Reflect the fact that the connection is already in place or not</TD></TR> <TR><TD>mEncoding</TD><TD>The encoding used by MySQL server, to ISO-1 default</TD></TR> </TABLE> </blockquote> <P><HR WIDTH=50% ALIGN=LEFT> <H2>Method Types</H2> <blockquote> Getting default of MySQL <DL><DT></DT> <DD> <A HREF="#+ getMySQLLocales">+ getMySQLLocales</A></DD> <DD> <A HREF="#+ encodingForMySQLEncoding:">+ encodingForMySQLEncoding:</A></DD> <DD> <A HREF="#+ defaultMySQLEncoding">+ defaultMySQLEncoding</A></DD> </DL> Initialisation <DL><DT></DT> <DD> <A HREF="#- init">- init</A></DD> <DD> <A HREF="#- initToHost:withLogin:password:usingPort:">- initToHost:withLogin:password:usingPort:</A></DD> <DD> <A HREF="#- initToSocket:withLogin:password:">- initToSocket:withLogin:password:</A></DD> <DD> <A HREF="#- setConnectionOption:withArgument:">- setConnectionOption:withArgument:</A></DD> <DD> <A HREF="#- connectWithLogin:password:host:port:socket:">- connectWithLogin:password:host:port:socket:</A></DD> <DD> <A HREF="#- selectDB:">- selectDB:</A></DD> </DL> Errors information <DL><DT></DT> <DD> <A HREF="#- getLastErrorMessage">- getLastErrorMessage</A></DD> <DD> <A HREF="#- getLastErrorID">- getLastErrorID</A></DD> <DD> <A HREF="#- isConnected">- isConnected</A></DD> <DD> <A HREF="#- checkConnection">- checkConnection</A></DD> </DL> Queries <DL><DT></DT> <DD> <A HREF="#- prepareBinaryData:">- prepareBinaryData:</A></DD> <DD> <A HREF="#- queryString:">- queryString:</A></DD> <DD> <A HREF="#- affectedRows">- affectedRows</A></DD> <DD> <A HREF="#- insertId">- insertId</A></DD> </DL> Getting description of the database structure <DL><DT></DT> <DD> <A HREF="#- listDBs">- listDBs</A></DD> <DD> <A HREF="#- listDBsLike:">- listDBsLike:</A></DD> <DD> <A HREF="#- listTables">- listTables</A></DD> <DD> <A HREF="#- listTablesLike:">- listTablesLike:</A></DD> <DD> <A HREF="#- listTablesFromDB:like:">- listTablesFromDB:like:</A></DD> <DD> <A HREF="#- listFieldsFromTable:">- listFieldsFromTable:</A></DD> <DD> <A HREF="#- listFieldsFromTable:like:">- listFieldsFromTable:like:</A></DD> </DL> Server information and control <DL><DT></DT> <DD> <A HREF="#- clientInfo">- clientInfo</A></DD> <DD> <A HREF="#- hostInfo">- hostInfo</A></DD> <DD> <A HREF="#- serverInfo">- serverInfo</A></DD> <DD> <A HREF="#- protoInfo">- protoInfo</A></DD> <DD> <A HREF="#- listProcesses">- listProcesses</A></DD> <DD> <A HREF="#- killProcess:">- killProcess:</A></DD> </DL> Disconnection <DL><DT></DT> <DD> <A HREF="#- disconnect">- disconnect</A></DD> <DD> <A HREF="#- dealloc">- dealloc</A></DD> </DL> String encoding concerns (c string type to NSString). It's unlikely that users of the framework needs to use these methods which are used internally <DL><DT></DT> <DD> <A HREF="#- setEncoding:">- setEncoding:</A></DD> <DD> <A HREF="#- encoding">- encoding</A></DD> <DD> <A HREF="#- cStringFromString:">- cStringFromString:</A></DD> <DD> <A HREF="#- stringWithCString:">- stringWithCString:</A></DD> </DL> </blockquote> <P><HR WIDTH=50% ALIGN=LEFT> <H2>Class Methods</H2> <A NAME="+ defaultMySQLEncoding"></A><H3><A NAME="//apple_ref/occ/clm/SMySQLConnection/defaultMySQLEncoding">defaultMySQLEncoding</A></H3> <CODE>+ (NSStringEncoding)<B>defaultMySQLEncoding</B> </CODE><P> Returns the default charset of the library mysqlclient used. <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="+ encodingForMySQLEncoding:"></A><H3><A NAME="//apple_ref/occ/clm/SMySQLConnection/encodingForMySQLEncoding:">encodingForMySQLEncoding:</A></H3> <CODE>+ (NSStringEncoding)<B>encodingForMySQLEncoding:</B>(const char *)<EM>mysqlEncoding</EM> </CODE><P> Gets a proper NSStringEncoding according to the given MySQL charset.<P> MySQL 4.0 offers this charsets: big5 cp1251 cp1257 croat czech danish dec8 dos estonia euc_kr gb2312 gbk german1 greek hebrew hp8 hungarian koi8_ru koi8_ukr latin1 latin1_de latin2 latin5 sjis swe7 tis620 ujis usa7 win1250 win1251ukr<P> WARNING : incomplete implementation. Please, send your fixes. <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="+ getMySQLLocales"></A><H3><A NAME="//apple_ref/occ/clm/SMySQLConnection/getMySQLLocales">getMySQLLocales</A></H3> <CODE>+ (NSDictionary *)<B>getMySQLLocales</B> </CODE><P> Gets a proper Locale dictionary to use formater to parse strings from MySQL. For example strings representing dates should give a proper Locales for use with methods such as NSDate::dateWithNaturalLanguageString: locales: <HR WIDTH=50% ALIGN=LEFT> <H2>Instance Methods</H2> <A NAME="- affectedRows"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLConnection/affectedRows">affectedRows</A></H3><P> <CODE>- (my_ulonglong)<B>affectedRows</B> </CODE><P> Returns the number of affected rows by the last query. <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="- cStringFromString:"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLConnection/cStringFromString:">cStringFromString:</A></H3><P> <CODE>- (const char *)<B>cStringFromString:</B>(NSString *)<EM>theString</EM> </CODE><P> For internal use only. Transforms a NSString to a C type string (ending with \0) using the character set from the SMySQLConnection. Lossy conversions are enabled. <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="- checkConnection"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLConnection/checkConnection">checkConnection</A></H3><P> <CODE>- (BOOL)<B>checkConnection</B> </CODE><P> Checks if the connection to the server is still on. If not, tries to reconnect (changing no parameters from the MYSQL pointer). This method just uses mysql_ping(). <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="- clientInfo"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLConnection/clientInfo">clientInfo</A></H3><P> <CODE>- (NSString *)<B>clientInfo</B> </CODE><P> Returns a string giving the client library version. <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="- connectWithLogin:password:host:port:socket:"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLConnection/connectWithLogin:password:host:port:socket:">connectWithLogin:password:host:port:socket:</A></H3><P> <CODE>- (BOOL)<B>connectWithLogin:</B>(NSString *)<EM>login</EM> <B>password:</B>(NSString *)<EM>pass</EM> <B>host:</B>(NSString *)<EM>host</EM> <B>port:</B>(int)<EM>port</EM> <B>socket:</B>(NSString *)<EM>socket</EM> </CODE><P> The method used by <B>initToHost:withLogin:password:usingPort:</B> and <B>initToSocket:withLogin:password:</B>. Same information and use of the parameters:<P> - <I>login</I> is the user name - <I>pass</I> is the password corresponding to the user name - <I>host</I> is the hostname or IP adress - <I>port</I> is the TCP <I>port</I> to use to connect. If <I>port</I> = 0, uses the default <I>port</I> from mysql.h - <I>socket</I> is the path to the <I>socket</I> (for the localhost)<P> The <I>socket</I> is used if the <I>host</I> is set to <CODE>@"localhost"</CODE>, to an empty or a <CODE>nil</CODE> string For the moment the implementation might not be safe if you have a <B>nil</B> pointer to one of the NSString* variables (underestand: I don't know what the result will be). <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="- dealloc"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLConnection/dealloc">dealloc</A></H3><P> <CODE>- (void)<B>dealloc</B> </CODE><P> The standard deallocation method for SMySQLConnection objects. <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="- disconnect"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLConnection/disconnect">disconnect</A></H3><P> <CODE>- (void)<B>disconnect</B> </CODE><P> Disconnects a connected SMySQLConnection object; used by <B>-dealloc</B> method. <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="- encoding"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLConnection/encoding">encoding</A></H3><P> <CODE>- (NSStringEncoding)<B>encoding</B> </CODE><P> Gets the encoding for the connection <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="- getLastErrorID"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLConnection/getLastErrorID">getLastErrorID</A></H3><P> <CODE>- (unsigned int)<B>getLastErrorID</B> </CODE><P> Returns the ErrorID of the last MySQL error on the connection. <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="- getLastErrorMessage"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLConnection/getLastErrorMessage">getLastErrorMessage</A></H3><P> <CODE>- (NSString *)<B>getLastErrorMessage</B> </CODE><P> Returns a string with the last MySQL error message on the connection. <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="- hostInfo"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLConnection/hostInfo">hostInfo</A></H3><P> <CODE>- (NSString *)<B>hostInfo</B> </CODE><P> Returns a string giving information on the host of the DB server. <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="- init"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLConnection/init">init</A></H3><P> <CODE>- (id)<B>init</B> </CODE><P> Initialise a MySQLConnection without making a connection, most likely useless, except with <B>setConnectionOption:withArgument:</B>. <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="- initToHost:withLogin:password:usingPort:"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLConnection/initToHost:withLogin:password:usingPort:">initToHost:withLogin:password:usingPort:</A></H3><P> <CODE>- (id)<B>initToHost:</B>(NSString *)<EM>host</EM> <B>withLogin:</B>(NSString *)<EM>login</EM> <B>password:</B>(NSString *)<EM>pass</EM> <B>usingPort:</B>(int)<EM>port</EM> </CODE><P> Initialise a connection using a <B>TCP/IP connection</B> with the given parameters (except if <I>host</I> is set to <CODE>localhost</CODE>, in which case uses the default)<P> - <I>host</I> is the hostname or IP adress - <I>login</I> is the user name - <I>pass</I> is the password corresponding to the user name - <I>port</I> is the TCP <I>port</I> to use to connect. If <I>port</I> = 0, uses the default <I>port</I> from mysql.h <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="- initToSocket:withLogin:password:"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLConnection/initToSocket:withLogin:password:">initToSocket:withLogin:password:</A></H3><P> <CODE>- (id)<B>initToSocket:</B>(NSString *)<EM>socket</EM> <B>withLogin:</B>(NSString *)<EM>login</EM> <B>password:</B>(NSString *)<EM>pass</EM> </CODE><P> Initialise a connection using a <B>unix <I>socket</I></B> with the given parameters<P> - <I>socket</I> is the path to the <I>socket</I> - <I>login</I> is the user name - <I>pass</I> is the password corresponding to the user name <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="- insertId"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLConnection/insertId">insertId</A></H3><P> <CODE>- (my_ulonglong)<B>insertId</B> </CODE><P> If the last query was an insert in a table having a autoindex column, returns the <B>id</B> (autoindexed field) of the last row inserted. <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="- isConnected"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLConnection/isConnected">isConnected</A></H3><P> <CODE>- (BOOL)<B>isConnected</B> </CODE><P> Returns YES if the SMySQLConnection is connected to a DB, NO otherwise. <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="- killProcess:"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLConnection/killProcess:">killProcess:</A></H3><P> <CODE>- (BOOL)<B>killProcess:</B>(unsigned long)<EM>pid</EM> </CODE><P> Kills the process with the given <I>pid</I>. The users needs the <B>Process_priv</B> privilege. <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="- listDBs"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLConnection/listDBs">listDBs</A></H3><P> <CODE>- (SMySQLResult *)<B>listDBs</B> </CODE><P> Just a fast wrapper for the more complex <CODE>listDBsWithPattern:</CODE> method. <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="- listDBsLike:"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLConnection/listDBsLike:">listDBsLike:</A></H3><P> <CODE>- (SMySQLResult *)<B>listDBsLike:</B>(NSString *)<EM>dbsName</EM> </CODE><P> Returns a list of database which name correspond to the SQL regular expression in 'pattern'. The comparison is done with wild card extension : % and _. The result should correspond to the queryString:@"SHOW databases [LIKE wild]"; but implemented with mysql_list_dbs. If an empty string or <B>nil</B> is passed as pattern, all databases will be shown. <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="- listFieldsFromTable:"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLConnection/listFieldsFromTable:">listFieldsFromTable:</A></H3><P> <CODE>- (SMySQLResult *)<B>listFieldsFromTable:</B>(NSString *)<EM>tableName</EM> </CODE><P> Just a fast wrapper for the more complex list <CODE>listFieldsWithPattern:forTable:</CODE> method. <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="- listFieldsFromTable:like:"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLConnection/listFieldsFromTable:like:">listFieldsFromTable:like:</A></H3><P> <CODE>- (SMySQLResult *)<B>listFieldsFromTable:</B>(NSString *)<EM>tableName</EM> <B>like:</B>(NSString *)<EM>fieldsName</EM> </CODE><P> Show all the fields of the table <I>tableName</I> which name correspond to pattern (with wild card expansion : %,_). Indeed, and as recommanded from mysql reference, this method is NOT using mysql_list_fields but the <CODE>queryString:</CODE> method. If an empty string or <B>nil</B> is passed as <I>fieldsName</I>, all fields (of <I>tableName</I>) will be returned. <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="- listProcesses"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLConnection/listProcesses">listProcesses</A></H3><P> <CODE>- (SMySQLResult *)<B>listProcesses</B> </CODE><P> Lists active process <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="- listTables"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLConnection/listTables">listTables</A></H3><P> <CODE>- (SMySQLResult *)<B>listTables</B> </CODE><P> Make sure a DB is selected (with <CODE>selectDB</CODE> method) first. <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="- listTablesFromDB:like:"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLConnection/listTablesFromDB:like:">listTablesFromDB:like:</A></H3><P> <CODE>- (SMySQLResult *)<B>listTablesFromDB:</B>(NSString *)<EM>dbName</EM> <B>like:</B>(NSString *)<EM>tablesName</EM> </CODE><P> List tables in DB specified by <I>dbName</I> and corresponding to pattern. This method indeed issues a <CODE>SHOW TABLES FROM dbName LIKE ...</CODE> query to the server. This is done this way to make sure the selected DB is not changed by this method. <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="- listTablesLike:"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLConnection/listTablesLike:">listTablesLike:</A></H3><P> <CODE>- (SMySQLResult *)<B>listTablesLike:</B>(NSString *)<EM>tablesName</EM> </CODE><P> From within a database, give back the list of table which name correspond to <I>tablesName</I> (with wild card %, _ extension). Correspond to queryString:@"SHOW tables [LIKE wild]"; uses mysql_list_tables function. If an empty string or <B>nil</B> is passed as <I>tablesName</I>, all tables will be shown. WARNING: <B>produce an error if no databases are selected</B> (with <CODE>selectDB:</CODE> for example). <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="- prepareBinaryData:"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLConnection/prepareBinaryData:">prepareBinaryData:</A></H3><P> <CODE>- (NSString *)<B>prepareBinaryData:</B>(NSData *)<EM>theData</EM> </CODE><P> Takes a NSData object and transform it in a proper string for sending to the server in between quotes. <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="- protoInfo"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLConnection/protoInfo">protoInfo</A></H3><P> <CODE>- (NSNumber *)<B>protoInfo</B> </CODE><P> Returns the number of the protocole used to transfer info from server to client <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="- queryString:"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLConnection/queryString:">queryString:</A></H3><P> <CODE>- (SMySQLResult *)<B>queryString:</B>(NSString *)<EM>query</EM> </CODE><P> Takes a <I>query</I> string and return an SMySQLResult object holding the result of the <I>query</I>. The returned SMySQLResult is not retained, the client is responsible for that (it's autoreleased before being returned) Note that if you want to use this method with binary data (in the <I>query</I>), you should use <CODE>prepareBinaryData:</CODE> to include the binary data in the <I>query</I> string. <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="- selectDB:"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLConnection/selectDB:">selectDB:</A></H3><P> <CODE>- (BOOL)<B>selectDB:</B>(NSString *)<EM>dbName</EM> </CODE><P> Selects a database to work with. The SMySQLConnection object needs to be properly inited and connected to a server. If a connection is not yet set or the selection of the database didn't work, returns NO. Returns YES in normal cases where the database is properly selected.<P> So far, if <I>dbName</I> is a <B>nil</B> pointer it will return NO (as if it cannot connect), most likely this will throw an exception in the future. <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="- serverInfo"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLConnection/serverInfo">serverInfo</A></H3><P> <CODE>- (NSString *)<B>serverInfo</B> </CODE><P> Returns a string giving the server version. <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="- setConnectionOption:withArgument:"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLConnection/setConnectionOption:withArgument:">setConnectionOption:withArgument:</A></H3><P> <CODE>- (BOOL)<B>setConnectionOption:</B>(int)<EM>option</EM> <B>withArgument:</B>(id)<EM>arg</EM> </CODE><P> <B>NOT YET IMPLEMENTED</B><P> This method is to be used for getting special <I>option</I> for a connection, in which case the SMySQLConnection has to be inited with the init method, then <I>option</I> are selected, finally connection is done using one of the connect methods:<P> <CODE> <BR> SMySQLConnection *theConnect = [[SMySQLConnection alloc] init]; <BR> [theConnect setConnectionOption: option withArgument: arg]; <BR> [theConnect connectToHost:albert.com withLogin:@"toto" password:@"albert" port:0]; <BR> .... <BR> </CODE> <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="- setEncoding:"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLConnection/setEncoding:">setEncoding:</A></H3><P> <CODE>- (void)<B>setEncoding:</B>(NSStringEncoding)<EM>theEncoding</EM> </CODE><P> Sets the encoding used by the server for data transfert. Used to make sure the output of the query result is ok even for non-ascii characters The character set (encoding) used by the db is passed to the SMySQLConnection object upon connection, so most likely the encoding (from -encoding) method is already the proper one. That is to say : It's unlikely you will need to call this method directly, and <B>if ever you use it, do it at your own risks</B>. <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="- stringWithCString:"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLConnection/stringWithCString:">stringWithCString:</A></H3><P> <CODE>- (NSString *)<B>stringWithCString:</B>(const char *)<EM>theCString</EM> </CODE><P> Returns a NSString from a C style string encoded with the character set of theSMySQLConnection. <P><HR> Version 1.1 Copyright ©2002 by MySQL Cocoa Project. All Rights Reserved. Wed May 15 13:02:11 2002 <P> </BODY></HTML> --- NEW FILE: SMySQLResult.html --- <HTML><HEAD><TITLE></TITLE></HEAD> <BODY BGCOLOR="#FFFFFF"> <BR><BR><FONT COLOR="#000066"><H1><A NAME="//apple_ref/occ/cl/SMySQLResult">SMySQLResult</A></H1></FONT><BR> <blockquote><DL><DT><B>Inherits From:</B></DT> <DD>NSObject</DD> </DL></blockquote> <blockquote><DL><DT><B>Declared In:</B></DT> <DD>SMySQLResult.h</DD> </DL></blockquote> <BR><BR> <H2>Class Description</H2> Hold the results of a query to a MySQL database server. It correspond to the MYSQL_RES structure of the C API, and to the statement handle of the PERL DBI/DBD.<P> Uses the <B>mysql_store_result()</B> function from the C API.<P> This object is generated only by a SMySQLConnection object, in this way (see <B>SMySQLConnection</B> documentation):<P> <CODE> <BR> SMySQLConnection *theConnec = [SMySQLConnection alloc]; <BR> SMySQLResult *theRes; <BR> NSDictionnary *theDict; <BR> NSArray *theColNames; <BR> int i, j;<BR> <BR> theConnec = [theConnec initToHost::albert.com withLogin:@"toto" password:@"albert" port:0]; <BR> [theConnec selectDB:@"db1"]; <BR> theRes = [theConnec queryString:@"select * from table1"]; <BR> theColNames = [theRes fetchFiedlsName]; <BR> i = 0; <BR> while (theDict = [theRes fetchRowAsDictionary]){ <BR> NSLog(@"Row : <I>d</I>\n", i); <BR> for (j=0; j<[theColNames count]; j++) { <BR> NSLog(@" Field : %@, contain : %@\n", [theColNames objectAtInex:j], [theDict objectForKey:[theColNames objectAtIndex:j]]); <BR> }<BR> i++; <BR> }<BR> </CODE> <P><HR WIDTH=50% ALIGN=LEFT> <H2>Instance Variables</H2> <blockquote> <CODE>MYSQL_RES *<B>mResult</B>;</CODE><BR> <CODE>NSArray *<B>mNames</B>;</CODE><BR> <CODE>NSDictionary *<B>mMySQLLocales</B>;</CODE><BR> <CODE>NSStringEncoding <B>mEncoding</B>;</CODE><BR> <P><TABLE> <TR><TD>mResult</TD><TD>The MYSQL_RES structure of the C API</TD></TR> <TR><TD>mNames</TD><TD>An NSArray holding the name of the columns</TD></TR> <TR><TD>mMySQLLocales</TD><TD>A Locales dictionary to define the locales of MySQL</TD></TR> <TR><TD>mEncoding</TD><TD>The encoding used by MySQL server, to ISO-1 default</TD></TR> </TABLE> </blockquote> <P><HR WIDTH=50% ALIGN=LEFT> <H2>Method Types</H2> <blockquote> Init used <B>only</B> by <B>SMySQLConnection</B> <DL><DT></DT> <DD> <A HREF="#- initWithMySQLPtr:encoding:">- initWithMySQLPtr:encoding:</A></DD> <DD> <A HREF="#- initWithResPtr:encoding:">- initWithResPtr:encoding:</A></DD> <DD> <A HREF="#- init">- init</A></DD> </DL> General info on the result <DL><DT></DT> <DD> <A HREF="#- numOfRows">- numOfRows</A></DD> <DD> <A HREF="#- numOfFields">- numOfFields</A></DD> </DL> Getting the rows <DL><DT></DT> <DD> <A HREF="#- dataSeek:">- dataSeek:</A></DD> <DD> <A HREF="#- fetchRowAsDictionary">- fetchRowAsDictionary</A></DD> <DD> <A HREF="#- fetchRowAsArray">- fetchRowAsArray</A></DD> </DL> Getting information on columns <DL><DT></DT> <DD> <A HREF="#- fetchFieldsName">- fetchFieldsName</A></DD> <DD> <A HREF="#- fetchTypesAsArray">- fetchTypesAsArray</A></DD> <DD> <A HREF="#- fetchTypesAsDictionary">- fetchTypesAsDictionary</A></DD> <DD> <A HREF="#- isBlobAtIndex:">- isBlobAtIndex:</A></DD> <DD> <A HREF="#- isBlobForKey:">- isBlobForKey:</A></DD> </DL> Utility method <DL><DT></DT> <DD> <A HREF="#- description">- description</A></DD> </DL> End of the scope... <DL><DT></DT> <DD> <A HREF="#- dealloc">- dealloc</A></DD> </DL> Private methods, internam use only <DL><DT></DT> <DD> <A HREF="#- cStringFromString:">- cStringFromString:</A></DD> <DD> <A HREF="#- stringWithCString:">- stringWithCString:</A></DD> </DL> </blockquote> <HR WIDTH=50% ALIGN=LEFT> <H2>Instance Methods</H2> <A NAME="- cStringFromString:"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLResult/cStringFromString:">cStringFromString:</A></H3><P> <CODE>- (const char *)<B>cStringFromString:</B>(NSString *)<EM>theString</EM> </CODE><P> For internal use only. Transform a NSString to a C type string (ended with \0) using ethe character set from the SMySQLConnection. Lossy conversions are enabled. <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="- dataSeek:"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLResult/dataSeek:">dataSeek:</A></H3><P> <CODE>- (void)<B>dataSeek:</B>(my_ulonglong)<EM>row</EM> </CODE><P> Go to a precise <I>row</I> in the selected result. 0 is the very first <I>row</I> <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="- dealloc"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLResult/dealloc">dealloc</A></H3><P> <CODE>- (void)<B>dealloc</B> </CODE><P> No method description. <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="- description"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLResult/description">description</A></H3><P> <CODE>- (NSString *)<B>description</B> </CODE><P> Return a (long) string containing the table of results, first line being the fields name, next line(s) the row(s). Useful to have NSLog logging a SMySQLResult (example). <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="- fetchFieldsName"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLResult/fetchFieldsName">fetchFieldsName</A></H3><P> <CODE>- (NSArray *)<B>fetchFieldsName</B> </CODE><P> Generate the mNames if not already generated, and return it.<P> mNames is a NSArray holding the names of the fields(columns) of the results <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="- fetchRowAsArray"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLResult/fetchRowAsArray">fetchRowAsArray</A></H3><P> <CODE>- (NSArray *)<B>fetchRowAsArray</B> </CODE><P> Return the next row of the result as an array, the index in select field order, the object a proper object for handling the information in the field (NSString, NSNumber ...). <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="- fetchRowAsDictionary"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLResult/fetchRowAsDictionary">fetchRowAsDictionary</A></H3><P> <CODE>- (NSDictionary *)<B>fetchRowAsDictionary</B> </CODE><P> Return the next row of the result as a dictionary, the key being the field name, the object a proper object for handling the information in the field (NSString, NSNumber ...). <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="- fetchTypesAsArray"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLResult/fetchTypesAsArray">fetchTypesAsArray</A></H3><P> <CODE>- (NSArray *)<B>fetchTypesAsArray</B> </CODE><P> Return an array of the fields' types. <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="- fetchTypesAsDictionary"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLResult/fetchTypesAsDictionary">fetchTypesAsDictionary</A></H3><P> <CODE>- (NSDictionary *)<B>fetchTypesAsDictionary</B> </CODE><P> Return a dictionnary of the fields' types (keys are the fields' names). <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="- init"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLResult/init">init</A></H3><P> <CODE>- (id)<B>init</B> </CODE><P> Empty init, normaly of NO use to the user, again, SMySQLResult should be made through calls to SMySQLConnection <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="- initWithMySQLPtr:encoding:"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLResult/initWithMySQLPtr:encoding:">initWithMySQLPtr:encoding:</A></H3><P> <CODE>- (id)<B>initWithMySQLPtr:</B>(MYSQL *)<EM>mySQLPtr</EM> <B>encoding:</B>(NSStringEncoding)<EM>theEncoding</EM> </CODE><P> initialise a SMySQLResult, it is used internally by SMySQLConnection <B>queryString:</B> method: the only proper way to get a running SMySQLResult object. <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="- initWithResPtr:encoding:"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLResult/initWithResPtr:encoding:">initWithResPtr:encoding:</A></H3><P> <CODE>- (id)<B>initWithResPtr:</B>(MYSQL_RES *)<EM>mySQLResPtr</EM> <B>encoding:</B>(NSStringEncoding)<EM>theEncoding</EM> </CODE><P> This metod it is used internally by SMySQLConnection object when it have already a MYSQL_RES object to initialise SMySQLResult object. Initialise a SMySQLResult with the MYSQL_RES pointer (returned by such a function as mysql_list_dbs). NB: SMySQLResult should be made by using one of the method of SMySQLConnection. <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="- isBlobAtIndex:"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLResult/isBlobAtIndex:">isBlobAtIndex:</A></H3><P> <CODE>- (BOOL)<B>isBlobAtIndex:</B>(unsigned int)<EM>index</EM> </CODE><P> Return YES if the field with the given <I>index</I> is a BLOB. It should be used to discriminates between BLOBs and TEXTs.<P> <B>NOT YET IMPLEMENTED</B>, return YES for both BLOBs and TEXTs... <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="- isBlobForKey:"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLResult/isBlobForKey:">isBlobForKey:</A></H3><P> <CODE>- (BOOL)<B>isBlobForKey:</B>(NSString *)<EM>key</EM> </CODE><P> Return YES if the field (by name) with the given index is a BLOB. It should be used to discriminates between BLOBs and TEXTs.<P> <B>NOT YET IMPLEMENTED</B>, return YES for both BLOBs and TEXTs... <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="- numOfFields"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLResult/numOfFields">numOfFields</A></H3><P> <CODE>- (unsigned int)<B>numOfFields</B> </CODE><P> Return the number of fields selected by the query. <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="- numOfRows"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLResult/numOfRows">numOfRows</A></H3><P> <CODE>- (my_ulonglong)<B>numOfRows</B> </CODE><P> Return the number of rows selected by the query. <P><HR WIDTH=25% ALIGN=LEFT> <A NAME="- stringWithCString:"></A><H3><A NAME="//apple_ref/occ/instm/SMySQLResult/stringWithCString:">stringWithCString:</A></H3><P> <CODE>- (NSString *)<B>stringWithCString:</B>(const char *)<EM>theCString</EM> </CODE><P> Return a NSString from a C style string encoded with the character set of theSMySQLConnection. <P><HR> Version 1.1 Copyright ©2002 by MySQL Cocoa Project. All Rights Reserved. Wed May 15 13:02:12 2002 <P> </BODY></HTML> |
|
From: Serge C. <ser...@us...> - 2002-05-15 12:23:09
|
Update of /cvsroot/mysql-cocoa/Documentation/website/SMySQL_doc In directory usw-pr-cvs1:/tmp/cvs-serv26455/SMySQL_doc Log Message: Directory /cvsroot/mysql-cocoa/Documentation/website/SMySQL_doc added to the repository |
|
From: Serge C. <ser...@us...> - 2002-05-15 11:31:34
|
Update of /cvsroot/mysql-cocoa/SMySQL_test/SMySQL_test.pbproj
In directory usw-pr-cvs1:/tmp/cvs-serv6804/SMySQL_test.pbproj
Modified Files:
cohen.pbxuser
Log Message:
No changes.
Serge Cohen; MySQL Cocoa project, May 15th 2002.
Index: cohen.pbxuser
===================================================================
RCS file: /cvsroot/mysql-cocoa/SMySQL_test/SMySQL_test.pbproj/cohen.pbxuser,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** cohen.pbxuser 15 May 2002 11:03:40 -0000 1.4
--- cohen.pbxuser 15 May 2002 11:17:09 -0000 1.5
***************
*** 14,21 ****
Frame = "{{0, 23}, {946, 508}}";
Split0 = {
! ActiveTab = 1;
Frame = "{{257, 0}, {689, 508}}";
Split0 = {
! Frame = "{{0, 232}, {689, 276}}";
};
SplitCount = 1;
--- 14,21 ----
Frame = "{{0, 23}, {946, 508}}";
Split0 = {
! ActiveTab = 2;
Frame = "{{257, 0}, {689, 508}}";
Split0 = {
! Frame = "{{0, 152}, {689, 356}}";
};
SplitCount = 1;
|
|
From: Serge C. <ser...@us...> - 2002-05-15 11:10:05
|
Update of /cvsroot/mysql-cocoa/SMySQL/SMySQL.pbproj
In directory usw-pr-cvs1:/tmp/cvs-serv5226
Modified Files:
cohen.pbxuser
Log Message:
No changes.
Serge Cohen; MySQL Cocoa project, May 15th 2002.
Index: cohen.pbxuser
===================================================================
RCS file: /cvsroot/mysql-cocoa/SMySQL/SMySQL.pbproj/cohen.pbxuser,v
retrieving revision 1.12
retrieving revision 1.13
diff -C2 -d -r1.12 -r1.13
*** cohen.pbxuser 7 May 2002 18:52:30 -0000 1.12
--- cohen.pbxuser 15 May 2002 11:10:02 -0000 1.13
***************
*** 16,22 ****
Frame = "{{0, 23}, {971, 624}}";
Split0 = {
! Frame = "{{252, 0}, {719, 624}}";
Split0 = {
! Frame = "{{0, 24}, {719, 600}}";
};
SplitCount = 1;
--- 16,23 ----
Frame = "{{0, 23}, {971, 624}}";
Split0 = {
! ActiveTab = 2;
! Frame = "{{186, 0}, {785, 624}}";
Split0 = {
! Frame = "{{0, 216}, {785, 408}}";
};
SplitCount = 1;
***************
*** 54,60 ****
};
Tab2 = {
! BuildMessageFrame = "{{0, 0}, {721, 95}}";
! BuildTranscriptFrame = "{{0, 104}, {721, 90}}";
! Frame = "{{0, 0}, {719, 192}}";
};
Tab3 = {
--- 55,61 ----
};
Tab2 = {
! BuildMessageFrame = "{{0, 0}, {787, 95}}";
! BuildTranscriptFrame = "{{0, 104}, {787, 90}}";
! Frame = "{{0, 0}, {785, 192}}";
};
Tab3 = {
***************
*** 65,69 ****
SplitCount = 1;
Tab0 = {
! Frame = "{{0, 0}, {228, 624}}";
};
Tab1 = {
--- 66,70 ----
SplitCount = 1;
Tab0 = {
! Frame = "{{0, 0}, {162, 624}}";
};
Tab1 = {
***************
*** 102,105 ****
--- 103,111 ----
uiCtxt = {
sepNavWindowFrame = "{{38, 218}, {750, 502}}";
+ };
+ };
+ F5165EB701C50A5A0116CAC1 = {
+ uiCtxt = {
+ sepNavWindowFrame = "{{21, 215}, {750, 502}}";
};
};
|
|
From: Serge C. <ser...@us...> - 2002-05-15 11:07:41
|
Update of /cvsroot/mysql-cocoa/SMySQL/SMySQL.pbproj
In directory usw-pr-cvs1:/tmp/cvs-serv4748
Modified Files:
project.pbxproj
Log Message:
Version 0.7.0 of the framework:
- Removed the two connectTo... methods, replaced by a single connectWithLogin... method.
- Changed listDBs... methods name to better reflect SQL language in the method name.
- Added simple methods with less arguments as shortcuts to the listDBsLike... methods.
- Added method to manage "process".
- Reordered method in the files.
Serge Cohen; MySQL Cocoa project, May 15th 2002....
Index: project.pbxproj
===================================================================
RCS file: /cvsroot/mysql-cocoa/SMySQL/SMySQL.pbproj/project.pbxproj,v
retrieving revision 1.12
retrieving revision 1.13
diff -C2 -d -r1.12 -r1.13
*** project.pbxproj 7 May 2002 18:47:14 -0000 1.12
--- project.pbxproj 15 May 2002 11:07:39 -0000 1.13
***************
*** 116,120 ****
buildSettings = {
DYLIB_COMPATIBILITY_VERSION = 1.0.0;
! DYLIB_CURRENT_VERSION = 0.6.0;
FRAMEWORK_SEARCH_PATHS = "";
FRAMEWORK_VERSION = A;
--- 116,120 ----
buildSettings = {
DYLIB_COMPATIBILITY_VERSION = 1.0.0;
! DYLIB_CURRENT_VERSION = 0.7.0;
FRAMEWORK_SEARCH_PATHS = "";
FRAMEWORK_VERSION = A;
***************
*** 161,165 ****
<string>????</string>
<key>CFBundleVersion</key>
! <string>0.6.0d1</string>
<key>NSPrincipalClass</key>
<string>SMySQLConnection</string>
--- 161,165 ----
<string>????</string>
<key>CFBundleVersion</key>
! <string>0.7.0d1</string>
<key>NSPrincipalClass</key>
<string>SMySQLConnection</string>
***************
*** 410,414 ****
buildSettings = {
DYLIB_COMPATIBILITY_VERSION = 1.0.0;
! DYLIB_CURRENT_VERSION = 0.6.0;
FRAMEWORK_VERSION = A;
HEADER_SEARCH_PATHS = mysqlclient_source/headers;
--- 410,414 ----
buildSettings = {
DYLIB_COMPATIBILITY_VERSION = 1.0.0;
! DYLIB_CURRENT_VERSION = 0.7.0;
FRAMEWORK_VERSION = A;
HEADER_SEARCH_PATHS = mysqlclient_source/headers;
***************
*** 452,456 ****
<string>????</string>
<key>CFBundleVersion</key>
! <string>0.6.0d1</string>
<key>NSPrincipalClass</key>
<string>SMySQLConnection</string>
--- 452,456 ----
<string>????</string>
<key>CFBundleVersion</key>
! <string>0.7.0d1</string>
<key>NSPrincipalClass</key>
<string>SMySQLConnection</string>
***************
*** 1847,1851 ****
buildSettings = {
DYLIB_COMPATIBILITY_VERSION = 1.0.0;
! DYLIB_CURRENT_VERSION = 0.6.0;
FRAMEWORK_VERSION = A;
LIBRARY_SEARCH_PATHS = /usr/local/lib/mysql;
--- 1847,1851 ----
buildSettings = {
DYLIB_COMPATIBILITY_VERSION = 1.0.0;
! DYLIB_CURRENT_VERSION = 0.7.0;
FRAMEWORK_VERSION = A;
LIBRARY_SEARCH_PATHS = /usr/local/lib/mysql;
***************
*** 1893,1897 ****
<string>????</string>
<key>CFBundleVersion</key>
! <string>0.6.0d1</string>
<key>NSPrincipalClass</key>
<string>SMySQLConnection</string>
--- 1893,1897 ----
<string>????</string>
<key>CFBundleVersion</key>
! <string>0.7.0d1</string>
<key>NSPrincipalClass</key>
<string>SMySQLConnection</string>
|
|
From: Serge C. <ser...@us...> - 2002-05-15 11:07:34
|
Update of /cvsroot/mysql-cocoa/SMySQL In directory usw-pr-cvs1:/tmp/cvs-serv4720 Modified Files: SMySQLConnection.h SMySQLConnection.m SMySQLResult.h SMySQLResult.m Log Message: Version 0.7.0 of the framework: - Removed the two connectTo... methods, replaced by a single connectWithLogin... method. - Changed listDBs... methods name to better reflect SQL language in the method name. - Added simple methods with less arguments as shortcuts to the listDBsLike... methods. - Added method to manage "process". - Reordered method in the files. Serge Cohen; MySQL Cocoa project, May 15th 2002. Index: SMySQLConnection.h =================================================================== RCS file: /cvsroot/mysql-cocoa/SMySQL/SMySQLConnection.h,v retrieving revision 1.8 retrieving revision 1.9 diff -C2 -d -r1.8 -r1.9 *** SMySQLConnection.h 7 May 2002 18:43:58 -0000 1.8 --- SMySQLConnection.h 15 May 2002 11:07:30 -0000 1.9 *************** *** 21,25 **** // More info at <http://mysql-cocoa.sourceforge.net/> // ! // #import <Foundation/Foundation.h> --- 21,26 ---- // More info at <http://mysql-cocoa.sourceforge.net/> // ! // $Id$ ! #import <Foundation/Foundation.h> *************** *** 49,66 **** Initialisation "*/ ! - (id)init; // Port to 0 to use the default port ! - (id)initToHost:(NSString *)host withLogin:(NSString *)login password:(NSString *)pass usingPort:(int)port; ! - (id)initToSocket:(NSString *)socket withLogin:(NSString *)login password:(NSString *)pass; ! ! - (BOOL)setConnectionOption:(int)option withArgument:(id)arg; ! - (void)setEncoding:(NSStringEncoding) theEncoding; ! - (NSStringEncoding)encoding; // Port to 0 to use the default port ! - (BOOL)connectToHost:(NSString *)host withLogin:(NSString *)login password:(NSString *)pass usingPort:(int)port; ! - (BOOL)connectToSocket:(NSString *)socket withLogin:(NSString *)login password:(NSString *)pass; ! - (BOOL)selectDB:(NSString *)dbName; /*" --- 50,63 ---- Initialisation "*/ ! - (id) init; // Port to 0 to use the default port ! - (id) initToHost:(NSString *) host withLogin:(NSString *) login password:(NSString *) pass usingPort:(int) port; ! - (id) initToSocket:(NSString *) socket withLogin:(NSString *) login password:(NSString *) pass; + - (BOOL) setConnectionOption:(int) option withArgument:(id) arg; // Port to 0 to use the default port ! - (BOOL) connectWithLogin:(NSString *) login password:(NSString *) pass host:(NSString *) host port:(int) port socket:(NSString *) socket; ! - (BOOL) selectDB:(NSString *) dbName; /*" *************** *** 68,75 **** "*/ ! - (NSString *)getLastErrorMessage; ! - (unsigned int)getLastErrorID; ! - (BOOL)isConnected; ! - (BOOL)checkConnection; /*" --- 65,72 ---- "*/ ! - (NSString *) getLastErrorMessage; ! - (unsigned int) getLastErrorID; ! - (BOOL) isConnected; ! - (BOOL) checkConnection; /*" *************** *** 77,86 **** "*/ ! - (NSString *)prepareBinaryData:(NSData *)theData; ! - (SMySQLResult *)queryString:(NSString *)query; ! - (my_ulonglong)affectedRows; ! - (my_ulonglong)insertId; --- 74,83 ---- "*/ ! - (NSString *) prepareBinaryData:(NSData *) theData; ! - (SMySQLResult *) queryString:(NSString *) query; ! - (my_ulonglong) affectedRows; ! - (my_ulonglong) insertId; *************** *** 88,104 **** Getting description of the database structure "*/ ! - (SMySQLResult *)listDBs:(NSString *)dbsName; ! - (SMySQLResult *)listTables:(NSString *)tablesName; ! - (SMySQLResult *)listFields:(NSString *)fieldsName forTable:(NSString *)tableName; /*" ! Server information "*/ ! - (NSString *)clientInfo; ! - (NSString *)hostInfo; ! - (NSString *)serverInfo; ! - (NSNumber *)protoInfo; //- (BOOL)createDBWithName:(NSString *)dbName; --- 85,108 ---- Getting description of the database structure "*/ ! - (SMySQLResult *) listDBs; ! - (SMySQLResult *) listDBsLike:(NSString *) dbsName; ! - (SMySQLResult *) listTables; ! - (SMySQLResult *) listTablesLike:(NSString *) tablesName; ! // Next method uses SHOW TABLES FROM db to be sure that the db is not changed during this call. ! - (SMySQLResult *) listTablesFromDB:(NSString *) dbName like:(NSString *) tablesName; ! - (SMySQLResult *) listFieldsFromTable:(NSString *) tableName; ! - (SMySQLResult *) listFieldsFromTable:(NSString *) tableName like:(NSString *) fieldsName; /*" ! Server information and control "*/ ! - (NSString *) clientInfo; ! - (NSString *) hostInfo; ! - (NSString *) serverInfo; ! - (NSNumber *) protoInfo; ! - (SMySQLResult *) listProcesses; ! - (BOOL) killProcess:(unsigned long) pid; //- (BOOL)createDBWithName:(NSString *)dbName; *************** *** 109,120 **** "*/ ! - (void)disconnect; ! - (void)dealloc; /*" ! Private methods, internam use only "*/ ! - (const char *)cStringFromString:(NSString *)theString; ! - (NSString *)stringWithCString:(const char *)theCString; @end --- 113,128 ---- "*/ ! - (void) disconnect; ! - (void) dealloc; /*" ! String encoding concerns (c string type to NSString). ! It's unlikely that users of the framework needs to use these methods which are used internally "*/ ! - (void) setEncoding:(NSStringEncoding) theEncoding; ! - (NSStringEncoding) encoding; ! ! - (const char *) cStringFromString:(NSString *) theString; ! - (NSString *) stringWithCString:(const char *) theCString; @end Index: SMySQLConnection.m =================================================================== RCS file: /cvsroot/mysql-cocoa/SMySQL/SMySQLConnection.m,v retrieving revision 1.8 retrieving revision 1.9 diff -C2 -d -r1.8 -r1.9 *** SMySQLConnection.m 7 May 2002 19:01:53 -0000 1.8 --- SMySQLConnection.m 15 May 2002 11:07:30 -0000 1.9 *************** *** 21,25 **** // More info at <http://mysql-cocoa.sourceforge.net/> // ! // --- 21,25 ---- // More info at <http://mysql-cocoa.sourceforge.net/> // ! // $Id$ *************** *** 48,54 **** + (NSDictionary *) getMySQLLocales ! /*"Get a proper Locale dictionary to use formater to parse strings from MySQL. ! ! For example strings representing dates... Should give a proper Locales for use with method such as NSDate::dateWithNaturalLanguageString: locales:"*/ { NSMutableDictionary *theLocalDict = [NSMutableDictionary dictionaryWithCapacity:12]; --- 48,55 ---- + (NSDictionary *) getMySQLLocales ! /*" ! Gets a proper Locale dictionary to use formater to parse strings from MySQL. ! For example strings representing dates should give a proper Locales for use with methods such as NSDate::dateWithNaturalLanguageString: locales: ! "*/ { NSMutableDictionary *theLocalDict = [NSMutableDictionary dictionaryWithCapacity:12]; *************** *** 61,69 **** + (NSStringEncoding) encodingForMySQLEncoding:(const char *) mysqlEncoding ! /*"From the name a charset in mysql format return the proper NSStringEncoding corresponding to this charset. ! This method is not complete for the moment, I hope people using non "supported" encoding will addd them when one needs it, and send me back the modification. ! As off version 4.0 of MySQL, choice in : big5 cp1251 cp1257 croat czech danish dec8 dos estonia euc_kr gb2312 gbk german1 greek hebrew hp8 hungarian koi8_ru koi8_ukr latin1 latin1_de latin2 latin5 sjis swe7 tis620 ujis usa7 win1250 win1251ukr "*/ { --- 62,72 ---- + (NSStringEncoding) encodingForMySQLEncoding:(const char *) mysqlEncoding ! /*" ! Gets a proper NSStringEncoding according to the given MySQL charset. ! MySQL 4.0 offers this charsets: big5 cp1251 cp1257 croat czech danish dec8 dos estonia euc_kr gb2312 gbk german1 greek hebrew hp8 hungarian koi8_ru koi8_ukr latin1 latin1_de latin2 latin5 sjis swe7 tis620 ujis usa7 win1250 win1251ukr + + WARNING : incomplete implementation. Please, send your fixes. "*/ { *************** *** 93,97 **** + (NSStringEncoding) defaultMySQLEncoding ! /*"Return the default charset of the library mysqlclient used. "*/ { --- 96,101 ---- + (NSStringEncoding) defaultMySQLEncoding ! /*" ! Returns the default charset of the library mysqlclient used. "*/ { *************** *** 100,104 **** ! - (id)init /*" Initialise a MySQLConnection without making a connection, most likely useless, except with #{setConnectionOption:withArgument:}. --- 104,108 ---- ! - (id) init /*" Initialise a MySQLConnection without making a connection, most likely useless, except with #{setConnectionOption:withArgument:}. *************** *** 112,132 **** return nil; } ! mEncoding = NSISOLatin1StringEncoding; return self; } ! - (id)initToHost:(NSString *)host withLogin:(NSString *)login password:(NSString *)pass usingPort:(int)port ! /*"Initialise a connection using a #{TCP/IP connection} with the given parameters (except if host is set to !{localhost}, in which case uses the default) - host is the hostname or IP adress - - login is the user name - - pass is the password corresponding to the user name - - port is the TCP port to use to connect. If port = 0, uses the default port from mysql.h "*/ { self = [super init]; mEncoding = NSISOLatin1StringEncoding; --- 116,136 ---- return nil; } ! // mEncoding = NSISOLatin1StringEncoding; ! mEncoding = [SMySQLConnection encodingForMySQLEncoding:mysql_character_set_name(mConnection)]; return self; } ! - (id) initToHost:(NSString *) host withLogin:(NSString *) login password:(NSString *) pass usingPort:(int) port ! /*" ! Initialise a connection using a #{TCP/IP connection} with the given parameters (except if host is set to !{localhost}, in which case uses the default) - host is the hostname or IP adress - login is the user name - pass is the password corresponding to the user name - port is the TCP port to use to connect. If port = 0, uses the default port from mysql.h "*/ { + #warning What happens when inited twice the NSObject? self = [super init]; mEncoding = NSISOLatin1StringEncoding; *************** *** 137,142 **** } else { - // else the object has never been inited... - self = [super init]; } --- 141,144 ---- *************** *** 149,168 **** } ! [self connectToHost:host withLogin:login password:pass usingPort:port]; ! return self; ! } ! - (id)initToSocket:(NSString *)socket withLogin:(NSString *)login password:(NSString *)pass ! /*"Initialise a connection using a #{unix socket} with the given parameters - socket is the path to the socket - - login is the user name - - pass is the password corresponding to the user name ! "*/ { self = [super init]; mEncoding = NSISOLatin1StringEncoding; --- 151,169 ---- } ! [self connectWithLogin:login password:pass host:host port:port socket:nil]; ! return self; } ! - (id) initToSocket:(NSString *) socket withLogin:(NSString *) login password:(NSString *) pass ! /*" ! Initialise a connection using a #{unix socket} with the given parameters - socket is the path to the socket - login is the user name - pass is the password corresponding to the user name ! "*/ { + #warning What happens when inited twice the NSObject? self = [super init]; mEncoding = NSISOLatin1StringEncoding; *************** *** 173,178 **** } else { - // else the object has never been inited... - self = [super init]; } --- 174,177 ---- *************** *** 185,194 **** } ! [self connectToSocket:socket withLogin:login password:pass]; return self; } ! - (BOOL)setConnectionOption:(int)option withArgument:(id)arg /*" #{NOT YET IMPLEMENTED} --- 184,193 ---- } ! [self connectWithLogin:login password:pass host:NULL port:0 socket:socket]; return self; } ! - (BOOL) setConnectionOption:(int) option withArgument:(id) arg /*" #{NOT YET IMPLEMENTED} *************** *** 213,255 **** } - - (void)setEncoding:(NSStringEncoding) theEncoding - /*" - Select the encoding used by the server for data transfert. This is usefull for the output NSString (query result) to be Ok even for character which are not ASCII - NB: The character set (encoding) used by the db is passed to the SMySQLConnection object upon connection, so most likely the encoding (from -encoding) method is already the proper one. That is to say : It's unlikeley you need to use this method, and if ever you use it, do it at your own risks. - "*/ - { - mEncoding = theEncoding; - } - - - - (NSStringEncoding)encoding - /*" - Get back the encoding for the server connection - "*/ - { - return mEncoding; - } - ! // Give 0 for port to connect to default port ! - (BOOL)connectToHost:(NSString *)host withLogin:(NSString *)login password:(NSString *)pass usingPort:(int)port /*" ! The method used by #{initToHost:withLogin:password:usingPort:}. Same information and use of the parameters: ! ! - host is the hostname or IP adress ! ! - login is the user name ! ! - pass is the password corresponding to the user name ! - port is the TCP port to use to connect. If port = 0, uses the default port from mysql.h ! For the moment the implementation might not be safe if you have a nil pointer to one of the NSString* variables (underestand: I don't know what the result will be). ! "*/ { #warning What to do if one of the string is a nil pointer? ! const char *theHost = [host UTF8String]; ! const char *theLogin = [login UTF8String]; ! const char *thePass = [pass UTF8String]; void *theRet; --- 212,235 ---- } ! - (BOOL) connectWithLogin:(NSString *) login password:(NSString *) pass host:(NSString *) host port:(int) port socket:(NSString *) socket /*" ! The method used by #{initToHost:withLogin:password:usingPort:} and #{initToSocket:withLogin:password:}. Same information and use of the parameters: ! - login is the user name ! - pass is the password corresponding to the user name ! - host is the hostname or IP adress ! - port is the TCP port to use to connect. If port = 0, uses the default port from mysql.h ! - socket is the path to the socket (for the localhost) ! The socket is used if the host is set to !{@"localhost"}, to an empty or a !{nil} string ! For the moment the implementation might not be safe if you have a nil pointer to one of the NSString* variables (underestand: I don't know what the result will be). ! "*/ { #warning What to do if one of the string is a nil pointer? ! const char *theLogin = [self cStringFromString:login]; ! const char *theHost = [self cStringFromString:host]; ! const char *thePass = [self cStringFromString:pass]; ! const char *theSocket = [self cStringFromString:socket]; void *theRet; *************** *** 262,302 **** } ! theRet = mysql_real_connect(mConnection, theHost, theLogin, thePass, NULL, port, kSMySQLConnectionDefaultSocket, kSMySQL_default_option); ! if (theRet != mConnection) { ! return mConnected = NO; } ! mEncoding = [SMySQLConnection encodingForMySQLEncoding:mysql_character_set_name(mConnection)]; ! return mConnected = YES; ! } ! ! ! - (BOOL)connectToSocket:(NSString *)socket withLogin:(NSString *)login password:(NSString *)pass ! /*" ! The method used by #{initToSocket:withLogin:password:}. Same information and use of the parameters: ! ! - socket is the path to the socket ! ! - login is the user name ! ! - pass is the password corresponding to the user name ! ! For the moment the implementation might not be safe if you have a nil pointer to one of the NSString* variables (underestand: I don't know what the result will be). ! "*/ ! { ! #warning What to do if one of the string is a nil pointer? ! const char *theSocket = [socket UTF8String]; ! const char *theLogin = [login UTF8String]; ! const char *thePass = [pass UTF8String]; ! void *theRet; ! ! if (mConnected) { ! // Disconnect if it was already connected ! mysql_close(mConnection); ! mConnection = NULL; ! mConnected = NO; ! [self init]; } ! theRet = mysql_real_connect(mConnection, NULL, theLogin, thePass, NULL, 0, theSocket, kSMySQL_default_option); if (theRet != mConnection) { return mConnected = NO; --- 242,253 ---- } ! if ([host isEqualToString:@""]) { ! theHost = NULL; } ! if (theSocket == NULL) { ! theSocket = kSMySQLConnectionDefaultSocket; } ! theRet = mysql_real_connect(mConnection, theHost, theLogin, thePass, NULL, port, theSocket, kSMySQL_default_option); if (theRet != mConnection) { return mConnected = NO; *************** *** 307,313 **** ! - (BOOL)selectDB:(NSString *)dbName /*" ! Select a database to work with. The SMySQLConnection object needs to be properly inited and connected to a server. If a connection is not yet set or the selection of the database didn't worked, return NO. return yes in the normal case, where the database is properly selected. So far, if dbName is a nil pointer it will return NO (as if it cannot connect), most likely this will throw an exception in the future. --- 258,266 ---- ! - (BOOL) selectDB:(NSString *) dbName /*" ! Selects a database to work with. ! The SMySQLConnection object needs to be properly inited and connected to a server. ! If a connection is not yet set or the selection of the database didn't work, returns NO. Returns YES in normal cases where the database is properly selected. So far, if dbName is a nil pointer it will return NO (as if it cannot connect), most likely this will throw an exception in the future. *************** *** 316,320 **** if (dbName == nil) { #warning Should throw an exception, illegal string pointer (nil) ! // Here we should throw an exception, impossible to select a databse is the string is indeed a nil pointer return NO; } --- 269,273 ---- if (dbName == nil) { #warning Should throw an exception, illegal string pointer (nil) ! // Here we should throw an exception, impossible to select a databse if the string is indeed a nil pointer return NO; } *************** *** 329,335 **** ! - (NSString *)getLastErrorMessage /*" ! Return a string with the last MySQL error message on the connection. "*/ { --- 282,288 ---- ! - (NSString *) getLastErrorMessage /*" ! Returns a string with the last MySQL error message on the connection. "*/ { *************** *** 342,348 **** } ! - (unsigned int)getLastErrorID /*" ! Return the ErrorID of the last MySQL error on the connection. "*/ { --- 295,301 ---- } ! - (unsigned int) getLastErrorID /*" ! Returns the ErrorID of the last MySQL error on the connection. "*/ { *************** *** 353,359 **** } ! - (BOOL)isConnected /*" ! Return YES if the SMySQLConnection is connected to a DB, NO otherwise. "*/ { --- 306,312 ---- } ! - (BOOL) isConnected /*" ! Returns YES if the SMySQLConnection is connected to a DB, NO otherwise. "*/ { *************** *** 363,367 **** - (BOOL)checkConnection /*" ! Check if the connection to the server is still on; if not, tries to reconnect (changing no parameters from the MYSQL pointer). This method just uses mysql_ping(). "*/ { --- 316,322 ---- - (BOOL)checkConnection /*" ! Checks if the connection to the server is still on. ! If not, tries to reconnect (changing no parameters from the MYSQL pointer). ! This method just uses mysql_ping(). "*/ { *************** *** 370,374 **** ! - (NSString *)prepareBinaryData:(NSData *)theData /*" Takes a NSData object and transform it in a proper string for sending to the server in between quotes. --- 325,329 ---- ! - (NSString *) prepareBinaryData:(NSData *) theData /*" Takes a NSData object and transform it in a proper string for sending to the server in between quotes. *************** *** 386,393 **** } ! - (SMySQLResult *)queryString:(NSString *)query /*" Takes a query string and return an SMySQLResult object holding the result of the query. The returned SMySQLResult is not retained, the client is responsible for that (it's autoreleased before being returned) "*/ { --- 341,350 ---- } ! ! - (SMySQLResult *) queryString:(NSString *) query /*" Takes a query string and return an SMySQLResult object holding the result of the query. The returned SMySQLResult is not retained, the client is responsible for that (it's autoreleased before being returned) + Note that if you want to use this method with binary data (in the query), you should use !{prepareBinaryData:} to include the binary data in the query string. "*/ { *************** *** 415,421 **** } ! - (my_ulonglong)affectedRows /*" ! Return the number of affected rows by the last query. "*/ { --- 372,378 ---- } ! - (my_ulonglong) affectedRows /*" ! Returns the number of affected rows by the last query. "*/ { *************** *** 426,430 **** } ! - (my_ulonglong)insertId /*" If the last query was an insert in a table having a autoindex column, returns the id (autoindexed field) of the last row inserted. --- 383,388 ---- } ! ! - (my_ulonglong) insertId /*" If the last query was an insert in a table having a autoindex column, returns the id (autoindexed field) of the last row inserted. *************** *** 438,445 **** ! - (SMySQLResult *)listDBs:(NSString *)dbsName /*" ! Return a list of database which name correspond to the string dbsName. The comparison is done with wild card extension : % and _. The result should correspond to the queryString:@"SHOW databases [LIKE wild]"; but implemented with mysql_list_dbs. ! If an empty string of nil is passed as dbsName, all databases will be shown. "*/ { --- 396,414 ---- ! - (SMySQLResult *) listDBs /*" ! Just a fast wrapper for the more complex !{listDBsWithPattern:} method. ! "*/ ! { ! return [self listDBsLike:nil]; ! } ! ! ! - (SMySQLResult *) listDBsLike:(NSString *) dbsName ! /*" ! Returns a list of database which name correspond to the SQL regular expression in 'pattern'. ! The comparison is done with wild card extension : % and _. ! The result should correspond to the queryString:@"SHOW databases [LIKE wild]"; but implemented with mysql_list_dbs. ! If an empty string or nil is passed as pattern, all databases will be shown. "*/ { *************** *** 471,478 **** ! - (SMySQLResult *)listTables:(NSString *)tablesName /*" From within a database, give back the list of table which name correspond to tablesName (with wild card %, _ extension). Correspond to queryString:@"SHOW tables [LIKE wild]"; uses mysql_list_tables function. ! If an empty string of nil is passed as tablesName, all tables will be shown. "*/ { --- 440,457 ---- ! - (SMySQLResult *) listTables ! /*" ! Make sure a DB is selected (with !{selectDB} method) first. ! "*/ ! { ! return [self listTablesLike:nil]; ! } ! ! ! - (SMySQLResult *) listTablesLike:(NSString *) tablesName /*" From within a database, give back the list of table which name correspond to tablesName (with wild card %, _ extension). Correspond to queryString:@"SHOW tables [LIKE wild]"; uses mysql_list_tables function. ! If an empty string or nil is passed as tablesName, all tables will be shown. ! WARNING: #{produce an error if no databases are selected} (with !{selectDB:} for example). "*/ { *************** *** 504,511 **** ! - (SMySQLResult *)listFields:(NSString *)fieldsName forTable:(NSString *)tableName /*" ! Show all the fields of the table tableName which name correspond to fieldsName (with wild card expansion : %,_). Indeed, and as recommanded from mysql reference, this method is NOT using mysql_list_fields but the queryString:@"" method. ! If an empty string of nil is passed as fieldsName, all fields (of tableName) will be returned. "*/ { --- 483,521 ---- ! - (SMySQLResult *) listTablesFromDB:(NSString *) dbName like:(NSString *) tablesName /*" ! List tables in DB specified by dbName and corresponding to pattern. ! This method indeed issues a !{SHOW TABLES FROM dbName LIKE ...} query to the server. ! This is done this way to make sure the selected DB is not changed by this method. ! "*/ ! { ! SMySQLResult *theResult; ! ! if ((tablesName == nil) || ([tablesName isEqualToString:@""])) { ! NSString *theQuery = [NSString stringWithFormat:@"SHOW TABLES FROM %@", dbName]; ! theResult = [self queryString:theQuery]; ! } ! else { ! NSString *theQuery = [NSString stringWithFormat:@"SHOW COLUMNS FROM %@ LIKE '%@'", dbName, tablesName]; ! theResult = [self queryString:theQuery]; ! } ! return theResult; ! } ! ! ! - (SMySQLResult *)listFieldsFromTable:(NSString *)tableName ! /*" ! Just a fast wrapper for the more complex list !{listFieldsWithPattern:forTable:} method. ! "*/ ! { ! return [self listFieldsFromTable:tableName like:nil]; ! } ! ! ! - (SMySQLResult *) listFieldsFromTable:(NSString *) tableName like:(NSString *) fieldsName ! /*" ! Show all the fields of the table tableName which name correspond to pattern (with wild card expansion : %,_). ! Indeed, and as recommanded from mysql reference, this method is NOT using mysql_list_fields but the !{queryString:} method. ! If an empty string or nil is passed as fieldsName, all fields (of tableName) will be returned. "*/ { *************** *** 524,530 **** ! - (NSString *)clientInfo /*" ! Return a string giving the client library version "*/ { --- 534,540 ---- ! - (NSString *) clientInfo /*" ! Returns a string giving the client library version. "*/ { *************** *** 533,539 **** ! - (NSString *)hostInfo /*" ! Return a string giving information on the host of the DB server. "*/ { --- 543,549 ---- ! - (NSString *) hostInfo /*" ! Returns a string giving information on the host of the DB server. "*/ { *************** *** 542,548 **** ! - (NSString *)serverInfo /*" ! Return server information. "*/ { --- 552,558 ---- ! - (NSString *) serverInfo /*" ! Returns a string giving the server version. "*/ { *************** *** 554,560 **** ! - (NSNumber *)protoInfo /*" ! Return the number of the protocole used to transfer info from server to client "*/ { --- 564,570 ---- ! - (NSNumber *) protoInfo /*" ! Returns the number of the protocole used to transfer info from server to client "*/ { *************** *** 563,566 **** --- 573,597 ---- + - (SMySQLResult *) listProcesses + /*" + Lists active process + "*/ + { + SMySQLResult *theResult = [SMySQLResult alloc]; + MYSQL_RES *theResPtr; + + if (theResPtr = mysql_list_processes(mConnection)) { + [theResult initWithResPtr:theResPtr encoding:mEncoding]; + } else { + [theResult init]; + } + + if (theResult) { + [theResult autorelease]; + } + return theResult; + } + + /* - (BOOL)createDBWithName:(NSString *)dbName *************** *** 584,590 **** ! - (void)disconnect /*" ! Disconnect a connected SMySQLConnection object; used by #{-dealloc} method. "*/ { --- 615,634 ---- ! - (BOOL) killProcess:(unsigned long) pid /*" ! Kills the process with the given pid. ! The users needs the #{Process_priv} privilege. ! "*/ ! { ! int theErrorCode; ! ! theErrorCode = mysql_kill(mConnection, pid); ! return (theErrorCode) ? NO : YES; ! } ! ! ! - (void) disconnect ! /*" ! Disconnects a connected SMySQLConnection object; used by #{-dealloc} method. "*/ { *************** *** 608,619 **** ! - (const char *)cStringFromString:(NSString *)theString /*" ! For internal use only. Transform a NSString to a C type string (ended with \0) using ethe character set from the SMySQLConnection. Lossy conversions are enabled. "*/ { ! NSMutableData *theData = [NSMutableData dataWithData:[theString dataUsingEncoding:mEncoding allowLossyConversion:YES]]; [theData increaseLengthBy:1]; return (const char *)[theData bytes]; --- 652,690 ---- ! - (void) setEncoding:(NSStringEncoding) theEncoding /*" ! Sets the encoding used by the server for data transfert. ! Used to make sure the output of the query result is ok even for non-ascii characters ! The character set (encoding) used by the db is passed to the SMySQLConnection object upon connection, ! so most likely the encoding (from -encoding) method is already the proper one. ! That is to say : It's unlikely you will need to call this method directly, and #{if ever you use it, do it at your own risks}. ! "*/ ! { ! mEncoding = theEncoding; ! } ! ! ! - (NSStringEncoding) encoding ! /*" ! Gets the encoding for the connection ! "*/ ! { ! return mEncoding; ! } ! ! ! - (const char *) cStringFromString:(NSString *) theString ! /*" ! For internal use only. Transforms a NSString to a C type string (ending with \0) using the character set from the SMySQLConnection. Lossy conversions are enabled. "*/ { ! NSMutableData *theData; + if (! theString) { + return (const char *)NULL; + } + + theData = [NSMutableData dataWithData:[theString dataUsingEncoding:mEncoding allowLossyConversion:YES]]; [theData increaseLengthBy:1]; return (const char *)[theData bytes]; *************** *** 621,627 **** ! - (NSString *)stringWithCString:(const char *)theCString /*" ! Return a NSString from a C style string encoded with the character set of theSMySQLConnection. "*/ { --- 692,698 ---- ! - (NSString *) stringWithCString:(const char *) theCString /*" ! Returns a NSString from a C style string encoded with the character set of theSMySQLConnection. "*/ { Index: SMySQLResult.h =================================================================== RCS file: /cvsroot/mysql-cocoa/SMySQL/SMySQLResult.h,v retrieving revision 1.5 retrieving revision 1.6 diff -C2 -d -r1.5 -r1.6 *** SMySQLResult.h 7 May 2002 18:43:58 -0000 1.5 --- SMySQLResult.h 15 May 2002 11:07:30 -0000 1.6 *************** *** 21,25 **** // More info at <http://mysql-cocoa.sourceforge.net/> // ! // #import <Foundation/Foundation.h> --- 21,26 ---- // More info at <http://mysql-cocoa.sourceforge.net/> // ! // $Id$ ! #import <Foundation/Foundation.h> Index: SMySQLResult.m =================================================================== RCS file: /cvsroot/mysql-cocoa/SMySQL/SMySQLResult.m,v retrieving revision 1.5 retrieving revision 1.6 diff -C2 -d -r1.5 -r1.6 *** SMySQLResult.m 7 May 2002 17:22:21 -0000 1.5 --- SMySQLResult.m 15 May 2002 11:07:30 -0000 1.6 *************** *** 21,25 **** // More info at <http://mysql-cocoa.sourceforge.net/> // ! // #import "SMySQLConnection.h" --- 21,26 ---- // More info at <http://mysql-cocoa.sourceforge.net/> // ! // $Id$ ! #import "SMySQLConnection.h" *************** *** 790,795 **** "*/ { ! NSMutableData *theData = [NSMutableData dataWithData:[theString dataUsingEncoding:mEncoding allowLossyConversion:YES]]; [theData increaseLengthBy:1]; return (const char *)[theData bytes]; --- 791,801 ---- "*/ { ! NSMutableData *theData; + if (! theString) { + return (const char *)NULL; + } + + theData = [NSMutableData dataWithData:[theString dataUsingEncoding:mEncoding allowLossyConversion:YES]]; [theData increaseLengthBy:1]; return (const char *)[theData bytes]; |
|
From: Serge C. <ser...@us...> - 2002-05-15 11:03:43
|
Update of /cvsroot/mysql-cocoa/SMySQL_test/SMySQL_test.pbproj
In directory usw-pr-cvs1:/tmp/cvs-serv3973
Modified Files:
cohen.pbxuser
Log Message:
Check the new version of the framework:0.7.0 (modified list method names). Changed again list methods names.
Serge Cohen; MySQL Cocoa project, May 15th 2002....
Index: cohen.pbxuser
===================================================================
RCS file: /cvsroot/mysql-cocoa/SMySQL_test/SMySQL_test.pbproj/cohen.pbxuser,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** cohen.pbxuser 6 May 2002 10:04:29 -0000 1.3
--- cohen.pbxuser 15 May 2002 11:03:40 -0000 1.4
***************
*** 14,20 ****
Frame = "{{0, 23}, {946, 508}}";
Split0 = {
Frame = "{{257, 0}, {689, 508}}";
Split0 = {
! Frame = "{{0, 24}, {689, 484}}";
};
SplitCount = 1;
--- 14,21 ----
Frame = "{{0, 23}, {946, 508}}";
Split0 = {
+ ActiveTab = 1;
Frame = "{{257, 0}, {689, 508}}";
Split0 = {
! Frame = "{{0, 232}, {689, 276}}";
};
SplitCount = 1;
|
|
From: Serge C. <ser...@us...> - 2002-05-15 11:03:36
|
Update of /cvsroot/mysql-cocoa/SMySQL_test
In directory usw-pr-cvs1:/tmp/cvs-serv3925
Modified Files:
main2.m
Log Message:
Check the new version of the framework:0.7.0 (modified list method names). Changed again list methods names.
Serge Cohen; MySQL Cocoa project, May 15th 2002.
Index: main2.m
===================================================================
RCS file: /cvsroot/mysql-cocoa/SMySQL_test/main2.m,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** main2.m 15 May 2002 09:53:02 -0000 1.6
--- main2.m 15 May 2002 11:03:33 -0000 1.7
***************
*** 68,72 ****
NSLog (@"Here is theNSLog of a SMySQLResult %@", result);
! result = [connection listFieldsWithPattern:nil fromTable:@"test1"];
[result fetchFieldsName];
NSLog (@"Here is theNSLog of a SMySQLResult (listFields:nil forTable:test1) %@", result);
--- 68,72 ----
NSLog (@"Here is theNSLog of a SMySQLResult %@", result);
! result = [connection listFieldsFromTable:@"test1" like:nil];
[result fetchFieldsName];
NSLog (@"Here is theNSLog of a SMySQLResult (listFields:nil forTable:test1) %@", result);
***************
*** 80,84 ****
NSLog (@"Here is the NSLog of a SMySQLResult (listDBs) : \n%@", result);
! result = [connection listDBsWithPattern:@"test\\_%%"];
[result fetchFieldsName];
NSLog (@"Here is the NSLog of a SMySQLResult (listDBs:test\\_%%) : \n%@", result);
--- 80,84 ----
NSLog (@"Here is the NSLog of a SMySQLResult (listDBs) : \n%@", result);
! result = [connection listDBsLike:@"test\\_%%"];
[result fetchFieldsName];
NSLog (@"Here is the NSLog of a SMySQLResult (listDBs:test\\_%%) : \n%@", result);
|
|
From: Serge C. <ser...@us...> - 2002-05-15 09:53:07
|
Update of /cvsroot/mysql-cocoa/SMySQL_test
In directory usw-pr-cvs1:/tmp/cvs-serv17045
Modified Files:
main2.m
Log Message:
Check the new version of the framework:0.7.0 (modified list method names).
Serge Cohen; MySQL Cocoa project, May 15th 2002.
Index: main2.m
===================================================================
RCS file: /cvsroot/mysql-cocoa/SMySQL_test/main2.m,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** main2.m 7 May 2002 19:10:57 -0000 1.5
--- main2.m 15 May 2002 09:53:02 -0000 1.6
***************
*** 68,84 ****
NSLog (@"Here is theNSLog of a SMySQLResult %@", result);
! result = [connection listFields:nil forTable:@"test1"];
[result fetchFieldsName];
NSLog (@"Here is theNSLog of a SMySQLResult (listFields:nil forTable:test1) %@", result);
! result = [connection listDBs:nil];
[result fetchFieldsName];
NSLog (@"Here is the NSLog of a SMySQLResult (listDBs) : \n%@", result);
! result = [connection listDBs:@"test\\_%%"];
[result fetchFieldsName];
NSLog (@"Here is the NSLog of a SMySQLResult (listDBs:test\\_%%) : \n%@", result);
! result = [connection listTables:nil];
[result fetchFieldsName];
NSLog (@"Here is the NSLog of a SMySQLResult (listTables) : \n%@", result);
--- 68,88 ----
NSLog (@"Here is theNSLog of a SMySQLResult %@", result);
! result = [connection listFieldsWithPattern:nil fromTable:@"test1"];
[result fetchFieldsName];
NSLog (@"Here is theNSLog of a SMySQLResult (listFields:nil forTable:test1) %@", result);
! result = [connection listFieldsFromTable:@"test1"];
! [result fetchFieldsName];
! NSLog (@"Here is theNSLog of a SMySQLResult (listFields:nil forTable:test1) %@", result);
!
! result = [connection listDBs];
[result fetchFieldsName];
NSLog (@"Here is the NSLog of a SMySQLResult (listDBs) : \n%@", result);
! result = [connection listDBsWithPattern:@"test\\_%%"];
[result fetchFieldsName];
NSLog (@"Here is the NSLog of a SMySQLResult (listDBs:test\\_%%) : \n%@", result);
! result = [connection listTables];
[result fetchFieldsName];
NSLog (@"Here is the NSLog of a SMySQLResult (listTables) : \n%@", result);
|
|
From: Serge C. <ser...@us...> - 2002-05-08 16:46:15
|
Update of /cvsroot/mysql-cocoa/Documentation/website/Display In directory usw-pr-cvs1:/tmp/cvs-serv6230/Display Modified Files: index.html Log Message: Update the web pages of the framework and the Display application. Serge Cohen; MySQL Cocoa project, May 8th 2002. Index: index.html =================================================================== RCS file: /cvsroot/mysql-cocoa/Documentation/website/Display/index.html,v retrieving revision 1.7 retrieving revision 1.8 diff -C2 -d -r1.7 -r1.8 *** index.html 14 Mar 2002 09:59:44 -0000 1.7 --- index.html 8 May 2002 16:46:12 -0000 1.8 *************** *** 21,28 **** </div> - <a name="updates"><h2>Updates</h2></a> - <!--Updates--> <p><em>14 March 2002:</em> The new version of the <a href="../index.html">SMySQL frameworks</a> includes directly the libmysqlclient in the framework. Now you don't need any more to install the MySQL client side library to run MySQL Display. Just <a href="http://ftp1.sourceforge.net/mysql-cocoa/MySQL_Display_0.1.2.dmg.gz">download</a> it from sourceforge, expand, mount the disk image and launch the application (this should be done in three double-click).</p> <p><em>28 February 2002:</em> The framework is now ready to be embeded in the application(s) using it. I still have a problem for statically linking the libmysqlclient, so use of SMySQL framework still needs the installation of libmysqlclient.dylib (which is done by MySQL_Cocoa_installers_0.5.2.dmg.gz).Now MySQL Display should run without asking for a non exitent framwork.</p> --- 21,28 ---- </div> <!--Updates--> + <a name="updates"><h2>Updates</h2></a> + <p><em>8 May 2002:</em> The new <a href="../index.html">framework</a> (with better character set encoding) is included. Few bugs of the applications have been fixed. You can find either the <a href="../index.html#sources">source</a> (in which case you have to compile one of the embeded version of the framework). A binary is also released <a href="#binaries">here</a>; it's a disk image (dmg) which contain the licence (GPL) and the application.</p> <p><em>14 March 2002:</em> The new version of the <a href="../index.html">SMySQL frameworks</a> includes directly the libmysqlclient in the framework. Now you don't need any more to install the MySQL client side library to run MySQL Display. Just <a href="http://ftp1.sourceforge.net/mysql-cocoa/MySQL_Display_0.1.2.dmg.gz">download</a> it from sourceforge, expand, mount the disk image and launch the application (this should be done in three double-click).</p> <p><em>28 February 2002:</em> The framework is now ready to be embeded in the application(s) using it. I still have a problem for statically linking the libmysqlclient, so use of SMySQL framework still needs the installation of libmysqlclient.dylib (which is done by MySQL_Cocoa_installers_0.5.2.dmg.gz).Now MySQL Display should run without asking for a non exitent framwork.</p> *************** *** 42,48 **** <ul> ! <li>Binaries to install fast..</li> <ul> ! <li>Getting the MySQL Display application (alone): <a href="http://ftp1.sourceforge.net/mysql-cocoa/MySQL_Display_0.1.2.dmg.gz">Disk image</a>, MD5: 5a082b108a8eba108b27d22bdc0a3b42</li> <li>Installing the complete Client side of MySQL, and getting the MySQL Display application (as a free bonus): <a href="http://ftp1.sourceforge.net/mysql-cocoa/MySQL_Cocoa_installers_0.5.2.dmg.gz">Disk image</a>, MD5: fc88e839717d3a478fa44c56387da908</li> </ul> --- 42,48 ---- <ul> ! <li><a name="binaries">Binaries to install fast..</a></li> <ul> ! <li>Getting the MySQL Display application (alone): <a href="http://ftp1.sourceforge.net/mysql-cocoa/MySQL_Display_0.1.3.dmg.gz">Disk image</a>, MD5: 462f2cff5cc57c463418cb8af10b9f5d</li> <li>Installing the complete Client side of MySQL, and getting the MySQL Display application (as a free bonus): <a href="http://ftp1.sourceforge.net/mysql-cocoa/MySQL_Cocoa_installers_0.5.2.dmg.gz">Disk image</a>, MD5: fc88e839717d3a478fa44c56387da908</li> </ul> |
|
From: Serge C. <ser...@us...> - 2002-05-08 16:46:15
|
Update of /cvsroot/mysql-cocoa/Documentation/website In directory usw-pr-cvs1:/tmp/cvs-serv6230 Modified Files: index.html Log Message: Update the web pages of the framework and the Display application. Serge Cohen; MySQL Cocoa project, May 8th 2002. Index: index.html =================================================================== RCS file: /cvsroot/mysql-cocoa/Documentation/website/index.html,v retrieving revision 1.11 retrieving revision 1.12 diff -C2 -d -r1.11 -r1.12 *** index.html 3 May 2002 09:57:56 -0000 1.11 --- index.html 8 May 2002 16:46:10 -0000 1.12 *************** *** 20,26 **** </div> <a name="updates"><h2>Updates</h2></a> ! <!--Updates--> <p><em>3 May 2002:</em> After suggestion from Bertrand Mansion I added a couple of method to get databases, tables, and fields (of a table) list. They works they way they should from the C API recommandation (specific function for DBs, and tables, standard query for fields). I also started to enhance the handling of the charset encoding (suggestion by John Guy). This feature is not yet fully implemented. The new version (0.5.4) is only available through CVS so far (see information from the <a href="http://sourceforge.net/cvs/?group_id=42424">sourceforge project page</a>).</p> <p><em>14 March 2002:</em> A new target for SMySQL framework exists. It gives you access to a all in one version of the framework: libmysqlclient is statically linked inside the framework... No more need for a root user to install the mysqlclient library. The version of libmysqlclient is 3.23.49 (the lataest stable version). As a test I have linked <a href="Display/index.html">MySQL Display</a> to this version of the framework, and it works perfectly (<a href="http://ftp1.sourceforge.net/mysql-cocoa/MySQL_Display_0.1.2.dmg.gz">Download</a>).</p> --- 20,27 ---- </div> + <!--Updates--> <a name="updates"><h2>Updates</h2></a> ! <p><em>7 May 2002:</em> Cleaned up the methods from May 3rd, (databases, tables, fields list). Finished the proper encoding of the character sets (should run Ok with latin1, latin2, win1250, cp1251, euc_kr, sjis). Added methods to check the version of the protocole, the client library, the server, and to get info on the database server the host. The framework has been promoted to version 0.6.0. It's under CVS, but also on the <a href="#sources">File Release</a>.</p> <p><em>3 May 2002:</em> After suggestion from Bertrand Mansion I added a couple of method to get databases, tables, and fields (of a table) list. They works they way they should from the C API recommandation (specific function for DBs, and tables, standard query for fields). I also started to enhance the handling of the charset encoding (suggestion by John Guy). This feature is not yet fully implemented. The new version (0.5.4) is only available through CVS so far (see information from the <a href="http://sourceforge.net/cvs/?group_id=42424">sourceforge project page</a>).</p> <p><em>14 March 2002:</em> A new target for SMySQL framework exists. It gives you access to a all in one version of the framework: libmysqlclient is statically linked inside the framework... No more need for a root user to install the mysqlclient library. The version of libmysqlclient is 3.23.49 (the lataest stable version). As a test I have linked <a href="Display/index.html">MySQL Display</a> to this version of the framework, and it works perfectly (<a href="http://ftp1.sourceforge.net/mysql-cocoa/MySQL_Display_0.1.2.dmg.gz">Download</a>).</p> *************** *** 52,57 **** <li>Installing the Client side of MySQL, and getting the <a href="Display/index.html">MySQL Display application</a> (as a free bonus): <a href="http://ftp1.sourceforge.net/mysql-cocoa/MySQL_Cocoa_installers_0.5.2.dmg.gz">Disk image</a>, MD5: fc88e839717d3a478fa44c56387da908</li> </ul> ! <li>Mac OS X 10.1 or higher sources, version 0.5.3 r1 <! (note: not up to date, see CVS for version 0.5.2) !></li> <ul> <li><a href="http://ftp1.sourceforge.net/mysql-cocoa/SMySQL_0.5.3.tgz">SMySQL Framework v0.5.3r1</a>, MD5: 536de45748d9db6218e7e4d3eecaea06</li> <li><a href="http://ftp1.sourceforge.net/mysql-cocoa/SMySQL_0.5.1.tgz">SMySQL Framework v0.5.1r1</a>, MD5: a0ecaf53275cc068002b8e45cb0b6695</li> --- 53,59 ---- <li>Installing the Client side of MySQL, and getting the <a href="Display/index.html">MySQL Display application</a> (as a free bonus): <a href="http://ftp1.sourceforge.net/mysql-cocoa/MySQL_Cocoa_installers_0.5.2.dmg.gz">Disk image</a>, MD5: fc88e839717d3a478fa44c56387da908</li> </ul> ! <li><a name="sources">Mac OS X 10.1 or higher sources, version 0.5.3 r1 </a><! (note: not up to date, see CVS for version 0.5.2) !></li> <ul> + <li><a href="http://ftp1.sourceforge.net/mysql-cocoa/SMySQL_0.6.0.tgz">SMySQL Framework v0.6.0r1</a>, MD5: 685b6b4361936c4d9109d390686c6cdc</li> <li><a href="http://ftp1.sourceforge.net/mysql-cocoa/SMySQL_0.5.3.tgz">SMySQL Framework v0.5.3r1</a>, MD5: 536de45748d9db6218e7e4d3eecaea06</li> <li><a href="http://ftp1.sourceforge.net/mysql-cocoa/SMySQL_0.5.1.tgz">SMySQL Framework v0.5.1r1</a>, MD5: a0ecaf53275cc068002b8e45cb0b6695</li> *************** *** 59,66 **** --- 61,70 ---- </ul> <ul> + <li><a href="http://ftp1.sourceforge.net/mysql-cocoa/MySQL_Display_0.1.3.tgz">MySQL Display v0.1.3r1</a>, MD5: ec06db8c27ff8e53e4c1527024b829e8</li> <li><a href="http://ftp1.sourceforge.net/mysql-cocoa/MySQL_Display_0.1.2.tgz">MySQL Display v0.1.2r1</a>, MD5: 42bc3b8210541b166bac51a4d8a08aa7</li> <li><a href="http://ftp1.sourceforge.net/mysql-cocoa/MySQL_Display_0.1.1.tgz">MySQL Display v0.1.1r1</a>, MD5: 159f7032d426d5bc5eb9397402925482</li> </ul> <ul> + <li><a href="http://ftp1.sourceforge.net/mysql-cocoa/SMySQL_test_0.6.0.tgz">SMySQL test application v0.6.0r1</a>, MD5: be4b368887698c2fd461d6df89423094</li> <li><a href="http://ftp1.sourceforge.net/mysql-cocoa/SMySQL_test_0.5.tgz">SMySQL test application v0.5.0r1</a>, MD5: 303fc130b0b6211283c2f3252c8dfd08</li> </ul> |
|
From: Serge C. <ser...@us...> - 2002-05-07 19:16:15
|
Update of /cvsroot/mysql-cocoa/MySQL_Display/MySQL_Display.pbproj
In directory usw-pr-cvs1:/tmp/cvs-serv23160
Modified Files:
cohen.pbxuser
Log Message:
Update for tagging.
Serge Cohen; MySQL Cocoa project, May 7th 2002.
Index: cohen.pbxuser
===================================================================
RCS file: /cvsroot/mysql-cocoa/MySQL_Display/MySQL_Display.pbproj/cohen.pbxuser,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** cohen.pbxuser 7 May 2002 17:26:00 -0000 1.4
--- cohen.pbxuser 7 May 2002 19:16:08 -0000 1.5
***************
*** 16,23 ****
Frame = "{{0, 23}, {948, 489}}";
Split0 = {
- ActiveTab = 1;
Frame = "{{278, 0}, {670, 489}}";
Split0 = {
! Frame = "{{0, 232}, {670, 257}}";
};
SplitCount = 1;
--- 16,22 ----
Frame = "{{0, 23}, {948, 489}}";
Split0 = {
Frame = "{{278, 0}, {670, 489}}";
Split0 = {
! Frame = "{{0, 24}, {670, 465}}";
};
SplitCount = 1;
|
|
From: Serge C. <ser...@us...> - 2002-05-07 19:11:04
|
Update of /cvsroot/mysql-cocoa/SMySQL_test
In directory usw-pr-cvs1:/tmp/cvs-serv21771
Modified Files:
main2.m
Log Message:
Updating before tagging.
Serge Cohen; MySQL Cocoa project, May 7th 2002.
Index: main2.m
===================================================================
RCS file: /cvsroot/mysql-cocoa/SMySQL_test/main2.m,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** main2.m 6 May 2002 10:04:29 -0000 1.4
--- main2.m 7 May 2002 19:10:57 -0000 1.5
***************
*** 56,61 ****
NSLog(@"%@ : %@\n", name, [row objectForKey:name]);
if ([result isBlobAtIndex:i]) {
! const char *theUTF8String = [[row objectForKey:name] bytes];
! NSString *theString = [NSString stringWithUTF8String:theUTF8String];
NSLog(@" as string : %@\n",theString);
}
--- 56,60 ----
NSLog(@"%@ : %@\n", name, [row objectForKey:name]);
if ([result isBlobAtIndex:i]) {
! NSString *theString = [result stringWithCString:[[row objectForKey:name] bytes]];
NSLog(@" as string : %@\n",theString);
}
***************
*** 65,81 ****
// [result release];
! result = [connection queryString:@"select test1_id, test1_key from test1 where id=1"];
NSLog (@"Here is theNSLog of a SMySQLResult %@", result);
result = [connection listFields:nil forTable:@"test1"];
NSLog (@"Here is theNSLog of a SMySQLResult (listFields:nil forTable:test1) %@", result);
result = [connection listDBs:nil];
NSLog (@"Here is the NSLog of a SMySQLResult (listDBs) : \n%@", result);
result = [connection listDBs:@"test\\_%%"];
NSLog (@"Here is the NSLog of a SMySQLResult (listDBs:test\\_%%) : \n%@", result);
result = [connection listTables:nil];
NSLog (@"Here is the NSLog of a SMySQLResult (listTables) : \n%@", result);
--- 64,85 ----
// [result release];
! result = [connection queryString:@"select test1_id, test1_key from test1 where test1_id=1"];
! [result fetchFieldsName];
NSLog (@"Here is theNSLog of a SMySQLResult %@", result);
result = [connection listFields:nil forTable:@"test1"];
+ [result fetchFieldsName];
NSLog (@"Here is theNSLog of a SMySQLResult (listFields:nil forTable:test1) %@", result);
result = [connection listDBs:nil];
+ [result fetchFieldsName];
NSLog (@"Here is the NSLog of a SMySQLResult (listDBs) : \n%@", result);
result = [connection listDBs:@"test\\_%%"];
+ [result fetchFieldsName];
NSLog (@"Here is the NSLog of a SMySQLResult (listDBs:test\\_%%) : \n%@", result);
result = [connection listTables:nil];
+ [result fetchFieldsName];
NSLog (@"Here is the NSLog of a SMySQLResult (listTables) : \n%@", result);
|
|
From: Serge C. <ser...@us...> - 2002-05-07 19:01:57
|
Update of /cvsroot/mysql-cocoa/SMySQL In directory usw-pr-cvs1:/tmp/cvs-serv19250 Modified Files: SMySQLConnection.m Log Message: Test for tag. Serge Cohen; MySQL Cocoa project, May 7th 2002. Index: SMySQLConnection.m =================================================================== RCS file: /cvsroot/mysql-cocoa/SMySQL/SMySQLConnection.m,v retrieving revision 1.7 retrieving revision 1.8 diff -C2 -d -r1.7 -r1.8 *** SMySQLConnection.m 7 May 2002 17:22:21 -0000 1.7 --- SMySQLConnection.m 7 May 2002 19:01:53 -0000 1.8 *************** *** 23,26 **** --- 23,27 ---- // + #import "SMySQLConnection.h" #import "SMySQLResult.h" |
|
From: Serge C. <ser...@us...> - 2002-05-07 18:52:33
|
Update of /cvsroot/mysql-cocoa/SMySQL/SMySQL.pbproj
In directory usw-pr-cvs1:/tmp/cvs-serv16724
Modified Files:
cohen.pbxuser
Log Message:
Unknown changes.
Serge Cohen; MySQL Cocoa project, May 7th 2002.
Index: cohen.pbxuser
===================================================================
RCS file: /cvsroot/mysql-cocoa/SMySQL/SMySQL.pbproj/cohen.pbxuser,v
retrieving revision 1.11
retrieving revision 1.12
diff -C2 -d -r1.11 -r1.12
*** cohen.pbxuser 7 May 2002 17:22:33 -0000 1.11
--- cohen.pbxuser 7 May 2002 18:52:30 -0000 1.12
***************
*** 16,23 ****
Frame = "{{0, 23}, {971, 624}}";
Split0 = {
- ActiveTab = 3;
Frame = "{{252, 0}, {719, 624}}";
Split0 = {
! Frame = "{{0, 319}, {719, 305}}";
};
SplitCount = 1;
--- 16,22 ----
Frame = "{{0, 23}, {971, 624}}";
Split0 = {
Frame = "{{252, 0}, {719, 624}}";
Split0 = {
! Frame = "{{0, 24}, {719, 600}}";
};
SplitCount = 1;
***************
*** 60,64 ****
};
Tab3 = {
! Frame = "{{0, 0}, {719, 295}}";
};
TabCount = 4;
--- 59,63 ----
};
Tab3 = {
! Frame = "{{0, 0}, {747, 295}}";
};
TabCount = 4;
|
|
From: Serge C. <ser...@us...> - 2002-05-07 18:47:18
|
Update of /cvsroot/mysql-cocoa/SMySQL/SMySQL.pbproj
In directory usw-pr-cvs1:/tmp/cvs-serv15226
Modified Files:
project.pbxproj
Log Message:
Change to version 0.6.0.
Serge Cohen; MySQL Cocoa project, May 7th 2002....
Index: project.pbxproj
===================================================================
RCS file: /cvsroot/mysql-cocoa/SMySQL/SMySQL.pbproj/project.pbxproj,v
retrieving revision 1.11
retrieving revision 1.12
diff -C2 -d -r1.11 -r1.12
*** project.pbxproj 7 May 2002 18:44:10 -0000 1.11
--- project.pbxproj 7 May 2002 18:47:14 -0000 1.12
***************
*** 116,120 ****
buildSettings = {
DYLIB_COMPATIBILITY_VERSION = 1.0.0;
! DYLIB_CURRENT_VERSION = 0.5.5;
FRAMEWORK_SEARCH_PATHS = "";
FRAMEWORK_VERSION = A;
--- 116,120 ----
buildSettings = {
DYLIB_COMPATIBILITY_VERSION = 1.0.0;
! DYLIB_CURRENT_VERSION = 0.6.0;
FRAMEWORK_SEARCH_PATHS = "";
FRAMEWORK_VERSION = A;
***************
*** 161,165 ****
<string>????</string>
<key>CFBundleVersion</key>
! <string>0.5.5d1</string>
<key>NSPrincipalClass</key>
<string>SMySQLConnection</string>
--- 161,165 ----
<string>????</string>
<key>CFBundleVersion</key>
! <string>0.6.0d1</string>
<key>NSPrincipalClass</key>
<string>SMySQLConnection</string>
***************
*** 410,414 ****
buildSettings = {
DYLIB_COMPATIBILITY_VERSION = 1.0.0;
! DYLIB_CURRENT_VERSION = 0.5.5;
FRAMEWORK_VERSION = A;
HEADER_SEARCH_PATHS = mysqlclient_source/headers;
--- 410,414 ----
buildSettings = {
DYLIB_COMPATIBILITY_VERSION = 1.0.0;
! DYLIB_CURRENT_VERSION = 0.6.0;
FRAMEWORK_VERSION = A;
HEADER_SEARCH_PATHS = mysqlclient_source/headers;
***************
*** 452,456 ****
<string>????</string>
<key>CFBundleVersion</key>
! <string>0.5.5d1</string>
<key>NSPrincipalClass</key>
<string>SMySQLConnection</string>
--- 452,456 ----
<string>????</string>
<key>CFBundleVersion</key>
! <string>0.6.0d1</string>
<key>NSPrincipalClass</key>
<string>SMySQLConnection</string>
***************
*** 1847,1851 ****
buildSettings = {
DYLIB_COMPATIBILITY_VERSION = 1.0.0;
! DYLIB_CURRENT_VERSION = 0.5.5;
FRAMEWORK_VERSION = A;
LIBRARY_SEARCH_PATHS = /usr/local/lib/mysql;
--- 1847,1851 ----
buildSettings = {
DYLIB_COMPATIBILITY_VERSION = 1.0.0;
! DYLIB_CURRENT_VERSION = 0.6.0;
FRAMEWORK_VERSION = A;
LIBRARY_SEARCH_PATHS = /usr/local/lib/mysql;
***************
*** 1893,1897 ****
<string>????</string>
<key>CFBundleVersion</key>
! <string>0.5.5d1</string>
<key>NSPrincipalClass</key>
<string>SMySQLConnection</string>
--- 1893,1897 ----
<string>????</string>
<key>CFBundleVersion</key>
! <string>0.6.0d1</string>
<key>NSPrincipalClass</key>
<string>SMySQLConnection</string>
|
|
From: Serge C. <ser...@us...> - 2002-05-07 18:44:12
|
Update of /cvsroot/mysql-cocoa/SMySQL/SMySQL.pbproj
In directory usw-pr-cvs1:/tmp/cvs-serv14321
Modified Files:
project.pbxproj
Log Message:
Small changes in the include of the mysql headers, so the headers will be taken from the mysqlclient_source for the fully_embeded target (otherwise bugs when diff version of the lib are used).
Serge Cohen; MySQL Cocoa project, May 7th 2002....
Index: project.pbxproj
===================================================================
RCS file: /cvsroot/mysql-cocoa/SMySQL/SMySQL.pbproj/project.pbxproj,v
retrieving revision 1.10
retrieving revision 1.11
diff -C2 -d -r1.10 -r1.11
*** project.pbxproj 7 May 2002 17:22:32 -0000 1.10
--- project.pbxproj 7 May 2002 18:44:10 -0000 1.11
***************
*** 414,418 ****
HEADER_SEARCH_PATHS = mysqlclient_source/headers;
LIBRARY_SEARCH_PATHS = "";
! OTHER_CFLAGS = "-DDEFAULT_CHARSET_HOME=\\\\\\\"/usr/local\\\\\\\" -DDATADIR=\\\\\\\"/Users/mysql/Data\\\\\\\" -DSHAREDIR=\\\\\\\"/usr/local/share/mysql\\\\\\\" -DUNDEF_THREADS_HACK -DDONT_USE_RAID -DDBUG_OFF -traditional-cpp -DHAVE_DARWIN_THREADS -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -fno-common";
OTHER_LDFLAGS = "-seg1addr 0x08800000 -lz -lc -lm";
PRODUCT_NAME = SMySQL;
--- 414,418 ----
HEADER_SEARCH_PATHS = mysqlclient_source/headers;
LIBRARY_SEARCH_PATHS = "";
! OTHER_CFLAGS = "-DDEFAULT_CHARSET_HOME=\\\\\\\"/usr/local\\\\\\\" -DDATADIR=\\\\\\\"/Users/mysql/Data\\\\\\\" -DSHAREDIR=\\\\\\\"/usr/local/share/mysql\\\\\\\" -DUNDEF_THREADS_HACK -DDONT_USE_RAID -DDBUG_OFF -no-cpp-precomp -DHAVE_DARWIN_THREADS -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -fno-common";
OTHER_LDFLAGS = "-seg1addr 0x08800000 -lz -lc -lm";
PRODUCT_NAME = SMySQL;
***************
*** 463,472 ****
buildActionMask = 2147483647;
files = (
F51A62DE022D7C6201952E7A,
F51A62DF022D7C6201952E7A,
F51A62DD022D7C6201952E7A,
- F5649D70023FD0FB01D04C4B,
- F5649D71023FD0FB01D04C4B,
- F5649D72023FD0FB01D04C4B,
);
isa = PBXHeadersBuildPhase;
--- 463,472 ----
buildActionMask = 2147483647;
files = (
+ F5649D72023FD0FB01D04C4B,
+ F5649D70023FD0FB01D04C4B,
+ F5649D71023FD0FB01D04C4B,
F51A62DE022D7C6201952E7A,
F51A62DF022D7C6201952E7A,
F51A62DD022D7C6201952E7A,
);
isa = PBXHeadersBuildPhase;
***************
*** 639,646 ****
F51B527E01CA905F0130DCEA = {
children = (
F5649D6C023FD0D501D04C4B,
- F51B527F01CA908B0130DCEA,
- F51B528101CA90DE0130DCEA,
- F51B528201CA90DE0130DCEA,
);
isa = PBXGroup;
--- 639,644 ----
F51B527E01CA905F0130DCEA = {
children = (
+ F5C0D59002884F280172C088,
F5649D6C023FD0D501D04C4B,
);
isa = PBXGroup;
***************
*** 797,803 ****
F5649D6C023FD0D501D04C4B = {
children = (
! F5649D6D023FD0FB01D04C4B,
! F5649D6E023FD0FB01D04C4B,
! F5649D6F023FD0FB01D04C4B,
);
isa = PBXGroup;
--- 795,801 ----
F5649D6C023FD0D501D04C4B = {
children = (
! F51B527F01CA908B0130DCEA,
! F51B528101CA90DE0130DCEA,
! F51B528201CA90DE0130DCEA,
);
isa = PBXGroup;
***************
*** 2045,2048 ****
--- 2043,2056 ----
shellPath = /bin/sh;
shellScript = "MKDIRS=\"mkdir -p\"\nAUTODOC=/usr/local/bin/autodoc\nAUTODOC_FLAGS=\"-copydocs -timestamp -allclasses\"\nAUTODOC_FORMAT=html\nAUTODOC_LANGUAGE=English\nexport AD_COPYRIGHT=\"MySQL Cocoa Project\"\n\n# If autodoc is not installed, we quit without any error\ntest -x $AUTODOC || exit 0\n\nPUBLIC_DOC_INSTALLDIR=\"$SYMROOT/$PRODUCT_NAME.framework/Resources/$AUTODOC_LANGUAGE.lproj/Documentation\"\n\n# We need to write down file names here\nAUTODOC_FILES=\"SMySQLConnection.h SMySQLResult.h\"\nAUTODOC_DOCDIR=\"$PUBLIC_DOC_INSTALLDIR\"\n\nOTHER_AUTODOC_FLAGS=\"-typedirs -allclasses -combine -force -nosingles\"\n\nALL_AUTODOC_FLAGS=\"$AUTODOC_FLAGS $OTHER_AUTODOC_FLAGS\"\n\n$MKDIRS $PUBLIC_DOC_INSTALLDIR\n$AUTODOC $ALL_AUTODOC_FLAGS -format $AUTODOC_FORMAT -dest $AUTODOC_DOCDIR $AUTODOC_FILES\n";
+ };
+ F5C0D59002884F280172C088 = {
+ children = (
+ F5649D6D023FD0FB01D04C4B,
+ F5649D6E023FD0FB01D04C4B,
+ F5649D6F023FD0FB01D04C4B,
+ );
+ isa = PBXGroup;
+ name = mysqlclient_source/headers;
+ refType = 4;
};
F5F2A38502648DA50121D426 = {
|
|
From: Serge C. <ser...@us...> - 2002-05-07 18:44:02
|
Update of /cvsroot/mysql-cocoa/SMySQL In directory usw-pr-cvs1:/tmp/cvs-serv14258 Modified Files: SMySQL.h SMySQLConnection.h SMySQLResult.h Log Message: Small changes in the include of the mysql headers, so the headers will be taken from the mysqlclient_source for the fully_embeded target (otherwise bugs when diff version of the lib are used). Serge Cohen; MySQL Cocoa project, May 7th 2002. Index: SMySQL.h =================================================================== RCS file: /cvsroot/mysql-cocoa/SMySQL/SMySQL.h,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** SMySQL.h 1 Jan 2002 17:16:29 -0000 1.1.1.1 --- SMySQL.h 7 May 2002 18:43:58 -0000 1.2 *************** *** 27,29 **** #import <SMySQL/SMySQLResult.h> #import <SMySQL/SMySQLConnection.h> ! #import <SMySQL/mysql.h> --- 27,30 ---- #import <SMySQL/SMySQLResult.h> #import <SMySQL/SMySQLConnection.h> ! #import "mysql.h" ! //#import <SMySQL/mysql.h> Index: SMySQLConnection.h =================================================================== RCS file: /cvsroot/mysql-cocoa/SMySQL/SMySQLConnection.h,v retrieving revision 1.7 retrieving revision 1.8 diff -C2 -d -r1.7 -r1.8 *** SMySQLConnection.h 7 May 2002 17:22:21 -0000 1.7 --- SMySQLConnection.h 7 May 2002 18:43:58 -0000 1.8 *************** *** 24,28 **** #import <Foundation/Foundation.h> ! #import <SMySQL/mysql.h> //#import <SMySQL/SMySQL.h> --- 24,29 ---- #import <Foundation/Foundation.h> ! #import "mysql.h" ! //#import <SMySQL/mysql.h> //#import <SMySQL/SMySQL.h> Index: SMySQLResult.h =================================================================== RCS file: /cvsroot/mysql-cocoa/SMySQL/SMySQLResult.h,v retrieving revision 1.4 retrieving revision 1.5 diff -C2 -d -r1.4 -r1.5 *** SMySQLResult.h 6 May 2002 09:58:27 -0000 1.4 --- SMySQLResult.h 7 May 2002 18:43:58 -0000 1.5 *************** *** 24,28 **** #import <Foundation/Foundation.h> ! #import <SMySQL/mysql.h> //#import <SMySQL/SMySQL.h> --- 24,29 ---- #import <Foundation/Foundation.h> ! #import "mysql.h" ! //#import <SMySQL/mysql.h> //#import <SMySQL/SMySQL.h> |
|
From: Serge C. <ser...@us...> - 2002-05-07 18:41:43
|
Update of /cvsroot/mysql-cocoa/MySQL_Display/MySQL_Display.pbproj
In directory usw-pr-cvs1:/tmp/cvs-serv13606
Modified Files:
project.pbxproj
Log Message:
Smalls modifications, in the NSLogs.
Serge Cohen; MySQL Cocoa project, May 7th 2002....
Index: project.pbxproj
===================================================================
RCS file: /cvsroot/mysql-cocoa/MySQL_Display/MySQL_Display.pbproj/project.pbxproj,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** project.pbxproj 28 Feb 2002 10:25:38 -0000 1.3
--- project.pbxproj 7 May 2002 18:41:40 -0000 1.4
***************
*** 52,56 ****
children = (
1058C7A7FEA54F5311CA2CBB,
! F51A62EA022D7F7101952E7A,
);
isa = PBXGroup;
--- 52,56 ----
children = (
1058C7A7FEA54F5311CA2CBB,
! F558A006028855FB014B1BFB,
);
isa = PBXGroup;
***************
*** 364,368 ****
files = (
1058C7A9FEA54F5311CA2CBB,
! F51A62EC022D7F7101952E7A,
);
isa = PBXFrameworksBuildPhase;
--- 364,368 ----
files = (
1058C7A9FEA54F5311CA2CBB,
! F558A008028855FB014B1BFB,
);
isa = PBXFrameworksBuildPhase;
***************
*** 424,450 ****
dstSubfolderSpec = 10;
files = (
! F51A62EB022D7F7101952E7A,
);
isa = PBXCopyFilesBuildPhase;
name = "Copy Files";
};
- F51A62EA022D7F7101952E7A = {
- isa = PBXFrameworkReference;
- name = SMySQL.framework;
- path = ../SMySQL/build/SMySQL.framework;
- refType = 2;
- };
- F51A62EB022D7F7101952E7A = {
- fileRef = F51A62EA022D7F7101952E7A;
- isa = PBXBuildFile;
- settings = {
- };
- };
- F51A62EC022D7F7101952E7A = {
- fileRef = F51A62EA022D7F7101952E7A;
- isa = PBXBuildFile;
- settings = {
- };
- };
F51F10DC01F4380F017AAB60 = {
isa = PBXFileReference;
--- 424,432 ----
dstSubfolderSpec = 10;
files = (
! F558A007028855FB014B1BFB,
);
isa = PBXCopyFilesBuildPhase;
name = "Copy Files";
};
F51F10DC01F4380F017AAB60 = {
isa = PBXFileReference;
***************
*** 529,532 ****
--- 511,532 ----
F51F10F101F4FAF8017AAB60 = {
fileRef = F51F10EF01F4FAF8017AAB60;
+ isa = PBXBuildFile;
+ settings = {
+ };
+ };
+ F558A006028855FB014B1BFB = {
+ isa = PBXFrameworkReference;
+ name = SMySQL.framework;
+ path = ../SMySQL/build/SMySQL.framework;
+ refType = 2;
+ };
+ F558A007028855FB014B1BFB = {
+ fileRef = F558A006028855FB014B1BFB;
+ isa = PBXBuildFile;
+ settings = {
+ };
+ };
+ F558A008028855FB014B1BFB = {
+ fileRef = F558A006028855FB014B1BFB;
isa = PBXBuildFile;
settings = {
|
|
From: Serge C. <ser...@us...> - 2002-05-07 18:41:35
|
Update of /cvsroot/mysql-cocoa/MySQL_Display
In directory usw-pr-cvs1:/tmp/cvs-serv13566
Modified Files:
SMySQLDatabaseDoc.m
Log Message:
Smalls modifications, in the NSLogs.
Serge Cohen; MySQL Cocoa project, May 7th 2002.
Index: SMySQLDatabaseDoc.m
===================================================================
RCS file: /cvsroot/mysql-cocoa/MySQL_Display/SMySQLDatabaseDoc.m,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** SMySQLDatabaseDoc.m 7 May 2002 17:25:52 -0000 1.3
--- SMySQLDatabaseDoc.m 7 May 2002 18:41:31 -0000 1.4
***************
*** 199,203 ****
"*/
{
- NSLog (@"in resetConnection : protocol version : %d, server version : %s\n", (int)PROTOCOL_VERSION, MYSQL_SERVER_VERSION);
if ((mHost == nil) || (mLogin == nil) || (mDatabase == nil)) {
// Here we should throw an exception, impossible to connect (or reconnect) to unknown host, login or DB
--- 199,202 ----
***************
*** 212,216 ****
[mConnection selectDB:mDatabase];
}
! NSLog (@"Now the same info from the Library (no #defines) :\n protocol %@, server version %@, client version %@, host info %@", [mConnection protoInfo], [mConnection serverInfo], [mConnection clientInfo], [mConnection hostInfo]);
return;
}
--- 211,215 ----
[mConnection selectDB:mDatabase];
}
! NSLog (@"Some info from the Library :\n protocol %@, server version %@, client version %@, host info %@", [mConnection protoInfo], [mConnection serverInfo], [mConnection clientInfo], [mConnection hostInfo]);
return;
}
|
|
From: Serge C. <ser...@us...> - 2002-05-07 17:26:03
|
Update of /cvsroot/mysql-cocoa/MySQL_Display/MySQL_Display.pbproj
In directory usw-pr-cvs1:/tmp/cvs-serv15632
Modified Files:
cohen.pbxuser
Log Message:
Take care of the update of the DB. Still should bug if the columns (name or number) changed from last doQuery.
Abnormal behaviour when linked with the fully_embeded version of the SMySQL framework. Maybe a problem of version of the includes...
Serge Cohen; MySQL Cocoa project, May 7th 2002....
Index: cohen.pbxuser
===================================================================
RCS file: /cvsroot/mysql-cocoa/MySQL_Display/MySQL_Display.pbproj/cohen.pbxuser,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** cohen.pbxuser 28 Feb 2002 10:25:38 -0000 1.3
--- cohen.pbxuser 7 May 2002 17:26:00 -0000 1.4
***************
*** 13,23 ****
ContentSize = "{948, 512}";
LeftSlideOut = {
! ActiveTab = 3;
Frame = "{{0, 23}, {948, 489}}";
Split0 = {
ActiveTab = 1;
! Frame = "{{224, 0}, {724, 489}}";
Split0 = {
! Frame = "{{0, 232}, {724, 257}}";
};
SplitCount = 1;
--- 13,23 ----
ContentSize = "{948, 512}";
LeftSlideOut = {
! ActiveTab = 0;
Frame = "{{0, 23}, {948, 489}}";
Split0 = {
ActiveTab = 1;
! Frame = "{{278, 0}, {670, 489}}";
Split0 = {
! Frame = "{{0, 232}, {670, 257}}";
};
SplitCount = 1;
***************
*** 48,64 ****
};
Tab1 = {
! Frame = "{{0, 0}, {724, 208}}";
LauncherConfigVersion = 3;
Runner = {
! Frame = "{{0, 0}, {724, 208}}";
};
};
Tab2 = {
! BuildMessageFrame = "{{0, 0}, {726, 93}}";
! BuildTranscriptFrame = "{{0, 102}, {726, 92}}";
! Frame = "{{0, 0}, {724, 192}}";
};
Tab3 = {
! Frame = "{{0, 0}, {740, 182}}";
};
TabCount = 4;
--- 48,64 ----
};
Tab1 = {
! Frame = "{{0, 0}, {670, 208}}";
LauncherConfigVersion = 3;
Runner = {
! Frame = "{{0, 0}, {670, 208}}";
};
};
Tab2 = {
! BuildMessageFrame = "{{0, 0}, {672, 93}}";
! BuildTranscriptFrame = "{{0, 102}, {672, 92}}";
! Frame = "{{0, 0}, {670, 192}}";
};
Tab3 = {
! Frame = "{{0, 0}, {670, 182}}";
};
TabCount = 4;
|
|
From: Serge C. <ser...@us...> - 2002-05-07 17:25:55
|
Update of /cvsroot/mysql-cocoa/MySQL_Display
In directory usw-pr-cvs1:/tmp/cvs-serv15497
Modified Files:
SMySQLResultView.m SMySQLDatabaseDoc.m
Log Message:
Take care of the update of the DB. Still should bug if the columns (name or number) changed from last doQuery.
Abnormal behaviour when linked with the fully_embeded version of the SMySQL framework. Maybe a problem of version of the includes...
Serge Cohen; MySQL Cocoa project, May 7th 2002.
Index: SMySQLResultView.m
===================================================================
RCS file: /cvsroot/mysql-cocoa/MySQL_Display/SMySQLResultView.m,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** SMySQLResultView.m 22 Jan 2002 20:44:37 -0000 1.2
--- SMySQLResultView.m 7 May 2002 17:25:52 -0000 1.3
***************
*** 43,51 ****
"*/
{
if (mResult) {
- // [mResult autorelease];
[mResult release];
}
! NSLog(@" In SMySQLResultView load result, retain : %@\n", mResult);
[mTableView reloadData];
return;
--- 43,57 ----
"*/
{
+ SMySQLResult * theResult = [[[[mTableView window] windowController] document] queryString:mQuery];
+
+ // NSLog(@" In SMySQLResultView load result, retain : %@\n", theResult);
+ if (theResult == nil) {
+ NSBeginAlertSheet(@"Error", @"OK", nil, nil, [mTableView window], self, nil, nil, self, @"Empty result (nil object). There might be an error in the query!");
+ return;
+ }
if (mResult) {
[mResult release];
}
! mResult = [theResult retain];
[mTableView reloadData];
return;
Index: SMySQLDatabaseDoc.m
===================================================================
RCS file: /cvsroot/mysql-cocoa/MySQL_Display/SMySQLDatabaseDoc.m,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** SMySQLDatabaseDoc.m 22 Jan 2002 20:44:37 -0000 1.2
--- SMySQLDatabaseDoc.m 7 May 2002 17:25:52 -0000 1.3
***************
*** 199,202 ****
--- 199,203 ----
"*/
{
+ NSLog (@"in resetConnection : protocol version : %d, server version : %s\n", (int)PROTOCOL_VERSION, MYSQL_SERVER_VERSION);
if ((mHost == nil) || (mLogin == nil) || (mDatabase == nil)) {
// Here we should throw an exception, impossible to connect (or reconnect) to unknown host, login or DB
***************
*** 211,214 ****
--- 212,216 ----
[mConnection selectDB:mDatabase];
}
+ NSLog (@"Now the same info from the Library (no #defines) :\n protocol %@, server version %@, client version %@, host info %@", [mConnection protoInfo], [mConnection serverInfo], [mConnection clientInfo], [mConnection hostInfo]);
return;
}
|
