ccjeng

## backup nonsystem apk
adb backup -apk -shared -nosystem -all -f backup_apk.ab

### backup system and nonsystem apk
adb backup -apk -noshared -system -all -f backup_apk.ab

## backup individual apk
adb backup -apk com.example.testing -f testing.ab

## restore all

ccjeng

--get top 50 slow sql statement
select top 50 * from
(
SELECT    SUBSTRING(st.text, (qs.statement_start_offset/2)+1, 
        ((CASE qs.statement_end_offset
          WHEN -1 THEN DATALENGTH(st.text)
         ELSE qs.statement_end_offset
         END - qs.statement_start_offset)/2) + 1) AS StatementText,
        last_execution_time as LastExecuted,
        last_elapsed_time/1000000.0 as ElapsedTimeInSeconds,

ccjeng

SELECT DISTINCT B.TREE_NODE, Z.RECDESCR 
FROM PSTREEDEFN A, 
PSTREENODE B, 
PS_SCRTY_ACC_GRP C, 
PSTREENODE E, 
PSROLECLASS X, 
PSROLEUSER Y, 
PSRECDEFN Z 
WHERE A.SETID = ' ' 
AND A.TREE_STRCT_ID = 'ACCESS_GROUP' 

ccjeng

alter service master key force regenerate

ccjeng

USE DatabaseName
GO
DBCC SHRINKFILE(<TransactionLogName>, 1)
BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY
DBCC SHRINKFILE(<TransactionLogName>, 1)
GO

ccjeng

git init


## git link to github repo
## git remote add origin [email protected]:ccjeng/tptrash-api.git

git add .

# commit program to local git repo
git commit –m "First commit"

ccjeng

#mount
sshfs root@nexus5:/sdcard/ sdcard -p2222

#unmount
fusermount -u sdcard


# adb port forwarding
# This will redirect the local tcp port 22 to the port 2222 on the phone, on which the SSH server will be running now, served by QuickSSHd.
adb forward tcp:2222 tcp:22

ccjeng

#!/usr/bin/python
# -*- coding: utf-8 -*- 

import codecs, json,httplib
import urllib2
import ast

root = 'http://data.taipei/opendata/datalist/apiAccess?scope=resourceAquire&rid='

dict = {u'士林區':'97cc923a-e9ee-4adc-8c3d-335567dc15d3'

ccjeng

<framelayout xmlns:android="http://schemas.android.com/apk/res/android"  
    xmlns:tools="http://schemas.android.com/tools"  
    android:id="@+id/container"  
    android:layout_width="match_parent"  
    android:layout_height="match_parent"  
    tools:ignore="MergeRootFrame" >  
  
    <android.support.v4.widget.SwipeRefreshLayout  
        android:id="@+id/swipe_container"  
        android:layout_width="match_parent"  

ccjeng

private SwipeRefreshLayout mSwipeLayout;  

@Override  
protected void onCreate(Bundle savedInstanceState) {  
    super.onCreate(savedInstanceState); 
    ......

    mSwipeLayout = (SwipeRefreshLayout) findViewById(R.id.swipe_container);  
    mSwipeLayout.setOnRefreshListener(this);  
    mSwipeLayout.setColorSchemeResources(android.R.color.holo_red_light,