public static QvxTable.GetRowsHandler ListBucketObjectsRows(IDictionary <string, string> fields, QvxTable table, string jsonCredentials)
{
return(() =>
{
List <QvxDataRow> rows = new List <QvxDataRow>();
GoogleCredential credential = null;
StorageClient storage = null;
Google.Api.Gax.PagedEnumerable <Objects, Google.Apis.Storage.v1.Data.Object> bucketObjects = null;
fields.TryGetValue("bucketname", out string bucketName);
if (String.IsNullOrEmpty(bucketName))
{
throw new QvxPleaseSendReplyException(QvxResult.QVX_UNKNOWN_COMMAND, String.Format("Missing required param: {0}", "BucketName"));
}
try
{
credential = GoogleCredential.FromJson(jsonCredentials);
storage = StorageClient.Create(credential);
bucketObjects = storage.ListObjects(bucketName, null, null);
foreach (Google.Apis.Storage.v1.Data.Object bucketObject in bucketObjects)
{
var row = new QvxDataRow();
row[table.Fields[0]] = bucketObject.Acl?.ToString() ?? "";
row[table.Fields[1]] = bucketObject.Bucket?.ToString() ?? "";
row[table.Fields[2]] = bucketObject.CacheControl?.ToString() ?? "";
row[table.Fields[3]] = bucketObject.ComponentCount ?? 0;
row[table.Fields[4]] = bucketObject.ContentDisposition?.ToString() ?? "";
row[table.Fields[5]] = bucketObject.ContentEncoding?.ToString() ?? "";
row[table.Fields[6]] = bucketObject.ContentLanguage?.ToString() ?? "";
row[table.Fields[7]] = bucketObject.Crc32c.ToString() ?? "";
row[table.Fields[8]] = bucketObject.ETag?.ToString() ?? "";
row[table.Fields[9]] = bucketObject.Generation?.ToString() ?? "";
row[table.Fields[10]] = bucketObject.Id?.ToString() ?? "";
row[table.Fields[11]] = bucketObject.Kind?.ToString() ?? "";
row[table.Fields[12]] = bucketObject.KmsKeyName?.ToString() ?? "";
row[table.Fields[13]] = bucketObject.Md5Hash?.ToString() ?? "";
row[table.Fields[14]] = bucketObject.MediaLink?.ToString() ?? "";
row[table.Fields[15]] = ""; // bucketObject.Metadata?.ToString() ?? "";
row[table.Fields[16]] = bucketObject.Metageneration ?? 0;
row[table.Fields[17]] = bucketObject.Name?.ToString() ?? "";
row[table.Fields[18]] = bucketObject.Owner?.ToString() ?? "";
row[table.Fields[19]] = bucketObject.SelfLink?.ToString() ?? "";
row[table.Fields[20]] = bucketObject.Size ?? 0;
row[table.Fields[21]] = bucketObject.StorageClass?.ToString() ?? "";
row[table.Fields[22]] = bucketObject.TimeCreatedRaw?.ToString() ?? "";
row[table.Fields[23]] = bucketObject.TimeDeletedRaw?.ToString() ?? "";
row[table.Fields[24]] = bucketObject.TimeStorageClassUpdatedRaw?.ToString() ?? "";
row[table.Fields[25]] = bucketObject.UpdatedRaw?.ToString() ?? "";
rows.Add(row);
}
}
catch (Exception ex)
{
QvxLog.Log(QvxLogFacility.Application, QvxLogSeverity.Error, ex.Message);
throw new QvxPleaseSendReplyException(QvxResult.QVX_UNKNOWN_COMMAND, "Error getting the data from Google Storage");
}
return rows;
});
}
public static QvxTable.GetRowsHandler ListBucketsRows(QvxTable table, string jsonCredentials)
{
string GCPProjectId = "";
try
{
var JSONObj = new JavaScriptSerializer().Deserialize <Dictionary <string, string> >(jsonCredentials);
GCPProjectId = JSONObj["project_id"];
} catch (Exception ex)
{
QvxLog.Log(QvxLogFacility.Application, QvxLogSeverity.Error, ex.Message);
throw new QvxPleaseSendReplyException(QvxResult.QVX_UNKNOWN_COMMAND, "Error parsing the JSON credentials file.");
}
return(() =>
{
List <QvxDataRow> rows = new List <QvxDataRow>();
GoogleCredential credential = null;
StorageClient storage = null;
Google.Api.Gax.PagedEnumerable <Buckets, Bucket> buckets = null;
try
{
credential = GoogleCredential.FromJson(jsonCredentials);
storage = StorageClient.Create(credential);
buckets = storage.ListBuckets(GCPProjectId);
} catch (Exception ex)
{
QvxLog.Log(QvxLogFacility.Application, QvxLogSeverity.Error, ex.Message);
throw new QvxPleaseSendReplyException(QvxResult.QVX_UNKNOWN_COMMAND, "Error getting the data from Google Storage");
}
int length = 0;
foreach (Bucket bucket in buckets)
{
length++;
}
if (length == 0)
{
throw new QvxPleaseSendReplyException(QvxResult.QVX_UNKNOWN_COMMAND, String.Format("No buckets found for project {0}", GCPProjectId));
}
else
{
foreach (Bucket bucket in buckets)
{
var row = new QvxDataRow();
row[table.Fields[0]] = bucket.Acl?.ToString() ?? "";
row[table.Fields[1]] = bucket.Billing?.ToString() ?? "";
row[table.Fields[2]] = bucket.Cors?.ToString() ?? "";
row[table.Fields[3]] = bucket.ETag?.ToString() ?? "";
row[table.Fields[4]] = bucket.Encryption?.ToString() ?? "";
row[table.Fields[5]] = bucket.Id?.ToString() ?? "";
row[table.Fields[6]] = bucket.Kind?.ToString() ?? "";
row[table.Fields[7]] = bucket.Labels?.ToString() ?? "";
row[table.Fields[8]] = bucket.Lifecycle?.ToString() ?? "";
row[table.Fields[9]] = bucket.Location?.ToString() ?? "";
row[table.Fields[10]] = bucket.Logging?.ToString() ?? "";
row[table.Fields[11]] = bucket.Name?.ToString() ?? "";
row[table.Fields[12]] = bucket.Owner?.ToString() ?? "";
rows.Add(row);
}
}
return rows;
});
}
