private void InstallNuGutPackage(NuGetPackage package, string branchNuGetUrl)
{
var downloadUrl = $"{branchNuGetUrl}/package/__{package.Branch.ToLower()}__{package.Id}/{package.Version}";
var packageName = $"{Args.PackagesPath}\\{package.Id}.{package.Version}\\{package.Id}.{package.Version}.nupkg";
ClearPackage(packageName);
(new WebClient()).DownloadFile(downloadUrl, packageName);
UnZipPackage(packageName);
}
public List <NuGetPackage> GetLatestVersions()
{
var result = new List <NuGetPackage>();
using (var conn = new SqlConnection(m_connectionString))
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText =
@"
SELECT MAX([Key]) AS LatestKey
INTO #Latest
FROM Packages WITH(NOLOCK)
GROUP BY PackageRegistrationKey
SELECT
PR.Id,
P.Tags,
P.Title,
P.[Version],
PF.TargetFramework
FROM #Latest T
INNER JOIN Packages P WITH(NOLOCK)
ON P.[Key] = T.LatestKey
INNER JOIN PackageRegistrations PR WITH(NOLOCK)
ON PR.[Key] = P.PackageRegistrationKey
INNER JOIN PackageFrameworks PF WITH(NOLOCK)
ON PF.[Key] = P.[Key]
DROP TABLE #Latest
" ;
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var id = reader.ReadString("Id");
var version = reader.ReadString("Version");
var framework = reader.ReadString("TargetFramework");
var title = reader.ReadStringOrNull("Title");
var tags = reader.ReadStringOrNull("Tags");
var package = new NuGetPackage(id, version, framework, title, tags);
result.Add(package);
}
}
}
}
return(result);
}
public List<NuGetPackage> GetLatestVersions()
{
var result = new List<NuGetPackage>();
using (var conn = new SqlConnection(m_connectionString))
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText =
@"
SELECT MAX([Key]) AS LatestKey
INTO #Latest
FROM Packages WITH(NOLOCK)
GROUP BY PackageRegistrationKey
SELECT
PR.Id,
P.Tags,
P.Title,
P.[Version],
PF.TargetFramework
FROM #Latest T
INNER JOIN Packages P WITH(NOLOCK)
ON P.[Key] = T.LatestKey
INNER JOIN PackageRegistrations PR WITH(NOLOCK)
ON PR.[Key] = P.PackageRegistrationKey
INNER JOIN PackageFrameworks PF WITH(NOLOCK)
ON PF.[Key] = P.[Key]
DROP TABLE #Latest
";
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var id = reader.ReadString("Id");
var version = reader.ReadString("Version");
var framework = reader.ReadString("TargetFramework");
var title = reader.ReadStringOrNull("Title");
var tags = reader.ReadStringOrNull("Tags");
var package = new NuGetPackage(id, version, framework, title, tags);
result.Add(package);
}
}
}
}
return result;
}
