#
# # tuple_example = (2, 1, 5, 2, 2, 1, 1, 5)
# # print(tuple_example[5])
# #
# # list_a = [2, 3, 5, 8, 4, 0]
# # # print(list_a[3])
# # print(list_a)
# # list_a.append(10)
#
# # print(list_a)
#
# dictionary_example = {
#     "name": "karthika",
#     "age": 28
# }
#
# dictionary_example['age'] = 28
#
# print(dictionary_example)
# print(dictionary_example['age'])


from flask import jsonify, make_response
from flask_restful import Resource, reqparse
from app import db


class MultipleRows(Resource):
    def post(self):
        parser = reqparse.RequestParser()
        parser.add_argument('a')
        parser.add_argument('b')
        parser.add_argument('sipname')
        args = parser.parse_args()
        a = args['a']
        b = args['b']
        sipname = args['sipname']

        result_list = []

        #sipname = 31
        sql_str = "SELECT * FROM `extensions` WHERE `extn_group_id`={}".format(args["sipname"])
        result = db.engine.execute(sql_str)

        for rows in result:
            # print("res -->"+str(rows))
            result_data = {}
            result_data['extension_number'] = rows[1]
            result_data['sipusername'] = rows[5]
            result_list.append(result_data)

        return jsonify(staus=1, message="Success", result=result_list)