Aventurine Yao

Syntax: /* the correct way of putting multiple fields together, using comma */ UPDATE `stories` SET `content`='Once upon a time ...', `update_time`=now() WHERE id=1; Note: there is no 'and' between the fields you are trying to update. You should use comma between each pair of the fields you are trying to update. Otherwise, you will likely get an '0' as the result value in the 'content' field without getting any error message. If you do the following, you will likely get an '0' in the 'content' field, without any error message /* the wrong way of putting multiple fields together, using 'and' */ UPDATE `stories` SET `content`='My Story' and `update_time`=now() WHERE id=1; See also:  http://stackoverflow.com/a/7375371

I was using 'fragment' tag in the layout file for the Android app I was developing, as shown in the first code block. The id of the layout file for the CalendarFragment (.java) is R.id.calendar. I want to get the CalendarFragment instance in my code at runtime using getFragmentMeneger.findFragmentById(R.id.calendar) but kept getting null result. I ended up using getFragmentMeneger.findFragmentById(R.id.left1), the id for the 'fragment' tag in the main layout file to get the CalendarFragment at run time and it works. 'fragment' tag in the layout file for MainActivity.java: Actual layout file for the CalendarFragment.java: Actual java code in MainActivity.java to access the fragment:

There is a light-weight desktop environment, Maynard, for Raspberry Pi. Here are the steps to install and start using it. wget http://raspberrypi.collabora.co.uk/setup-maynard.sh chmod 755 setup-maynard.sh ./setup-maynard.sh // reboot // login maynard // enjoy Reference: http://raspberrypi.collabora.co.uk/maynard.html

In this example, we used regular expression to implement the strings.startswith() function. The program will ask for users' input on a sub-string to find at the beginning of each string. The program will then open a file and print out the lines that start with the sub-string being specified. #Implementing Python's string.startswith() using regular expression # import the regular expression module import re # allow users to specify what string to look for as the start of a string start_str = raw_input("Enter the string that starts a line: ") # specify the name of the file to search within file_name = 'my_file.txt' # open the file for reading file_h = open(file_name, 'r') # define the pattern # ^ : start of the string # {} : place holder for start_str # ^{} -> ^start_str # -> pattern: a string that starts with the content stored in start_str # if You want to specify a word, followed by a space, that starts a string # leave a space after ...

Here I used the code on page 122 ~ 123 of the book ' Python for Informatics ’ by Charles Severance (Dr. Chuck) as an example to explain how to sort the key value pairs in a Python dictionary by value. # open the file named remeo.txt fhand = open('romeo.txt') # create a dictionary counts = dict() # read the file line by line for line in fhand: # split the line by whitespace characters (space, tab, newline, return, formfeed) words = line.split() # read the individual word for word in words: # increase the word count by 1 for that specific 'word' counts[word] = counts.get(word, 0 ) + 1 # create our list lst = list() # iterate over each tuple (key value pair) in the list generated by counts.items() for key, val in counts.items(): # create a new tuple (value, key) and append to our list, so that sort() will sort the list by the first element, value. # if we want to sort the list (or you can say dictionary) by key, we ...

When you need to extract data from a string in Python, you can use the built-in String.find() method in Python and the String[n:m] notation to extract the sub-string. string.find(str) will return the starting position of the first instance of str in string. For example. 'abcdecd'.find('cd') will return 2, because the first 'cd' instance starts at position 2 (not 3, since position starts with 0). If no str can be found in the string, the method will return -1. str[n:m] notation will extract the sub-string starting at position n and ending at position m-1, not including the m-th character. For example, if the content of my_str is 'I don't know', my_str[2:] will return 'don't know'. By using string.find() and [n:m] notation, we can write a script to automatically extract the data we need from a string. For example, we have a file test_score.txt that records the scores of all the students enrolled in a class. We know that each line re...

Step 1: Install QT Download and install from here:  http://qt-project.org/downloads   (Locate where the "qmake" is. For example, "/Applications/Qt5.1.1/5.1.1/clang_64/bin/qmake" when I choose to install qt at "/Applicaitons/Qt5.1.1") Step 2: Install SIP Download the package from here:  http://www.riverbankcomputing.co.uk/software/pyqt/ Unzip it and "cd" into the resulted folder. python configure.py make sudo make install (Review the output messages and locate where sip is installed. For example, "/System/Library/Frameworks/Python.framework/Versions/2.7/bin/sip".) Step 3: Install PyQT Download the package from here:   http://www.riverbankcomputing.co.uk/software/pyqt/ Unzip it and "cd" into the resulted folder. python configure.py --qmake where_qmake_is --sip where_sip_is (ex. python  configure.py  --qmake /Applications/Qt5.1.1/5.1.1/clang_64/bin/qmake --sip /System/Library/Frameworks/Python.fra...