Loïc Sharma loic-sharma

Developer on the Flutter team

loic-sharma / script.ps1

Created May 3, 2018 21:59

Script to find all packages that depend on a specific package

	$package = 'Newtonsoft.Json'

	$connection = "TODO..."

	$done = @()
	$todo = @($package.ToLowerInvariant())

	while ($todo.Count -gt 0) {
	$next = $todo \| Select-Object -First 50
	$nextIn = [string]::Join(',', @($next \| % { "'$($_)'" }))

loic-sharma / Program.cs

Created May 4, 2018 20:59

Repository sign a NuGet Package

	using System;
	using System.IO;
	using System.Security.Cryptography.X509Certificates;
	using System.Threading.Tasks;
	using NuGet.Packaging.Signing;

	namespace ConsoleApp7
	{
	using System.Threading;
	using NuGet.Common;

loic-sharma / prepare.ps1

Last active October 10, 2023 20:18

Scripts to setup development VM

	# Requires:
	# Set-ExecutionPolicy RemoteSigned -s CurrentUser

	# Install apps
	iex (New-Object Net.WebClient).DownloadString('https://get.scoop.sh')

	scoop install git

	scoop bucket add extras
	scoop install vscode

loic-sharma / Program.cs

Last active August 3, 2018 04:32

Authenticating to a private BaGet feed using Azure Active Directory's Device Flow Authentication

	using System;
	using System.Net.Http;
	using System.Net.Http.Headers;
	using System.Text;
	using System.Threading.Tasks;
	using Microsoft.IdentityModel.Clients.ActiveDirectory;

	namespace DeviceFlow
	{
	class Program

loic-sharma / Program.cs

Created June 7, 2019 23:18

azs-clean

	using Microsoft.Azure.Search;
	using Microsoft.Azure.Storage;
	using System;
	using System.Collections.Concurrent;
	using System.Linq;
	using System.Threading.Tasks;

	namespace azs_clean
	{
	public class Program

loic-sharma / RefreshNonCommunityPackageList.sql

Created July 3, 2019 00:36

	BEGIN TRANSACTION;

	IF NOT EXISTS (SELECT * FROM [dbo].[Dimension_PackageSet] WHERE [Name] = 'NonCommunityPackages')
	BEGIN
	INSERT INTO [dbo].[Dimension_PackageSet] (Name) VALUES ('NonCommunityPackages')
	END

	DECLARE @NonCommunityPackagesId int = (SELECT [Id] FROM [dbo].[Dimension_PackageSet] WHERE [Name] = 'NonCommunityPackages');

	DELETE FROM [dbo].[Fact_Package_PackageSet]

loic-sharma / Program.cs

Last active September 11, 2019 06:47

Improving NuGetVersion parse performance

	using System;
	using BenchmarkDotNet.Attributes;
	using BenchmarkDotNet.Running;

	namespace ConsoleApp1
	{
	class Program
	{
	static void Main(string[] args)
	{

loic-sharma / ConsoleApp17.csproj

Last active January 22, 2020 18:13

Get the download count for all versions of a package

	<Project Sdk="Microsoft.NET.Sdk">

	<PropertyGroup>
	<OutputType>Exe</OutputType>
	<TargetFramework>netcoreapp3.1</TargetFramework>
	</PropertyGroup>

	<ItemGroup>
	<PackageReference Include="NuGet.Protocol" Version="5.5.0-preview.1.6319" />
	</ItemGroup>

loic-sharma / ConsoleApp17.csproj

Last active January 22, 2020 19:27

Get the download count for all versions of a package

	<Project Sdk="Microsoft.NET.Sdk">

	<PropertyGroup>
	<OutputType>Exe</OutputType>
	<TargetFramework>netcoreapp3.1</TargetFramework>
	<LangVersion>8.0</LangVersion>
	</PropertyGroup>

	<ItemGroup>
	<PackageReference Include="NuGet.Protocol" Version="5.5.0-preview.1.6319" />

loic-sharma / Program.cs

Last active May 24, 2020 04:57

	using System;
	using System.IO;
	using System.IO.Compression;
	using System.Net.Http;
	using System.Threading.Tasks;

	namespace ConsoleApp2
	{
	class Program
	{