44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
|
# File 'lib/catori/Query.rb', line 44
def gtk(widget,pix)
ts=Gtk::TreeStore.new(String,String,String,String,Gdk::Pixbuf)
widget.model=ts
widget.=true
cd=nil
artist=nil
album=nil
cdi=nil
artisti=nil
albumi=nil
@db.select_all(@sQuery) {|row|
if row['cd_id']!=cd
cdi=ts.append(nil)
artisti=nil
albumi=nil
artist=nil
album=nil
end
cd=row['cd_id']
cdi[0]=cd
cdi[4]=pix['cd']
artisti=ts.append(cdi) if row['artist_name']!=artist
artist=row['artist_name']
artisti[0]=artist
artisti[4]=pix['artist']
albumi=ts.append(artisti) if row['album_name']!=album
album=row['album_name']
albumi[0]=album+"("+row['album_year'].to_s+")"
albumi[4]=pix['album']
titlei=ts.append(albumi)
titlei[1]=row['as_track'].to_s
titlei[2]=row['song_name']
titlei[3]=row['file_name']
titlei[4]=pix['song']
}
end
|