Update of /cvsroot/freevo/freevo/helpers
In directory sc8-pr-cvs1:/tmp/cvs-serv21043/helpers
Modified Files:
musicsqlimport.py
Log Message:
Changed type of 'last_play' field to float so we can use python's time.time()
instead of timestamps.
Index: musicsqlimport.py
===================================================================
RCS file: /cvsroot/freevo/freevo/helpers/musicsqlimport.py,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** musicsqlimport.py 30 Jun 2003 03:29:37 -0000 1.1
--- musicsqlimport.py 30 Jun 2003 04:38:47 -0000 1.2
***************
*** 52,56 ****
db = sqlite.connect(DATABASE)
cursor = db.cursor()
! cursor.execute("CREATE TABLE music (id INTEGER PRIMARY KEY, dirtitle
VARCHAR(255), md5 VARCHAR(33), 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
timestamp, play_count NUMERIC, start_time VARCHAR, end_time VARCHAR, rating NUMERIC,
eq VARCHAR)")
db.commit()
db.close()
--- 52,56 ----
db = sqlite.connect(DATABASE)
cursor = db.cursor()
! cursor.execute("CREATE TABLE music (id INTEGER PRIMARY KEY, dirtitle
VARCHAR(255), md5 VARCHAR(33), 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()
-------------------------------------------------------
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
