Skip to content

Instantly share code, notes, and snippets.

View davepape's full-sized avatar

Dave Pape davepape

5 followers · 1 following
View GitHub Profile
@davepape
davepape / mysql0.py
Created April 2, 2014 15:30
# 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")
@davepape
davepape / mysql2.py
Created April 2, 2014 15:34
# 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()
@davepape
davepape / mysql3.py
Created April 2, 2014 16:34
# 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:"
@davepape
davepape / world.cgi
Last active August 29, 2015 13:58
#!/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'")
@davepape
davepape / queryform.html
Created April 2, 2014 15:38
<!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 / webpage.py
Created April 2, 2014 15:37
#!/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">
@davepape
davepape / fovy.py
Created October 20, 2014 14:54
OpenGL perspective projection - use left & right arrow keys to change the field-of-view angle
# 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 / depth.py
Created October 20, 2014 14:52
basic depth buffering, with orthographic projection and 3D transformations
# 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 / warpmesh.js
Created September 29, 2015 04:42
modifying a GameObject's geometry data (mesh) in Unity
#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 September 29, 2015 04:44
create a mesh with 2 triangles in Unity
#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>();