Python query Examples

Example #1

File: playlist.py Project: SpeakerBlack/Raptor

def listItems():
    r = cocomo.query(
        "SELECT CONCAT('[',CONCAT(GROUP_CONCAT(REPLACE(track_json,\";\",'\"')),']')) FROM track_playlist WHERE id_playlist = '"
        + _POST["id"]
        + "'"
    )
    cocomo.printJson(r, "success")

Example #2

File: playlist.py Project: SpeakerBlack/Raptor

def listByUser():
    r = cocomo.query("SELECT id_playlist , nombre FROM playlist WHERE id_user = '******'")
    cocomo.printJson(r, "success")

Example #3

File: playlist.py Project: camarin24/Raptor

def listByUser():
    r = cocomo.query(
        "SELECT id_playlist , nombre FROM playlist WHERE id_user = '******'id'] + "'")
    cocomo.printJson(r, "success")

Example #4

File: playlist.py Project: camarin24/Raptor

def listItems():
    r = cocomo.query(
        "SELECT CONCAT('[',CONCAT(GROUP_CONCAT(REPLACE(track_json,\";\",'\"')),']')) FROM track_playlist WHERE id_playlist = '"
        + _POST['id'] + "'")
    cocomo.printJson(r, "success")

Example #5

File: user.py Project: camarin24/Raptor

def getDownloadUser():
	_result = cocomo.query("CALL getDownloaUser ( " + _POST['id_user'] + " )")
	cocomo.printJson(_result, "success")