Skip to content

Instantly share code, notes, and snippets.

Dave Pape davepape

View GitHub Profile
View mysql3.py
# Script to insert a new city into the example 'world' database
import MySQLdb
db = MySQLdb.connect(host='localhost', port=3306, user='myusername', passwd='mypassword', db='world')
cur = db.cursor()
print "enter new city's name:"
name = raw_input()
print "enter new city's country code:"
View mysql0.py
# Query the example "world" database using MySQLdb
import MySQLdb
db = MySQLdb.connect(host='localhost', port=3306, user='myusername', passwd='mypassword', db='world')
cur = db.cursor()
cur.execute("SELECT ID, Name, Population from City order by Name limit 3")
View world.cgi
#!/usr/bin/python
# Query the 'world' database for a country whose name (or partial name) was entered via queryform.html
import MySQLdb
db = MySQLdb.connect(host='localhost', port=3306, user='myusername', passwd='mypassword', db='world')
cur = db.cursor()
cur.execute("set names 'utf8'")
View mysql2.py
# Perform an 'update' query on the sample database, with data input by the user
import MySQLdb
db = MySQLdb.connect(host='localhost', port=3306, user='myusername', passwd='mypassword', db='world')
cur = db.cursor()
print 'enter new name for City 1:'
newname = raw_input()
View webpage.py
#!/usr/bin/python
# Simple CGI python script that generates a web page dynamically
print '''Content-type: text/html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
View queryform.html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>HTML form example</title>
</head>
<body>
<form method="post" action="world.cgi">
Country name? <input type="text" name="name" size="40" value="">
<br>
@davepape
davepape / depth.py
Created Oct 20, 2014
basic depth buffering, with orthographic projection and 3D transformations
View depth.py
# Demonstration of depth buffering
# When depth buffering is active, the orbiting yellow planet
# will be properly hidden by the blue and red planets as it
# passes behind them.
# Depth buffering is toggled on & off by pressing the space bar.
import sys
import time
from pyglet.gl import *
@davepape
davepape / fovy.py
Created Oct 20, 2014
OpenGL perspective projection - use left & right arrow keys to change the field-of-view angle
View fovy.py
# Demonstration of perspective projection
#
import sys, time
from pyglet.gl import *
window = pyglet.window.Window()
keys = pyglet.window.key.KeyStateHandler()
window.push_handlers(keys)
glLineWidth(5.0)
@davepape
davepape / warpmesh.js
Created Sep 29, 2015
modifying a GameObject's geometry data (mesh) in Unity
View warpmesh.js
#pragma strict
// Script to warp an existing mesh.
// This can be attached to any GameObject that includes a Mesh Filter.
// It will move the vertices up and down in Y, based on the sine of the X
// value + the time.
private var originalVerts : Vector3[];
function Start ()
@davepape
davepape / makeTriangles.js
Created Sep 29, 2015
create a mesh with 2 triangles in Unity
View makeTriangles.js
#pragma strict
// Script to create a mesh with 2 triangles.
// This should be attached to an empty GameObject.
// It assumes the existence of a custom shader to use the vertex colors
// without texture or lighting.
function Start ()
{
gameObject.AddComponent.<MeshFilter>();
You can’t perform that action at this time.