/**
* Helper function for getResultField returns a 0-based column number
*
* @param colName the column name
* @param rsmd the result set meta data
* @return the column number (0-based) or -1 on error
*/
private int getColumnNumber(String colName,
ResultSetMetaData md)
{
int numColumns = md.getColumnCount();
if (colName.indexOf('.') == -1)
{
for (int i = 1; i <= numColumns; i++)
{
if (colName.equals(getColumnLabel(md, i)))
{
return(i - 1);
}
}
return(-1);
}
else
{
for (int i = 1; i <= numColumns; i++)
{
if (colName.equals(md.getTableName(i) + '.' + md.getColumnLabel(i)))
{
return(i - 1);
}
}
return(-1);
}
}
//static void DerbytTest1(string dbpath)
//{
// DerbyNET derbyDB = new DerbyNET(dbpath + ";create=true"); // don't use "\" in directory
// if (!derbyDB.openConnection())
// {
// Console.WriteLine(derbyDB.getLastError());
// Console.ReadKey();
// //Error opening Derby DB
// return;
// }
// DataTable oDT = derbyDB.getRS("SELECT * FROM schemaExample.tblExample") as DataTable;
// if (oDT.Columns[0].ColumnName == "Erro")
// {
// //Read the ** ERRORS ** section below
// Thread.sleep(1000);
// oDT = derbyDB.getRS("SELECT * FROM schemaExample.tblExample") as DataTable;
// }
// else if (oDT.Rows.Count == 1 && oDT.Columns.Count == 1)
// {
// //Some error occured
// Console.WriteLine(derbyDB.getLastError());
// Console.ReadKey();
// return;
// }
// derbyDB.closeConnection();
//}
static void DerbytTest2(string dbpath)
{
Console.WriteLine("Set Property: derby.system.home");
java.lang.System.setProperty("derby.system.home", dbpath);
Console.WriteLine("Register Driver: EmbeddedDriver");
DriverManager.registerDriver(new org.apache.derby.jdbc.EmbeddedDriver());
Console.WriteLine("Connection: jdbc:derby:security");
Connection derbyConn = DriverManager.getConnection(@"jdbc:derby:security;create=true");
Console.WriteLine("Create Statement... (ITEM_SEC)");
Statement sta = derbyConn.createStatement();
ResultSet res = sta.executeQuery("SELECT * from ITEM_SEC");
ResultSetMetaData rsmd = res.getMetaData();
Console.WriteLine("List Columns: ITEM_SEC");
for (var i = 1; i <= rsmd.getColumnCount() - 1; i++)
{
Console.WriteLine("- Column: {0}", rsmd.getColumnName(i));
}
res = sta.executeQuery("SELECT COUNT(*) nTotal from ITEM_SEC");
while (res.next())
{
Console.WriteLine("ITEM_SEC ({0} rows)", res.getString("nTotal"));
}
res.close();
sta.close();
derbyConn.close();
Console.ReadKey();
}
protected MysqlResultSetMetaData(ResultSetMetaData metaData)
{
_resultSetMetaData = metaData;
try {
_columnEncodings = new String[metaData.getColumnCount()];
} catch (SQLException e) {
throw new QuercusException(e);
}
}
/**
* Returns an object with properties that correspond to the fetched row and
* moves the internal data pointer ahead.
*
* @param env the PHP executing environment
* @return an object representing the current fetched row
*/
protected Value fetchObject(Env env, string className, Value[] args)
{
if (_rs == null)
{
return(NullValue.NULL);
}
try {
if (_rs.next())
{
_isValid = true;
Value result;
if (className != null)
{
QuercusClass cls = env.findClass(className);
if (args == null)
{
args = Value.NULL_ARGS;
}
result = cls.callNew(env, args);
}
else
{
result = env.createObject();
}
ResultSetMetaData md = getMetaData();
int count = md.getColumnCount();
for (int i = 0; i < count; i++)
{
string name = getColumnLabel(md, i + 1);
Value value = getColumnValue(env, i + 1);
result.putField(env, name, value);
}
return(result);
}
else
{
return(NullValue.NULL);
}
} catch (SQLException e) {
log.log(Level.FINE, e.ToString(), e);
return(NullValue.NULL);
}
}
public JDBCInputAdapter(Connection connection, string sql)
{
try
{
Statement stmt = connection.createStatement(); // Get a statement from the connection
resultSet = stmt.executeQuery(sql); // Execute the query
ResultSetMetaData rsmd = resultSet.getMetaData();
inputSize = rsmd.getColumnCount();
}
catch (SQLException ex)
{
//JAVA TO C# CONVERTER WARNING: The .NET Type.FullName property will not always yield results identical to the Java Class.getName method:
throw new NeurophInputException("Error executing query at JdbcInputAdapter", ex);
}
}
protected int getColumnCount(Env env)
{
try {
ResultSetMetaData md = getMetaData();
if (md == null)
{
return(-1);
}
return(md.getColumnCount());
}
catch (SQLException e) {
setError(env, e);
return(-1);
}
}
private bool init(ResultSetMetaData metaData)
{
int columnCount = metaData.getColumnCount();
if (_columnAsName != null) {
for (int i = 1; i <= columnCount; i++) {
string name = metaData.getColumnName(i);
if (name.equals(_columnAsName)) {
_column = i;
break;
}
}
}
_isValid = _column > 0 && _column <= columnCount;
return true;
}
protected Value fetchArray(Env env, int type, bool isOrderIndexBeforeName)
{
try {
if (_rs == null)
{
return(NullValue.NULL);
}
if (_rs.next())
{
_isValid = true;
ArrayValue array = new ArrayValueImpl();
ResultSetMetaData md = getMetaData();
int count = md.getColumnCount();
if ((type & FETCH_ASSOC) != 0)
{
_columnNames = new Value[count];
for (int i = 0; i < count; i++)
{
string columnName = getColumnLabel(md, i + 1);
_columnNames[i] = env.createString(columnName);
}
}
for (int i = 0; i < count; i++)
{
Value value = getColumnValue(env, i + 1);
if (isOrderIndexBeforeName)
{
if ((type & FETCH_NUM) != 0)
{
array.put(LongValue.create(i), value);
}
if ((type & FETCH_ASSOC) != 0)
{
array.put(_columnNames[i], value);
}
}
else
{
if ((type & FETCH_ASSOC) != 0)
{
array.put(_columnNames[i], value);
}
if ((type & FETCH_NUM) != 0)
{
array.put(LongValue.create(i), value);
}
}
}
return(array);
}
else
{
return(NullValue.NULL);
}
}
catch (SQLException e) {
log.log(Level.FINE, e.ToString(), e);
return(NullValue.NULL);
}
}
