Python dump_as_csv Examples

Example #1

def spiderweb_download(project):
    projectdb = app.config['projectdb']
    print("hello")
    conn = pymysql.connect(host='127.0.0.1',port=3306,user='******',password='******',db='repository',charset='utf8')
    dbcur= conn.cursor()
    dbcur.execute('select * from shuiliting')
    results = result_dump.select(dbcur)
    _format = 'txt'
    print(results)
    if _format == 'json':
        valid = request.args.get('style', 'rows') == 'full'
        return Response(result_dump.dump_as_json(results, valid),
                        mimetype='application/json')
    elif _format == 'txt':
        return Response(result_dump.dump_as_txt(results),
                        mimetype='text/plain')
    elif _format == 'csv':
        return Response(result_dump.dump_as_csv(results),
                        mimetype='text/csv')

Example #2

File: result.py Project: v0ila/Lauwersscan

def dump_result(project, _format):
    resultdb = app.config['resultdb']
    # force update project list
    resultdb.get(project, 'any')
    if project not in resultdb.projects:
        return "no such project.", 404

    offset = int(request.args.get('offset', 0))
    limit = int(request.args.get('limit', 0)) or None
    results = resultdb.select(project, offset=offset, limit=limit)

    if _format == 'json':
        valid = request.args.get('style', 'rows') == 'full'
        return Response(result_dump.dump_as_json(results, valid),
                        mimetype='application/json')
    elif _format == 'txt':
        return Response(result_dump.dump_as_txt(results),
                        mimetype='text/plain')
    elif _format == 'csv':
        return Response(result_dump.dump_as_csv(results), mimetype='text/csv')

Example #3

File: result.py Project: qiulimao/weblocust

def dump_result(project, _format):
    resultdb = app.config['resultdb']
    # force update project list
    resultdb.get(project, 'any')
    if project not in resultdb.projects:
        return "no such project.", 404

    offset = int(request.args.get('offset', 0)) or None
    limit = int(request.args.get('limit', 0)) or None
    results = resultdb.select(project, offset=offset, limit=limit)

    if _format == 'json':
        valid = request.args.get('style', 'rows') == 'full'
        return Response(result_dump.dump_as_json(results, valid),
                        mimetype='application/json')
    elif _format == 'txt':
        return Response(result_dump.dump_as_txt(results),
                        mimetype='text/plain')
    elif _format == 'csv':
        return Response(result_dump.dump_as_csv(results),
                        mimetype='text/csv')

Example #4

File: test_result_dump.py Project: 01jiagnwei01/pyspider

 def test_dump_as_csv_case_1(self):
     reader = csv.reader(StringIO(''.join(result_dump.dump_as_csv(result_list_error))))
     for row in reader:
         self.assertEqual(len(row), 2)

Example #5

File: test_result_dump.py Project: 01jiagnwei01/pyspider

 def test_dump_as_csv(self):
     reader = csv.reader(StringIO(''.join(result_dump.dump_as_csv(results1))))
     for row in reader:
         self.assertEqual(len(row), 4)

Example #6

File: test_result_dump.py Project: CoderLeague/research_pyspider

 def test_dump_as_csv_case_1(self):
     reader = csv.reader(
         StringIO(''.join(result_dump.dump_as_csv(result_list_error))))
     for row in reader:
         self.assertEqual(len(row), 2)

Example #7

File: test_result_dump.py Project: CoderLeague/research_pyspider

 def test_dump_as_csv(self):
     reader = csv.reader(
         StringIO(''.join(result_dump.dump_as_csv(results1))))
     for row in reader:
         self.assertEqual(len(row), 4)