ccjeng

git init


## git link to github repo
## git remote add origin git@github.com: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

--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

#!/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,

ccjeng

@Override
public void onCreate(Bundle saved){
  super.onCreate(saved);

  // Init the swipe back
  SwipeBack.attach(this, Position.LEFT)
      .setContentView(R.layout.activity_simple)
      .setSwipeBackView(R.layout.swipeback_default);
}