| | 40 | |
| | 41 | def main(self): |
| | 42 | print "Dvd view" |
| | 43 | pass |
| | 44 | |
| | 45 | |
| | 46 | class TvView(object): |
| | 47 | def __init__(self): |
| | 48 | pass |
| | 49 | |
| | 50 | def main(self): |
| | 51 | print "Tv view" |
| | 52 | pass |
| | 53 | |
| | 54 | |
| | 55 | class AudioView(object): |
| | 56 | def __init__(self, aViewStack, aActionStack, aListStack): |
| | 57 | self._iViewStack = aViewStack |
| | 58 | self._iActionStack = aActionStack |
| | 59 | self._iListStack = aListStack |
| | 60 | self._iDB = AudioQueries() |
| | 61 | |
| | 62 | def main(self): |
| | 63 | print "Audio main" |
| | 64 | actions = [] |
| | 65 | id_list = [] |
| | 66 | lb = ListBox(Lang().label('Audio')) |
| | 67 | # Feed listbox |
| | 68 | lb.addLabel(Lang().label('AllSongs')) |
| | 69 | actions.append( self.allSongs ) |
| | 70 | |
| | 71 | lb.addLabel(Lang().label('Playlists')) |
| | 72 | actions.append( self.playlists ) |
| | 73 | |
| | 74 | lb.addLabel(Lang().label('Artists')) |
| | 75 | actions.append( self.artists ) |
| | 76 | |
| | 77 | lb.addLabel(Lang().label('Albums')) |
| | 78 | actions.append( self.albums ) |
| | 79 | |
| | 80 | lb.addLabel(Lang().label('Genres')) |
| | 81 | actions.append( self.genres ) |
| | 82 | |
| | 83 | # Feed options menu |
| | 84 | lb.addCommand('select', Lang().label('Select'), OPCode()['SELECT']) |
| | 85 | lb.addCommand('options', Lang().label('Select'), OPCode()['SELECT']) |
| | 86 | lb.addCommand('options', Lang().label('NowPlaying'), OPCode()['NOWPLAYING']) |
| | 87 | lb.addCommand('options', Lang().label('Back'), OPCode()['BACK']) |
| | 88 | lb.addCommand('back', Lang().label('Back'), OPCode()['BACK']) |
| | 89 | self._iActionStack.append(actions) |
| | 90 | self._iViewStack.append(lb.getList()) |
| | 91 | self._iListStack.append(id_list) |
| | 92 | |
| | 93 | def allSongs(self): |
| | 94 | print "Audio all songs" |
| | 95 | |
| | 96 | lb = ListBox(Lang().label('AllSongs')) |
| | 97 | actions = [] |
| | 98 | id_list = [] |
| | 99 | |
| | 100 | db = AudioQueries() |
| | 101 | resultset = db.allSongs() |
| | 102 | #resultset = db.execute(query) |
| | 103 | |
| | 104 | # feed list |
| | 105 | for song in resultset.fetchall(): |
| | 106 | print song |
| | 107 | lb.addLabel(song[3]) |
| | 108 | id_list.append(song[0]) |
| | 109 | |
| | 110 | # Feed options menu |
| | 111 | lb.addCommand('options', Lang().label('Play'), OPCode()['PLAY']) |
| | 112 | lb.addCommand('options', Lang().label('AddToPlaylist'), OPCode()['DISCONNECT']) |
| | 113 | lb.addCommand('options', Lang().label('NowPlaying'), OPCode()['NOWPLAYING']) |
| | 114 | lb.addCommand('options', Lang().label('Back'), OPCode()['BACK']) |
| | 115 | lb.addCommand('back', Lang().label('Back'), OPCode()['BACK']) |
| | 116 | lb.addCommand('select', Lang().label('Play'), OPCode()['PLAY']) |
| | 117 | self._iActionStack.append(actions) |
| | 118 | self._iViewStack.append(lb.getList()) |
| | 119 | self._iListStack.append(id_list) |
| | 120 | |
| | 121 | |
| | 122 | def artists(self): |
| | 123 | print "Audio Artists" |
| | 124 | lb = ListBox(Lang().label('Artists')) |
| | 125 | actions = [] |
| | 126 | id_list = [] |
| | 127 | |
| | 128 | db = AudioQueries() |
| | 129 | resultset = db.artists() |
| | 130 | |
| | 131 | # feed list |
| | 132 | for artist in resultset.fetchall(): |
| | 133 | print artist |
| | 134 | lb.addLabel(artist) |
| | 135 | actions.append(lambda:self.artistAlbums(artist)) |
| | 136 | |
| | 137 | # Feed options menu |
| | 138 | lb.addCommand('options', Lang().label('Select'), OPCode()['SELECT']) |
| | 139 | lb.addCommand('options', Lang().label('AddToPlaylist'), OPCode()['PLNEW']) |
| | 140 | lb.addCommand('options', Lang().label('NowPlaying'), OPCode()['NOWPLAYING']) |
| | 141 | lb.addCommand('options', Lang().label('Back'), OPCode()['BACK']) |
| | 142 | lb.addCommand('back', Lang().label('Back'), OPCode()['BACK']) |
| | 143 | lb.addCommand('select', Lang().label('Select'), OPCode()['SELECT']) |
| | 144 | |
| | 145 | self._iActionStack.append(actions) |
| | 146 | self._iViewStack.append(lb.getList()) |
| | 147 | self._iListStack.append(id_list) |
| | 148 | |
| | 149 | |
| | 150 | def artistAlbums(self, aArtistName): |
| | 151 | print "Audio %s album" %(aArtistName) |
| | 152 | lb = ListBox(aArtistName) |
| | 153 | actions = [] |
| | 154 | id_list = [] |
| | 155 | |
| | 156 | # all songs |
| | 157 | lb.addLabel(Lang().label('AllSongs')) |
| | 158 | actions.append(lambda:self.artistAllSongs()) |
| | 159 | |
| | 160 | |
| | 161 | db = AudioQueries() |
| | 162 | resultset = db.artistAlbums(aArtistName) |
| | 163 | |
| | 164 | # feed list |
| | 165 | for album in resultset.fetchall(): |
| | 166 | lb.addLabel(album) |
| | 167 | actions.append(lambda:self.artistAlbumSongs(album)) |
| | 168 | |
| | 169 | # Feed options menu |
| | 170 | lb.addCommand('options', Lang().label('Select'), OPCode()['SELECT']) |
| | 171 | lb.addCommand('options', Lang().label('AddToPlaylist'), OPCode()['PLNEW']) |
| | 172 | lb.addCommand('options', Lang().label('NowPlaying'), OPCode()['NOWPLAYING']) |
| | 173 | lb.addCommand('options', Lang().label('Back'), OPCode()['BACK']) |
| | 174 | lb.addCommand('back', Lang().label('Back'), OPCode()['BACK']) |
| | 175 | lb.addCommand('select', Lang().label('Select'), OPCode()['SELECT']) |
| | 176 | |
| | 177 | self._iActionStack.append(actions) |
| | 178 | self._iViewStack.append(lb.getList()) |
| | 179 | self._iListStack.append(id_list) |
| | 180 | |
| | 181 | |
| | 182 | def artistAlbumSongs(self, aAlbum): |
| | 183 | print "Audio artist album songs" |
| | 184 | lb = ListBox(aAlbum) |
| | 185 | actions = [] |
| | 186 | id_list = [] |
| | 187 | |
| | 188 | db = AudioQueries() |
| | 189 | resultset = db.albumSongs(aAlbum) |
| | 190 | |
| | 191 | # feed list |
| | 192 | for song in resultset.fetchall(): |
| | 193 | lb.addLabel(song[3]) |
| | 194 | |
| | 195 | # Feed options menu |
| | 196 | lb.addCommand('options', Lang().label('Play'), OPCode()['PLAY']) |
| | 197 | lb.addCommand('options', Lang().label('AddToPlaylist'), OPCode()['PLNEW']) |
| | 198 | lb.addCommand('options', Lang().label('NowPlaying'), OPCode()['NOWPLAYING']) |
| | 199 | lb.addCommand('options', Lang().label('Back'), OPCode()['BACK']) |
| | 200 | lb.addCommand('back', Lang().label('Back'), OPCode()['BACK']) |
| | 201 | lb.addCommand('select', Lang().label('Play'), OPCode()['PLAY']) |
| | 202 | self._iActionStack.append(actions) |
| | 203 | self._iViewStack.append(lb.getList()) |
| | 204 | self._iListStack.append(id_list) |
| | 205 | |
| | 206 | |
| | 207 | def artistAllSongs(self): |
| | 208 | print "Audio artist all songs" |
| | 209 | artistName = "Unknown" |
| | 210 | lb = ListBox(artistName) |
| | 211 | actions = [] |
| | 212 | id_list = [] |
| | 213 | |
| | 214 | db = AudioQueries() |
| | 215 | resultset = db.artistAllSongs(artistName) |
| | 216 | |
| | 217 | # feed list |
| | 218 | for song in resultset.fetchall(): |
| | 219 | lb.addLabel(song[3]) |
| | 220 | |
| | 221 | # Feed options menu |
| | 222 | lb.addCommand('options', Lang().label('Play'), OPCode()['PLAY']) |
| | 223 | lb.addCommand('options', Lang().label('AddToPlaylist'), OPCode()['DISCONNECT']) |
| | 224 | lb.addCommand('options', Lang().label('NowPlaying'), OPCode()['NOWPLAYING']) |
| | 225 | lb.addCommand('options', Lang().label('Back'), OPCode()['BACK']) |
| | 226 | lb.addCommand('back', Lang().label('Back'), OPCode()['BACK']) |
| | 227 | lb.addCommand('select', Lang().label('Play'), OPCode()['PLAY']) |
| | 228 | |
| | 229 | self._iActionStack.append(actions) |
| | 230 | self._iViewStack.append(lb.getList()) |
| | 231 | self._iListStack.append(id_list) |
| | 232 | |
| | 233 | |
| | 234 | def albums(self): |
| | 235 | print "Audio album" |
| | 236 | lb = ListBox(Lang().label('Albums')) |
| | 237 | actions = [] |
| | 238 | id_list = [] |
| | 239 | |
| | 240 | db = AudioQueries() |
| | 241 | resultset = db.albums() |
| | 242 | |
| | 243 | # feed list |
| | 244 | for album in resultset.fetchall(): |
| | 245 | lb.addLabel(album) |
| | 246 | actions.append(lambda:self.albumSongs(album)) |
| | 247 | |
| | 248 | # Feed options menu |
| | 249 | lb.addCommand('options', Lang().label('Select'), OPCode()['SELECT']) |
| | 250 | lb.addCommand('options', Lang().label('AddToPlaylist'), OPCode()['PLNEW']) |
| | 251 | lb.addCommand('options', Lang().label('NowPlaying'), OPCode()['NOWPLAYING']) |
| | 252 | lb.addCommand('options', Lang().label('Back'), OPCode()['BACK']) |
| | 253 | lb.addCommand('back', Lang().label('Back'), OPCode()['BACK']) |
| | 254 | lb.addCommand('select', Lang().label('Select'), OPCode()['SELECT']) |
| | 255 | |
| | 256 | self._iActionStack.append(actions) |
| | 257 | self._iViewStack.append(lb.getList()) |
| | 258 | self._iListStack.append(id_list) |
| | 259 | |
| | 260 | |
| | 261 | def albumSongs(self, aAlbum): |
| | 262 | print "Audio album songs" |
| | 263 | lb = ListBox(aAlbum) |
| | 264 | actions = [] |
| | 265 | id_list = [] |
| | 266 | |
| | 267 | db = AudioQueries() |
| | 268 | resultset = db.albumSongs(aAlbum) |
| | 269 | |
| | 270 | # feed list |
| | 271 | for song in resultset.fetchall(): |
| | 272 | lb.addLabel(song[3]) |
| | 273 | actions.append(lambda:None) |
| | 274 | |
| | 275 | # Feed options menu |
| | 276 | lb.addCommand('options', Lang().label('Play'), OPCode()['PLAY']) |
| | 277 | lb.addCommand('options', Lang().label('AddToPlaylist'), OPCode()['PLNEW']) |
| | 278 | lb.addCommand('options', Lang().label('NowPlaying'), OPCode()['NOWPLAYING']) |
| | 279 | lb.addCommand('options', Lang().label('Back'), OPCode()['BACK']) |
| | 280 | lb.addCommand('back', Lang().label('Back'), OPCode()['BACK']) |
| | 281 | lb.addCommand('select', Lang().label('Play'), OPCode()['PLAY']) |
| | 282 | |
| | 283 | self._iActionStack.append(actions) |
| | 284 | self._iViewStack.append(lb.getList()) |
| | 285 | |
| | 286 | |
| | 287 | def genres(self): |
| | 288 | print "Audio genres" |
| | 289 | lb = ListBox(Lang().label('Genres')) |
| | 290 | actions = [] |
| | 291 | id_list = [] |
| | 292 | |
| | 293 | db = AudioQueries() |
| | 294 | resultset = db.genres() |
| | 295 | |
| | 296 | # feed list |
| | 297 | for genre in resultset.fetchall(): |
| | 298 | lb.addLabel(genre) |
| | 299 | actions.append(lambda:self.genreSongs(genre)) |
| | 300 | |
| | 301 | # Feed options menu |
| | 302 | lb.addCommand('options', Lang().label('Select'), OPCode()['SELECT']) |
| | 303 | lb.addCommand('options', Lang().label('AddToPlaylist'), OPCode()['PLNEW']) |
| | 304 | lb.addCommand('options', Lang().label('NowPlaying'), OPCode()['NOWPLAYING']) |
| | 305 | lb.addCommand('options', Lang().label('Back'), OPCode()['BACK']) |
| | 306 | lb.addCommand('back', Lang().label('Back'), OPCode()['BACK']) |
| | 307 | lb.addCommand('select', Lang().label('Select'), OPCode()['SELECT']) |
| | 308 | |
| | 309 | self._iActionStack.append(actions) |
| | 310 | self._iViewStack.append(lb.getList()) |
| | 311 | self._iListStack.append(id_list) |
| | 312 | |
| | 313 | |
| | 314 | def genreSongs(self, aGenre): |
| | 315 | print "Audio genres songs" |
| | 316 | lb = ListBox(aGenre) |
| | 317 | actions = [] |
| | 318 | id_list = [] |
| | 319 | |
| | 320 | db = AudioQueries() |
| | 321 | resultset = db.genreSongs( aGenre ) |
| | 322 | |
| | 323 | # feed list |
| | 324 | for song in resultset.fetchall(): |
| | 325 | lb.addLabel(song[3]) |
| | 326 | |
| | 327 | # Feed options menu |
| | 328 | lb.addCommand('options', Lang().label('Play'), OPCode()['PLAY']) |
| | 329 | lb.addCommand('options', Lang().label('AddToPlaylist'), OPCode()['PLNEW']) |
| | 330 | lb.addCommand('options', Lang().label('NowPlaying'), OPCode()['NOWPLAYING']) |
| | 331 | lb.addCommand('options', Lang().label('Back'), OPCode()['BACK']) |
| | 332 | lb.addCommand('back', Lang().label('Back'), OPCode()['BACK']) |
| | 333 | lb.addCommand('select', Lang().label('Play'), OPCode()['PLAY']) |
| | 334 | |
| | 335 | self._iActionStack.append(actions) |
| | 336 | self._iViewStack.append(lb.getList()) |
| | 337 | self._iListStack.append(id_list) |
| | 338 | |
| | 339 | |
| | 340 | def playlists(self): |
| | 341 | print "Audio playlists" |
| | 342 | lb = ListBox(Lang().label('Playlists')) |
| | 343 | actions = [] |
| | 344 | id_list = [] |
| | 345 | |
| | 346 | db = AudioQueries() |
| | 347 | resultset = db.playlists() |
| | 348 | |
| | 349 | # feed list |
| | 350 | for playlist in resultset.fetchall(): |
| | 351 | lb.addLabel(playlist) |
| | 352 | |
| | 353 | # Feed options menu |
| | 354 | lb.addCommand('options', Lang().label('Select'), OPCode()['SELECT']) |
| | 355 | lb.addCommand('options', Lang().label('NowPlaying'), OPCode()['NOWPLAYING']) |
| | 356 | lb.addCommand('options', Lang().label('Back'), OPCode()['BACK']) |
| | 357 | lb.addCommand('back', Lang().label('Back'), OPCode()['BACK']) |
| | 358 | lb.addCommand('select', Lang().label('Select'), OPCode()['SELECT']) |
| | 359 | |
| | 360 | self._iActionStack.append(actions) |
| | 361 | self._iViewStack.append(lb.getList()) |
| | 362 | self._iListStack.append(id_list) |
| | 363 | |
| | 364 | |
| | 365 | def playlistSongs(self): |
| | 366 | print "Audio playlist" |
| | 367 | playlistName="" |
| | 368 | lb = ListBox(playlistName) |
| | 369 | actions = [] |
| | 370 | id_list = [] |
| | 371 | |
| | 372 | db = AudioQueries() |
| | 373 | resultset = db.genreSongs( playlistName ) |
| | 374 | |
| | 375 | # feed list |
| | 376 | for song in resultset.fetchall(): |
| | 377 | lb.addLabel(song[3]) |
| | 378 | |
| | 379 | # Feed options menu |
| | 380 | lb.addCommand('options', Lang().label('Play'), OPCode()['PLAY']) |
| | 381 | lb.addCommand('options', Lang().label('NowPlaying'), OPCode()['NOWPLAYING']) |
| | 382 | lb.addCommand('options', Lang().label('Back'), OPCode()['BACK']) |
| | 383 | lb.addCommand('back', Lang().label('Back'), OPCode()['BACK']) |
| | 384 | lb.addCommand('select', Lang().label('Play'), OPCode()['PLAY']) |
| | 385 | |
| | 386 | self._iActionStack.append(actions) |
| | 387 | self._iViewStack.append(lb.getList()) |
| | 388 | self._iListStack.append(id_list) |
| | 389 | |
| | 390 | |
| | 391 | |
| | 392 | class ViewEngine( object ): |
| | 393 | def __init__(self): |
| | 394 | self._iViewStack = [] |
| | 395 | self._iActionStack = [] |
| | 396 | self._iListStack = [] |
| | 397 | |
| | 398 | self._iAudioView = AudioView(self._iViewStack, self._iActionStack, |
| | 399 | self._iListStack) |
| | 400 | self._iVideoView = VideoView(self._iViewStack, self._iActionStack, |
| | 401 | self._iListStack) |
| | 402 | self._iDvdView = DvdView() |
| | 403 | self._iTvView = TvView() |
| | 404 | |
| | 405 | |
| | 406 | |
| | 407 | |
| | 408 | def select_view(self, aOPCode): |
| | 409 | if aOPCode == OPCode()['HELLO']: |
| | 410 | self._main() |
| | 411 | |
| | 412 | elif aOPCode == 1: |
| | 413 | return self._iViewStack[1]['view']() |
| | 414 | elif aOPCode == 2: |
| | 415 | return self._iViewStack[2]['view']() |
| | 416 | |
| | 417 | return self._iViewStack[-1] |
| | 418 | |
| | 419 | |
| | 420 | def _main(self): |
| | 421 | lb = ListBox('myMRC') |
| | 422 | action = [] |
| | 423 | # Feed listbox |
| | 424 | if Settings().get('settings', 'audio') == '1': |
| | 425 | lb.addLabel(Lang().label('Audio')) |
| | 426 | action.append( self._audio ) |
| | 427 | if Settings().get('settings', 'video') == '1': |
| | 428 | lb.addLabel(Lang().label('Video')) |
| | 429 | action.append( self._video ) |
| | 430 | if Settings().get('settings', 'dvd') == '1': |
| | 431 | lb.addLabel(Lang().label('DVD')) |
| | 432 | action.append( self._DVD ) |
| | 433 | if Settings().get('settings', 'tv') == '1': |
| | 434 | lb.addLabel(Lang().label('TV')) |
| | 435 | action.append( self._TV ) |
| | 436 | |
| | 437 | # Feed options menu |
| | 438 | lb.addCommand('options', Lang().label('Select'), OPCode()['SELECT']) |
| | 439 | lb.addCommand('options', Lang().label('Disconnect'), OPCode()['DISCONNECT']) |
| | 440 | lb.addCommand('options', Lang().label('Settings'), OPCode()['SETTINGS']) |
| | 441 | lb.addCommand('options', Lang().label('About'), OPCode()['ABOUT']) |
| | 442 | lb.addCommand('options', Lang().label('Exit'), OPCode()['EXIT']) |
| | 443 | lb.addCommand('back', Lang().label('Exit'), OPCode()['EXIT']) |
| | 444 | lb.addCommand('select', Lang().label('Select'), OPCode()['SELECT']) |
| | 445 | self._iViewStack.append(lb.getList()) |
| | 446 | self._iActionStack.append(action) |
| | 447 | |
| | 448 | def _audio(self): |
| | 449 | print "audio" |
| | 450 | self._iAudioView.main() |
| | 451 | |
| | 452 | |
| | 453 | def _video(self): |
| | 454 | self._iVideoView.main() |
| | 455 | |
| | 456 | |
| | 457 | def _DVD(self): |
| | 458 | print "DVD" |
| | 459 | |
| | 460 | |
| | 461 | def _TV(self): |
| | 462 | print "TV" |
| | 463 | |
| | 464 | def getResultset(self): |
| | 465 | return self._iResultSet |
| | 466 | |
| | 467 | def getActions(self): |
| | 468 | return self._iActionStack[-1] |
| | 469 | |
| | 470 | def getView(self): |
| | 471 | return self._iViewStack[-1] |
| | 472 | |
| | 473 | def getStack(self): |
| | 474 | return self._iListStack[-1] |
| | 475 | |
| | 476 | def back(self): |
| | 477 | if len(self._iViewStack)-1 > 0: |
| | 478 | self._iViewStack.pop() |
| | 479 | self._iActionStack.pop() |
| | 480 | print len(self._iViewStack) |
| | 481 | return self._iViewStack[-1] |
| | 482 | |
| | 483 | class ClientEngine( object ): |
| | 484 | def __init__(self, aSendCb): |
| | 485 | self._iViewEngine = ViewEngine() |
| | 486 | self.send = aSendCb |
| | 487 | DBDriver( '/home/dlefevre/workspace/mymrc/src' ) |
| | 488 | #self.handle_event(PacketBuilder().build('0000', '')) |
| | 489 | |
| | 490 | def handle_event(self, aEvent): |
| | 491 | print "Event received: ", aEvent |
| | 492 | opcode, length, value = PacketParser().parse(aEvent) |
| | 493 | |
| | 494 | ## UI |
| | 495 | if opcode == OPCode()['HELLO']: |
| | 496 | self._iViewEngine.select_view(opcode) |
| | 497 | retVal = self._iViewEngine.getView() |
| | 498 | self.send(PacketBuilder().build(OPCode()['PARSELS'], retVal)) |
| | 499 | elif opcode == OPCode()['SELECT']: |
| | 500 | actions = self._iViewEngine.getActions() |
| | 501 | actions[int(value)]() |
| | 502 | retVal = self._iViewEngine.getView() |
| | 503 | self.send(PacketBuilder().build(OPCode()['PARSELS'], retVal)) |
| | 504 | |
| | 505 | elif opcode == OPCode()['BACK']: |
| | 506 | retVal = self._iViewEngine.back() |
| | 507 | self.send(PacketBuilder().build(OPCode()['PARSELS'], retVal)) |
| | 508 | |
| | 509 | |
| | 510 | # controller |
| | 511 | elif opcode == OPCode()['PLAY']: |
| | 512 | try: |
| | 513 | print "value: ", value |
| | 514 | id = self._iViewEngine.getStack()[int(value)] |
| | 515 | path = AudioQueries().songById(id) |
| | 516 | print path |
| | 517 | AudioController().play( path[0] ) |
| | 518 | except: |
| | 519 | pass |
| | 520 | |
| | 521 | |
| | 522 | |
| | 523 | |
| | 524 | if __name__ == '__main__': |
| | 525 | Settings('/home/dlefevre/workspace/mymrc/src') |
| | 526 | Lang('/home/dlefevre/workspace/mymrc/src') |
| | 527 | DBDriver( '/home/dlefevre/workspace/mymrc/src' ) |
| | 528 | #resultset = DBDriver( '/home/dlefevre/workspace/mymrc/src' ).execute(query) |
| | 529 | #print resultset.fetchall() |
| | 530 | |
| | 531 | |
| | 532 | #query = "INSERT INTO song (artist_id, title, path, album_id, track_no, genre_id)"\ |
| | 533 | #"values (%d, '%s', '%s', %d, %d, %d)" %(1, |
| | 534 | # unicode('Counting Crows - Mr. Jones.mp3'), |
| | 535 | # unicode('/home/storage/Music/Counting Crows - Mr. Jones.mp3'), |
| | 536 | # 1, |
| | 537 | # 1, |
| | 538 | # 1 |
| | 539 | # ) |
| | 540 | #query = "INSERT INTO artist (name) values ('%s')" %(unicode('Counting Crows')) |
| | 541 | #query = "INSERT INTO genre (name) values ('%s')" %(unicode('Rock')) |
| | 542 | #print "All songs" |
| | 543 | #print AudioView().allSongs() |
| | 544 | #print "Artists" |
| | 545 | #print AudioView().artists() |
| | 546 | #print "Artist albums" |
| | 547 | #print AudioView().artistAlbums() |
| | 548 | #print "Artist album songs" |
| | 549 | #print AudioView().artistAlbumSongs() |
| | 550 | #print "Artist All songs" |
| | 551 | #print AudioView().artistAllSongs() |
| | 552 | #print "albums" |
| | 553 | #print AudioView().albums() |
| | 554 | #print "Album Songs" |
| | 555 | #print AudioView().albumSongs() |
| | 556 | #print "Genres" |
| | 557 | #print AudioView().genres() |
| | 558 | #print "Genre Songs" |
| | 559 | #print AudioView().genreSongs() |
| | 560 | #print "playlists" |
| | 561 | #print AudioView().playlists() |
| | 562 | #print "Playlist Songs" |
| | 563 | #print AudioView().playlistSongs() |
| | 564 | |
| | 565 | query = """ INSERT INTO song (title, path) values ('Gin Blossoms - Allison Road', '/home/storage/Music/Gin Blossoms - Allison Road.mp3')""" |
| | 566 | query = """SELECT * FROM song""" |
| | 567 | rs = DBDriver().execute(query) |
| | 568 | print rs.fetchall() |
| | 569 | |
| | 570 | |
| | 571 | def send(aData): |
| | 572 | print aData |
| | 573 | |
| | 574 | engine = ClientEngine( send ) |
| | 575 | |
| | 576 | while True: |
| | 577 | entry = raw_input('>>>').strip() |
| | 578 | if entry == 'hello': |
| | 579 | engine.handle_event(PacketBuilder().build(OPCode()['HELLO'],'')) |
| | 580 | elif entry == 'select': |
| | 581 | entry = raw_input('Index >>>').strip() |
| | 582 | engine.handle_event(PacketBuilder().build(OPCode()['SELECT'], entry) ) |
| | 583 | elif entry == 'back': |
| | 584 | engine.handle_event(OPCode()['BACK']) |
| | 585 | elif entry == 'q': |
| | 586 | break |
| | 587 | |
| | 588 | print "Bye bye" |
| | 589 | |
| | 590 | |
| | 591 | |