DavidPx

These are CopyQ commands I use for copying data out of spreadsheets and into SQL windows.

single-quoted-list.ini is good for creating an in clause from a single column of values.

values-grid.ini is good for creating the values section of an insert statement.

Installing these is quite easy:

1. Copy the script
2. Within Copyq hit F6 to bring up the Command editor
3. Now click the Paste Commands button

DavidPx

  public class FileEvent
  {
    public FileEvent(string fullPath, WatcherChangeTypes changeTypes)
    {
      FullPath = fullPath;
      ChangeType = changeTypes;
    }
    public string FullPath { get; set; }
    public WatcherChangeTypes ChangeType { get; set; }
 }

DavidPx

// Everyone has their own set of oddball extension methods.. here are mine.

void Main()
{
	// Write code to test your extensions here. Press F5 to compile and run.
}

public static class MyExtensions
{
	/// <summary>

DavidPx

// Add this to LinqPad "C# Program"
//  Example use:
//  Insead of this: (create a List<CS_POSITION>)
//  CS_POSITIONs.InsertOnSubmit(position);  
//  This:
//  positions.Add(position);
//  
//  Then instead of this:
//  SubmitChanges()
//  This:

DavidPx

public class Program : IProgram
{
	public Program(/* stuff your program needs */)
	{
	}
  
	private static void Main(string[] args)
	{
			var serviceProvider = Startup.RegisterDependencies(); // note that we do not pass in a DI modifier
			var program = (IProgram)serviceProvider.GetService(typeof(IProgram));

DavidPx

<Query Kind="Statements">
  <NuGetReference>CsvHelper</NuGetReference>
  <Namespace>CsvHelper</Namespace>
</Query>

// NPR Sunday Puzzle for 2017-12-24

// city data: https://github.com/grammakov/USA-cities-and-states

var cities = new List<string>();

DavidPx

; this has been tested on 1.12.2 against this farm: https://www.youtube.com/watch?v=Y31TEbKjSpg

; ctrl + alt + f starts the loop.  Every 1/2 second the right mouse button is clicked.
^!f::
	BreakLoop = 0
	Loop
	{
		if (BreakLoop = 1)
		{
			BreakLoop = 0