async Task Execute(string[] args)
{
Configure(args);
Console.WriteLine("Read configuration, logging in...");
await GoogleLogin();
Console.WriteLine("Logged in, downloading spreadsheet...");
var spreadsheet = await GoogleSheets.GetByDataFilter(new GetSpreadsheetByDataFilterRequest {
DataFilters = new[] { new DataFilter {
A1Range = "A1:F"
} },
IncludeGridData = true
}, Configuration["sheet"]).ExecuteAsync();
var sheet = spreadsheet.Sheets[0];
var cells = sheet.Data[0];
Console.WriteLine("Spreadsheet downloaded, starting searches...");
int currentRowNum = 0;
List <Task <Request> > requests = new List <Task <Request> >();
foreach (var row in cells.RowData)
{
currentRowNum++;
int rowNum = currentRowNum;
Func <Task <Request> > func = async() => {
if (rowNum < 2)
{
return(null);
}
var name = row.Values[0].FormattedValue;
if (name == "" || name == null)
{
return(null);
}
var number = row.Values[1].FormattedValue;
if (number == null)
{
number = "";
}
var set = row.Values[2].FormattedValue;
if (set == null)
{
set = "";
}
var oldLink = row.Values[5].FormattedValue;
if (oldLink != "" && oldLink != null)
{
Console.WriteLine($"skipping card {rowNum - 1}...");
return(null);
}
var query = $"buy \"{name}\" {set} {number} pokemon";
var request = GoogleSearch.Siterestrict.List(query);
request.Cx = Configuration["google-custom-search-cx"];
var list = await request.ExecuteAsync();
var attempts = 0;
var result = "";
if ((list?.Items?.Count ?? 0) < 1)
{
Console.WriteLine($"Query '{query}' for {name} had no results, skipping...");
return(null);
}
foreach (var possibleResult in list.Items)
{
var str = possibleResult.Link;
attempts++;
if (attempts > 5)
{
break;
}
if (!str.Contains(TCGPlayerSlug(set)))
{
continue;
}
if (str.Contains("deck") || str.Contains("product") || str.Contains("price-guide") || str.Contains("secret-rare"))
{
continue;
}
if (set != "" && new Regex(".*-[ -km-uw-~]+[0-9]+$").Match(str).Success&& !set.ToLower().Contains("promo"))
{
continue;
}
if (str.Contains("lvx") && !name.ToLower().Contains("lv"))
{
continue;
}
if (str.Count(f => f == '/') < 5)
{
continue;
}
if (str.Contains(TCGPlayerSlug(name)))
{
result = str; break;
}
}
if (result == "")
{
foreach (var possibleResult in list.Items)
{
var str = possibleResult.Link;
if (str.Contains("deck") || str.Contains("product") || str.Contains("price-guide") || str.Contains("secret-rare"))
{
continue;
}
if (set != "" && new Regex(".*-[ -km-uw-~]+[0-9]+$").Match(str).Success&& !set.ToLower().Contains("promo"))
{
continue;
}
if (str.Contains("lvx") && !name.ToLower().Contains("lv"))
{
continue;
}
if (str.Count(f => f == '/') < 5)
{
continue;
}
if (str.Contains(TCGPlayerSlug(name)))
{
result = str; break;
}
}
}
if (result == "")
{
Console.WriteLine($"defaulting to \"{result = list?.Items?[0]?.Link ?? ""}\"");
}
if (number != "" && !result.EndsWith(number.ToString()) && !(new Regex(".*-lv[0-9]+$")).Match(result).Success)
{
result = (new Regex("[0-9]+$")).Replace(result, number.ToString());
}
var link = new CellData();
link.UserEnteredValue = new ExtendedValue {
StringValue = result
};
var valueUpdateRequest = new Request {
UpdateCells = new UpdateCellsRequest {
Fields = "*",
Start = new GridCoordinate {
ColumnIndex = 5,
RowIndex = rowNum - 1
},
Rows = new[] { new RowData {
Values = new[] { link }
} }
}
};
Console.WriteLine($"card {rowNum - 1} ({name}): '{query}'...");
return(valueUpdateRequest);
};
requests.Add(func());
}
;
var finishedRequests = (await Task.WhenAll <Request>(requests)).Where(e => e != null);
Console.WriteLine("Sending updates...");
if (finishedRequests.Count() > 0)
{
var sheetUpdateRequest = new BatchUpdateSpreadsheetRequest {
Requests = finishedRequests.ToList()
};
await GoogleSheets.BatchUpdate(sheetUpdateRequest, Configuration["sheet"]).ExecuteAsync();
}
Console.WriteLine("Updates sent, exiting...");
}
