franzwong

package example.clob001;

import java.math.BigDecimal;
import java.nio.file.FileSystems;
import java.nio.file.Files;
import java.nio.file.Path;
import java.sql.Clob;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

franzwong

DECLARE
  documentId DOCUMENT.ID%TYPE;
  documentName DOCUMENT.NAME%TYPE := 'python cheatsheet';
  documentFileName VARCHAR2(1024 CHAR) := 'python.html';

  documentFile BFILE;
  documentClob CLOB;
  
  sourceOffset INTEGER := 1;
  destinationOffset INTEGER := 1;

franzwong

Python cheatsheet

• for loop

for i in xrange(10):
  print i

franzwong

import getpass

password = getpass.getpass('enter password: ')

franzwong

• usage of h:selectOneMenu

<h:selectOneMenu value="#{manageStudent.student.gender}">
    <f:selectItem itemLabel="- Select Gender -" itemValue=""/>
    <f:selectItems value="#{manageStudent.genders}"/>
</h:selectOneMenu>

• get HttpServletRequest and HttpServletResponse in managed bean

franzwong

import traceback
from PIL import Image

def resize():
	filePath = 'example.jpg'
	ratio = 0.5
	
	image = Image.open(filePath)
	
	width = image.size[0]

franzwong

<?xml version="1.0"?>
<web-app 
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
	xmlns="http://java.sun.com/xml/ns/javaee" 
	xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" 
	xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" 
	id="WebApp_ID" version="3.0">

	<servlet>
		<servlet-name>My Servlet</servlet-name>

franzwong

import sys
import ctypes
import time

EnumWindows         = ctypes.windll.user32.EnumWindows
EnumChildWindows    = ctypes.windll.user32.EnumChildWindows
EnumWindowsProc     = ctypes.WINFUNCTYPE(ctypes.c_bool, ctypes.POINTER(ctypes.c_int), ctypes.POINTER(ctypes.c_int))
GetWindowText       = ctypes.windll.user32.GetWindowTextW
GetWindowTextLength = ctypes.windll.user32.GetWindowTextLengthW
IsWindowVisible     = ctypes.windll.user32.IsWindowVisible

franzwong

• read file (sync)

var fs = require('fs');
var data = fs.readFileSync('text.txt', 'utf8');
console.log(data);

• read file (async)

franzwong

• Create project

django-admin.py startproject mysite

• Create application

python manage.py startapp polls