void UploadData(Table table)
{
Job job = new Job();
var config = new JobConfiguration();
var configLoad = new JobConfigurationLoad {
Schema = table.Schema,
DestinationTable = table.TableReference,
Encoding = "ISO-8859-1",
CreateDisposition = "CREATE_IF_NEEDED",
WriteDisposition = "",
FieldDelimiter = ",",
AllowJaggedRows = true,
SourceFormat = "CSV"
};
config.Load = configLoad;
job.Configuration = config;
var jobId = "---" + Environment.TickCount;
var jobRef = new JobReference {
JobId = jobId,
ProjectId = connection.ProjectId
};
job.JobReference = jobRef;
using (
Stream stream =
Assembly.GetExecutingAssembly()
.GetManifestResourceStream(
$"DevExpress.DataAccess.BigQuery.Tests.Tests.{table.TableReference.TableId}.csv")) {
var insertMediaUpload = new JobsResource.InsertMediaUpload(connection.Service,
job, job.JobReference.ProjectId, stream, "application/octet-stream");
insertMediaUpload.Upload();
}
while (true)
{
Job job1 = connection.Service.Jobs.Get(connection.ProjectId, jobId).Execute();
if (job1.Status.State.Equals("DONE"))
{
break;
}
Thread.Sleep(5000);
}
}
void UploadData(Table table)
{
Job job = new Job();
var config = new JobConfiguration();
var configLoad = new JobConfigurationLoad {
Schema = table.Schema,
DestinationTable = table.TableReference,
Encoding = "ISO-8859-1",
CreateDisposition = "CREATE_IF_NEEDED",
WriteDisposition = "",
FieldDelimiter = ",",
AllowJaggedRows = true,
SourceFormat = "CSV"
};
config.Load = configLoad;
job.Configuration = config;
var jobId = "---" + Environment.TickCount;
var jobRef = new JobReference {
JobId = jobId,
ProjectId = connection.ProjectId
};
job.JobReference = jobRef;
using (
Stream stream =
Assembly.GetExecutingAssembly()
.GetManifestResourceStream(string.Format("DevExpress.DataAccess.BigQuery.Tests.{0}.csv",
table.TableReference.TableId))) {
var insertMediaUpload = new JobsResource.InsertMediaUpload(connection.Service,
job, job.JobReference.ProjectId, stream, "application/octet-stream");
insertMediaUpload.Upload();
}
while (true) {
Job job1 = connection.Service.Jobs.Get(connection.ProjectId, jobId).Execute();
if (job1.Status.State.Equals("DONE")) {
break;
}
Thread.Sleep(5000);
}
}