wcoder

#!/bin/bash

DOC_ID=''
SHEET_ID=0
TMP_FILE='temp.csv'
OUTPUT_FILE='result.json'

# export csv
curl -L "https://docs.google.com/spreadsheets/d/$DOC_ID/export?format=csv&gid=$SHEET_ID" -o $TMP_FILE

wcoder

#!/usr/bin/env node

// How to
// wget http://gist.github.com/...
// chmod +x ya.js
// ./ya.js download_url path/to/directory

const https = require('https');
const { URL } = require('url');
const { spawn } = require('child_process');

wcoder

#!/bin/bash

PP="$HOME/Library/MobileDevice/Provisioning Profiles"

echo $PP

echo "All Provisioning Profiles:"
ls -al "$PP"

echo "Decoded Provisioning Profiles:"

wcoder

import admin from 'firebase-admin';

/**
 * Firestore does not accept more than 500 writes in a transaction or batch write.
 */
const MAX_TRANSACTION_WRITES = 499;

type WriteBigBatchOperationType = (batch: admin.firestore.WriteBatch) => void;
type WriteBigBatchCallbackType = (operation: WriteBigBatchOperationType) => void;

wcoder

using System;


public static class StringExtensions
{
    public static string Format(this string str, params object[] parameters)
    {
        return string.Format(str, parameters);
    }
    

wcoder

Xamarin.Android

How to get Java class from C# type?

Java.Lang.Class has a special method for managed types:

Java | C# (Xamarin.Android)

wcoder

private T FindSpan<T>(TextView textView, ISpannable spannable, MotionEvent e)
    where T : Java.Lang.Object
{
    var x = (int)e.GetX() - textView.TotalPaddingLeft + textView.ScrollX;
    var y = (int)e.GetY() - textView.TotalPaddingTop + textView.ScrollY;

    var layout = textView.Layout;
    int position = layout.GetOffsetForHorizontal(layout.GetLineForVertical(y), x);

    var links = spannable.GetSpans(position, position, Java.Lang.Class.FromType(typeof(T)));

wcoder

private void SetLeftDrawableWithBounds(Button button, int drawableResId, Size size, Android.Graphics.Color tintColor) {
    var context = button.Context;
    var drawable = DrawableCompat.Wrap(AppCompatDrawableManager.Get().GetDrawable(context, drawableResId)).Mutate();
    drawable.SetBounds(0, 0, (int) context.ToPixels(size.Width), (int) context.ToPixels(size.Height));

    if (tintColor != Android.Graphics.Color.Transparent) {
        DrawableCompat.SetTint(drawable, tintColor);
    }

    button.SetCompoundDrawables(drawable, null, null, null);

wcoder

1. open text editor (with ability to replace text via regex)
2. open target .csproj file
3. start find and replace: (csproj")>\n(.*)Project>\n(.*)Name>\n(.*)ProjectReference>
4. to $1 />

wcoder

const { randomBytes } = require('crypto');

// Sources: https://github.com/firebase/firebase-js-sdk/blob/4090271bb71023c3e6587d8bd8315ebf99b3ccd7/packages/firestore/src/util/misc.ts#L27-L55
const newId = () => {
    // Alphanumeric characters
    const chars = 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789';
    // The largest byte value that is a multiple of `char.length`.
    const maxMultiple = Math.floor(256 / chars.length) * chars.length;

    let autoId = '';