SF.net SVN: frontierkernel: [1706] ODBs/trunk/frontierRoot/system/verbs/ builtins/mySql

[<cre...@us...>]

Revision: 1706
          http://frontierkernel.svn.sourceforge.net/frontierkernel/?rev=1706&view=rev
Author:   creecode
Date:     2007-07-01 20:47:04 -0700 (Sun, 01 Jul 2007)

Log Message:
-----------
mySql verbs

Added Paths:
-----------
    ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/clearQuery.fvc
    ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/close.fvc
    ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/compileQuery.fvc
    ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/connect.fvc
    ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/easyQuery.fvc
    ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/end.fvc
    ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/escapeString.fvc
    ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getAffectedRowCount.fvc
    ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getClientInfo.fvc
    ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getClientVersion.fvc
    ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getColumnCount.fvc
    ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getDatabaseNames.fvc
    ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getErrorMessage.fvc
    ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getErrorNumber.fvc
    ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getFieldNames.fvc
    ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getHostInfo.fvc
    ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getProtocolInfo.fvc
    ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getQueryInfo.fvc
    ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getQueryWarningCount.fvc
    ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getRow.fvc
    ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getSQLSTATE.fvc
    ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getSelectedRowCount.fvc
    ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getServerInfo.fvc
    ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getServerStatus.fvc
    ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getServerVersion.fvc
    ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getTableNames.fvc
    ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/init.fvc
    ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/isThreadSafe.fvc
    ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/pingServer.fvc
    ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/seekRow.fvc
    ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/selectDatabase.fvc

Added: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/clearQuery.fvc
===================================================================
--- ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/clearQuery.fvc	                        (rev 0)
+++ ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/clearQuery.fvc	2007-07-02 03:47:04 UTC (rev 1706)
@@ -0,0 +1,11 @@
+FrontierVcsFile:3:scpt:system.verbs.builtins.mySql.clearQuery
+
+on clearQuery ( queryId ) {
+	
+	«Changes
+		«5/29/07; 12:00:00 AM by DG
+			«created
+	
+	kernel ( mysql.clearQuery )}
+
+


Property changes on: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/clearQuery.fvc
___________________________________________________________________
Name: svn:eol-style
   + native

Added: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/close.fvc
===================================================================
--- ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/close.fvc	                        (rev 0)
+++ ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/close.fvc	2007-07-02 03:47:04 UTC (rev 1706)
@@ -0,0 +1,11 @@
+FrontierVcsFile:3:scpt:system.verbs.builtins.mySql.close
+
+on close ( databaseId ) {
+	
+	«Changes
+		«5/29/07; 12:00:00 AM by DG
+			«created
+	
+	kernel ( mysql.close )}
+
+


Property changes on: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/close.fvc
___________________________________________________________________
Name: svn:eol-style
   + native

Added: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/compileQuery.fvc
===================================================================
--- ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/compileQuery.fvc	                        (rev 0)
+++ ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/compileQuery.fvc	2007-07-02 03:47:04 UTC (rev 1706)
@@ -0,0 +1,11 @@
+FrontierVcsFile:3:scpt:system.verbs.builtins.mySql.compileQuery
+
+on compileQuery ( databaseId ) {
+	
+	«Changes
+		«5/29/07; 12:00:00 AM by DG
+			«created
+	
+	kernel ( mysql.compileQuery )}
+
+


Property changes on: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/compileQuery.fvc
___________________________________________________________________
Name: svn:eol-style
   + native

Added: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/connect.fvc
===================================================================
--- ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/connect.fvc	                        (rev 0)
+++ ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/connect.fvc	2007-07-02 03:47:04 UTC (rev 1706)
@@ -0,0 +1,11 @@
+FrontierVcsFile:3:scpt:system.verbs.builtins.mySql.connect
+
+on connect ( host, user, password, databaseName, port ) {
+	
+	«Changes
+		«5/29/07; 12:00:00 AM by DG
+			«created
+	
+	kernel ( mysql.connect )}
+
+


Property changes on: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/connect.fvc
___________________________________________________________________
Name: svn:eol-style
   + native

Added: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/easyQuery.fvc
===================================================================
--- ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/easyQuery.fvc	                        (rev 0)
+++ ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/easyQuery.fvc	2007-07-02 03:47:04 UTC (rev 1706)
@@ -0,0 +1,47 @@
+FrontierVcsFile:3:scpt:system.verbs.builtins.mySql.easyQuery
+
+on easyQuery ( databaseId, queryString, maxRows = 0 ) {
+	
+	«Changes
+		«6/2/07; 12:00:00 AM by DG
+			«only get rows if compiledQuery is greater than zero
+		«5/29/07; 12:00:00 AM by DG
+			«created
+	
+	local ( compiledQuery, dataSet = { }, row, rowCount = 0 );
+	
+	on isNum ( s ) {
+		local ( ch, i );
+		
+		for i = 1 to string.length ( s ) {
+			ch = string.mid ( s, i, 1 );
+			
+			if ( ch < '0' ) or ( ch > '9' ) {
+				return ( false )}};
+		
+		return ( true )};
+	
+	if not ( isNum ( maxRows ) ) {
+		scriptError ( "mysql.easyQuery requires a numeric value for maxRows." )};
+	
+	compiledQuery = mysql.compileQuery ( databaseId, queryString ); // this will scriptError on its own if it fails
+	
+	if compiledQuery > 0 {
+		loop {
+			result = mysql.getRow ( compiledQuery );
+			
+			if result == 0 { // MySQL's code for no more rows
+				break};
+			
+			++rowCount;
+			
+			if ( maxRows > 0 ) and ( rowCount > maxRows ) {
+				break};
+			
+			dataSet [ rowCount ] = result};
+		
+		mysql.clearQuery ( compiledQuery )};
+	
+	return ( dataSet )}
+
+


Property changes on: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/easyQuery.fvc
___________________________________________________________________
Name: svn:eol-style
   + native

Added: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/end.fvc
===================================================================
--- ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/end.fvc	                        (rev 0)
+++ ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/end.fvc	2007-07-02 03:47:04 UTC (rev 1706)
@@ -0,0 +1,11 @@
+FrontierVcsFile:3:scpt:system.verbs.builtins.mySql.end
+
+on end ( ) {
+	
+	«Changes
+		«5/29/07; 12:00:00 AM by DG
+			«created
+	
+	kernel ( mysql.end )}
+
+


Property changes on: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/end.fvc
___________________________________________________________________
Name: svn:eol-style
   + native

Added: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/escapeString.fvc
===================================================================
--- ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/escapeString.fvc	                        (rev 0)
+++ ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/escapeString.fvc	2007-07-02 03:47:04 UTC (rev 1706)
@@ -0,0 +1,11 @@
+FrontierVcsFile:3:scpt:system.verbs.builtins.mySql.escapeString
+
+on escapeString ( databaseId, s ) {
+	
+	«Changes
+		«5/29/07; 12:00:00 AM by DG
+			«created
+	
+	kernel ( mysql.escapeString )}
+
+


Property changes on: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/escapeString.fvc
___________________________________________________________________
Name: svn:eol-style
   + native

Added: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getAffectedRowCount.fvc
===================================================================
--- ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getAffectedRowCount.fvc	                        (rev 0)
+++ ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getAffectedRowCount.fvc	2007-07-02 03:47:04 UTC (rev 1706)
@@ -0,0 +1,11 @@
+FrontierVcsFile:3:scpt:system.verbs.builtins.mySql.getAffectedRowCount
+
+on getAffectedRowCount ( databaseId ) {
+	
+	«Changes
+		«5/29/07; 12:00:00 AM by DG
+			«created
+	
+	kernel ( mysql.getAffectedRowCount )}
+
+


Property changes on: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getAffectedRowCount.fvc
___________________________________________________________________
Name: svn:eol-style
   + native

Added: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getClientInfo.fvc
===================================================================
--- ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getClientInfo.fvc	                        (rev 0)
+++ ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getClientInfo.fvc	2007-07-02 03:47:04 UTC (rev 1706)
@@ -0,0 +1,11 @@
+FrontierVcsFile:3:scpt:system.verbs.builtins.mySql.getClientInfo
+
+on getClientInfo ( ) {
+	
+	«Changes
+		«5/29/07; 12:00:00 AM by DG
+			«created
+	
+	kernel ( mysql.getClientInfo )}
+
+


Property changes on: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getClientInfo.fvc
___________________________________________________________________
Name: svn:eol-style
   + native

Added: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getClientVersion.fvc
===================================================================
--- ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getClientVersion.fvc	                        (rev 0)
+++ ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getClientVersion.fvc	2007-07-02 03:47:04 UTC (rev 1706)
@@ -0,0 +1,11 @@
+FrontierVcsFile:3:scpt:system.verbs.builtins.mySql.getClientVersion
+
+on getClientVersion ( ) {
+	
+	«Changes
+		«5/29/07; 12:00:00 AM by DG
+			«created
+	
+	kernel ( mysql.getClientVersion )}
+
+


Property changes on: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getClientVersion.fvc
___________________________________________________________________
Name: svn:eol-style
   + native

Added: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getColumnCount.fvc
===================================================================
--- ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getColumnCount.fvc	                        (rev 0)
+++ ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getColumnCount.fvc	2007-07-02 03:47:04 UTC (rev 1706)
@@ -0,0 +1,11 @@
+FrontierVcsFile:3:scpt:system.verbs.builtins.mySql.getColumnCount
+
+on getColumnCount ( databaseId ) {
+	
+	«Changes
+		«5/29/07; 12:00:00 AM by DG
+			«created
+	
+	kernel ( mysql.getColumnCount )}
+
+


Property changes on: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getColumnCount.fvc
___________________________________________________________________
Name: svn:eol-style
   + native

Added: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getDatabaseNames.fvc
===================================================================
--- ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getDatabaseNames.fvc	                        (rev 0)
+++ ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getDatabaseNames.fvc	2007-07-02 03:47:04 UTC (rev 1706)
@@ -0,0 +1,27 @@
+FrontierVcsFile:3:scpt:system.verbs.builtins.mySql.getDatabaseNames
+
+on getDatabaseNames ( databaseId ) {
+	
+	«Changes
+		«5/29/07; 12:00:00 AM by DG
+			«created
+	
+	local ( compiledQuery, dataSet = { }, query = "SHOW databases", result, rowCount = 1, rowList );
+	
+	compiledQuery = mysql.compileQuery ( databaseId, query );
+	
+	loop {
+		result = mysql.getRow ( compiledQuery );
+		
+		if result == 0 {
+			break};
+		
+		dataSet [ rowCount ] = string.trimWhiteSpace ( result [ 1 ] );
+		
+		++rowCount};
+	
+	mysql.clearQuery ( compiledQuery );
+	
+	return ( dataSet )}
+
+


Property changes on: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getDatabaseNames.fvc
___________________________________________________________________
Name: svn:eol-style
   + native

Added: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getErrorMessage.fvc
===================================================================
--- ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getErrorMessage.fvc	                        (rev 0)
+++ ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getErrorMessage.fvc	2007-07-02 03:47:04 UTC (rev 1706)
@@ -0,0 +1,11 @@
+FrontierVcsFile:3:scpt:system.verbs.builtins.mySql.getErrorMessage
+
+on getErrorMessage ( databaseId ) {
+	
+	«Changes
+		«5/29/07; 12:00:00 AM by DG
+			«created
+	
+	kernel ( mysql.getErrorMessage )}
+
+


Property changes on: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getErrorMessage.fvc
___________________________________________________________________
Name: svn:eol-style
   + native

Added: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getErrorNumber.fvc
===================================================================
--- ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getErrorNumber.fvc	                        (rev 0)
+++ ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getErrorNumber.fvc	2007-07-02 03:47:04 UTC (rev 1706)
@@ -0,0 +1,11 @@
+FrontierVcsFile:3:scpt:system.verbs.builtins.mySql.getErrorNumber
+
+on getErrorNumber ( databaseId ) {
+	
+	«Changes
+		«5/29/07; 12:00:00 AM by DG
+			«created
+	
+	kernel ( mysql.getErrorNumber )}
+
+


Property changes on: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getErrorNumber.fvc
___________________________________________________________________
Name: svn:eol-style
   + native

Added: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getFieldNames.fvc
===================================================================
--- ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getFieldNames.fvc	                        (rev 0)
+++ ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getFieldNames.fvc	2007-07-02 03:47:04 UTC (rev 1706)
@@ -0,0 +1,27 @@
+FrontierVcsFile:3:scpt:system.verbs.builtins.mySql.getFieldNames
+
+on getFieldNames ( databaseId, tableName ) {
+	
+	«Changes
+		«5/29/07; 12:00:00 AM by DG
+			«created
+	
+	local ( compiledQuery, dataSet = { }, query = "SHOW COLUMNS FROM " + tableName, result, rowCount = 1, rowList );
+	
+	compiledQuery = mysql.compileQuery ( databaseId, query );
+	
+	loop {
+		result = mysql.getRow ( compiledQuery );
+		
+		if result == 0 {
+			break};
+		
+		dataSet [ rowCount ] = string.trimWhiteSpace ( result [ 1 ] );
+		
+		++rowCount};
+	
+	mysql.clearQuery ( compiledQuery );
+	
+	return ( dataSet )}
+
+


Property changes on: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getFieldNames.fvc
___________________________________________________________________
Name: svn:eol-style
   + native

Added: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getHostInfo.fvc
===================================================================
--- ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getHostInfo.fvc	                        (rev 0)
+++ ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getHostInfo.fvc	2007-07-02 03:47:04 UTC (rev 1706)
@@ -0,0 +1,11 @@
+FrontierVcsFile:3:scpt:system.verbs.builtins.mySql.getHostInfo
+
+on getHostInfo ( databaseId ) {
+	
+	«Changes
+		«5/29/07; 12:00:00 AM by DG
+			«created
+	
+	kernel ( mysql.getHostInfo )}
+
+


Property changes on: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getHostInfo.fvc
___________________________________________________________________
Name: svn:eol-style
   + native

Added: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getProtocolInfo.fvc
===================================================================
--- ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getProtocolInfo.fvc	                        (rev 0)
+++ ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getProtocolInfo.fvc	2007-07-02 03:47:04 UTC (rev 1706)
@@ -0,0 +1,11 @@
+FrontierVcsFile:3:scpt:system.verbs.builtins.mySql.getProtocolInfo
+
+on getProtocolInfo ( databaseId ) {
+	
+	«Changes
+		«5/29/07; 12:00:00 AM by DG
+			«created
+	
+	kernel ( mysql.getProtocolInfo )}
+
+


Property changes on: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getProtocolInfo.fvc
___________________________________________________________________
Name: svn:eol-style
   + native

Added: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getQueryInfo.fvc
===================================================================
--- ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getQueryInfo.fvc	                        (rev 0)
+++ ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getQueryInfo.fvc	2007-07-02 03:47:04 UTC (rev 1706)
@@ -0,0 +1,11 @@
+FrontierVcsFile:3:scpt:system.verbs.builtins.mySql.getQueryInfo
+
+on getQueryInfo ( databaseId ) {
+	
+	«Changes
+		«5/29/07; 12:00:00 AM by DG
+			«created
+	
+	kernel ( mysql.getQueryInfo )}
+
+


Property changes on: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getQueryInfo.fvc
___________________________________________________________________
Name: svn:eol-style
   + native

Added: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getQueryWarningCount.fvc
===================================================================
--- ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getQueryWarningCount.fvc	                        (rev 0)
+++ ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getQueryWarningCount.fvc	2007-07-02 03:47:04 UTC (rev 1706)
@@ -0,0 +1,11 @@
+FrontierVcsFile:3:scpt:system.verbs.builtins.mySql.getQueryWarningCount
+
+on getQueryWarningCount ( databaseId ) {
+	
+	«Changes
+		«5/29/07; 12:00:00 AM by DG
+			«created
+	
+	kernel ( mysql.getQueryWarningCount )}
+
+


Property changes on: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getQueryWarningCount.fvc
___________________________________________________________________
Name: svn:eol-style
   + native

Added: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getRow.fvc
===================================================================
--- ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getRow.fvc	                        (rev 0)
+++ ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getRow.fvc	2007-07-02 03:47:04 UTC (rev 1706)
@@ -0,0 +1,11 @@
+FrontierVcsFile:3:scpt:system.verbs.builtins.mySql.getRow
+
+on getRow ( queryId ) {
+	
+	«Changes
+		«5/29/07; 12:00:00 AM by DG
+			«created
+	
+	kernel ( mysql.getRow )}
+
+


Property changes on: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getRow.fvc
___________________________________________________________________
Name: svn:eol-style
   + native

Added: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getSQLSTATE.fvc
===================================================================
--- ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getSQLSTATE.fvc	                        (rev 0)
+++ ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getSQLSTATE.fvc	2007-07-02 03:47:04 UTC (rev 1706)
@@ -0,0 +1,11 @@
+FrontierVcsFile:3:scpt:system.verbs.builtins.mySql.getSQLSTATE
+
+on getSQLSTATE ( databaseId ) {
+	
+	«Changes
+		«5/29/07; 12:00:00 AM by DG
+			«created
+	
+	kernel ( mysql.getSQLSTATE )}
+
+


Property changes on: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getSQLSTATE.fvc
___________________________________________________________________
Name: svn:eol-style
   + native

Added: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getSelectedRowCount.fvc
===================================================================
--- ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getSelectedRowCount.fvc	                        (rev 0)
+++ ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getSelectedRowCount.fvc	2007-07-02 03:47:04 UTC (rev 1706)
@@ -0,0 +1,11 @@
+FrontierVcsFile:3:scpt:system.verbs.builtins.mySql.getSelectedRowCount
+
+on getSelectedRowCount ( queryId ) {
+	
+	«Changes
+		«5/29/07; 12:00:00 AM by DG
+			«created
+	
+	kernel ( mysql.getSelectedRowCount )}
+
+


Property changes on: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getSelectedRowCount.fvc
___________________________________________________________________
Name: svn:eol-style
   + native

Added: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getServerInfo.fvc
===================================================================
--- ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getServerInfo.fvc	                        (rev 0)
+++ ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getServerInfo.fvc	2007-07-02 03:47:04 UTC (rev 1706)
@@ -0,0 +1,11 @@
+FrontierVcsFile:3:scpt:system.verbs.builtins.mySql.getServerInfo
+
+on getServerInfo ( databaseId ) {
+	
+	«Changes
+		«5/29/07; 12:00:00 AM by DG
+			«created
+	
+	kernel ( mysql.getServerInfo )}
+
+


Property changes on: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getServerInfo.fvc
___________________________________________________________________
Name: svn:eol-style
   + native

Added: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getServerStatus.fvc
===================================================================
--- ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getServerStatus.fvc	                        (rev 0)
+++ ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getServerStatus.fvc	2007-07-02 03:47:04 UTC (rev 1706)
@@ -0,0 +1,11 @@
+FrontierVcsFile:3:scpt:system.verbs.builtins.mySql.getServerStatus
+
+on getServerStatus ( databaseId ) {
+	
+	«Changes
+		«5/29/07; 12:00:00 AM by DG
+			«created
+	
+	kernel ( mysql.getServerStatus )}
+
+


Property changes on: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getServerStatus.fvc
___________________________________________________________________
Name: svn:eol-style
   + native

Added: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getServerVersion.fvc
===================================================================
--- ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getServerVersion.fvc	                        (rev 0)
+++ ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getServerVersion.fvc	2007-07-02 03:47:04 UTC (rev 1706)
@@ -0,0 +1,11 @@
+FrontierVcsFile:3:scpt:system.verbs.builtins.mySql.getServerVersion
+
+on getServerVersion ( databaseId ) {
+	
+	«Changes
+		«5/29/07; 12:00:00 AM by DG
+			«created
+	
+	kernel ( mysql.getServerVersion )}
+
+


Property changes on: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getServerVersion.fvc
___________________________________________________________________
Name: svn:eol-style
   + native

Added: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getTableNames.fvc
===================================================================
--- ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getTableNames.fvc	                        (rev 0)
+++ ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getTableNames.fvc	2007-07-02 03:47:04 UTC (rev 1706)
@@ -0,0 +1,27 @@
+FrontierVcsFile:3:scpt:system.verbs.builtins.mySql.getTableNames
+
+on getTableNames ( databaseId ) {
+	
+	«Changes
+		«5/29/07; 12:00:00 AM by DG
+			«created
+	
+	local ( compiledQuery, dataSet = { }, query = "SHOW tables", result, rowCount = 1, rowList );
+	
+	compiledQuery = mysql.compileQuery ( databaseId, query );
+	
+	loop {
+		result = mysql.getRow ( compiledQuery );
+		
+		if result == 0 {
+			break};
+		
+		dataSet [ rowCount ] = string.trimWhiteSpace ( result [ 1 ] );
+		
+		++rowCount};
+	
+	mysql.clearQuery ( compiledQuery );
+	
+	return ( dataSet )}
+
+


Property changes on: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/getTableNames.fvc
___________________________________________________________________
Name: svn:eol-style
   + native

Added: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/init.fvc
===================================================================
--- ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/init.fvc	                        (rev 0)
+++ ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/init.fvc	2007-07-02 03:47:04 UTC (rev 1706)
@@ -0,0 +1,11 @@
+FrontierVcsFile:3:scpt:system.verbs.builtins.mySql.init
+
+on init ( ) {
+	
+	«Changes
+		«5/29/07; 12:00:00 AM by DG
+			«created
+	
+	kernel ( mysql.init )}
+
+


Property changes on: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/init.fvc
___________________________________________________________________
Name: svn:eol-style
   + native

Added: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/isThreadSafe.fvc
===================================================================
--- ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/isThreadSafe.fvc	                        (rev 0)
+++ ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/isThreadSafe.fvc	2007-07-02 03:47:04 UTC (rev 1706)
@@ -0,0 +1,11 @@
+FrontierVcsFile:3:scpt:system.verbs.builtins.mySql.isThreadSafe
+
+on isThreadSafe ( ) {
+	
+	«Changes
+		«5/29/07; 12:00:00 AM by DG
+			«created
+	
+	kernel ( mysql.isThreadSafe )}
+
+


Property changes on: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/isThreadSafe.fvc
___________________________________________________________________
Name: svn:eol-style
   + native

Added: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/pingServer.fvc
===================================================================
--- ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/pingServer.fvc	                        (rev 0)
+++ ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/pingServer.fvc	2007-07-02 03:47:04 UTC (rev 1706)
@@ -0,0 +1,11 @@
+FrontierVcsFile:3:scpt:system.verbs.builtins.mySql.pingServer
+
+on pingServer ( databaseId ) {
+	
+	«Changes
+		«5/29/07; 12:00:00 AM by DG
+			«created
+	
+	kernel ( mysql.pingServer )}
+
+


Property changes on: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/pingServer.fvc
___________________________________________________________________
Name: svn:eol-style
   + native

Added: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/seekRow.fvc
===================================================================
--- ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/seekRow.fvc	                        (rev 0)
+++ ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/seekRow.fvc	2007-07-02 03:47:04 UTC (rev 1706)
@@ -0,0 +1,11 @@
+FrontierVcsFile:3:scpt:system.verbs.builtins.mySql.seekRow
+
+on seekRow ( queryId, row ) {
+	
+	«Changes
+		«5/29/07; 12:00:00 AM by DG
+			«created
+	
+	kernel ( mysql.seekRow )}
+
+


Property changes on: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/seekRow.fvc
___________________________________________________________________
Name: svn:eol-style
   + native

Added: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/selectDatabase.fvc
===================================================================
--- ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/selectDatabase.fvc	                        (rev 0)
+++ ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/selectDatabase.fvc	2007-07-02 03:47:04 UTC (rev 1706)
@@ -0,0 +1,11 @@
+FrontierVcsFile:3:scpt:system.verbs.builtins.mySql.selectDatabase
+
+on selectDatabase ( databaseId, databaseName ) {
+	
+	«Changes
+		«5/29/07; 12:00:00 AM by DG
+			«created
+	
+	kernel ( mysql.selectDatabase )}
+
+


Property changes on: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/selectDatabase.fvc
___________________________________________________________________
Name: svn:eol-style
   + native


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.