Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!gegeweb.org!de-l.enfer-du-nord.net!feeder2.enfer-du-nord.net!newsfeed.eweka.nl!eweka.nl!feeder3.eweka.nl!newsfeed.xs4all.nl!newsfeed6.news.xs4all.nl!xs4all!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
Return-Path: <jabba.laci@gmail.com>
X-Original-To: python-list@python.org
Delivered-To: python-list@mail.python.org
X-Spam-Status: OK 0.035
X-Spam-Evidence: '*H*': 0.93; '*S*': 0.00; 'integer,': 0.09; 'prefix': 0.09; 'subject:beginner': 0.09; 'to:name:python mailing list': 0.09; 'sqlalchemy': 0.16; 'solution.': 0.17; 'thanks,': 0.18; 'explains': 0.24; 'essential': 0.25; "i'm": 0.26; 'column': 0.28; 'message-id:@mail.gmail.com': 0.28; 'convention': 0.29; 'table,': 0.29; 'unicode': 0.29; 'example': 0.29; 'correct': 0.29; 'version': 0.32; 'does': 0.32; 'hi,': 0.32; 'value.': 0.32; 'there': 0.33; 'to:addr:python-list': 0.34; 'changing': 0.35; 'uses': 0.36; 'but': 0.37; 'received:google.com': 0.37; 'some': 0.38; 'received:209.85': 0.38; "it's": 0.40; 'received:209': 0.40; 'to:addr:python.org': 0.40; 'here': 0.65; 'disappear': 0.84; 'non- unicode': 0.84
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=mime-version:from:date:message-id:subject:to:content-type; bh=xKrcp5In2Jk/oUskAIcq+safey/TeppkJMYfqizE3Jw=; b=RWcfPB+H7uiFIQIQ/x7p7XhxcfIoUmcjvw+dwP1iiaL61/LTq7wB1XxSJmYTJ6zYIb vOFfJPG2ox5LbolcWT010VHzxI5B76VmUQ+Yzt/MKpPYEcsbtCUVxgfaspnLmwRFG1QT MGVZQZYWCE3e3VL1LklPxUplggjS24XYANClw=
MIME-Version: 1.0
From: Jabba Laci <jabba.laci@gmail.com>
Date: Mon, 21 Nov 2011 16:56:59 +0100
Subject: sqlalchemy beginner
To: Python mailing list <python-list@python.org>
Content-Type: text/plain; charset=ISO-8859-1
X-BeenThere: python-list@python.org
X-Mailman-Version: 2.1.12
Precedence: list
List-Id: General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe: <http://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive: <http://mail.python.org/pipermail/python-list>
List-Post: <mailto:python-list@python.org>
List-Help: <mailto:python-list-request@python.org?subject=help>
List-Subscribe: <http://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups: comp.lang.python
Message-ID: <mailman.2906.1321891043.27778.python-list@python.org>
Lines: 30
NNTP-Posting-Host: 2001:888:2000:d::a6
X-Trace: 1321891043 news.xs4all.nl 6960 [2001:888:2000:d::a6]:59261
X-Complaints-To: abuse@xs4all.nl
Xref: x330-a1.tempe.blueboxinc.net comp.lang.python:16018

Hi,

I'm reading the Essential SQLAlchemy book from O'Reilly. It explains
SqlAlch 0.4 but my current version is 0.7 and there are some
differences.

Here is an example from the book:

user_table = Table('tf_user', metadata,
        Column('id', Integer, primary_key=True),
        Column('user_name', Unicode(16), unique=True, nullable=False),
        Column('password', Unicode(40), nullable=False),
        Column('display_name', Unicode(255), default=''),
        Column('created', DateTime, default=datetime.now)
    )

Here I get the following warning:

SAWarning: Unicode column received non-unicode default value.
  Column('display_name', Unicode(255), default=''),

Changing Unicode(255) to String(255) makes the warning disappear but
I'm not sure if it's the correct solution.

For table names, the book uses the prefix convention 'tf_' but what
does it mean? 't' is table, but what is 'f'?

Thanks,

Laszlo