Python query示例

示例#1

文件： playlist.py 项目： 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")

示例#2

文件： playlist.py 项目： SpeakerBlack/Raptor

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

示例#3

文件： playlist.py 项目： camarin24/Raptor

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

示例#4

文件： playlist.py 项目： 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")

示例#5

文件： user.py 项目： camarin24/Raptor

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