Пример #1
0
def _string2dataframe(data):
    sb = io(data)
    dataFrame = pd.read_csv(
        sb,
        #                             sep=' ',
        names=('d', 'bin_no')).sort('d')
    return dataFrame
Пример #2
0
def _string2dataframe(data):
    sb = io(data)
    dataFrame = pd.read_csv(sb,
#                             sep=' ',
                            names=('d', 'bin_no')
                           ).sort('d')
    return dataFrame
Пример #3
0
 def deleteinfo(self, number, file_path):
     read = io.io()
     information = []
     information = read.read(information, file_path)
     for i in information:
         if i[0] == number:
             information.remove(i)
     read.write(information, file_path)
Пример #4
0
        def export(cls, request, *args, **kwargs):
            page_size = int(request.GET.get('limit'))
            offset = int(request.GET.get('offset'))
            filters = request.GET.get('filter')
            sort = request.GET.get('sort')
            order = request.GET.get('order')
            date = request.GET.get('date')
            file_type = request.GET.get('type')

            date = UDatetime.datetime_str_init(date).date()

            data, num = DataDAO.get_productopt(
                                                 date=date,
                                                 pagination=True,
                                                 page_size=page_size,
                                                 offset=offset,
                                                 filters=filters,
                                                 sort=sort,
                                                 order=order,
                                               )

            # Replace columns
            product_records = cls.get_products()
            product_records['name'] = \
                product_records['short_product_name'] + ' {' + product_records['product_num'] + '}'
            product_map = dict(zip(product_records['product_id'], product_records['name']))
            columns = ['center_id', 'center_name'] + product_records['product_id'].tolist()
            data = data.reindex(columns=columns)
            data.rename(columns=product_map, inplace=True)
            data['center_id'] = data['center_id'].astype(int)

            if file_type == 'json':
                response = json.dumps(data.to_dict(orient='records'), ensure_ascii=False)
                response = HttpResponse(response, content_type='application/json')
                response['Content-Disposition'] = 'attachment; filename=export.json'
            elif file_type == 'csv':
                response = data.to_csv(index=False)
                response = HttpResponse(response, content_type='application/csv')
                response['Content-Disposition'] = 'attachment; filename=export.csv'
            elif file_type == 'xlsx':
                response = io()
                xlwriter = pd.ExcelWriter(response)
                data.to_excel(xlwriter, index=False)

                xlwriter.save()
                xlwriter.close()
                response.seek(0)

                response = HttpResponse(response.read(),
                                        content_type='application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
                                        )
                response['Content-Disposition'] = 'attachment; filename=export.xlsx'
            else:
                response = json.dumps([], ensure_ascii=False)
                response = HttpResponse(response, content_type='application/json')
                response['Content-Disposition'] = 'attachment; filename=export.json'

            return response
Пример #5
0
 def startTest(self, test):
     TestResult.startTest(self, test)
     # just one buffer for both stdout and stderr
     self.outputBuffer = io.io()
     stdout_redirector.fp = self.outputBuffer
     stderr_redirector.fp = self.outputBuffer
     self.stdout0 = sys.stdout
     self.stderr0 = sys.stderr
     sys.stdout = stdout_redirector
     sys.stderr = stderr_redirector
Пример #6
0
 def changeinfo(self, number, file_path):
     read = io.io()
     information = []
     information = read.read(information, file_path)
     for i in information:
         if i[0] == number:
             print u"please input the student's information that you want to change like n:"
             keyword = raw_input(u"please input what you want:")
             keyword = keyword + '/n'
             information[information.index(i)] = keyword.split(" ")
     read.write(information, file_path)
Пример #7
0
 def getmeta(self):
     Assert(self.state == META)
     if not self.readahead:
         x, y = self.pollmeta(None)
         while not y:
             x, y = self.pollmeta(None)
     file = io.io(self.readahead)
     errcode, errmsg, headers = self.h.getreply(file)
     self.state = DATA
     self.readahead = file.read()
     return errcode, errmsg, headers
Пример #8
0
def upload_file(file, size=None):
    aa = ' '
    msize = 200000000
    osize = size
    if size == None:
        file = file.read()
        size, file = len(file), io(file)
    while size > msize:
        aa += post_data(file.read(msize)) + ' '
        size -= msize
    if size:
        aa += post_data(file.read(size)) + ' '
    return post_data(aa.encode())
Пример #9
0
 async def cbitcmd(self, message):
     """.cbit <число от 0 до 255"""
     reply = await message.get_reply_message()
     if not reply or not reply.file or not "image" in reply.file.mime_type:
         return await message.edit("<b>Reply to image!</b>")
     x = utils.get_args_raw(message)
     x = int(x) if x.isdigit() else 8
     if x <= 0 or x >= 256:
         x = 8
     x = 256 // x
     im = Image.open(io(await reply.download_media(bytes)))
     w, h = im.size
     mode = im.mode
     out = []
     await message.edit("<b>Processing...</b>")
     for bit in list(im.tobytes()):
         bit = list(range(0, 256 + x, x))[bit // x]
         out.append(bit)
     image = Image.frombytes(mode, (w, h), bytes(out))
     output = io()
     image.save(output, "PNG")
     output.seek(0)
     await message.delete()
     await reply.reply(file=output)
Пример #10
0
    def format_directory(self):
        # XXX Unixism
        if self.url and self.url[-1] != '/':
            self.url = self.url + '/'
        fp = os.popen("ls -l -a %s/. 2>&1" % self.pathname, "r")
        lines = fp.readlines()
        fp.close()
        import io
        import re
        from urllib import quote
        from urllib import urljoin
        import regsub

        def escape(s, regsub=regsub):
            if not s: return ""
            s = regsub.gsub('&', '&amp;', s)  # Must be done first
            s = regsub.gsub('<', '&lt;', s)
            s = regsub.gsub('>', '&gt;', s)
            return s

        prog = re.compile(self.listing_pattern)
        data = self.listing_header % {
            'url': self.url,
            'pathname': escape(self.pathname)
        }
        for line in lines:
            if line[-1] == '\n': line = line[:-1]
            if prog.match(line) < 0:
                line = escape(line) + '\n'
                data = data + line
                continue
            mode, middle, name = prog.group(1, 2, 3)
            rawname = name
            [mode, middle, name] = map(escape, [mode, middle, name])
            href = urljoin(self.url, quote(rawname))
            if len(mode) == 10 and mode[0] == 'd' or name[-1:] == '/':
                if name[-1:] != '/':
                    name = name + '/'
                if href[-1:] != '/':
                    href = href + '/'
            line = '%s%s<A HREF="%s">%s</A>\n' % (mode, middle, escape(href),
                                                  name)
            data = data + line
        data = data + self.listing_trailer
        self.fp = io.io(data)
        self.headers['content-type'] = 'text/html'
        self.headers['content-length'] = str(len(data))
Пример #11
0
        def export(request, *args, **kwargs):
            district = request.GET.getlist('district[]')
            region = request.GET.getlist('region[]')
            page_size = request.GET.get('limit')
            offset = request.GET.get('offset')
            filters = request.GET.get('filter')
            sort = request.GET.get('sort')
            order = request.GET.get('order')
            file_type = request.GET.get('type')

            pagination = True

            if page_size:
                page_size = int(page_size)
            if offset:
                offset = int(offset)

            columns = [
                    'center_id',
                       'center_name',
                       'region',
                       'district',
                       ]

            data, num = TestDAO.get_centers(
                                            region,
                                            district,
                                            columns,
                                            pagination=True,
                                            page_size=page_size,
                                            offset=offset,
                                            filters=filters,
                                            sort=sort,
                                            order=order,
                                            )

            # data = data.where((pd.notnull(data)), "")
            #data.columns = map(str.capitalize, data.columns)

            if file_type == 'json':
                response = json.dumps(data.to_dict(orient='records'), ensure_ascii=False)
                response = HttpResponse(response, content_type='application/json')
                response['Content-Disposition'] = 'attachment; filename=export.json'
            elif file_type == 'csv':
                response = data.to_csv(index=False)
                response = HttpResponse(response, content_type='application/csv')
                response['Content-Disposition'] = 'attachment; filename=export.csv'
            elif file_type == 'xlsx':
                response = io()
                xlwriter = pd.ExcelWriter(response)
                data.to_excel(xlwriter, index=False)

                xlwriter.save()
                xlwriter.close()
                response.seek(0)

                response = HttpResponse(response.read(), content_type='application/vnd.openxmlformats-officedocument.spreadsheetml.sheet')
                response['Content-Disposition'] = 'attachment; filename=export.xlsx'
            else:
                response = json.dumps([], ensure_ascii=False)
                response = HttpResponse(response, content_type='application/json')
                response['Content-Disposition'] = 'attachment; filename=export.json'

            return response
Пример #12
0
def _string2Dataframe(data, log=True):
    sb = io(data)
    dataFrame = pd.read_csv(sb, sep=' ', names=('d', 'amp')).sort_values('d')
    if log:
        dataFrame.amp = 10**dataFrame.amp
    return dataFrame
Пример #13
0
        def export(request, *args, **kwargs):
            page_size = int(request.GET.get('limit'))
            offset = int(request.GET.get('offset'))
            filters = request.GET.get('filter')
            sort = request.GET.get('sort')
            order = request.GET.get('order')
            start = request.GET.get('start')
            end = request.GET.get('end')
            file_type = request.GET.get('type')
            product_list = request.GET.getlist('product[]')

            start = UDatetime.datetime_str_init(start).date()
            end = UDatetime.datetime_str_init(end,
                                              start,
                                              default_delta=DEFAULT_RANGE)
            if type(end) == datetime.datetime:
                end = end.date()

            # init product_list
            product_list_new = []
            for product_ids in product_list:
                product_list_new += product_ids.split(',')

            data, num = GetEvent.get_event_price_table(start,
                                                       end,
                                                       product_list_new,
                                                       pagination=True,
                                                       page_size=page_size,
                                                       offset=offset,
                                                       filters=filters,
                                                       sort=sort,
                                                       order=order)
            data = data.where((pd.notnull(data)), "")
            data.columns = map(str.capitalize, data.columns)

            if file_type == 'json':
                response = json.dumps(data.to_dict(orient='records'),
                                      ensure_ascii=False)
                response = HttpResponse(response,
                                        content_type='application/json')
                response[
                    'Content-Disposition'] = 'attachment; filename=tableExport.json'
            elif file_type == 'csv':
                response = data.to_csv(index=False)
                response = HttpResponse(response,
                                        content_type='application/csv')
                response[
                    'Content-Disposition'] = 'attachment; filename=tableExport.csv'
            elif file_type == 'xlsx':
                response = io()
                xlwriter = pd.ExcelWriter(response)
                data.to_excel(xlwriter, index=False)

                xlwriter.save()
                xlwriter.close()
                response.seek(0)

                response = HttpResponse(
                    response.read(),
                    content_type=
                    'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
                )
                response[
                    'Content-Disposition'] = 'attachment; filename=tableExport.xlsx'
            # elif type == 'excel':
            #     writer = pd.ExcelWriter('export.xlsx')
            #     response = data.to_excel(writer)
            #     writer.save()
            #     response = HttpResponse(response, content_type='application/vnd.ms-excel')
            #     response['Content-Disposition'] = 'attachment; filename=export.xlsx'
            else:
                response = json.dumps([], ensure_ascii=False)
                response = HttpResponse(response,
                                        content_type='application/json')
                response[
                    'Content-Disposition'] = 'attachment; filename=export.json'

            return response
Пример #14
0
 def addinfo(self, student, file_path):
     read = io.io()
     read.add(student, file_path)
Пример #15
0
 def scoresort(self,file_path):
     read=io.io()
     information=[]
     information=read.read(information,file_path)
     sorted_information=sorted(information,key=lambda student:student[3])
     print_stu.printstudent(sorted_information)
Пример #16
0
        def export(request, *args, **kwargs):
            page_size = request.GET.get('limit')
            offset = request.GET.get('offset')
            filters = request.GET.get('filter')
            sort = request.GET.get('sort')
            order = request.GET.get('order')
            product = request.GET.get('product')
            as_of_date = request.GET.get('as_of_date')
            file_type = request.GET.get('type')

            as_of_date = UDatetime.datetime_str_init(as_of_date).date()
            pagination = True

            if page_size:
                page_size = int(page_size)
            if offset:
                offset = int(offset)

            if product == 'retail bowling':
                product_ids = ProductChoice.retail_bowling_ids_new_short
            elif product == 'retail shoe':
                product_ids = ProductChoice.retail_shoe_product_ids_new
            elif product == 'after party friday':
                product_ids = [
                    '2146481686', '2146532909', '2146507303', '2146481687'
                ]
            elif product:
                product_ids = [product]
            else:
                product_ids = ProductChoice.retail_bowling_ids_new_short

            data, num = DataDAO.get_centers(pagination=pagination,
                                            page_size=page_size,
                                            offset=offset,
                                            filters=filters,
                                            sort=sort,
                                            order=order,
                                            last_price=True,
                                            last_price_product_ids=product_ids,
                                            last_price_from_change=True,
                                            lastPriceSplit=True,
                                            columns=[
                                                'center_name', 'region',
                                                'district', 'brand',
                                                'time_zone', 'center_type'
                                            ],
                                            as_of_date=as_of_date)

            # data = data.where((pd.notnull(data)), "")
            data.columns = map(str.capitalize, data.columns)

            if file_type == 'json':
                response = json.dumps(data.to_dict(orient='records'),
                                      ensure_ascii=False)
                response = HttpResponse(response,
                                        content_type='application/json')
                response[
                    'Content-Disposition'] = 'attachment; filename=export.json'
            elif file_type == 'csv':
                response = data.to_csv(index=False)
                response = HttpResponse(response,
                                        content_type='application/csv')
                response[
                    'Content-Disposition'] = 'attachment; filename=export.csv'
            elif file_type == 'xlsx':
                response = io()
                xlwriter = pd.ExcelWriter(response)
                data.to_excel(xlwriter, index=False)

                xlwriter.save()
                xlwriter.close()
                response.seek(0)

                response = HttpResponse(
                    response.read(),
                    content_type=
                    'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
                )
                response[
                    'Content-Disposition'] = 'attachment; filename=export.xlsx'
            # elif type == 'excel':
            #     writer = pd.ExcelWriter('export.xlsx')
            #     response = data.to_excel(writer)
            #     writer.save()
            #     response = HttpResponse(response, content_type='application/vnd.ms-excel')
            #     response['Content-Disposition'] = 'attachment; filename=export.xlsx'
            else:
                response = json.dumps([], ensure_ascii=False)
                response = HttpResponse(response,
                                        content_type='application/json')
                response[
                    'Content-Disposition'] = 'attachment; filename=export.json'

            return response
Пример #17
0
        def export(request, *args, **kwargs):
            page_size = int(request.GET.get('limit'))
            offset = int(request.GET.get('offset'))
            filters = request.GET.get('filter')
            sort = request.GET.get('sort')
            order = request.GET.get('order')
            start = request.GET.get('start')
            end = request.GET.get('end')
            menu_id = request.GET.get('menu_id')
            file_type = request.GET.get('type')

            # Get all selection values
            category = request.GET.getlist('category')
            district = request.GET.getlist('district')
            region = request.GET.getlist('region')
            center_id = request.GET.getlist('center_id')

            # Find if all in the selections
            if category and 'all' in category:
                category = []
            if district and 'all' in district:
                district = []
            if region and 'all' in region:
                region = []
            if center_id and 'all' in center_id:
                center_id = []

            # Remove empty string
            category = [item for item in category if item]
            district = [item for item in district if item]
            region = [item for item in region if item]
            center_id = [item for item in center_id if item]

            start = UDatetime.datetime_str_init(
                start).date() if start else UDatetime.now_local().date()

            data, num = FoodDataDao.getFoodByCenter(menu_id,
                                                    start,
                                                    category,
                                                    district,
                                                    region,
                                                    center_id,
                                                    pagination=True,
                                                    page_size=page_size,
                                                    offset=offset,
                                                    filters=filters,
                                                    sort=sort,
                                                    order=order,
                                                    download=True)

            if file_type == 'json':
                response = json.dumps(data.to_dict(orient='records'),
                                      ensure_ascii=False)
                response = HttpResponse(response,
                                        content_type='application/json')
                response[
                    'Content-Disposition'] = 'attachment; filename=export.json'
            elif file_type == 'csv':
                response = data.to_csv(index=False)
                response = HttpResponse(response,
                                        content_type='application/csv')
                response[
                    'Content-Disposition'] = 'attachment; filename=export.csv'
            elif file_type == 'xlsx':
                response = io()
                xlwriter = pd.ExcelWriter(response)
                data.to_excel(xlwriter, index=False)

                xlwriter.save()
                xlwriter.close()
                response.seek(0)

                response = HttpResponse(
                    response.read(),
                    content_type=
                    'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
                )
                response[
                    'Content-Disposition'] = 'attachment; filename=export.xlsx'
            else:
                response = json.dumps([], ensure_ascii=False)
                response = HttpResponse(response,
                                        content_type='application/json')
                response[
                    'Content-Disposition'] = 'attachment; filename=export.json'

            return response
Пример #18
0
        def export(cls, request, *args, **kwargs):
            page_size = int(request.GET.get('limit'))
            offset = int(request.GET.get('offset'))
            filters = request.GET.get('filter')
            sort = request.GET.get('sort')
            order = request.GET.get('order')
            date = request.GET.get('date')
            file_type = request.GET.get('type')

            date = UDatetime.datetime_str_init(date).date()

            # Get all selection values
            sale_region = request.GET.getlist('sale_region[]')
            territory = request.GET.getlist('territory[]')
            center_id = request.GET.getlist('center_id[]')
            center_name = request.GET.getlist('center_name[]')
            columns = request.GET.getlist('columns[]')

            # Find if all in the selections
            if sale_region and 'all' in sale_region:
                sale_region = []
            if territory and 'all' in territory:
                territory = []
            if center_id and 'all' in center_id:
                center_id = []
            if center_name and 'all' in center_name:
                center_name = []
            if columns and 'all' in columns:
                columns = []

            # Remove empty string
            sale_region = [item for item in sale_region if item]
            territory = [item for item in territory if item]
            center_id = [item for item in center_id if item]
            center_name = [item for item in center_name if item]
            columns = [item for item in columns if item]

            data, num = EventDataDao.get_event_RMPS(sale_region,
                                                    territory,
                                                    center_id,
                                                    center_name,
                                                    columns,
                                                    pagination=True,
                                                    page_size=page_size,
                                                    offset=offset,
                                                    filters=filters,
                                                    sort=sort,
                                                    order=order)

            # data, num = DataDAO.get_productopt(
            #     date=date,
            #     pagination=True,
            #     page_size=page_size,
            #     offset=offset,
            #     filters=filters,
            #     sort=sort,
            #     order=order,
            # )

            #Replace columns
            #event_records = cls.get_columns()

            RMPSObjs = RMPS.objects.filter()
            RMPSRecords = pd.DataFrame.from_records(
                RMPSObjs.values('center_id', 'attribute', 'value', 'unit',
                                'order'))

            RMPSRecords['attribute'] = \
                RMPSRecords['attribute'] + ' {' + RMPSRecords['id'] + '}'
            #product_map = dict(zip(RMPSRecords['id'], RMPSRecords['attribute']))
            #columns = ['center_id', 'center_name', 'sale_region', 'territory', 'arcade_type']\
            # + RMPSRecords['id'].tolist()
            print(RMPSRecords['attribute'])
            #data = data.reindex(columns=columns)
            #data.rename(columns=product_map, inplace=True)
            #data['center_id'] = data['center_id'].astype(int)

            if file_type == 'json':
                response = json.dumps(data.to_dict(orient='records'),
                                      ensure_ascii=False)
                response = HttpResponse(response,
                                        content_type='application/json')
                response[
                    'Content-Disposition'] = 'attachment; filename=export.json'
            elif file_type == 'csv':
                response = data.to_csv(index=False)
                response = HttpResponse(response,
                                        content_type='application/csv')
                response[
                    'Content-Disposition'] = 'attachment; filename=export.csv'
            elif file_type == 'xlsx':
                response = io()
                xlwriter = pd.ExcelWriter(response)
                data.to_excel(xlwriter, index=False)

                xlwriter.save()
                xlwriter.close()
                response.seek(0)

                response = HttpResponse(
                    response.read(),
                    content_type=
                    'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
                )
                response[
                    'Content-Disposition'] = 'attachment; filename=export.xlsx'
            else:
                response = json.dumps([], ensure_ascii=False)
                response = HttpResponse(response,
                                        content_type='application/json')
                response[
                    'Content-Disposition'] = 'attachment; filename=export.json'

            return response
Пример #19
0
def sum_string(content):
    f = io.io(content)
    md5sum = sumfile(f)
    f.close()
    return md5sum
Пример #20
0
 def selectinfo(self, number, file_path):
     read = io.io()
     information = []
     information = read.read(information, file_path)
     print_stu.selectstudent(number, information)
Пример #21
0
from Command import Command
from io import io

io = io()


def new_run(options, arg):
    """Adds a new issue with a priority level"""
    io.new(max(options), arg)


new = Command(name="new",
              aliases="mk,touch",
              options="12345",
              usage="[new/mk/touch -[priority] issue]",
              run=new_run)


def edit_run(options, arg):
    """Edit an issue"""
    #this one is a bit hacky since I only intended to allow a single argument
    args = arg.split(' ')
    priority = max(options) if len(options) != 0 else ""
    io.edit(args[0], priority, ' '.join(args[1:]))


edit = Command(
    name="edit",
    aliases="amend, change",
    options="12345",
    usage="[edit/amend/change] -[priority] [issue_id] [new description]",
Пример #22
0
def _string2Dataframe(data, log=True):
    sb = io(data)
    dataFrame = pd.read_csv(sb, sep = ' ', names = ('d','amp')).sort('d')
    if log:
        dataFrame.amp = 10 ** dataFrame.amp
    return dataFrame