OracleServer SetupOracleServer(ErrorResultTO errors)
{
var server = new OracleServer();
try
{
var connected = server.Connect(Source.ConnectionString, CommandType.StoredProcedure, ProcedureName);
if (!connected)
{
Dev2Logger.Error(string.Format(ErrorResource.FailedToConnectWithConnectionString,
Source.ConnectionString), GlobalConstants.WarewolfError);
}
return(server);
}
catch (OracleException oex)
{
var errorMessages = new StringBuilder();
errorMessages.Append(oex.Message);
errors.AddError(errorMessages.ToString());
Dev2Logger.Error(errorMessages.ToString(), GlobalConstants.WarewolfError);
}
catch (Exception ex)
{
errors.AddError($"{ex.Message}{Environment.NewLine}{ex.StackTrace}");
Dev2Logger.Error(ex, GlobalConstants.WarewolfError);
}
return(server);
}
public void OracleTest()
{
BaseKeyPair kp = BaseKeyPair.Generate();
Account oracleAccount = fluentClient.ConstructAccount(kp);
Account account = fluentClient.ConstructAccount(baseKeyPair);
ulong money = (ulong)1m.ToAettos(Unit.AE);
bool result = account.SendAmount(oracleAccount.KeyPair.PublicKey, money).WaitForFinish(TimeSpan.FromSeconds(30));
Assert.IsTrue(result);
oracleAccount.Refresh();
Assert.AreEqual(oracleAccount.Balance, money);
OracleServer <CityQuery, TemperatureResponse> query = oracleAccount.RegisterOracle <CityQuery, TemperatureResponse>().WaitForFinish(TimeSpan.FromSeconds(30));
CityTemperatureService svc = new CityTemperatureService();
svc.Server = query;
Task.Factory.StartNew(svc.Start);
OracleClient <CityQuery, TemperatureResponse> reg = account.GetOracle <CityQuery, TemperatureResponse>(query.OracleId);
TemperatureResponse resp = reg.Ask(new CityQuery {
City = "montevideo"
}).WaitForFinish(TimeSpan.FromSeconds(300));
Assert.AreEqual(resp.TemperatureCelsius, 24);
resp = reg.Ask(new CityQuery {
City = "sofia"
}).WaitForFinish(TimeSpan.FromSeconds(30));
Assert.AreEqual(resp.TemperatureCelsius, 25);
resp = reg.Ask(new CityQuery {
City = "hell"
}).WaitForFinish(TimeSpan.FromSeconds(30));
Assert.AreEqual(resp.TemperatureCelsius, 2000);
svc.Stop();
}
static void Main(string[] args)
{
int selector = 2;
SqlServer sqlServer = new SqlServer();
OracleServer oracleServer = new OracleServer();
sqlServer.Add(selector);
oracleServer.Delete();
Console.ReadLine();
}
static void Main(string[] args)
{
// Test Code.
var svr = new OracleServer("ktarbet", File.ReadAllLines(@"C:\temp\karl.txt")[0], "uchdb2.uc.usbr.gov", "uchdb2.uc.usbr.gov", "MST", "1521");
Hdb.Instance = new Hdb(svr);
SqlViewEditor.Server = Hdb.Instance.Server;
var f = new FormMetaData();
Application.Run(f);
}
public async Task <(object result, bool done)> CheckForFinishAsync(object input, CancellationToken token = default(CancellationToken))
{
OracleServer <T, S> c = (OracleServer <T, S>)input;
RegisteredOracle oracle = await c.Account.Client.GetRegisteredOracleAsync(c.OracleId, token).ConfigureAwait(false);
c.AbiVersion = oracle.AbiVersion;
c.QueryFee = oracle.QueryFee;
c.QueryFormat = oracle.QueryFormat;
c.ResponseFormat = oracle.ResponseFormat;
c.Ttl = oracle.Ttl;
return(c, true);
}
private static void PushCode(string[] temp, OracleServer _lstserver, int lastIndex, int i)
{
StringBuilder sb = new StringBuilder(500);
for (int _i = lastIndex; _i < i - 3; _i++)
{
string line = temp[_i];
if (!line.Trim().StartsWith("#"))
{
sb.AppendLine(line);
}
}
_lstserver.Value = sb.ToString();
}
private void addHDB_Click(object sender, EventArgs e)
{
var server = OracleServer.ConnectToOracle();
if (server != null)
{
Hdb.Instance = new Hdb(server);
var dlg = new HdbPoet.FormAddSeries();
if (dlg.ShowDialog() == DialogResult.OK)
{
HdbPoet.Properties.Settings.Default.Save();
ImportFromHdb.Import(dlg.DataSet, DB, CurrentFolder);
DatabaseChanged();
}
}
}
// ReSharper disable InconsistentNaming
public void OracleServer_FetchDataTable_AddParams_VerifyAllAdded()
// ReSharper restore InconsistentNaming
{
//------------Setup for test--------------------------
var factory = new Mock <IDbFactory>();
var mockCommand = new Mock <IDbCommand>();
mockCommand.Setup(a => a.ExecuteReader(It.IsAny <CommandBehavior>())).Returns(new Mock <IDataReader>().Object);
mockCommand.Setup(a => a.CommandText).Returns("Dave.Bob");
var added = new SqlCommand().Parameters;
mockCommand.Setup(a => a.Parameters).Returns(added);
var helpTextCommand = new Mock <IDbCommand>();
helpTextCommand.Setup(a => a.ExecuteReader(It.IsAny <CommandBehavior>())).Returns(new Mock <IDataReader>().Object);
DataTable dt = new DataTable();
dt.Columns.Add("database_name");
dt.Rows.Add(new object[] { "Bob" });
dt.Rows.Add(new object[] { "Dave" });
factory.Setup(a => a.GetSchema(It.IsAny <IDbConnection>(), "Databases")).Returns(dt);
var conn = new Mock <IDbConnection>();
conn.Setup(a => a.State).Returns(ConnectionState.Open);
var sqlServer = new OracleServer(factory.Object);
try
{
PrivateObject pvt = new PrivateObject(sqlServer);
pvt.SetField("_connection", conn.Object);
pvt.SetField("_command", mockCommand.Object);
//------------Execute Test---------------------------
IDbDataParameter[] param = new IDbDataParameter[] { new SqlParameter("a", "a"), new SqlParameter("b", "b") };
SqlServer.AddParameters(mockCommand.Object, param);
Assert.AreEqual(2, added.Count);
//------------Assert Results-------------------------
}
finally
{
sqlServer.Dispose();
}
}
// ReSharper disable InconsistentNaming
public void OracleServer_FetchDataTable_CommandIsNull_ThrowsArgumentNullException()
// ReSharper restore InconsistentNaming
{
//------------Setup for test--------------------------
var sqlServer = new OracleServer();
try
{
//------------Execute Test---------------------------
sqlServer.FetchDataTable(null);
//------------Assert Results-------------------------
}
finally
{
sqlServer.Dispose();
}
}
public void OracleServer_CreateCommand_ConnectionNotInitialized_ThrowsConnectFirstException()
{
//------------Setup for test--------------------------
var sqlServer = new OracleServer();
try
{
//------------Execute Test---------------------------
sqlServer.CreateCommand();
//------------Assert Results-------------------------
}
finally
{
sqlServer.Dispose();
}
}
public void OracleServer_Connect_ConnectionStringIsNull_ThrowsArgumentNullException()
{
//------------Setup for test--------------------------
var sqlServer = new OracleServer();
try
{
//------------Execute Test---------------------------
sqlServer.Connect(null, CommandType.Text, null);
//------------Assert Results-------------------------
}
finally
{
sqlServer.Dispose();
}
}
// ReSharper disable InconsistentNaming
public void OracleServer_FetchDatabases_ConnectionNotInitialized_ThrowsConnectFirstException()
// ReSharper restore InconsistentNaming
{
//------------Setup for test--------------------------
var sqlServer = new OracleServer();
try
{
//------------Execute Test---------------------------
sqlServer.FetchDatabases();
//------------Assert Results-------------------------
}
finally
{
sqlServer.Dispose();
}
}
// ReSharper disable InconsistentNaming
public void OracleServer_Connect_ConnectionStringIsInvalid_ThrowsArgumentException()
// ReSharper restore InconsistentNaming
{
//------------Setup for test--------------------------
var sqlServer = new OracleServer();
try
{
//------------Execute Test---------------------------
sqlServer.Connect("xxx", CommandType.Text, null);
//------------Assert Results-------------------------
}
finally
{
sqlServer.Dispose();
}
}
private void AddHDBModel_Click(object sender, EventArgs e)
{
#if !PISCES_OPEN
var server = OracleServer.ConnectToOracle();
if (server == null)
{
return;
}
Hdb.Instance = new Hdb(server);
SelectHdbModel dlg = new SelectHdbModel();
if (dlg.ShowDialog() == DialogResult.OK && dlg.ModelID > 0)
{
// create tree for this model.
var folder = DB.AddFolder(CurrentFolder, dlg.ModelName + " " + dlg.ModelTable);
var tbl = HdbModelTreeBuilder.PiscesSeriesCatalog(dlg.ModelID, dlg.ModelTable, dlg.OldestModelRunDate, DB.NextSDI(), folder.ID);
if (tbl.Rows.Count == 0)
{
MessageBox.Show("No model runs found for model_id " + dlg.ModelID + " after " + dlg.OldestModelRunDate.ToString());
return;
}
DB.Server.SaveTable(tbl);
// create scenario list.
var scenarioTable = DB.GetScenarios();
var ref_model_run = Hdb.Instance.ref_model_run(dlg.ModelID, dlg.OldestModelRunDate);
foreach (DataRow item in ref_model_run.Rows)
{
string date = Convert.ToDateTime(item["run_date"]).ToShortDateString();
string model_run_name = item["model_run_name"].ToString();
string id = item["model_run_id"].ToString();
string path = HdbModelSeries.BuildScenairoPath(model_run_name, id, date);
string name = HdbModelSeries.BuildScenairoName(model_run_name, id, date);
scenarioTable.AddScenarioRow(name, true, path, 0);
}
DB.Server.SaveTable(scenarioTable);
DatabaseChanged();
}
#endif
}
// ReSharper disable InconsistentNaming
public void OracleServer_CreateCommand_CreateCommand()
// ReSharper restore InconsistentNaming
{
//------------Setup for test--------------------------
var factory = new Mock <IDbFactory>();
var mockCommand = new Mock <IDbCommand>();
mockCommand.Setup(a => a.ExecuteReader(It.IsAny <CommandBehavior>())).Returns(new Mock <IDataReader>().Object);
mockCommand.Setup(a => a.CommandText).Returns("Dave.Bob");
var added = new SqlCommand().Parameters;
mockCommand.Setup(a => a.Parameters).Returns(added);
var helpTextCommand = new Mock <IDbCommand>();
helpTextCommand.Setup(a => a.ExecuteReader(It.IsAny <CommandBehavior>())).Returns(new Mock <IDataReader>().Object);
DataTable dt = new DataTable();
dt.Columns.Add("database_name");
dt.Rows.Add(new object[] { "Bob" });
dt.Rows.Add(new object[] { "Dave" });
factory.Setup(a => a.GetSchema(It.IsAny <IDbConnection>(), "Databases")).Returns(dt);
var conn = new Mock <IDbConnection>();
conn.Setup(a => a.State).Returns(ConnectionState.Open);
conn.Setup(a => a.ConnectionString).Returns("bob");
conn.Setup(a => a.CreateCommand()).Returns(mockCommand.Object);
factory.Setup(a => a.CreateConnection(It.IsAny <string>())).Returns(conn.Object);
var sqlServer = new OracleServer(factory.Object);
try
{
PrivateObject pvt = new PrivateObject(sqlServer);
pvt.SetField("_connection", conn.Object);
//------------Execute Test---------------------------
sqlServer.CreateCommand();
conn.Verify(a => a.CreateCommand());
}
finally
{
sqlServer.Dispose();
}
}
// ReSharper disable InconsistentNaming
public void OracleServer_FetchStoredProcedures_FunctionProcessorIsNull_ThrowsArgumentNullException()
// ReSharper restore InconsistentNaming
{
//------------Setup for test--------------------------
var sqlServer = new OracleServer();
try
{
//------------Execute Test---------------------------
Func <IDbCommand, List <IDbDataParameter>, string, string, bool> procProcessor = (command, list, arg3, a) => false;
sqlServer.FetchStoredProcedures(procProcessor, null);
//------------Assert Results-------------------------
}
finally
{
sqlServer.Dispose();
}
}
public void OracleServer_FetchDataTable_ConnectionsString()
{
//------------Setup for test--------------------------
var factory = new Mock <IDbFactory>();
var mockCommand = new Mock <IDbCommand>();
mockCommand.Setup(a => a.ExecuteReader(It.IsAny <CommandBehavior>())).Returns(new Mock <IDataReader>().Object);
mockCommand.Setup(a => a.CommandText).Returns("Dave.Bob");
var added = new SqlCommand().Parameters;
mockCommand.Setup(a => a.Parameters).Returns(added);
var helpTextCommand = new Mock <IDbCommand>();
helpTextCommand.Setup(a => a.ExecuteReader(It.IsAny <CommandBehavior>())).Returns(new Mock <IDataReader>().Object);
var dt = new DataTable();
dt.Columns.Add("database_name");
dt.Rows.Add(new object[] { "Bob" });
dt.Rows.Add(new object[] { "Dave" });
factory.Setup(a => a.GetSchema(It.IsAny <IDbConnection>(), "Databases")).Returns(dt);
var conn = new Mock <IDbConnection>();
conn.Setup(a => a.State).Returns(ConnectionState.Open);
conn.Setup(a => a.ConnectionString).Returns("bob");
var sqlServer = new OracleServer(factory.Object);
try
{
var pvt = new Warewolf.Testing.PrivateObject(sqlServer);
pvt.SetField("_connection", conn.Object);
pvt.SetField("_command", mockCommand.Object);
//------------Execute Test---------------------------
Assert.AreEqual("bob", sqlServer.ConnectionString);
}
finally
{
sqlServer.Dispose();
}
}
public static InProgress <bool> Extend <T, S>(this OracleServer <T, S> oracleQuery, ulong fee = Constants.BaseConstants.FEE, ulong extendTtl = Constants.BaseConstants.ORACLE_RESPONSE_TTL_VALUE) => oracleQuery.ExtendAsync(fee, extendTtl).RunAndUnwrap();
public static List <OracleQuestion <T, S> > Query <T, S>(this OracleServer <T, S> oracleQuery, ushort?limit, string lastQueryId = null) => oracleQuery.QueryAsync(limit, lastQueryId).RunAndUnwrap();
private static List <OracleServer> LoadServersFromTextFile(string FP)
{
List <OracleServer> _lst = new List <OracleServer>();
string inputString;
StreamReader streamReader = File.OpenText(FP.Trim()); // FP is the filepath of TNS file
inputString = streamReader.ReadToEnd();
string[] temp = inputString.Split(new string[] { Environment.NewLine }, StringSplitOptions.None);
OracleServer _lstserver = null;
int lastIndex = 0;
for (int i = 0; i < temp.Length; i++)
{
OracleServer _server = null;
if (temp[i].Trim(' ', '(').Contains("DESCRIPTION"))
{
string DS = temp[i - 1].Trim('=', ' ');
if (DS != "(LOAD_BALANCE = OFF)" && DS != ")")
{
if (_lstserver != null)
{
PushCode(temp, _lstserver, lastIndex, i);
}
_server = new OracleServer()
{
Name = DS, index = i - 1
};
_lst.Add(_server);
lastIndex = i - 1;
_lstserver = _server;
}
}
}
if (_lstserver != null)
{
PushCode(temp, _lstserver, lastIndex, temp.Length);
}
streamReader.Close();
foreach (OracleServer item in _lst)
{
string u = item.Value;
var c = u.IndexOf('=');
if (c != -1)
{
u = u.Substring(c + 1).Trim();
}
u = u.Replace(Environment.NewLine, " ");
while (item.Value != u)
{
item.Value = u;
u = u.Replace(" ", " ");
u = u.Replace(") )", "))");
u = u.Replace("( (", "((");
}
}
return(_lst);
}
