You put a colon instead of a comma.
On Mar 21, 1:13 pm, kike <eacarm...@estudiantes.uci.cu> wrote:
> I put that and now web2py don't reconice that
>
> Traceback (most recent call last):
> File "/home/kike/sbdv/web2py/gluon/restricted.py", line 171, in
> restricted
> File "/home/kike/Desktop/web2py/applications/SBDV/models/db.py",
> line 6
> Field('name', length=128):migrate=False)
> ^
> SyntaxError: invalid syntax
>
> On Mar 21, 1:59 pm, "mr.freeze" <nat...@freezable.com> wrote:
>
> > You need to put migrate=False after Field(...):
>
> > vul.define_table('object_vendors',Field('name', length=128),
> > migrate=False)
>
> > On Mar 21, 12:47 pm, kike <eacarm...@estudiantes.uci.cu> wrote:
>
> > > I use yours sugestion but don't work, I definet again my database in
> > > web2py, I think that is to work with a big app, but is for my meaby
> > > the best solution, and now sendme a new error what is the keywork
> > > arg????
>
> > > Traceback (most recent call last):
> > > File "/home/kike/sbdv/web2py/gluon/restricted.py", line 171, in
> > > restricted
> > > File "/home/kike/Desktop/web2py/applications/SBDV/models/db.py",
> > > line 6
> > > Field('name', length=128, migrate=False))
> > > SyntaxError: non-keyword arg after keyword arg
>
> > > here is a small view of my code:
>
> > > (........)
> > > vul=DAL('mysql://root:r...@localhost/sbdv',pool_size=20)
> > > (........)
> > > vul.define_table('object_vendors',migrate=False,
> > > Field('name', length=128, migrate=False))
> > > vul.define_table('object_products', migrate=False,
> > > Field('name',length=128, migrate=False))
> > > vul.define_table('object_versions', migrate=False,
> > > Field('name', length=128, migrate=False))
> > > vul.define_table('object_correlations', migrate=False,
> > > Field('object_vendor_id', 'integer',
> > > vul.object_vendors.id, migrate=False),
> > > Field('object_product_id', 'integer',
> > > vul.object_products.id, migrate=False),
> > > Field('object_version_id', 'integer',
> > > vul.object_versions.id, migrate=False))
> > > (.......)
>
> > > On Mar 21, 10:28 am, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > > > Oops you are right. The problem is here then:
>
> > > > auth_table=db.define_table(
> > > > ...
> > > > Field('preference', vul.object_vendors, label='Preferencia
> > > > Principal'),
> > > > ...)
>
> > > > you cannot have a referent to a different database (db to vul). You
> > > > can use a trick:
>
> > > > auth_table=db.define_table(
> > > > ...
> > > > Field('preference', 'integer', label='Preferencia Principal'),
> > > > ...)
>
> > > > db.auth_user.preferece.requires=IS_IN_DB(vul,'object_vendors.id')
>
> > > > The last line must be after both dbs and tables are defined.
>
> > > > On Mar 20, 11:03 pm, "mr.freeze" <nat...@freezable.com> wrote:
>
> > > > > db = DAL('mysql://root:r...@localhost/usbdv',pool_size=20)
> > > > > vul=DAL('mysql://root:r...@localhost/sbdv',pool_size=20)
>
> > > > > They're different. Does he need to do fake_migrate to make the .table
> > > > > files?
>
> > > > > On Mar 20, 10:23 pm, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > > > > > I do not understand. db and vui connect to the same database. why
> > > > > > not
> > > > > > "vui=db"? Are they defined in two different applications? If they
> > > > > > are
> > > > > > defined in the same applications db and vui should be the same
> > > > > > connections else they will not see each other tables.
>
> > > > > > On Mar 20, 8:38 pm, kike <eacarm...@estudiantes.uci.cu> wrote:
>
> > > > > > > I have two databases, the first was created by auth, and the
> > > > > > > second is
> > > > > > > a database with 14 tables, created previusly.
>
> > > > > > > Traceback (most recent call last):
> > > > > > > File "/home/kike/sbdv/web2py/gluon/restricted.py", line 173, in
> > > > > > > restricted
> > > > > > > File "/home/kike/Desktop/web2py/applications/SBDV/models/db.py",
> > > > > > > line 58, in <module>
> > > > > > > Field('second_preference', vul.object_products,
> > > > > > > label='Preferencia
> > > > > > > Secundaria'))
> > > > > > > File "/home/kike/sbdv/web2py/gluon/sql.py", line 1270, in
> > > > > > > define_table
> > > > > > > File "/home/kike/sbdv/web2py/gluon/sql.py", line 1540, in
> > > > > > > _create_references
> > > > > > > SyntaxError: Table: table "object_vendors" does not exist
>
> > > > > > > this is my code:
>
> > > > > > > db = DAL('mysql://root:r...@localhost/usbdv',pool_size=20)
>
> > > > > > > from gluon.tools import *
> > > > > > > auth=Auth(globals(),db)
> > > > > > > auth.settings.hmac_key='sha512:582aedbf-4d01-4f41-81ad-ffb7eed2ada4'
> > > > > > > auth_table=db.define_table(
> > > > > > > auth.settings.table_user_name,
> > > > > > > Field('first_name', length=128, label='Nombre(s)'),
> > > > > > > Field('last_name', length=128, label='Apellidos'),
> > > > > > > Field('email', length=128, unique=True, label='Correo'),
> > > > > > > Field('password', 'password', length=256, readable=False,
> > > > > > > label='Contraseña'),
> > > > > > > Field('registration_key', length=128, writable=False,
> > > > > > > readable=False),
> > > > > > > Field('preference', vul.object_vendors, label='Preferencia
> > > > > > > Principal'),
> > > > > > > Field('second_preference', vul.object_products,
> > > > > > > label='Preferencia
> > > > > > > Secundaria'))
> > > > > > > # creates all needed tables
>
> > > > > > > auth_table.first_name.requires=IS_NOT_EMPTY()
> > > > > > > auth_table.last_name.requires=IS_NOT_EMPTY()
> > > > > > > auth_table.password.requires=[CRYPT()]
> > > > > > > auth_table.email.requires=[IS_EMAIL(), IS_NOT_IN_DB(db,
> > > > > > > auth_table.email)]
> > > > > > > auth_table.preference.requires=IS_IN_DB(vul,'object_vendors.id','object_vendors.name')
> > > > > > > auth_table.second_preference=IS_IN_DB(vul,'object_products.id','object_products.name')
> > > > > > > auth.settings.table_user=auth_table
> > > > > > > auth.define_tables()
>
> > > > > > > and this is my declaration for the second databases(previusly
> > > > > > > created):
>
> > > > > > > vul=DAL('mysql://root:r...@localhost/sbdv',pool_size=20)
>
> > > > > > > vul.define_table('object_vendors', migrate=False)
> > > > > > > vul.define_table('object_products', migrate=False)
> > > > > > > vul.define_table('object_versions', migrate=False)
> > > > > > > vul.define_table('object_correlations', migrate=False)
> > > > > > > vul.define_table('object_affect_types', migrate=False)
> > > > > > > vul.define_table('object_links', migrate=False)
> > > > > > > vul.define_table('vulnerabilities', migrate=False)
> > > > > > > vul.define_table('credits', migrate=False)
> > > > > > > vul.define_table('authors', migrate=False)
> > > > > > > vul.define_table('ext_reference_types', migrate=False)
> > > > > > > vul.define_table('ext_references', migrate=False)
> > > > > > > vul.define_table('classification_types', migrate=False)
> > > > > > > vul.define_table('classification_items', migrate=False)
> > > > > > > vul.define_table('classifications', migrate=False)
>
>
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
