2007/11/23, Leandro Sales <[EMAIL PROTECTED]>: > 2007/11/23, Leandro Sales <[EMAIL PROTECTED]>: > > 2007/11/23, Oleg Broytmann <[EMAIL PROTECTED]>: > > > On Fri, Nov 23, 2007 at 08:58:22AM -0300, ?eandro Sales wrote: > > > > OK. Any comment about the error? > > > > > > I cannot run the program - I don't have ID3 module. > > > > > > PS. I stopped using ID3.py long ago. These days I use eyeD3. You can find > > > my public scripts at http://phd.pp.ru/Software/misc/cdr-mp3-video-tools/ > > > > > > Oleg. > > > -- > > > Oleg Broytmann http://phd.pp.ru/ [EMAIL > > > PROTECTED] > > > Programmers don't die, they just GOSUB without RETURN. > > > > > > > I will see your suggestion later. It seems that it is good. > > > > Well, since you don't have ID3 module, I'm sending to you a new > > version of the example that include the id3 module. Please, consider > > this one. Please, let me know if now it is right. > > > > Leandro. > > > > > > > Hello Oleg, > I realized that the problem is not when the data is insert. Instead, > the problem occurs when I call musicAlbum.count(). > > File > "/home/leandro/workspace/BRisa/brisa/media_services/cds/plugins/filesystem/persistence/Facade.py", > line 163, in add_music_track > if musicAlbum.count() > 0: > File "/usr/lib/python2.5/site-packages/sqlobject/sresults.py", line > 197, in count > count = self.accumulate('COUNT(*)') > File "/usr/lib/python2.5/site-packages/sqlobject/sresults.py", line > 179, in accumulate > return conn.accumulateSelect(self, *expressions) > File "/usr/lib/python2.5/site-packages/sqlobject/dbconnection.py", > line 418, in accumulateSelect > > Error while loading plugin filesystem > Exception type / message: <class > 'sqlobject.dberrors.OperationalError'> / unrecognized token: "'Heathen > Chemistry" > > ... > musicAlbum = select_container_by_title(title=kwargs["album"]) > if musicAlbum.count() > 0: > musicAlbum = musicAlbum[0] > ... > > It seems a problem regarding to count() function. > > Any clue? > > Leandro >
When I "print musicAlbum" I get: SELECT db_container.id, db_container.container_id, db_container.child_name FROM db_container, db_object WHERE (((db_object.title) = ('Heathen Chemistry Where is the rest of the SQL statement? Leandro. ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss