librefm-commits
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Librefm-commits] [1544] catch up with field renames


From: Clint Adams
Subject: [Librefm-commits] [1544] catch up with field renames
Date: Wed, 13 May 2009 22:41:49 +0000

Revision: 1544
          http://svn.sv.gnu.org/viewvc/?view=rev&root=librefm&revision=1544
Author:   clint
Date:     2009-05-13 22:41:49 +0000 (Wed, 13 May 2009)
Log Message:
-----------
catch up with field renames

Modified Paths:
--------------
    trunk/scripts/import-jamendo.py

Modified: trunk/scripts/import-jamendo.py
===================================================================
--- trunk/scripts/import-jamendo.py     2009-05-13 22:36:20 UTC (rev 1543)
+++ trunk/scripts/import-jamendo.py     2009-05-13 22:41:49 UTC (rev 1544)
@@ -211,14 +211,14 @@
 
                                                if 
self.track_exists(artist["name"], album["name"], track["name"]):
                                                        try:
-                                                               
self.cursor.execute("UPDATE Track SET downloadurl = %s, streamurl = %s, mbid = 
%s, license = %s, duration = %s, otherid = %s, streamable = %s WHERE name = %s 
AND artist = %s AND album = %s", (track["downloadurl"], track["streamurl"], 
track["mbid"], track["license"], duration, otherid, streamable, track["name"], 
artist["name"], album["name"]))
+                                                               
self.cursor.execute("UPDATE Track SET downloadurl = %s, streamurl = %s, mbid = 
%s, license = %s, duration = %s, otherid = %s, streamable = %s WHERE name = %s 
AND artist_name = %s AND album_name = %s", (track["downloadurl"], 
track["streamurl"], track["mbid"], track["license"], duration, otherid, 
streamable, track["name"], artist["name"], album["name"]))
                                                                
self.conn.commit()
                                                        except Exception,  e:
                                                                
self.conn.rollback()
                                                                print 'ut', e
                                                else:
                                                        try:
-                                                               
self.cursor.execute("INSERT INTO Track (name, artist, album, mbid, downloadurl, 
streamurl, license, duration, otherid, streamable) VALUES (%s, %s, %s, %s, %s, 
%s, %s, %s, %s, %s)", (track["name"], artist["name"], album["name"], 
track["mbid"], track["downloadurl"], track["streamurl"], track["license"], 
duration, otherid, streamable))
+                                                               
self.cursor.execute("INSERT INTO Track (name, artist_name, album_name, mbid, 
downloadurl, streamurl, license, duration, otherid, streamable) VALUES (%s, %s, 
%s, %s, %s, %s, %s, %s, %s, %s)", (track["name"], artist["name"], 
album["name"], track["mbid"], track["downloadurl"], track["streamurl"], 
track["license"], duration, otherid, streamable))
                                                                
self.conn.commit()
                                                        except Exception,  e:
                                                                
self.conn.rollback()
@@ -377,7 +377,7 @@
 
        def track_exists(self, artist, album, track):
                try:
-                       self.cursor.execute("SELECT name FROM Track WHERE 
artist = %s AND album = %s AND name = %s", (artist, album, track))
+                       self.cursor.execute("SELECT name FROM Track WHERE 
artist_name = %s AND album_name = %s AND name = %s", (artist, album, track))
                        return self.cursor.rowcount != 0
                except:
                        return False





reply via email to

[Prev in Thread] Current Thread [Next in Thread]