0 scieditor2 10
190923
import sys ,os ,ctypes , io,subprocess
from PyQt5 import QtCore, QtWidgets
from PyQt5.QtWidgets import QApplication,QWidget,QMainWindow,QSizePolicy,QVBoxLayout, QTreeWidgetItem,QLabel,\
QMenu,QAction , QDialog , QInputDialog
from PyQt5.Qsci import QsciScintilla
from PyQt5.QtCore import Qt , QSettings,QSize,QRectF , QTimer,QByteArray
from PyQt5.QtGui import QKeyEvent, QStandardItem ,QStandardItemModel,QPixmap,QPainter,QBrush ,QPalette,QColor,\
QCursor
from Scintilla_subclass import qsc,myListView
from Scintilla_sql import settingsdb
import ui
from ui_searchload import Ui_Dialog
# from numba import jit
class MainWindow(QMainWindow):
TAB_NUM=0
def __init__(self, parent=None):
super(MainWindow, self).__init__(parent)
self.ui = ui.Ui_MainWindow() # <---------------------------
self.ui.setupUi(self)
self.currentSci = None
self.ui.listView.LDclicked.connect(self.fileload)
self.mes=dispinfo(self) # call information class
self.db=settingsdb() # call sql class
self.restoreSettings()
self.fav=QStandardItemModel() # favoritemodel
self.loadfav()
self.ui.treeView_2.setContextMenuPolicy(Qt.CustomContextMenu)
self.ui.treeView_2.customContextMenuRequested.connect(self.favmenu )
def loadfav(self):
fname=os.path.join(os.path.dirname(__file__) , 'Scintilla_fav.ini')
self.fav.clear()
with open(fname,'r') as f:
for line in f:
if line[0:1] == '.' :
line = line.replace('\n','')
line = line.replace('\r','')
if line[1:2] == '<' :
root = QStandardItem( line[ 2: -1] )
self.fav.appendRow( root )
elif line[1:2] == '.' :
root.appendRow( [ QStandardItem( os.path.split(line[2:])[1]) , QStandardItem( line[2:]) ] )
else :
self.fav.appendRow( [ QStandardItem( os.path.split(line[2:])[1] ) , QStandardItem( line[1:] ) ] )
self.ui.treeView_2.setModel( self.fav )
self.ui.treeView_2.hideColumn(1)
def favmenu(self,e):
menu=QMenu()
action = QAction('Reload', self)
action.triggered.connect(self.loadfav)
menu.addAction(action)
action = QAction('OpenFolder', self)
action.triggered.connect(self.openfolder)
menu.addAction(action)
menu.exec_(QCursor.pos ())
def openfolder(self):
# print(self.ui.treeView_2.selectedIndexes())
item=self.ui.treeView_2.selectedIndexes()[0]
# print(item.sibling(item.row(),1).data() )
if item.sibling(item.row(),1).data() :
subprocess.Popen( ('explorer' , os.path.split(item.sibling(item.row(),1).data() )[0] ))
def ListDClicked(self,item): # favorite open
if item.sibling(item.row(),1).data() :
self.fileload( item.sibling(item.row(),1).data() )
def restoreSettings(self):
try:
settings=self.db.gload()
self.restoreGeometry( settings[0])
self.ui.splitter.restoreState(settings[1])
self.ui.splitter_2.restoreState(settings[2])
except:
self.mes.disp(1,'main loadini fail')
def treeClicked(self,item): # outline Clicked
i=int(item.siblingAtColumn(1).data())
firstvisible = i-10 if i-10>0 else 0 # ターゲット行は常に上から10行目に表示する
self.currentSci.SendScintilla(2613,firstvisible) # SCI_SETFIRSTVISIBLELINE
self.currentSci.SendScintilla(2024,i) # SCI_GOTOLINE 2024
self.currentSci.setFocus()
def makenewtab(self,name): # 新規作成時もこれが呼ばれる
if not name:
name='*New*'
self.currentSci = qsc(self)
self.ui.tabWidget.addTab(self.currentSci, name)
self.ui.tabWidget.setCurrentWidget(self.currentSci)
self.__lyt = QVBoxLayout()
self.__lyt.setContentsMargins(0, 0, 0, 0)
self.__lyt.setSpacing(0)
self.currentSci.setLayout(self.__lyt)
self.currentSci.dropfile.connect(self.fileload)
self.currentSci.message.connect(self.mesfromsci)
def tabCloseMessage(self,e):
if self.currentSci :
self.db.save(( self.currentSci.PropDict['fname'] , self.currentSci.SendScintilla(2008 ) ,# SCI_GETCURRENTPOS
self.currentSci.SendScintilla(2152 )) ) # SCI_GETFIRSTVISIBLELINE
del self.currentSci
self.ui.tabWidget.removeTab(e) # e にタブのインデクス
def tabChanged(self,e):
if not self.ui.tabWidget.count():
self.ui.treeView.setModel (QStandardItemModel()) # 空のモデルをセットしないと消えてくれない
return
self.currentSci=self.ui.tabWidget.currentWidget()
self.ui.treeView.setModel( self.currentSci.PropDict['model'] )
self.searchModel() # set outline index from SCI line
self.setWindowTitle(self.currentSci.PropDict['fname'])
self.mes.disp(-2,self.currentSci )
self.currentSci.setFocus()
def search(self):
if self.ui.lineEdit.text():
self.currentSci.findFirst ( self.ui.lineEdit.text() , 1,0,0,1 )
def searchback(self):
if self.ui.lineEdit.text():
pos=self.currentSci.SendScintilla(2143) # SCI_GETSELECTIONSTART
self.currentSci.SendScintilla(2025,pos) # SCI_GOTOPOS
self.currentSci.findFirst ( self.ui.lineEdit.text() , 1,0,0,1,forward=False )
def replace(self):
self.currentSci.replace ( self.ui.lineEdit_3.text())
def searchline( self ) :
search= self.ui.lineEdit.text().lower()
line , index = self.currentSci.getCursorPosition()
model = QStandardItemModel()
self.ui.treeView.setModel(model)
model.appendRow( [ QStandardItem('＜ 検索時のポジション ＞' ) , QStandardItem( str(line) ) ] )
counter = 0
for i in range( self.currentSci.lines() ) :
if search in self.currentSci.text( i ).lower() :
string= '[ ' + str(i+1) + ' 行]' + self.currentSci.text( i )[ : 15]
string = string.replace('\n','') # これで改行取れるかな？？
string = string.replace('\r','')
model.appendRow( [ QStandardItem(string) , QStandardItem( str(i) ) ] )
counter += 1
if counter >50 :
self.mes.disp(1,'seach line : Hit over 50 !!')
# counter=-1
break
def lineEditReturn(self):
modifiers = QApplication.keyboardModifiers()
if modifiers ==Qt.ControlModifier :
self.searchline()
elif modifiers ==Qt.ShiftModifier :
self.searchback()
else :
self.search()
def searchsave(self):
text=QInputDialog.getText(self,r'( ´∀｀)','set Name')
if text[1]:
self.db.searchsave((text[0] ,self.ui.lineEdit.text() , self.ui.lineEdit_3.text()))
def searchload(self): # Show Dialog
self.sdlg=searchdlg(self)
def searchModel(self):
line , index = self.currentSci.getCursorPosition()
self.hit=self.ui.treeView.model().index(0,0)
for i in range(self.ui.treeView.model().rowCount( )) :
root = self.ui.treeView.model().index( i,0) # start 0,0
if int(self.ui.treeView.model().index( i,1).data()) > line :
self.ui.treeView.setCurrentIndex( self.hit )
return
self.hit=root
if self.searchModelChild(root , line ): # Recursion
self.ui.treeView.setCurrentIndex( self.hit )
return
self.ui.treeView.setCurrentIndex( self.hit ) # 文書の最後の場合
def searchModelChild(self , index_prev , line): # Recursion routine
count=self.ui.treeView.model().rowCount( index_prev )
if not count:
return 0
for i in range( count):
if int( index_prev.child( i ,1).data() ) > line :
return 1
self.hit=index_prev.child( i ,0)
if self.searchModelChild(index_prev.child( i ,0) , line): # Recursion
return 1
return 0
def mesfromsci(self,id ,string): # message from sci
self.mes.disp(id,string)
if id == -1 : # save ok 再度アウトライン解析
if ( self.ui.tabWidget.tabText(self.ui.tabWidget.currentIndex() ) ) == '*New*':
self.setWindowTitle(self.currentSci.PropDict['fname'])
self.ui.tabWidget.setTabText( self.ui.tabWidget.currentIndex() ,
os.path.split(self.currentSci.PropDict['fname'])[1] )
self.ui.treeView.setModel( self.currentSci.analyze( ) )
self.searchModel() # set outline index from SCI line
self.ui.treeView.hideColumn(1)
def dragEnterEvent(self, e):
e.accept()
def dropEvent(self, e):
string=e.mimeData().text()[8:]
string=string.replace('/','//')
self.fileload(string)
def fileload(self,string): # 複数から呼ばれる
if not os.path.exists(string):
return
for i in range( self.ui.tabWidget.count() ): # 重複チェック
if string==self.ui.tabWidget.widget(i).PropDict['fname'] :
self.ui.tabWidget.setCurrentIndex(i)
self.currentSci.setFocus()
return
a=os.path.split(string)
self.makenewtab(a[1])
self.ui.treeView.setModel( self.currentSci.load(string) )
self.ui.treeView.hideColumn(1)
self.setWindowTitle(self.currentSci.PropDict['fname'])
self.mes.disp(-2,self.currentSci )
pos=self.db.load(string)
try:
self.currentSci.SendScintilla(2613,pos[1]) # SCI_SETFIRSTVISIBLELINE
self.currentSci.SendScintilla(2025,pos[0]) # SCI_GOTOPOS
except Exception as e: # 全ての例外
self.mes.disp(0,e)
self.searchModel() # set outline index from SCI line
self.currentSci.setFocus()
def keyPressEvent_(self, event):
print('kitayo')
def closeEvent (self,e):
self.db.gsave((self.saveGeometry(),self.ui.splitter.saveState(),self.ui.splitter_2.saveState()))
class dispinfo() :
def __init__( self , parent ) :
self.label=[]
self.label.append( QLabel() )
self.label.append( QLabel() )
self.label.append( QLabel() )
parent.ui.statusbar.addPermanentWidget(self.label[0],2)
parent.ui.statusbar.addPermanentWidget(self.label[1],1)
parent.ui.statusbar.addPermanentWidget(self.label[2],1)
self.p=parent
def disp( self , id , object ) : # オブジェクトで受ける、最初に判定する
if id == -1 : # special message
self.saveok()
return
if id == -2 : # special message
self.sciproperty( object ) # カレントチーを引数にする
return
if id == 5 : # special message
self.p.setWindowTitle(object)
return
if type(object) is str :
pass
elif type(object) is int :
object = str( object )
else :
object = self.print_s( object )
self.label[ id ].setText( object )
def saveok(self) : #
pal=self.label[0].palette()
pal.setColor( QPalette.AlternateBase , QColor(Qt.black) )
pal.setColor( QPalette.Foreground , QColor(Qt.red) )
self.label[0].setPalette( pal )
self.label[0].setText( r'Save OK !! (・∀・)ﾉ' )
ti=QTimer()
ti.singleShot ( 2000, (lambda : self.disp(0,''))) # 表示を消す
def sciproperty(self , current): #
self.label[2].setText('{} EOL:{} Lines : {} Length : {}'.format(
current.PropDict['enc'] , current.PropDict['EOL'] ,
'{:,}'.format(current.PropDict['Lines']) ,
'{:,}'.format(current.PropDict['Length'] )))
def print_s(self,object):
with io.StringIO() as f:
sys.stdout = f
print(object)
text = f.getvalue()
sys.stdout = sys.__stdout__
text = text.replace('\n','') # これで改行取れるかな？？
text = text.replace('\r','')
return text
class searchdlg(QDialog): # Dialog for search data load
def __init__(self,parent):
super().__init__()
self.parent=parent
self.ui = Ui_Dialog()
self.ui.setupUi(self)
self.result=self.parent.db.searchload()
if self.result:
for l in self.result :
self.ui.listWidget.addItem(l[0])
self.show()
def listDClicked(self,item):
id=item.listWidget().row(item)
self.parent.ui.lineEdit.setText( self.result[id][1])
self.parent.ui.lineEdit_3.setText( self.result[id][2])
def listSelect(self,item):
id=item.listWidget().row(item)
self.ui.label.setText(self.result[id][1])
self.ui.label_2.setText(self.result[id][2])
def delitem(self):
self.parent.db.searchdell(self.ui.listWidget.currentItem().text())
# print(self.ui.listWidget.currentItem().text())
if __name__ == '__main__':
import sys
app = QApplication(sys.argv)
main_window = MainWindow()
main_window.show()
sys.exit(app.exec_())
- Scintilla_subclass.py
import sys , ctypes , os, glob , subprocess , re
from PyQt5.Qsci import QsciScintilla,QsciLexerPython,QsciMacro
from PyQt5.QtWidgets import QMenu , QListView,QAction,QMessageBox ,QColorDialog
from PyQt5.QtCore import Qt,QRectF,QSize , pyqtSignal
from PyQt5.QtGui import QCursor ,QFont,QFontMetrics,QColor
from PyQt5.Qsci import *
from PyQt5.QtGui import QCursor ,QFont,QFontMetrics,QColor , QStandardItem ,QStandardItemModel,QPixmap,\
QPainter,QBrush
class qsc(QsciScintilla):
ARROW_MARKER_NUM = 8
dropfile = pyqtSignal( str )
message = pyqtSignal( int , object)
def __init__(self, parent):
super().__init__( )
# self.setAcceptDrops(True)
self.parent=parent
self.set()
self.PropDict={'fname':'','enc':'','EOL':0,'Lines':0 , 'Length':0 ,
'model':QStandardItemModel() , 'analyzetype':0 }
self.Lsp=False
self.wrap=0
self.SendScintilla(self.SCI_SETMODEVENTMASK,
self.SC_MOD_INSERTTEXT | self.SC_MOD_DELETETEXT )
self.SCEN_CHANGE.connect(self.modify)
def load(self,fname):
with open(fname , mode='rb') as f:
s=f.read() # bynary
encodeType='UTF-8','cp932','UTF-16','EUC-JP'
for i,l in enumerate(encodeType) :
try :
self.setText(s.decode(encoding=l))
self.PropDict['enc'] =l
self.PropDict['fname'] =fname
self.PropDict['Lines'] =self.lines()
self.PropDict['Length'] =self.length()
# self.currentSci.PropDict['EOL'] =self.currentSci.GetEOLMode()
# self.analyztree()
# self.ShowInfo()
break
except :
if i== len(encodeType)-1 : # 全部だめ
self.setText('fail to load ... decode error ')
else:
pass
self.markerDeleteAll(0)
if fname[-2:] == 'py' :
self.PropDict['analyzetype'] = 1
lexer = QsciLexerPython()
self.setLexer(lexer)
return self.analyze()
def analyze(self) :
self.PropDict['model'].clear()
if not self.PropDict['analyzetype'] : # normal text
import time
start = time.time()
tree=[]
current=0 # 階層
for i in range(0 , self.PropDict['Lines']):
linet = self.text( i )
linet = linet.replace('\n',' ') # 改行削除
linet = linet.replace('\r',' ') # 文字数ゼロだとだめなのでここで空白文字を与えておく
# i2=0
for i2 , l in enumerate( linet ) :
if l == '.' :
continue
else :
break
if not i2 : # i2 : 階層
continue
if i2 == 1 : # root
tree.clear()
tree.append( QStandardItem( linet[ 1:] ) )
self.PropDict['model'].appendRow( [ tree[0] , QStandardItem( str( i ) ) ] )
current = 1
else : # child
if i2 <= current + 1 : # normal
if len( tree ) == i2 -1 :
tree.append( None )
tree[ i2-1 ] = QStandardItem( linet[ i2 : ] )
tree[ i2 - 2 ].appendRow( [ tree[ i2 - 1] , QStandardItem( str( i ) ) ] )
current = i2
else : # error
self.PropDict['model'].appendRow( [ QStandardItem( ' -- error --' ) , QStandardItem( str( i ) ) ] )
elapsed_time = time.time() - start
self.message.emit( 1 , elapsed_time )
else: # py analyze
for i in range(0 , self.PropDict['Lines']):
linet = self.text( i )
linet = linet.replace('\n','') # これで改行取れるかな？？
linet = linet.replace('\r','')
if (linet[0:5]=='class') or (' def ' in linet ) :
self.PropDict['model'].appendRow( [ QStandardItem(linet) , QStandardItem( str(i) ) ] )
return self.PropDict['model']
def modify(self):
linenum=self.SendScintilla(self.SCI_LINEFROMPOSITION ,self.SendScintilla(self.SCI_GETCURRENTPOS))
handle = self.markerAdd(linenum, 0)
def keyPressEvent(self, event): # filter
# print(str(event.modifiers()))
if (event.key() == Qt.Key_D) and (event.modifiers() & Qt.ControlModifier):
self.key_selectword()
elif (event.key() == Qt.Key_C) and (event.modifiers() & Qt.ControlModifier):
self.key_copy()
elif (event.key() == Qt.Key_S) and (event.modifiers() & Qt.ControlModifier):
self.key_save()
elif (event.key() == Qt.Key_1) and (event.modifiers() & Qt.ControlModifier):
self.calcline()
elif (event.key() == Qt.Key_2) and (event.modifiers() & Qt.ControlModifier):
self.calcline2()
elif (event.key() == Qt.Key_3) and (event.modifiers() & Qt.ControlModifier):
self.key_color()
elif (event.key() == Qt.Key_F1):
self.key_toggleEOL()
elif (event.key() == Qt.Key_F2):
self.linewrpping()
elif (event.key() == Qt.Key_F3):
self.charcount()
elif (event.key() == Qt.Key_Escape):
self.showhelp()
else:
super(qsc, self).keyPressEvent(event) # send to parent
def calcline(self):
self.SendScintilla(2314) # SCI_LINEEND = 2314
line , index = self.getCursorPosition()
result = re.findall(r'\d{1,}', self.text( line) )
p= sum( [ int(l) for l in result ] )
p='| ' + str( p ) # 挿入文字列
self.insertAt ( p , line , index )
def calcline2 ( self ) :
line , index = self.getCursorPosition()
p = re.compile( r'\d+' )
n,sum = 0,0
while( 1 ):
res = p.search( self.text( line + n)[index : ] )
if res :
sum += int( res[0] )
n += 1
else :
break
self.insertAt ( str(sum) , line +n+1 , index )
def key_color(self): # color select dialog
getcolor = QColorDialog.getColor()
colots=getcolor.name()
print(colots)
def key_toggleEOL(self): # 改行表示 F1
self.setEolVisibility(not self.eolVisibility())
def linewrpping(self): # 折りたたみ F2
self.wrap=0 if self.wrap==2 else 2
self.setWrapMode(self.wrap)
def charcount(self): # 文字数カウント F3
mes=self.selectedText().__len__() if self.hasSelectedText() else self.text().__len__()
self.message.emit( 1 , '文字数 : {:,}'.format(mes) )
def showhelp(self):
self.message.emit(5,'F1：改行表示 F2：折り返し F3：文字数カウント ' \
' c-1:行数値加算 c-2:縦数値加算 c-3:カラーダイアログ' )
def key_copy(self):
if( self.SendScintilla(self.SCI_GETCURRENTPOS) == self.SendScintilla(self.SCI_GETANCHOR )):
self.SendScintilla(self.SCI_LINECOPY)
else :
# self.SendScintilla(self.SCI_COPY)
super().SendScintilla(self.SCI_COPY)
def key_selectword(self): # C-R
pos=self.SendScintilla(self.SCI_GETCURRENTPOS)
epos=self.SendScintilla(self.SCI_WORDENDPOSITION,pos)
spos=self.SendScintilla(self.SCI_WORDSTARTPOSITION, pos)
self.SendScintilla(self.SCI_SETSEL,spos,epos)
self.SendScintilla(self.SCI_COPY) # copy
def key_save(self):
if not self.PropDict['fname'] :
self.PropDict['fname'] = self.makesavename()
self.PropDict['enc'] = 'UTF-8'
self.message.emit(-2,self)
fname=self.PropDict['fname']
# enc=self.PropDict['enc']
size=self.SendScintilla(self.SCI_GETLENGTH)
s = ctypes.create_string_buffer(size+1) # +1 で確保
self.SendScintilla(self.SCI_GETTEXT , size+1 , s)
if self.PropDict['enc'] == 'UTF-8' :
with open(fname,'wb') as f :# 書き込み専用
f.write(s)
self.message.emit(-1,None)
self.markerDeleteAll(0)
else:
try:
s=s.value.decode()
senc=s.encode(encoding = self.PropDict['enc'])
with open(fname,'wb') as f :# 書き込み専用
f.write(senc)
self.message.emit(-1,None)
self.markerDeleteAll(0)
except Exception as e:
self.message.emit(0,e)
def makesavename(self):
dir=os.path.join(os.path.dirname(__file__) , 'txt')
n=0
name='{:02}.txt'.format(n)
filepath=os.path.join(dir,name)
while os.path.exists(filepath):
n+=1
filepath=os.path.join(dir,'{:02}.txt'.format(n) )
# print(filepath)
return filepath
def dragEnterEvent(self,e): #多分すでに実装されてるからいらないんだと思う
e.accept()
def dropEvent(self,e):
string=e.mimeData().text()[8:]
string=string.replace('/','//')
self.dropfile.emit(string)
def set(self): # -------------------設 定------------------------------
font = QFont()
font.setFamily('Ms Gothic')
font.setFixedPitch(False)
font.setPointSize(10)
self.setFont(font)
self.setMarginsFont(font)
# Margin 0 is used for line numbers
fontmetrics = QFontMetrics(font)
self.setMarginsFont(font)
self.markerDefine(QsciScintilla.RightArrow, 0)
self.setMarginWidth(0, fontmetrics.width("00000") )
self.setMarginLineNumbers(0, True)
self.setMarginsForegroundColor(QColor('blue'))
self.setMarginsBackgroundColor(QColor("#cccccc"))
# Clickable margin 1 for showing markers
# self.setMarginSensitivity(1, True)
#self.connect(self,
# SIGNAL('marginClicked(int, int, Qt::KeyboardModifiers)'),
# self.on_margin_clicked)
# self.markerDefine(QsciScintilla.ThreeRightArrows, 1)
# self.setMarginWidth(1, fontmetrics.width("000") )
# self.setMarkerBackgroundColor(QColor("#ee1111"), self.ARROW_MARKER_NUM)
# Brace matching: enable for a brace immediately before or after
# the current position
self.setBraceMatching(QsciScintilla.SloppyBraceMatch)
# Current line visible with special background color
self.setCaretLineVisible(True)
self.setCaretLineBackgroundColor(QColor("#fff9cb")) #55ffff
# Custom Lexer
# lexer = MyLexer(self)
# self.setLexer(lexer)
text = bytearray(str.encode("Arial")) # 32, "Courier New"
self.SendScintilla(QsciScintilla.SCI_STYLESETFONT, 1, text)
# Don't want to see the horizontal scrollbar at all
# Use raw message to Scintilla here (all messages are documented
# here: http://www.scintilla.org/ScintillaDoc.html)
self.SendScintilla(QsciScintilla.SCI_SETHSCROLLBAR, 0)
self.setUtf8(True)
self.setWhitespaceVisibility(True)
self.setWhitespaceForegroundColor(QColor('#e5e5e5')) #'red' blue#EEEEEE
self.setWhitespaceSize(2)
class myListView(QListView):
LDclicked = pyqtSignal( str )
def __init__(self,p):
super().__init__()
self.iconsize=70
self.setIconSize(QSize(self.iconsize,self.iconsize))
self.setSpacing(1)
self.foldadir=None
self.setContextMenuPolicy(Qt.CustomContextMenu)
self.customContextMenuRequested.connect(self.cmenu )
self.loadfolda()
def loadfolda(self):
# print('kita')
model = QStandardItemModel()
self.setModel(model)
f=os.path.join(os.path.dirname(__file__) , 'txt', '**')
self.foldadir=f[:-2]
# print(self.foldadir)
for i , p in enumerate(glob.iglob(f )):
l= os.path.split(p)[1]
with open(p,'r',encoding='UTF-8',errors='ignore') as f2: # 指定文字数を読み込む
buf=f2.read(35)
model.appendRow(QStandardItem(l))
img=QPixmap(self.iconsize,self.iconsize)
paint=QPainter()
paint.begin(img)
paint.setBrush( Qt.white )
paint.setPen( Qt.white )
paint.drawRect(0,0,self.iconsize-1,self.iconsize-1)
paint.setPen( Qt.black )
paint.drawRoundedRect(0,0,self.iconsize-1,self.iconsize-1 ,10,10)
paint.drawText( QRectF(0,3,self.iconsize-1,self.iconsize-1) , buf)
paint.end()
model.setData( model.index(i,0) , img , Qt.DecorationRole )
def openfolder(self):
subprocess.Popen( ('explorer' , self.foldadir) )
# print(self.foldadir)
def browserDclicked(self,index):
f=os.path.join(self.foldadir , index.data(Qt.DisplayRole))
self.LDclicked.emit(f)
def cmenu (self,e):
menu=QMenu(self)
action = QAction('DELL', self)
action.triggered.connect(self.fileDel)
menu.addAction(action)
action = QAction('CUT', self)
action.triggered.connect(self.fileCut)
menu.addAction(action)
menu.exec_(QCursor.pos ())
def fileDel(self,index):
f=os.path.join(self.foldadir , self.selectedIndexes()[0].data(Qt.DisplayRole))
reply = QMessageBox.question(self, f,"want to DELL ?",
QMessageBox.Yes | QMessageBox.No, QMessageBox.No)
if reply == QMessageBox.Yes:
os.remove(f)
self.loadfolda()
def fileCut(self,index):
pass
- Scintilla_sql.py
import os , sqlite3 , datetime
class settingsdb():
def __init__(self):
self.db=os.path.join(os.path.dirname(__file__) , 'settings.db')
conn = sqlite3.connect(self.db)
c = conn.cursor()
c.execute('create table IF NOT EXISTS database(path PRIMARY KEY,line,times,date)')
c.execute('create table IF NOT EXISTS general(gpos , splpos1 , splpos2)')
c.execute('create table IF NOT EXISTS spattern( name , word , replace )')
c.close()
conn.commit()
conn.close()
def searchload( self ): # search pattern
conn = sqlite3.connect( self.db )
c = conn.cursor()
c.execute( 'select * from spattern' )
res=c.fetchall()
c.close()
conn.close()
return res # 結果を全て渡す、タプルのリスト
def searchsave( self , lists ):
conn = sqlite3.connect( self.db )
c = conn.cursor()
c.execute( "INSERT INTO spattern ( name , word , replace ) VALUES (?,?,?)" , lists )
c.close()
conn.commit()
conn.close()
def searchdell( self , key ):
conn = sqlite3.connect( self.db )
c = conn.cursor()
c.execute( "DELETE FROM spattern WHERE name= ?" , (key,) )
c.close()
conn.commit()
conn.close()
def gload(self):
conn = sqlite3.connect(self.db)
c = conn.cursor()
c.execute('select gpos , splpos1 , splpos2 from general ')
res=c.fetchall()
c.close()
conn.close()
if res :
return res[0]
else:
return 0
def gsave(self,lists):
conn = sqlite3.connect(self.db)
c = conn.cursor()
c.execute('DELETE FROM general')
c.execute( "INSERT INTO general (gpos , splpos1 , splpos2) VALUES (?,?,?)" ,lists)
c.close()
conn.commit()
conn.close()
def save(self,lists):
conn = sqlite3.connect(self.db)
c = conn.cursor()
date="{0:%Y%m%d}".format( datetime.datetime.now() )
times=1
try:
c.execute( "INSERT INTO database (path,line,page,times,date) VALUES (?,?,?,?,?)" ,
( lists[0] , lists[1] , lists[2] , times,date ))
except:
c.execute('select times from database where path = ?',(lists[0] , ))
times=c.fetchone()[0]+1
c.execute('update database set line= ? , page=? , times=? ,date=? where path = ? ',
( lists[1] ,lists[2] , times, date ,lists[0] ) )
c.close()
conn.commit()
conn.close()
# print(line,times)
def load(self,fname):
conn = sqlite3.connect(self.db)
c = conn.cursor()
c.execute('select line ,page from database where path = ?',(fname, ))
res=c.fetchone()
c.close()
conn.close()
if res :
return res
else:
return 0
---> scieditor2
コメント(0)