[Top][All Lists]
[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
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Librefm-commits] [1544] catch up with field renames,
Clint Adams <=