Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #16018

sqlalchemy beginner

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> (permalink)
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

Show key headers only | View raw

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

Back to comp.lang.python | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

sqlalchemy beginner Jabba Laci <jabba.laci@gmail.com> - 2011-11-21 16:56 +0100
  Re: sqlalchemy beginner John Gordon <gordon@panix.com> - 2011-11-21 17:08 +0000
  Re: sqlalchemy beginner Roy Smith <roy@panix.com> - 2011-11-21 19:25 -0500
    Re: sqlalchemy beginner alex23 <wuwei23@gmail.com> - 2011-11-21 18:51 -0800
      Re: sqlalchemy beginner Roy Smith <roy@panix.com> - 2011-11-21 22:18 -0500
        Re: sqlalchemy beginner Cameron Simpson <cs@zip.com.au> - 2011-11-22 17:06 +1100

csiph-web