Форум сайта python.su
# coding: utf-8 from win32com.client import Dispatch import pythoncom import datetime import sys import fdb #================================================================== def main(argv=None): start_time=datetime.datetime.now() print(start_time) fb_conn = fdb.connect(dsn='firebird:d:\\pgn.FDB',user='user',password='password') trans=fb_conn.trans() trans.begin fb_cur=trans.cursor() sql_prep=fb_cur.prep(r"INSERT INTO gpk_input (lat_name,name,to_date) VALUES (?,?,?)") xlApp = Dispatch("Excel.Application") xlApp.Visible=False xlWb = xlApp.Workbooks.Open(r"D:\Documents\children.xls") try: for Sheet in xlWb.WorkSheets: print("Sheet=",Sheet.Name," ",datetime.datetime.now()) for y in range(2,10): if str(Sheet.Cells(y,1)) != 'None': # Sheet.Cells(y,1) - ФИО в латинской транскрипции # Sheet.Cells(y,2) - ФИО на русском # Sheet.Cells(y,3) - дата чего-то . Пока не интересно dt1=str(Sheet.Cells(y,3)) dt1=dt1[0:19] dt1=str(dt1[8:10])+'.'+str(dt1[5:7])+'.'+str(dt1[0:4])+' '+str(dt1[11:]) print(type(Sheet.Cells(y,2))) rus_name=str(Sheet.Cells(y,2)) print(type(rus_name)) print('-------\n','orig=',rus_name) fb_cur.execute(sql_prep,[Sheet.Cells(y,1),rus_name.encode('utf-8'),dt1]) trans.commit() fb_cur.close() trans.close() except Exception as e3: print("main try:","Line "+format(sys.exc_info()[-1].tb_lineno),e3.__str__()) print("Sheet='",Sheet.Name,"' y=",y) trans.rollback() fb_cur.close() trans.close() xlApp.Quit() fin_time=datetime.datetime.now() print(fin_time," | ",fin_time-start_time)
r"INSERT INTO gpk_input (lat_name,name,to_date) VALUES (?,CAST(? AS VARCHAR(50)),?)"
import Tkinter as tk def fileSave(): c.postscript(file='XXX.ps',height=300, width=300, fontmap=(font,size_font),colormode="mono") master1 = tk.Tk() master1.geometry('300x300') frame1=tk.Frame(master1) frame1.pack(side=tk.TOP,fill=tk.X) frame2=tk.Frame(master1) frame2.pack(side=tk.TOP, fill=tk.BOTH,expand=tk.NO) font = 'txt' size_font=30 button_seve=tk.Button(frame1,text="save",font=('txt 12'),command = fileSave) button_seve.pack(side = tk.LEFT) canvas=tk.Canvas(frame2) c=canvas c.pack(side=tk.LEFT, fill=tk.BOTH, expand=tk.YES) t=u'\u2205' c.create_text(100,100,text=t, font=(font,size_font),fill='black') c.create_line(120,120,120,80,fill='black') master1.mainloop()
data['Product Composition'] = '93% Polyamide 7% Elastane Lining: 100% Polyester</p><p>Dress Length: 90 cm' data['Product Attributes;'] = ': Boat Neck, Long Sleeve, Midi, Zip, Concealed, Laced, Side Lining Type: Full Lining'
import lxml.html import requests import pprint def get_doc(url): try: req = requests.get(url) except requests.exceptions.ConnectionError as exc: print('A Connection error occurred. ', exc) else: doc_html = req.text doc_obj = lxml.html.document_fromstring(doc_html) return doc_html, doc_obj req = get_doc('http://en.modagram.com/women/open-back-velvet-dress-claret/detail/37803/168598') doc_html, doc_obj = req details = {} base_details_query = doc_obj.xpath('//section[@id="ProductInfo"]/div[contains(concat(" ", normalize-space(@class), " "), " TabItem ")]') if len(base_details_query): base_details_query = base_details_query[0].xpath('//p/strong') if len(base_details_query): for dict_title in base_details_query: p = dict_title.getparent() print(dict_title, dict_title.text, p, p.text, '-----') desc = [] while p is not None and not p.xpath('.//strong'): desc.append(p.text) p = p.getnext() details[dict_title.text] = " ".join(desc) pprint.pprint(details)
import tkinter as tk class CustomText(tk.Text): def __init__(self, parent=None): tk.Text.__init__(self, parent, undo=True, wrap='word') self.pack(expand=1, fill='both') self.cmenu = tk.Menu(self, tearoff=False) self.cmenu.add_command(label='Undo', command=self.undo, accelerator='Ctrl+Z') self.cmenu.add_command(label='Redo', command=self.redo, accelerator='Ctrl+Y') self.bind('<ButtonPress-3>', self.right_but_bind) def right_but_bind(self, event): #Проверка изменялся ли текст #Для Undo if self.edit_modified(): self.cmenu.entryconfig(0, state='normal') else: self.cmenu.entryconfig(0, state='disabled') #Для Redo try: self.edit_redo() except: print('Стек redo пуст') self.cmenu.entryconfig(1, state='disabled') else: self.edit_undo() self.cmenu.entryconfig(1, state='normal') pos_x = self.winfo_rootx() + event.x pos_y = self.winfo_rooty() + event.y self.cmenu.tk_popup(pos_x, pos_y) #Отменить действие def undo(self): self.edit_undo() #Вернуть действие def redo(self): self.edit_redo() if __name__ == '__main__': root = tk.Tk() root.title('Custom Text') frm = tk.Frame(root) CustomText(frm) frm.pack() root.mainloop()
app = QApplication(sys.argv)
wdgt = MyWindow()
wdgt.show()
wdgt.tableModel._setRowsCount(10)
app = QApplication(sys.argv)
wdgt = MyWindow()
wdgt.tableModel._setRowsCount(10)
wdgt.show()
import pycurl c = pycurl.Curl() c.setopt(pycurl.URL, 'smtp://smtp.mail.ru') c.perform()
class Author(models.Model): name = models.CharField(max_length=100) mail = models.EmailField(max_length=254)
>>> from app_main.models import * >>> a = Author.objects.using('ORACLE') >>> from django import db >>> reset = db.reset_queries >>> conns = db.connections['ORACLE'] >>> a_list = [Author(name='CONSOLE', mail='ma@na.vd') for _ in range(10)] >>> reset() >>> conns.queries [] >>> a.bulk_create(a_list) [<Author: Author object>, <Author: Author object>, <Author: Author object>, <Author: Author object>, <Author: Author object>, <Author: Author object>, <Author: Author object>, <Author: Author object>, <Author: Author object>, <Author: Author object>] >>> conns.queries [{'sql': 'QUERY = \'INSERT INTO "APP_MAIN_AUTHOR" ("NAME", "MAIL") SELECT :arg0, :arg1 FROM DUAL UNION ALL SELECT :arg2, :arg3 FROM DUAL UNION ALL SELECT :arg4, :arg5 FROM DUAL UNION ALL SELECT :arg6, :arg7 FROM DUAL UNION ALL SELECT :arg8, :arg9 FROM DUAL UNION ALL SELECT :arg10, :arg11 FROM DUAL UNION ALL SELECT :arg12, :arg13 FROM DUAL UNION ALL SELECT :arg14, :arg15 FROM DUAL UNION ALL SELECT :arg16, :arg17 FROM DUAL UNION ALL SELECT :arg18, :arg19 FROM DUAL\' - PARAMS = (\'CONSOLE\', \'ma@na.vd\', \'CONSOLE\', \'ma@na.vd\', \'CONSOLE\', \'ma@na.vd\', \'CONSOLE\', \'ma@na.vd\', \'CONSOLE\', \'ma@na.vd\', \'CONSOLE\', \'ma@na.vd\', \'CONSOLE\', \'ma@na.vd\', \'CONSOLE\', \'ma@na.vd\', \'CONSOLE\', \'ma@na.vd\', \'CONSOLE\', \'ma@na.vd\')', 'time': '0.158'}]