public void DisposeCreateDbCommandTest()
{
BigQueryConnection connection = new BigQueryConnection(ConnectionStringHelper.OAuthConnectionString);
connection.Dispose();
Assert.Throws <ObjectDisposedException>(() => { connection.CreateCommand(); });
}
public void DisposeOpenConnectionTest()
{
BigQueryConnection connection = new BigQueryConnection(ConnectionStringHelper.OAuthConnectionString);
connection.Dispose();
Assert.Throws <ObjectDisposedException>(() => { connection.Open(); });
}
public void DisposeDisposeConnectionTest()
{
BigQueryConnection connection = new BigQueryConnection(ConnectionStringHelper.OAuthConnectionString);
connection.Dispose();
connection.Dispose();
}
public void DisposeGetTableNamesTest()
{
BigQueryConnection connection = new BigQueryConnection(ConnectionStringHelper.OAuthConnectionString);
connection.Dispose();
Assert.Throws <ObjectDisposedException>(() => { connection.GetTableNames(); });
}
public void GetViewNamesTest()
{
using (BigQueryConnection connection = new BigQueryConnection(ConnectionStringHelper.OAuthConnectionString)) {
connection.Open();
string[] tableNames = connection.GetViewNames();
Assert.Single(tableNames);
Assert.Equal(TestingInfrastructureHelper.NatalityViewName, tableNames[0]);
}
}
public void GetDataSetNamesTest()
{
using (BigQueryConnection connection = new BigQueryConnection(ConnectionStringHelper.OAuthConnectionString)) {
connection.Open();
string[] dataSetNames = connection.GetDataSetNames();
Assert.Single(dataSetNames);
Assert.Equal("testdata", dataSetNames[0]);
}
}
public void ChangeDatabaseCloseTest()
{
using (BigQueryConnection connection = new BigQueryConnection(ConnectionStringHelper.OAuthConnectionString)) {
string newDatabase = "";
connection.ChangeDatabase(newDatabase);
Assert.NotNull(connection.Service);
Assert.Equal(connection.DataSetId, newDatabase);
Assert.Equal(ConnectionState.Open, connection.State);
}
}
protected BigQueryCommandTestsBase() {
natalitySchemaTable = new DataTable();
natalitySchemaTable.Columns.Add("ColumnName", typeof (string));
natalitySchemaTable.Columns.Add("DataType", typeof (Type));
natalitySchemaTable.Rows.Add("weight_pounds", typeof (float));
natalitySchemaTable.Rows.Add("is_male", typeof (bool));
connection = new BigQueryConnection(GetConnectionString());
connection.Open();
}
public void GetTableNamesTest()
{
using (BigQueryConnection connection = new BigQueryConnection(ConnectionStringHelper.OAuthConnectionString)) {
connection.Open();
string[] tableNames = connection.GetTableNames();
Assert.Equal(3, tableNames.Length);
Assert.Equal(TestingInfrastructureHelper.NatalityTableName, tableNames[0]);
Assert.Equal(TestingInfrastructureHelper.Natality2TableName, tableNames[1]);
Assert.Equal(TestingInfrastructureHelper.TimesTableName, tableNames[2]);
}
}
public void openConnection_SuccessTest()
{
// given
var connectionStringBuilder = new BigQueryConnectionStringBuilder();
// when
using BigQueryConnection connection = new BigQueryConnection(connectionStringBuilder.ToString());
connection.Open();
// then
Assert.AreEqual(ConnectionState.Open, connection.State);
}
public async void OpenConnectionTest_Async() {
using (BigQueryConnection connection = new BigQueryConnection(ConnectionStringHelper.OAuthConnectionString)) {
Assert.NotNull(connection.ConnectionString);
Assert.True(string.Equals(ConnectionStringHelper.OAuthConnectionString, connection.ConnectionString, StringComparison.OrdinalIgnoreCase));
Assert.Equal(ConnectionState.Closed, connection.State);
Assert.Null(connection.Service);
await connection.OpenAsync();
Assert.NotNull(connection.ConnectionString);
Assert.True(string.Equals(ConnectionStringHelper.OAuthConnectionString, connection.ConnectionString, StringComparison.OrdinalIgnoreCase));
Assert.Equal(ConnectionState.Open, connection.State);
Assert.NotNull(connection.Service);
}
}
public void OpenConnectionTest()
{
using (BigQueryConnection connection = new BigQueryConnection(ConnectionStringHelper.OAuthConnectionString)) {
Assert.NotNull(connection.ConnectionString);
Assert.Equal(ConnectionStringHelper.OAuthConnectionString, connection.ConnectionString, ignoreCase: true);
Assert.Equal(ConnectionState.Closed, connection.State);
Assert.Null(connection.Service);
connection.Open();
Assert.NotNull(connection.ConnectionString);
Assert.Equal(ConnectionStringHelper.OAuthConnectionString, connection.ConnectionString, ignoreCase: true);
Assert.Equal(ConnectionState.Open, connection.State);
Assert.NotNull(connection.Service);
}
}
public void Get_DataSets_SuccessTest()
{
// given
var connectionString = new BigQueryConnectionStringBuilder().ToString();
using BigQueryConnection connection = new BigQueryConnection(connectionString);
connection.Open();
// when
string[] dataSetNames = connection.GetDataSetNames();
// then
Assert.IsNotEmpty(dataSetNames);
}
public void CreateDbCommandTest()
{
using (BigQueryConnection connection = new BigQueryConnection(ConnectionStringHelper.OAuthConnectionString)) {
connection.Open();
var dbCommand = connection.CreateCommand();
Assert.NotNull(dbCommand);
Assert.NotNull(dbCommand.Connection);
Assert.Same(connection, dbCommand.Connection);
Assert.Equal("", dbCommand.CommandText);
Assert.Null(dbCommand.Transaction);
Assert.NotNull(dbCommand.Parameters);
Assert.Empty(dbCommand.Parameters);
Assert.Equal((CommandType)0, dbCommand.CommandType);
}
}
public void OpenDisposeConnectionTest() {
BigQueryConnection connection;
using(connection = new BigQueryConnection(ConnectionStringHelper.OAuthConnectionString)) {
Assert.NotNull(connection.ConnectionString);
Assert.True(string.Equals(ConnectionStringHelper.OAuthConnectionString, connection.ConnectionString, StringComparison.OrdinalIgnoreCase));
Assert.Equal(ConnectionState.Closed, connection.State);
Assert.Null(connection.Service);
connection.Open();
Assert.NotNull(connection.ConnectionString);
Assert.True(string.Equals(ConnectionStringHelper.OAuthConnectionString, connection.ConnectionString, StringComparison.OrdinalIgnoreCase));
Assert.Equal(ConnectionState.Open, connection.State);
Assert.NotNull(connection.Service);
connection.Dispose();
}
Assert.Equal(ConnectionState.Closed, connection.State);
}
protected BigQueryCommandTestsBase()
{
natalitySchemaTable = new DataTable();
natalitySchemaTable.Columns.Add("ColumnName", typeof(string));
natalitySchemaTable.Columns.Add("DataType", typeof(Type));
natalitySchemaTable.Rows.Add("weight_pounds", typeof(float));
natalitySchemaTable.Rows.Add("is_male", typeof(bool));
#region consts
commandText = $"select * from {FormatTable(dataSetName, TestingInfrastructureHelper.NatalityTableName)} limit 10";
commandTextWithFilter = $"select * from {FormatTable(dataSetName, TestingInfrastructureHelper.Natality2TableName)} where {{0}} limit 10";
#endregion
connection = new BigQueryConnection(PatchConnectionString(GetConnectionString()));
connection.Open();
}
public TestingInfrastructureHelper()
{
connection = new BigQueryConnection(ConnectionStringHelper.JsonConnectionString);
connection.Open();
}
public void CreateDbCommandTest() {
using(BigQueryConnection connection = new BigQueryConnection(ConnectionStringHelper.OAuthConnectionString)) {
connection.Open();
var dbCommand = connection.CreateCommand();
Assert.NotNull(dbCommand);
Assert.NotNull(dbCommand.Connection);
Assert.Same(connection, dbCommand.Connection);
Assert.Equal("", dbCommand.CommandText);
Assert.Null(dbCommand.Transaction);
Assert.NotNull(dbCommand.Parameters);
Assert.Equal(0, dbCommand.Parameters.Count);
Assert.Equal((CommandType)0, dbCommand.CommandType);
}
}
public void ChangeDatabaseCloseTest() {
using(BigQueryConnection connection = new BigQueryConnection(ConnectionStringHelper.OAuthConnectionString)) {
string newDatabase = "";
connection.ChangeDatabase(newDatabase);
Assert.NotNull(connection.Service);
Assert.Equal(connection.DataSetId, newDatabase);
Assert.Equal(connection.State, ConnectionState.Open);
}
}
public void DisposeChangeDatabaseTest() {
BigQueryConnection connection = new BigQueryConnection(ConnectionStringHelper.OAuthConnectionString);
connection.Open();
connection.Dispose();
Assert.Throws<ObjectDisposedException>(() => {
connection.ChangeDatabase("");
});
}
public void DisposeCloseConnectionTest() {
BigQueryConnection connection = new BigQueryConnection(ConnectionStringHelper.OAuthConnectionString);
connection.Dispose();
Assert.Throws<ObjectDisposedException>(() => {
connection.Close();
});
}
public void DisposeDisposeConnectionTest() {
BigQueryConnection connection = new BigQueryConnection(ConnectionStringHelper.OAuthConnectionString);
connection.Dispose();
connection.Dispose();
}
public void GetDataSetNamesTest() {
using(BigQueryConnection connection = new BigQueryConnection(ConnectionStringHelper.OAuthConnectionString)) {
connection.Open();
string[] dataSetNames = connection.GetDataSetNames();
Assert.Equal(1, dataSetNames.Length);
Assert.Equal("testdata", dataSetNames[0]);
}
}
public void GetTableNamesTest() {
using(BigQueryConnection connection = new BigQueryConnection(ConnectionStringHelper.OAuthConnectionString)) {
connection.Open();
string[] tableNames = connection.GetTableNames();
Assert.Equal(2, tableNames.Length);
Assert.Equal(TestingInfrastructureHelper.NatalityTableName, tableNames[0]);
Assert.Equal(TestingInfrastructureHelper.Natality2TableName, tableNames[1]);
}
}
public TestingInfrastructureHelper()
{
connection = new BigQueryConnection(ConnectionStringHelper.P12ConnectionString);
connection.Open();
}
/// <summary>
/// Constructs a <see cref="BigQueryQueryProvider"/>
/// </summary>
public BigQueryQueryProvider(BigQueryConnection connection, QueryMapping mapping = null, QueryPolicy policy = null)
: base(connection, BigQueryLanguage.Default, mapping, policy)
{
}
