That's a pity! My tutorial for the creation of a cd database begin to be
more complex but in some way more interesting! :-) There's a tutorial for
the creation of custom widgets? I didn't find much on this topic on the
book. :-/


2009/10/30 mdipierro <mdipie...@cs.depaul.edu>

>
> You cannot using crud unless you make your own widget.
>
> Massimo
>
> On Oct 30, 10:18 am, Doxaliber <salingro...@gmail.com> wrote:
> > Hello everyone!
> >
> ---------------------------------------------------------------------------------------------------------------------
> > This is my model:
> > db.define_table('autori',
> >     Field('nome_autore', 'string', length=300),
> >     Field('bio', 'text'))
> >
> > db.define_table('case_discografiche',
> >     Field('nome_casa_discografica', 'string', length=300),
> >     Field('bio_casa_discografica', 'text'))
> >
> > db.define_table('generi',
> >     Field('genere_musicale','string', length=300))
> >
> > db.define_table('songs',
> >     Field('titolo', 'string', length=300))
> >
> > db.define_table('albums',
> >     Field('autore', db.autori),
> >     Field('titolo', 'string', length=600),
> >     Field('genere','string', length=300),
> >     Field('tracklist','text'),
> >     Field('casa_discografica', db.case_discografiche),
> >     Field('copertina', 'upload'))
> >
> > db.define_table('songs_albums',
> >     Field('song_relation', db.songs),
> >     Field('album_relation', db.albums))
> >
> > db.autori.nome_autore.requires = IS_NOT_EMPTY(), IS_LOWER(),
> > IS_NOT_IN_DB(db, 'autori.nome_autore')
> > db.case_discografiche.nome_casa_discografica.requires = IS_NOT_EMPTY
> > (), IS_LOWER(), IS_NOT_IN_DB(db,
> > 'case_discografiche.nome_casa_discografica')
> > db.generi.genere_musicale.requires = IS_NOT_EMPTY(), IS_LOWER(),
> > IS_NOT_IN_DB(db, 'generi.genere_musicale')
> > db.albums.autore.requires = IS_IN_DB(db, db.autori.id,'%(nome_autore)
> > s')
> > db.albums.titolo.requires = IS_NOT_EMPTY(), IS_LOWER()
> > db.albums.genere.requires = IS_IN_DB(db,db.generi.id, '%
> > (genere_musicale)s')
> > db.albums.casa_discografica.requires = IS_IN_DB
> > (db,db.case_discografiche.id,'%(nome_casa_discografica)s')
> >
> ----------------------------------------------------------------------------------------------------------------
> >
> > A song can be in many albums and an album has many songs so we need a
> > many to many relationship here. For this reason I've created the table
> > "songs_albums" where there are relationships between albums and songs.
> > But I can't figure out how to update this relationship table using
> > crud! Can you help me please?
> >
>

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web2py@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
-~----------~----~----~----~------~----~------~--~---

Reply via email to