Check if a Service is Already Running in Android

private boolean isServiceRunning(Class<?> serviceClass) {
    ActivityManager manager = (ActivityManager) getSystemService(Context.ACTIVITY_SERVICE);
    for (ActivityManager.RunningServiceInfo service : manager.getRunningServices(Integer.MAX_VALUE)) {
        if (serviceClass.getName().equals(service.service.getClassName())) {
            return true;
        }
    }
    return false;
}
Advertisements

Rename a local and remote branch in git

If you have named a branch incorrectly AND pushed this to the remote repository follow these steps before any other developers get a chance to jump on you and give you shit for not correctly following naming conventions.

1. Rename your local branch.
If you are on the branch you want to rename:

1
git branch -m new-name

If you are on a different branch:

1
git branch -m old-name new-name

2. Delete the old-name remote branch and push the new-name local branch.

1
git push origin :old-name new-name

3. Reset the upstream branch for the new-name local branch.
Switch to the branch and then:

1
git push origin -u new-name

Validating JSON in SQL Server 2016

SQL Server 2016 and upwards has a useful feature where JSON data can be validated through SQL Code.

There are two ways of doing this:

Inline in a SQL Function/Procedure

IF (ISJSON(@json) = 1)
BEGIN
   PRINT 'Is valid JSON'
END
As part of a check constraint on a table
CREATE TABLE Person 
 ( ID INT IDENTITY PRIMARY KEY,
 json NVARCHAR(MAX)
 CONSTRAINT [Content should be formatted as JSON]
 CHECK ( ISJSON(json )>0 )
 )