public List<string> GetSequences(List<Table> tables) { var sequences = new List<string>(); var conn = new CUBRIDConnection(connectionStr); conn.Open(); try { using (conn) { CUBRIDCommand seqCommand = conn.CreateCommand(); seqCommand.CommandText = "select [name], class_name from db_serial"; var seqReader = (CUBRIDDataReader)seqCommand.ExecuteReader(CommandBehavior.CloseConnection); while (seqReader.Read()) { sequences.AddRange(from table in tables where table.Name.ToUpper() == seqReader.GetString(1).ToUpper() select seqReader.GetString(0)); } } } finally { conn.Close(); } return sequences; }
public void CreateCommand_Test() { using (CUBRIDConnection conn = new CUBRIDConnection()) { conn.ConnectionString = DBHelper.connString; conn.Open(); DBHelper.ExecuteSQL("drop table if exists t", conn); CUBRIDCommand cmd = conn.CreateCommand(); cmd.CommandText = "create table t(idx integer)"; cmd.ExecuteNonQuery(); int tablesCount = DBHelper.GetTablesCount("t", conn); Assert.AreEqual(1, tablesCount); //revert the test db DBHelper.ExecuteSQL("drop table t", conn); LogTestResult(); } }
public List<string> GetSequences(string tablename, string column) { var sequences = new List<string>(); var conn = new CUBRIDConnection(connectionStr); conn.Open(); try { using (conn) { CUBRIDCommand seqCommand = conn.CreateCommand(); string sqlCmd = String.Format(@"select [name] from db_serial where class_name='{0}' and att_name='{1}'", tablename, column); seqCommand.CommandText = sqlCmd; var seqReader = (CUBRIDDataReader)seqCommand.ExecuteReader(CommandBehavior.CloseConnection); while (seqReader.Read()) { sequences.Add(seqReader.GetString(0)); } } } finally { conn.Close(); } return sequences; }
/// <summary> /// Test basic SQL statements execution, using parameters /// </summary> private static void Test_Command_Multiple_CommandText() { string sqlTablesCount = "select count(*) from db_class"; int tablesCount, newTableCount; using (CUBRIDConnection conn = new CUBRIDConnection()) { conn.ConnectionString = TestCases.connString; conn.Open(); using (CUBRIDCommand cmd = conn.CreateCommand()) { tablesCount = (int)TestCases.GetSingleValue(sqlTablesCount, conn); cmd.CommandText = "create table test(id int)"; cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); newTableCount = (int)TestCases.GetSingleValue(sqlTablesCount, conn); Debug.Assert(newTableCount == tablesCount + 1); cmd.CommandText = "drop table test"; cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); newTableCount = (int)TestCases.GetSingleValue(sqlTablesCount, conn); Debug.Assert(newTableCount == tablesCount); } } }