Sorry the first query was wrong: if db((db.SkillLevel.Skill == db.Skill.id <http://db.skilllevel.id/>) & (db.Skill.Nom == "toto")).count() == 0:
On Thursday, March 29, 2012 11:01:14 AM UTC-3, Alan Etkin wrote: > > For counting SkillLevels that match a Skill with name "toto" you can use > this: > > if db((db.SkillLevel.Skill == db.SkillLevel.id) & (db.Skill.Nom == > "toto")).count() == 0: > > Select the first item by Nom (for Nome a string): > # you can make .last() or simply .select(), which will return a Rows > object with > # the sequence of records that match the query if found > > db(db.item.Nom == <Nom value>).select().first() > > Add a record to demande: > > db.Demande.insert(Topic=<topic value>, Texte=<texte value>, ...) > > On Thursday, March 29, 2012 7:20:31 AM UTC-3, bussiere adrien wrote: >> >> Thanks to you my project make nice progress : >> http://img26.imageshack.us/img26/1271/loginscreena.png >> >> But i need to know some things : >> here is my database : >> >> >> db.define_table('Skill', >> Field('Nom', unique=True), >> format = '%(Nom)s') >> >> db.define_table('SkillLevel', >> Field('Level', 'integer'), >> Field('Skill', db.Skill), >> Field('Parent', db.Skill), >> format = '%(Skill)s') >> >> >> and : >> if db(db.SkillLevel.Skill.Nom == ''toto").count() == 0: >> >> Don't work i says to me skill have no nom attribute >> >> >> then an other question : >> db.define_table('Demande', >> Field('Topic', unique=True), >> Field('Texte'), >> Field('Skills','list:reference SkillDemande'), >> Field('Items','list:reference Item'), >> Field('auth_user',db.auth_user), >> format = '%(Topic)s') >> >> >> db.define_table('Item', >> Field('Nom', unique=True), >> Field('SkillUse', db.SkillLevel), >> format = '%(Nom)s') >> >> >> How to select an item by Nom ? >> How to add an item in demande ? >> >> regards >> Bussiere >> >
