public void InstanceTest()
{
SqlClientFactory instance = SqlClientFactory.Instance;
Assert.NotNull(instance);
Assert.Same(instance, SqlClientFactory.Instance);
}
public IActionResult ExecuteQuery(string type, string query)
{
var factory = (IDatabaseFactory)null;
if (string.IsNullOrEmpty(AppSettings.FactoryType))
{
if (type == "sqlclient")
{
factory = new SqlClientFactory();
}
else
{
// factory = new OleDbFactory();
}
}
else
{
factory = (IDatabaseFactory)Activator.CreateInstance(Type.GetType(AppSettings.FactoryType));
}
var helper = new DatabaseHelper(factory);
if (query.ToLower().StartsWith("select"))
{
var reader = helper.ExecuteSelect(query);
return(View("ShowTable", reader));
}
else
{
var i = helper.ExecuteAction(query);
return(View("ShowResult", i));
}
}
public void InstantiateUnderlyingSession_CosmosDbConnectionString_ISession()
{
var factory = new SqlClientFactory();
var session = factory.Instantiate($"Endpoint=https://xyz.graphs.azure.com:443;AuthKey={base64AuthKey};database=db;collection=FoF;api=sql");
Assert.That(session.UnderlyingSessionType, Is.EqualTo(typeof(SqlClientOperation)));
}
public void Execute_Edge_DataSetFilled()
{
SqlClient session = new SqlClientFactory().Instantiate(ConnectionStringReader.GetLocaleSql()) as SqlClient;
var statement = Mock.Of <IQuery>(x => x.Statement == "SELECT * FROM FoF f WHERE f.label='knows'");
SqlCommandOperation commandOperation = new SqlCommandFactory().Instantiate(session, statement).Implementation as SqlCommandOperation;
var engine = new SqlExecutionEngine(session.CreateClientOperation(), commandOperation);
var ds = engine.Execute();
Assert.That(ds.Tables, Has.Count.EqualTo(1));
Assert.That(ds.Tables[0].Rows, Has.Count.EqualTo(3));
Assert.That(ds.Tables[0].Columns, Has.Count.EqualTo(12));
Assert.That(ds.Tables[0].Columns.Cast <DataColumn>().Select(x => x.ColumnName), Has.Member("id"));
Assert.That(ds.Tables[0].Columns.Cast <DataColumn>().Select(x => x.ColumnName), Has.Member("label"));
Assert.That(ds.Tables[0].Columns.Cast <DataColumn>().Select(x => x.ColumnName), Has.Member("_sink"));
Assert.That(ds.Tables[0].Columns.Cast <DataColumn>().Select(x => x.ColumnName), Has.Member("_vertexId"));
Assert.That(ds.Tables[0].Columns.Cast <DataColumn>().Select(x => x.ColumnName), Has.Member("_sinkLabel"));
Assert.That(ds.Tables[0].Columns.Cast <DataColumn>().Select(x => x.ColumnName), Has.Member("_vertexLabel"));
foreach (DataRow row in ds.Tables[0].Rows)
{
Assert.That(row["id"], Is.Not.Null.Or.Empty);
Assert.That(row["_vertexLabel"], Is.EqualTo("person"));
Assert.That(row["_sinkLabel"], Is.EqualTo("person"));
Assert.That(row["_isEdge"], Is.True);
}
}
public void InstantiateCreate_CosmosDbConnectionStringWithoutBase64Encoding_NBiException()
{
var factory = new SqlClientFactory();
var session = factory.Instantiate($"Endpoint=https://xyz.graphs.azure.com:443;AuthKey=@uthK3y;database=db;collection=FoF;api=sql");
Assert.Throws <Exception>(() => session.CreateNew());
}
public User Get(string login, string password)
{
var factory = new SqlClientFactory();
using (var connection = factory.CreateConnection())
{
var command = factory.CreateCommand();
command.Connection = connection;
command.CommandType = CommandType.Text;
command.CommandText = "select * from tb_user where login =@login and password=@password";
command.Parameters.Add(new SqlParameter("@login", login));
command.Parameters.Add(new SqlParameter("@password", password));
try
{
connection.Open();
var reader = command.ExecuteReader();
while (reader.Read())
{
var objUser = GetFromReader(reader);
return(objUser);
}
return(null);
}
catch
{
return(null);
}
}
}
public IActionResult ExecuteQueryConfig(string query)
{
IDatabaseFactory factory = null;
string factorytype = AppSettings.Factory;
if (factorytype == "sqlclient")
{
factory = new SqlClientFactory();
}
else
{
factory = new OleDbFactory();
}
DatabaseHelper helper = new DatabaseHelper(factory);
query = query.ToLower();
if (query.StartsWith("select"))
{
DbDataReader reader = helper.ExecuteSelect(query);
return(View("ShowTable", reader));
}
else
{
int i = helper.ExecuteAction(query);
return(View("ShowResult", i));
}
}
/**/
private bool mensajeError = true;
public bool MensajeError {
get { return(mensajeError); }
set { mensajeError = value; }
}
/**/
public DatabaseHelper(string connectionstring, Providers provider)
{
strConnectionString = connectionstring;
switch (provider)
{
case Providers.SqlServer:
objFactory = SqlClientFactory.Instance;
break;
case Providers.ConfigDefined:
string providername = ConfigurationManager.ConnectionStrings["DGP_cs"].ProviderName;
switch (providername)
{
case "System.Data.SqlClient":
objFactory = SqlClientFactory.Instance;
break;
}
break;
}
objConnection = (SqlConnection)objFactory.CreateConnection();
objCommand = (SqlCommand)objFactory.CreateCommand();
objConnection.ConnectionString = strConnectionString;
objCommand.Connection = objConnection;
}
public void Instantiate_CosmosDbSql_SqlClient()
{
var factory = new SqlClientFactory();
var session = factory.Instantiate("Endpoint=https://xyz.graphs.azure.com:443;AuthKey=@uthk3y;database=db;collection=FoF;api=sql");
Assert.That(session, Is.Not.Null);
Assert.That(session, Is.TypeOf <SqlClient>());
}
public void CreatePermissionTest()
{
SqlClientFactory factory = SqlClientFactory.Instance;
CodeAccessPermission permission, perm;
permission = factory.CreatePermission(PermissionState.None);
perm = factory.CreatePermission(PermissionState.Unrestricted);
Assert.AreEqual(false, perm.IsSubsetOf(permission), "#1");
}
public void InstantiateCreate_CosmosDbConnectionString_ISession()
{
var factory = new SqlClientFactory();
var session = factory.Instantiate($"Endpoint=https://xyz.graphs.azure.com:443;AuthKey={base64AuthKey};database=db;collection=FoF;api=sql");
var underlyingSession = session.CreateNew();
Assert.That(underlyingSession, Is.Not.Null);
Assert.That(underlyingSession, Is.AssignableTo <SqlClientOperation>());
}
private void MainForm_Load(object sender, EventArgs e)
{
SqlClientFactory factory = SqlClientFactory.Instance;
DbConnection connection = factory.CreateConnection();
DbCommand command = factory.CreateCommand();
command.Connection = connection;
command.CommandText = "query here";
command.ExecuteNonQuery();
}
public void Execute_NullString_ScalarReturned()
{
SqlClient session = new SqlClientFactory().Instantiate(ConnectionStringReader.GetLocaleSql()) as SqlClient;
var statement = Mock.Of <IQuery>(x => x.Statement == "SELECT VALUE p.lastName[0]._value FROM ROOT p WHERE p.label = 'person' and p.firstName[0]._value = 'Thomas'");
SqlCommandOperation cosmosdbQuery = new SqlCommandFactory().Instantiate(session, statement).Implementation as SqlCommandOperation;
var engine = new SqlExecutionEngine(session.CreateClientOperation(), cosmosdbQuery);
var count = engine.ExecuteScalar();
Assert.That(count, Is.Null);
}
public void Execute_Integer_ScalarReturned()
{
SqlClient session = new SqlClientFactory().Instantiate(ConnectionStringReader.GetLocaleSql()) as SqlClient;
var statement = Mock.Of <IQuery>(x => x.Statement == "SELECT VALUE count(1) FROM FoF f WHERE f.label='person'");
SqlCommandOperation cosmosdbQuery = new SqlCommandFactory().Instantiate(session, statement).Implementation as SqlCommandOperation;
var engine = new SqlExecutionEngine(session.CreateClientOperation(), cosmosdbQuery);
var age = engine.ExecuteScalar();
Assert.That(age, Is.EqualTo(4));
}
public void Execute_ListOfString_ListReturned()
{
SqlClient session = new SqlClientFactory().Instantiate(ConnectionStringReader.GetLocaleSql()) as SqlClient;
var statement = Mock.Of <IQuery>(x => x.Statement == "SELECT VALUE p.lastName[0]._value FROM ROOT p WHERE p.label = 'person'");
SqlCommandOperation cosmosdbQuery = new SqlCommandFactory().Instantiate(session, statement).Implementation as SqlCommandOperation;
var engine = new SqlExecutionEngine(session.CreateClientOperation(), cosmosdbQuery);
var count = engine.ExecuteList <object>();
Assert.That(count, Has.Member("Andersen"));
Assert.That(count, Has.Member("Miller"));
Assert.That(count, Has.Member("Wakefield"));
}
public void Instantiate_NoParameter_CorrectResultSet()
{
var client = new SqlClientFactory().Instantiate(ConnectionStringReader.GetLocaleSql()) as SqlClient;
var query = Mock.Of <IQuery>(
x => x.Statement == "SELECT * FROM FoF f WHERE f.label='person'"
);
var factory = new SqlCommandFactory();
var command = (factory.Instantiate(client, query, null).Implementation) as SqlCommandOperation;
var statement = command.Create();
var clientOperation = client.CreateClientOperation();
var results = clientOperation.Run(statement);
Assert.That(results.Count, Is.EqualTo(4));
}
static bool CheckDBInit(string connectionString)
{
SqlClientFactory newFactory = SqlClientFactory.Instance;
SqlConnection sqlConnection = new SqlConnection(connectionString);
sqlConnection.Open();
DbCommand cmd = newFactory.CreateCommand();
//MSSQL, Pstrgre и MySQL
cmd.CommandText = "select case when exists((select* from information_schema.tables where table_name = 'OrleansQuery')) then 1 else 0 end";
cmd.Connection = sqlConnection;
var res = (int)cmd.ExecuteScalar();
return(res == 1);
}
public void Execute_ProjectionOfObjects_DataSetFilled()
{
SqlClient session = new SqlClientFactory().Instantiate(ConnectionStringReader.GetLocaleSql()) as SqlClient;
var statement = Mock.Of <IQuery>(x => x.Statement == "SELECT p.firstName[0]._value as FirstName, p.age[0]._value as Age FROM ROOT p WHERE p.label = 'person'");
SqlCommandOperation commandOperation = new SqlCommandFactory().Instantiate(session, statement).Implementation as SqlCommandOperation;
var engine = new SqlExecutionEngine(session.CreateClientOperation(), commandOperation);
var ds = engine.Execute();
Assert.That(ds.Tables, Has.Count.EqualTo(1));
Assert.That(ds.Tables[0].Rows, Has.Count.EqualTo(4));
Assert.That(ds.Tables[0].Columns, Has.Count.EqualTo(2));
Assert.That(ds.Tables[0].Columns.Cast <DataColumn>().Select(x => x.ColumnName), Has.Member("FirstName"));
Assert.That(ds.Tables[0].Columns.Cast <DataColumn>().Select(x => x.ColumnName), Has.Member("Age"));
var firstNames = new List <object>();
var ages = new List <object>();
foreach (DataRow row in ds.Tables[0].Rows)
{
for (int i = 0; i < ds.Tables[0].Columns.Count; i++)
{
if (row.Table.Columns[i].ColumnName == "FirstName")
{
firstNames.Add(row.ItemArray[i]);
}
else if (row.Table.Columns[i].ColumnName == "Age")
{
ages.Add(row.ItemArray[i]);
}
}
}
foreach (var expectedFirstName in new[] { "Thomas", "Mary", "Ben", "Robin" })
{
Assert.That(firstNames, Has.Member(expectedFirstName));
}
foreach (var expectedAge in new object[] { 44, 39 })
{
Assert.That(ages, Has.Member(expectedAge));
}
}
public void Execute_Vertex_DataSetFilled()
{
SqlClient client = new SqlClientFactory().Instantiate(ConnectionStringReader.GetLocaleSql()) as SqlClient;
var statement = Mock.Of <IQuery>(x => x.Statement == "SELECT * FROM FoF f WHERE f.label='person'");
SqlCommandOperation commandOperation = new SqlCommandFactory().Instantiate(client, statement).Implementation as SqlCommandOperation;
var engine = new SqlExecutionEngine(client.CreateClientOperation(), commandOperation);
var ds = engine.Execute();
Assert.That(ds.Tables, Has.Count.EqualTo(1));
Assert.That(ds.Tables[0].Rows, Has.Count.EqualTo(4));
Assert.That(ds.Tables[0].Columns.Cast <DataColumn>().Select(x => x.ColumnName), Has.Member("id"));
Assert.That(ds.Tables[0].Columns.Cast <DataColumn>().Select(x => x.ColumnName), Has.Member("label"));
Assert.That(ds.Tables[0].Columns.Cast <DataColumn>().Select(x => x.ColumnName), Has.Member("firstName"));
Assert.That(ds.Tables[0].Columns.Cast <DataColumn>().Select(x => x.ColumnName), Has.Member("age"));
}
static bool InitDB(string connectionString)
{
SqlClientFactory newFactory = SqlClientFactory.Instance;
SqlConnection sqlConnection = new SqlConnection(connectionString);
sqlConnection.Open();
if (!Directory.Exists("OrleansAdoNetContent\\SQLServer"))
{
return(false);
}
;
//xxx-Main should be the first :)
foreach (var scriptFile in Directory.GetFiles("OrleansAdoNetContent\\SQLServer", "*.sql").OrderByDescending(c => c.Contains("Main")))
{
DbCommand cmd = newFactory.CreateCommand();
cmd.CommandText = File.ReadAllText(scriptFile);
cmd.Connection = sqlConnection;
cmd.ExecuteNonQuery();
}
sqlConnection.Close();
return(true);
}
public UserInfraDAPPER()
{
factory = new SqlClientFactory();
}
public ConnectionFactory(IConfiguration config)
{
connectionString = config[ConnectionName];
provider = SqlClientFactory.Instance;
}
public void CanHandle_OleDbConnectionString_False()
{
var factory = new SqlClientFactory();
Assert.That(factory.CanHandle("data source=SERVER;initial catalog=DB;IntegratedSecurity=true;Provider=OLEDB.1"), Is.False);
}
public void CanHandle_CosmosDbSql_True()
{
var factory = new SqlClientFactory();
Assert.That(factory.CanHandle("Endpoint=https://xyz.graphs.azure.com:443;AuthKey=@uthk3y;database=db;collection=FoF;api=sql"), Is.True);
}
static SqlClientFactory()
{
Instance = new SqlClientFactory();
}
public DataAccess(SqlClientFactory sQLClientFactory, ApplicationSettings applicationSettings)
{
Connection = sQLClientFactory.CreateConnection();
Connection.ConnectionString = applicationSettings.ConnectionString;
}
/// <summary>
/// Initializes a new instance of the <see cref="MssqlFactory"/> class.
/// </summary>
protected MssqlFactory()
{
sqlClientFactory = SqlClientFactory.Instance;
}
