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.
