I have defined my model.
====================================================
# coding: utf8
# define a SQLite database
database=SQLDB("sqlite://database.db")
# create a vendor table
database.define_table('vendor',
database.Field('name'),
database.Field('alias'),
database.Field('url'),
database.Field('logo'),
database.Field('active')
)
database.vendor.name.type='string'
database.vendor.name.length=64
database.vendor.name.unique=True
database.vendor.name.requires=[IS_NOT_EMPTY(),IS_NOT_IN_DB(database,
database.vendor.name)]
database.vendor.alias.type='string'
database.vendor.alias.length=16
database.vendor.alias.unique=True
database.vendor.alias.requires=[IS_NOT_EMPTY(),IS_NOT_IN_DB(database,
database.vendor.name),IS_NOT_IN_DB(database, database.vendor.alias)]
database.vendor.url.type='string'
database.vendor.url.length=128
database.vendor.url.requires=[IS_NOT_EMPTY()]
database.vendor.logo.type='upload'
database.vendor.logo.requires=[IS_NOT_EMPTY()]
database.vendor.active.type='boolean'
database.vendor.active.requires=[IS_NOT_EMPTY()]
database.define_table('distro',
database.Field('vendor_id'),
database.Field('name'),
database.Field('alias'),
database.Field('active')
)
database.distro.vendor_id.type='database.vendor'
database.distro.vendor_id.requires=IS_IN_DB
(database,database.vendor.id,'%(name)s')
database.distro.name.type='string'
database.distro.name.length=64
database.distro.name.unique=True
database.distro.name.requires=[IS_NOT_EMPTY()]
database.distro.alias.type='string'
database.distro.alias.length=16
database.distro.alias.unique=True
database.distro.alias.requires=[IS_NOT_EMPTY(),IS_NOT_IN_DB
(database,database.distro.alias)]
database.distro.active.type='boolean'
database.distro.active.requires=[IS_NOT_EMPTY()]
database.define_table('release',
database.Field('distro_id'),
database.Field('version'),
database.Field('alias'),
database.Field('active')
)
database.release.distro_id.type='database.distro'
database.release.distro_id.requires=IS_IN_DB
(database,database.distro.id,'%(name)s')
database.release.version.type='string'
database.release.version.length=16
database.release.version.unique=True
database.release.version.requires=[IS_NOT_EMPTY()]
database.release.alias.type='string'
database.release.alias.length=16
database.release.alias.unique=True
database.release.alias.requires=[IS_NOT_EMPTY(),IS_NOT_IN_DB
(database,database.release.alias)]
database.release.active.type='boolean'
database.release.active.default=True
=========================================
When I look at sql.log I see
=========================================
timestamp: 2009-08-10T11:15:24.393714
CREATE TABLE vendor(
id INTEGER PRIMARY KEY AUTOINCREMENT,
name CHAR(32),
alias CHAR(32),
url CHAR(32),
logo CHAR(32),
active CHAR(32)
);
success!
timestamp: 2009-08-10T11:15:24.411343
CREATE TABLE distro(
id INTEGER PRIMARY KEY AUTOINCREMENT,
vendor_id CHAR(32),
name CHAR(32),
alias CHAR(32),
active CHAR(32)
);
success!
timestamp: 2009-08-10T11:15:24.423518
CREATE TABLE release(
id INTEGER PRIMARY KEY AUTOINCREMENT,
distro_id CHAR(32),
version CHAR(32),
alias CHAR(32),
active CHAR(32)
);
success!
=========================================
Is it normal for my specifications to be ignored? Also, via the
database administration page, I can set the active field of a record
to "True" but not "False". If I try to change something to "False" I
get "invalid length!".
What am I doing wrong?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
