Update of /cvsroot/freevo/freevo/helpers
In directory sc8-pr-cvs1:/tmp/cvs-serv24208/helpers
Modified Files:
musicsqlimport.py
Log Message:
I had left a debug line in the insert so all songs showed up as having an
end time of 4:22. It now uses the info from mmpython. Ugh. How embarrassing.
Index: musicsqlimport.py
===================================================================
RCS file: /cvsroot/freevo/freevo/helpers/musicsqlimport.py,v
retrieving revision 1.7
retrieving revision 1.8
diff -C2 -d -r1.7 -r1.8
*** musicsqlimport.py 30 Jun 2003 22:35:05 -0000 1.7
--- musicsqlimport.py 1 Jul 2003 02:22:53 -0000 1.8
***************
*** 40,44 ****
db = sqlite.connect(DATABASE)
cursor = db.cursor()
! cursor.execute("CREATE TABLE music (id INTEGER PRIMARY KEY, dirtitle
VARCHAR(255), md5 VARCHAR(32) UNIQUE, path VARCHAR(255), filename VARCHAR(255), type
VARCHAR(3), artist VARCHAR(255), title VARCHAR(255), album VARCHAR(255), year
VARCHAR(255), track NUMERIC(3), track_total NUMERIC(3), bpm NUMERIC(3), last_play
float, play_count NUMERIC, start_time VARCHAR, end_time VARCHAR, rating NUMERIC, eq
VARCHAR)")
db.commit()
db.close()
--- 40,44 ----
db = sqlite.connect(DATABASE)
cursor = db.cursor()
! cursor.execute("CREATE TABLE music (id INTEGER PRIMARY KEY, dirtitle
VARCHAR(255), md5 VARCHAR(32) UNIQUE, path VARCHAR(255), filename VARCHAR(255), type
VARCHAR(3), artist VARCHAR(255), title VARCHAR(255), album VARCHAR(255), year
VARCHAR(255), track NUMERIC(3), track_total NUMERIC(3), bpm NUMERIC(3), last_play
float, play_count NUMERIC, start_time NUMERIC, end_time NUMERIC, rating NUMERIC, eq
VARCHAR)")
db.commit()
db.close()
***************
*** 68,72 ****
%
(util.escape(dirtitle),md5,util.escape(os.path.dirname(filename)),util.escape(os.path.basename(filename)),
\
'mp3',util.escape(a['artist']),util.escape(a['title']),util.escape(a['album']),inti(a['date']),trackno,
\
! trackof, 100,0,0,'0','262',0,'null')
SQL = 'INSERT OR IGNORE INTO music VALUES ' + VALUES
--- 68,72 ----
%
(util.escape(dirtitle),md5,util.escape(os.path.dirname(filename)),util.escape(os.path.basename(filename)),
\
'mp3',util.escape(a['artist']),util.escape(a['title']),util.escape(a['album']),inti(a['date']),trackno,
\
! trackof, 100,0,0,'0',inti(a['length']),0,'null')
SQL = 'INSERT OR IGNORE INTO music VALUES ' + VALUES
-------------------------------------------------------
This SF.Net email sponsored by: Free pre-built ASP.NET sites including
Data Reports, E-commerce, Portals, and Forums are available now.
Download today and enter to win an XBOX or Visual Studio .NET.
http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_061203_01/01
_______________________________________________
Freevo-cvslog mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/freevo-cvslog
