Convert MS Access to MySQL

This little app will dump the structure and data of a Microsoft Access DB to a flat file for insert into MySQL. Free, too.

http://www.bullzip.com/products/a2m/info.php

Things explained!

Intro to Distributed Version Control (Illustrated)
http://betterexplained.com/articles/intro-to-distributed-version-control-illustrated/

PyCon 2010

Using Gmail's SMTP with Django

In settings.py, I put:

EMAIL_HOST = 'smtp.gmail.com'
EMAIL_HOST_USER = 'youremail@gmail.com'
EMAIL_HOST_PASSWORD = 'yourpassword'
EMAIL_PORT = 587
EMAIL_USE_TLS = True

Then, in code I put:

send_mail(msg_title, msg_body, from_email, [recipient_email,], fail_silently=False)


Where from_email is your email address that you have specified in settings.py under EMAIL_HOST_USER.

Breakfast this morning :-)

The Todo.txt Command Line Interface (CLI)

If you've got a file called todo.txt on your computer right now, you're in the right place. Countless software applications and web sites can manage your to-do list with all sorts of bells and whistles. But if you don't want to depend on someone else's data format or someone else's server, a plain text file is the way to go.

http://ginatrapani.github.com/todo.txt-cli/

How to Run Django's Own Tests (Not your code!)

I was trying to run Django's own tests. However, that was somewhat of a challenge and so, I Googled for some help and found nothing that really worked out of the box. So, this is what I did to run them.

I am running Python 2.6 and using sqlite 3.

Check out trunk:
svn co http://code.djangoproject.com/svn/django/trunk/ django-trunk

Create a settings_unittest.py file with this as the content:
DATABASE_ENGINE = 'sqlite3' # 'postgresql', 'mysql', 'sqlite3' or 'ado_mssql'.
DATABASE_NAME = ':memory:' # Or path to database file if using sqlite3.
DATABASE_USER = '' # Not used with sqlite3.
DATABASE_PASSWORD = '' # Not used with sqlite3.
DATABASE_HOST = '' # Set to empty string for localhost. Not used with sqlite3.
DATABASE_PORT = '' # Set to empty string for default. Not used with sqlite3.
ROOT_URLCONF = 'foo.urls'


Then, create Makefile file in the root of the trunk and add:
# run unit tests
test:
DJANGO_SETTINGS_MODULE=settings_unittest PYTHONPATH=.:tests python tests/runtests.py -v1


Then, all I had to do to run them is:
$ make

My iPhone Apps *

Air Mouse	AP Mobile	Are My Sites Up?
AT&T myWireless App	Birthdays	CameraBag
CinemaFX	ColorSplash	Cropulator
Evernote	Facebook	flickr sendr
Flixster Movies	Google Earth	Google Mobile App
Handshake	Hero of Sparta	Hey Where Are You?
iBird Plus	iExercise	IM+
JotNot	Kindle for iPhone	Mover
My Eyes Only	OmniFocus	Paper Toss
Photogene	Portfolio Live	Remote
Road Trip	Scrabble	Shazam
Sims 3	Skype	SnapTell
Squeeze It	Trivial Pursuit	TweetDeck
Weather Alert

* With links to iTMS

Last updated on June 28, 2009

Configure Flags

These are the flags/switches I used with configure.

MySQL on Mac
CC=gcc CFLAGS="-O3 -fno-omit-frame-pointer" \
CXX=gcc CXXFLAGS="-O3 -fno-omit-frame-pointer \
-felide-constructors -fno-exceptions -fno-rtti"
./configure \
--prefix=/Applications/mysql \
--with-extra-charsets=complex \
--enable-thread-safe-client \
--enable-local-infile \
--enable-shared \
--with-plugins=innobase \
--localstatedir=/Users/<UserName>/Documents/mysql/dataDon't know why I decided to install the bins under Applications, but I did. Put them where you want. I did install the data dirs under Docs so that my backup backs them up! :)

Python 2.4.6 on Mac
./configure MACOSX_DEPLOYMENT_TARGET=10.5

Here the PATH statements from .bash_profile and .bash_login:

.bash_profile
export PATH=/usr/local/bin/:/Applications/mysql/bin:$PATH

.bash_login
export PATH="/usr/local/bin:/usr/local/sbin:/Applications/mysql/bin/:$PATH"

This is the area where I work

In a couple of the scenes, you can see where I work. :)

LXML on Mac OS X

Thanks to this info on Reinout's blog, I was able to install lxml in just a couple of minutes using buildout!!!!! Previously, I spent hours and hours on it and didn't get it done.

Here the info:
http://reinout.vanrees.org/weblog/2009/03/19/static-lxml-recipe-and-ligbcrypt-works-now.html

And, thanks Reinout! :)

WTF, Miss California ?!: As usual, Keith Olbermann got it right!

Visit msnbc.com for Breaking News, World News, and News about the Economy

Need to skin your site?

I just found this site called Open Source Templates. They have some very appealing skins for you to choose from.

http://www.OpenSourceTemplates.org/

Hugs for Bush

Now, you have to see this. Very funny.... if you watch it all the way to the end. Yes, ALL THE WAY TO THE END.

Plone and Unit tests and ZSQL Methods

So, while writing running unit tests for a new class method, a call to a ZSQL method, in the skins folder, kept failing. Then after a long search, I finally found:

http://markmail.org/message/uhh3dhxvypfcnglu#query:plone%20skins%20%22unit%20test%22+page:1+mid:uhh3dhxvypfcnglu+state:results

So, the reason as stated is this:
because in tests new skin layers aren't automatically added to the
default search path on product installation.

So, adding this code to 'afterSetUp' solved everything for me:

def afterSetUp(self):
    self._refreshSkinData()