arshad115

FROM ubuntu:18.10

# non interactive frontend for locales
ENV DEBIAN_FRONTEND=noninteractive

# installing texlive and utils
RUN apt-get update && \
    apt-get -y install --no-install-recommends pandoc texlive texlive-latex-extra texlive-generic-extra texlive-extra-utils texlive-fonts-extra texlive-bibtex-extra biber latexmk make git procps locales curl && \
    rm -rf /var/lib/apt/lists/*

arshad115

Collection of Useful SQL queries

/* Count Number Of Tables In A Database */
SELECT COUNT(*) AS TABLE_COUNT FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE'
 
/* Count Number Of Views In A Database */
SELECT COUNT(*) AS VIEW_COUNT FROM INFORMATION_SCHEMA.VIEWS
 
/* Count Number Of Stored Procedures In A Database */

arshad115

How to bind data correctly with ng-model with angular uib-datepicker-popup

If you get a date from a database and you bind it to the Angular ui datepicker and it does not bind correctly, you just have to convert it into a date object on init like:

JS

data.bsc = new Date(data.bsc);

HTML

arshad115

    /***
     * Android L (lollipop, API 21) introduced a new problem when trying to invoke implicit intent,
     * "java.lang.IllegalArgumentException: Service Intent must be explicit"
     *
     * The function given here works for a single application package with the same intent filter. 
     * https://gist.github.com/SeanZoR/068f19545e51e4627749
     * 
     * I had a scenario in which there was a free version and a paid version of the same app installed, this function returns null in that case. 
     * So I decided to fix it and here is the working solution which matches the application package and then returns the correct intent.
     *