def delete_data(request): sq_acttax2 = request.data["sq_acttax2"] #if sq_acttax2: # sq_acttax2 = eval(sq_acttax2) if (type(sq_acttax2)) is list: sq_acttax2 = tuple(sq_acttax2) query = 'delete from fta_acttax2 ' if len(sq_acttax2) is 1: query += ' where sq_acttax2 = %s' % (sq_acttax2[0]) else: query += ' where sq_acttax2 in %s' % (str(sq_acttax2)) # query = 'delete from fta_acttax2 ' # query += ' where sq_acttax2 = %s' % (sq_acttax2) try: state = status.HTTP_200_OK cursor = connection.cursor() cursor.execute(query) except psycopg2.Error: state = status.HTTP_500_INTERNAL_SERVER_ERROR result = Response(json_result(stat=state)) return result
def detail_data1(request, question_id): sq_acttax2 = question_id if request.method == "PUT": query = 'update fta_acttax2 ' subqry = '' for key in request.data.keys(): if subqry: subqry += ' ,' else: subqry = ' set' subqry += ' %s = \'%s\'' % (key, request.data[key]) query += subqry query += ' where sq_acttax2 = %s;' % (sq_acttax2) query += select_normal_slipinput(sq_acttax2=sq_acttax2) try: state = status.HTTP_200_OK cursor = connection.cursor() cursor.execute(query) rows = name_to_json(cursor) data = { 'data': rows, 'length': len(rows), } except psycopg2.Error: state = status.HTTP_500_INTERNAL_SERVER_ERROR data = {} result = Response(json_result(stat=state, data=data)) elif request.method == "DELETE": query = 'delete from fta_acttax2 ' query += ' where sq_acttax2 = %s' % (sq_acttax2) try: state = status.HTTP_200_OK cursor = connection.cursor() cursor.execute(query) except psycopg2.Error: state = status.HTTP_500_INTERNAL_SERVER_ERROR result = Response(json_result(stat=state)) return result
def get_data(request): query = 'select * from ftb_trade ' try: cursor = connection.cursor() cursor.execute(query) rows = name_to_json(cursor) data = { 'data': rows, 'length': len(rows), } except psycopg2.Error: print("error") result = Response(json_result(stat=status.HTTP_200_OK, data=data)) return result
def cash_balnce(request, from_date, to_date): query = select_cash_balance(from_date, to_date) try: state = status.HTTP_200_OK cursor = connection.cursor() cursor.execute(query) rows = name_to_json(cursor) data = { 'data': rows, 'length': len(rows), } except psycopg2.Error: state = status.HTTP_500_INTERNAL_SERVER_ERROR data = {} result = Response(json_result(stat=state, data=data)) return result
def select_data1(request): from_date = request.data["date_from"] to_date = request.data["date_to"] query = select_normal_slipinput(from_date, to_date) try: cursor = connection.cursor() cursor.execute(query) rows = name_to_json(cursor) data = { 'data': rows, 'length': len(rows), } except psycopg2.Error: print("error") result = Response(json_result(stat=status.HTTP_200_OK, data=data)) return result
def insert_data(request): try: #NOT NULL항목 da_date = request.data["da_date"] ty_gubn = request.data["ty_gubn"] key_acctit = request.data["key_acctit"] cd_acctit = request.data["cd_acctit"] mn_bungae = request.data["mn_bungae"] #NOT NULL항목 종료 cd_trade = request.data["cd_trade"] nm_trade = request.data["nm_trade"] cd_remark = request.data["cd_remark"] nm_remark = request.data["nm_remark"] query = 'insert into fta_acttax2 (da_date, ty_gubn, key_acctit, cd_acctit, mn_bungae, cd_trade, nm_trade, cd_remark, nm_remark, id_insert, dt_insert)' query += ' values(\'%s\', \'%s\', \'%s\', \'%s\', %s, \'%s\', \'%s\', \'%s\', \'%s\', \'admin\', now())' % ( da_date, ty_gubn, key_acctit, cd_acctit, mn_bungae, cd_trade, nm_trade, cd_remark, nm_remark) query += ' returning sq_acttax2, no_acct, sq_bungae;' try: state = status.HTTP_200_OK cursor = connection.cursor() cursor.execute(query) rows = name_to_json(cursor) data = { 'data': rows, 'length': len(rows), } except psycopg2.Error: state = status.HTTP_500_INTERNAL_SERVER_ERROR data = {} except: state = status.HTTP_417_EXPECTATION_FAILED data = {} result = Response(json_result(stat=state, data=data)) return result
def update_data(request): sq_acttax2 = request.data["sq_acttax2"] update = request.data["update"] # column = request.data["column"] # value = request.data["value"] # another = request.data["another"] query = 'update fta_acttax2 ' subqry = '' for cont in update: if subqry: subqry += ' ,' else: subqry = ' set' subqry += ' %s = \'%s\'' % (cont["column"], cont["value"]) query += subqry # query += ' set %s = %s %s' % (column, value, another) query += ' where sq_acttax2 = %s' % (sq_acttax2) #column = request.data["column"] #value = request.data["value"] #another = request.data["another"] #query = 'update fta_acttax2 ' #query += ' set %s = %s %s' % (column, value, another) #query += ' where sq_acttax2 = %s' %(sq_acttax2) try: state = status.HTTP_200_OK cursor = connection.cursor() cursor.execute(query) except psycopg2.Error: state = status.HTTP_500_INTERNAL_SERVER_ERROR result = Response(json_result(stat=status.HTTP_200_OK)) return result