static void TestQuery()
{
try
{
CubridConnection con = new CubridConnection();
con.ConnectionString = "server=localhost;database=testdb;port=30000;user=dba;password="******"SELECT * FROM t";
CubridCommand cmd = new CubridCommand(sql, con);
DbDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Console.Write(reader.GetInt32(0) + " | ");
Console.Write(reader.GetString(1) + " | ");
Console.Write(reader.GetString(2) + " | ");
Console.Write(reader.GetFloat(3) + " | ");
Console.Write(reader.GetDouble(4) + " | ");
Console.WriteLine(reader.GetDateTime(5));
}
cmd.Close();
con.Close();
}
catch (CubridException e)
{
Console.WriteLine(e);
}
}
protected override DbCommand CreateDbCommand()
{
CubridCommand command = new CubridCommand();
command.Connection = this;
return(command);
}
internal CubridDataReader(CubridCommand stmt, int handle, int count, ColumnMetaData[] columnInfos)
{
this.stmt = stmt;
this.con = (CubridConnection)stmt.Connection;
this.handle = handle;
resultCount = count;
this.columnMetaData = columnInfos;
current = 0;
resultTuple = new ResultTuple(columnInfos.Length);
}
internal CubridDataReader(CubridCommand stmt, int handle, int count, ColumnMetaData[] columnInfos)
{
this.stmt = stmt;
this.con = (CubridConnection) stmt.Connection;
this.handle = handle;
resultCount = count;
this.columnMetaData = columnInfos;
current = 0;
resultTuple = new ResultTuple(columnInfos.Length);
}
static void TestSimple()
{
try
{
CubridConnection con = new CubridConnection();
con.ConnectionString = "server=localhost;database=testdb;port=30000;user=dba;password="******"CREATE TABLE t(a int, b char(10), c string, d float, e double, f date)";
CubridCommand command = new CubridCommand(sql, con);
command.ExecuteNonQuery();
command.Close();
con.Close();
}
catch (CubridException e)
{
Console.WriteLine(e);
}
}
static void TestStoredProcedure()
{
try
{
CubridConnection con = new CubridConnection();
con.ConnectionString = "server=localhost;database=testdb;port=30000;user=dba;password="******"CREATE FUNCTION sp1(a int) RETURN string AS LANGUAGE JAVA NAME 'SpTest.test1(int) return java.lang.String'";
CubridCommand cmd = new CubridCommand(sql, con);
cmd.ExecuteNonQuery();
cmd.Close();
sql = "? = CALL sp1(?)";
cmd = new CubridCommand(sql, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add();
cmd.Parameters[0].Direction = ParameterDirection.Output;
cmd.Parameters[0].DbType = DbType.String;
cmd.Parameters.Add(12345678);
cmd.Parameters[1].DbType = DbType.Int32;
cmd.ExecuteNonQuery();
Console.WriteLine("result: " + cmd.Parameters[0].Value);
cmd.Close();
sql = "DROP FUNCTION sp1";
cmd = new CubridCommand(sql, con);
cmd.ExecuteNonQuery();
cmd.Close();
con.Close();
}
catch (CubridException e)
{
Console.WriteLine(e);
}
}
internal object ReadValue(int index, CubridDataType type, int size, CubridConnection con)
{
switch (type)
{
case CubridDataType.Char:
case CubridDataType.Nchar:
case CubridDataType.String:
case CubridDataType.Varnchar:
return(ReadString(size, Encoding.Default));
case CubridDataType.Short:
return(ReadShort());
case CubridDataType.Int:
return(ReadInt());
case CubridDataType.Float:
return(ReadFloat());
case CubridDataType.Double:
case CubridDataType.Monetary:
return(ReadDouble());
case CubridDataType.Date:
return(ReadDate());
case CubridDataType.Time:
return(ReadTime());
case CubridDataType.Timestamp:
return(ReadDateTime());
case CubridDataType.Object:
return(ReadOid());
case CubridDataType.Bit:
case CubridDataType.Varbit:
return(ReadBytes(size));
case CubridDataType.Set:
case CubridDataType.Multiset:
case CubridDataType.Sequence:
CubridDataType baseType = (CubridDataType)ReadByte();
int count = ReadInt();
object[] seq = new object[count];
for (int i = 0; i < count; i++)
{
int elesize = ReadInt();
if (elesize <= 0)
{
seq[i] = null;
}
else
{
seq[i] = ReadValue(i, baseType, elesize, con);
}
}
return(seq);
case CubridDataType.ResultSet:
int handle = ReadInt();
CubridCommand cmd = new CubridCommand(con, handle);
return(cmd.GetDataReaderFromStoredProcedure());
default:
return(null); //throw exception ??
}
}
static void TestTransaction()
{
DbTransaction tran = null;
try
{
CubridConnection con = new CubridConnection();
con.ConnectionString = "server=localhost;database=testdb;port=30000;user=dba;password="******"INSERT INTO t VALUES(?, ?, ?, ?, ?, ?)";
CubridCommand cmd = new CubridCommand(sql, con);
cmd.Parameters.Add(1);
cmd.Parameters[0].DbType = DbType.Int32;
cmd.Parameters.Add("cubrid");
cmd.Parameters[1].DbType = DbType.String;
cmd.Parameters.Add(CubridDataType.String);
cmd.Parameters[2].Value = "ado.net provider";
cmd.Parameters.Add(3.14f);
cmd.Parameters[3].DbType = DbType.Single;
cmd.Parameters.Add(3.14159253637283645);
cmd.Parameters[4].DbType = DbType.Double;
cmd.Parameters.Add(new DateTime());
cmd.Parameters[5].DbType = DbType.Date;
cmd.ExecuteNonQuery();
cmd.Parameters[0].Value = 2;
cmd.Parameters[1].Value = "open";
cmd.Parameters[2].Value = "source";
cmd.Parameters[3].Value = 735626.34f;
cmd.Parameters[4].Value = 8373625.383635235373;
cmd.Parameters[5].Value = new DateTime(2008, 12, 24);
cmd.ExecuteNonQuery();
tran.Commit();
cmd.Close();
con.Close();
}
catch (CubridException e)
{
tran.Rollback();
Console.WriteLine(e);
}
}
static void TestStoredProcedureResultSet()
{
try
{
CubridConnection con = new CubridConnection();
con.ConnectionString = "server=localhost;database=testdb;port=30000;user=dba;password="******"CREATE FUNCTION sp2() RETURN cursor AS LANGUAGE JAVA NAME 'SpTest.test2() return java.sql.ResultSet'";
CubridCommand cmd = new CubridCommand(sql, con);
cmd.ExecuteNonQuery();
cmd.Close();
sql = "? = CALL sp2()";
cmd = new CubridCommand(sql, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(CubridDataType.ResultSet);
cmd.Parameters[0].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
DbDataReader reader = (DbDataReader)cmd.Parameters[0].Value;
while (reader.Read())
{
Console.Write(reader.GetInt32(0) + " | ");
Console.Write(reader.GetString(1) + " | ");
Console.Write(reader.GetString(2) + " | ");
Console.Write(reader.GetFloat(3) + " | ");
Console.Write(reader.GetDouble(4) + " | ");
Console.WriteLine(reader.GetDateTime(5));
}
cmd.Close();
sql = "DROP FUNCTION sp2";
cmd = new CubridCommand(sql, con);
cmd.ExecuteNonQuery();
cmd.Close();
con.Close();
}
catch (CubridException e)
{
Console.WriteLine(e);
}
}
internal object ReadValue(int index, CubridDataType type, int size, CubridConnection con)
{
switch (type)
{
case CubridDataType.Char:
case CubridDataType.Nchar:
case CubridDataType.String:
case CubridDataType.Varnchar:
return ReadString(size, Encoding.Default);
case CubridDataType.Short:
return ReadShort();
case CubridDataType.Int:
return ReadInt();
case CubridDataType.Float:
return ReadFloat();
case CubridDataType.Double:
case CubridDataType.Monetary:
return ReadDouble();
case CubridDataType.Date:
return ReadDate();
case CubridDataType.Time:
return ReadTime();
case CubridDataType.Timestamp:
return ReadDateTime();
case CubridDataType.Object:
return ReadOid();
case CubridDataType.Bit:
case CubridDataType.Varbit:
return ReadBytes(size);
case CubridDataType.Set:
case CubridDataType.Multiset:
case CubridDataType.Sequence:
CubridDataType baseType = (CubridDataType)ReadByte();
int count = ReadInt();
object[] seq = new object[count];
for (int i = 0; i < count; i++)
{
int elesize = ReadInt();
if(elesize <= 0)
{
seq[i] = null;
}
else
{
seq[i] = ReadValue(i, baseType, elesize, con);
}
}
return seq;
case CubridDataType.ResultSet:
int handle = ReadInt();
CubridCommand cmd = new CubridCommand(con, handle);
return cmd.GetDataReaderFromStoredProcedure();
default:
return null; //throw exception ??
}
}
protected override DbCommand CreateDbCommand()
{
CubridCommand command = new CubridCommand();
command.Connection = this;
return command;
}
