Python models.SqlHandler类代码示例

OGeek|极客世界-中国程序员成长平台 › 门户 › 编程› Python›Python编程经验

原作者: [db:作者] 来自: [db:来源] 收藏邀请

本文整理汇总了Python中models.SqlHandler类的典型用法代码示例。如果您正苦于以下问题：Python SqlHandler类的具体用法？Python SqlHandler怎么用？Python SqlHandler使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。

在下文中一共展示了SqlHandler类的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的Python代码示例。

示例1: init

    def __init__(self, parent=None, item=None):
        owner = None
        animal = None
        #check if item is dictionary. So it is called by ownerTab
        if(item != None and item.__class__.__name__ == 'dict'):
            if("owner" in item):
                owner = item["owner"]
            if("animal" in item):
                animal = item["animal"]
            item = None

        GenericTab.__init__(self, parent=parent, item=item)
        self.ui = Ui_Visit()
        self.ui.setupUi(self)
        self.ui.stackedWidget.setCurrentIndex(0) #TODO:remove if needed

        self.currentVisitAnimal = None
        self.currentOperation = None
        
        self.configure()
        self.createConnections()

        self.setBasicInfo()
        if(owner != None):
            owner = SqlHandler.makeCopy(self.session,owner)
            self.ownerserachline.setCurrentItem(owner)
            if(animal != None):
                animal = SqlHandler.makeCopy(self.session,animal)
                self.animalTreeWidget.addAskedItem(animal) #TODO find function to add animal
            self.disableAnimalTree(False)

开发者ID:mape90，项目名称:VetApp，代码行数:30，代码来源:visittab.py

示例2: saveNewItem

 def saveNewItem(self):
     specie = self.ui.comboBox.itemData(self.ui.comboBox.currentIndex())
     if specie != None:
         SqlHandler.addItem(self.session, SqlHandler.Color(self.ui.lineEdit.text(), specie.id))
         if self.parent().specieName() == specie.name:
             self.parent().setColor(self.ui.lineEdit.text())
     self.closeDialog()

开发者ID:mape90，项目名称:VetApp，代码行数:7，代码来源:addNewDialog.py

示例3: deleteItemFromSearch

 def deleteItemFromSearch(self):
     item = self.itemSearchEdit.getCurrentItem()
     if item and self.askUser():
         if self.itemCanBeDeleted(item):
             SqlHandler.removeItem(self.session, item)
         else:
             pass #error

开发者ID:mape90，项目名称:VetApp，代码行数:7，代码来源:itemcreatortab.py

示例4: setPrices

    def setPrices(self, visit):
        price_dict = visit.getPriceDict()

        self.ui.operationSpinBox.setValue(price_dict["operation_price"] * (100+SqlHandler.getALV(1))/100.)
        self.ui.accessoriesSpinBox.setValue(price_dict["accesories_price"] * (100+SqlHandler.getALV(1))/100.)
        self.ui.labSpinBox.setValue( price_dict["lab_price"] * (100+SqlHandler.getALV(1))/100.)
        self.ui.medicineSpinBox.setValue(price_dict["medicine_price"] * (100+SqlHandler.getALV(2))/100.)
        self.ui.dietSpinBox.setValue(price_dict["diet_price"] * (100+SqlHandler.getALV(3))/100.)

开发者ID:mape90，项目名称:VetApp，代码行数:8，代码来源:billTab.py

示例5: saveDialog

 def saveDialog(self):
     if self.animalsearch.getCurrentItem() != None:
         if self.item != None:
             self.item.update()
             self.parent().update()
             self.closeDialog()
         else:
             self.item = SqlHandler.PhoneRecipie(self.animalsearch.getCurrentItem(), self.recipieMedicineTreeWidget.getItemsFromList())
             self.item.update(self.getData())
             SqlHandler.addItem(self.session, self.item)
             self.parent().update()
             self.closeDialog()

开发者ID:mape90，项目名称:VetApp，代码行数:12，代码来源:generictreewidget.py

示例6: getData

    def getData(self):
        print("DEBUG: getData")
        data = {}
        data['visit'] = self.visit
        if self.ui.clinic_radio_button.isChecked():
            data['clinic_payment'] = self.ui.clinicPriceSpinBox.value() / ((100+SqlHandler.getALV(1))/100.)
            data['km'] = 0.0
            data['km_payment'] = 0.0
        else:
            data['clinic_payment'] = self.ui.visitPriceSpinBox.value() / ((100+SqlHandler.getALV(1))/100.)
            data['km'] = self.ui.KmSpinBox.value()
            data['km_payment'] = self.ui.KmPriceSpinBox.value() / ((100+SqlHandler.getALV(1))/100.)

        data['operations_payment'] = self.ui.operationSpinBox.value() / ((100+SqlHandler.getALV(1))/100.)
        data['lab_payment'] = self.ui.labSpinBox.value() / ((100+SqlHandler.getALV(1))/100.)
        data['accessories_payment'] = self.ui.accessoriesSpinBox.value() / ((100+SqlHandler.getALV(1))/100.)
        data['extra_percent'] = self.ui.precentSlider.value()
        data['medicines_payment'] = self.ui.medicineSpinBox.value() / ((100+SqlHandler.getALV(2))/100.)
        data['diet_payment'] = self.ui.dietSpinBox.value() / ((100+SqlHandler.getALV(3))/100.)
        data['payment_method'] = (self.ui.paymentComboBox.itemData(self.ui.paymentComboBox.currentIndex()))
        data['due_date'] = self.qdateToPy(self.ui.DueDateEdit.date())
        data['paid_time'] = self.qdateToPy(self.ui.paidDateEdit.date())
        data['paid_value'] = self.ui.paidSpinBox.value()
        data['index_number'] = self.ui.indexNumberLabel.text()
        data['other_info'] = self.ui.otherInfoTextEdit.toPlainText()
        data['satus'] = 0 #status TODO: implement if needed
        
        print('operations_payment ',data['operations_payment'])
        
        return data

开发者ID:mape90，项目名称:VetApp，代码行数:30，代码来源:billTab.py

示例7: init

 def __init__(self, parent=None, item=None, animal=None):
     from uipy.ui_phonerecipiedialog import Ui_PhoneRecipieDialog
     QDialog.__init__(self, parent=parent)
     self.ui = Ui_PhoneRecipieDialog()
     self.ui.setupUi(self)
     self.session = SqlHandler.newSession()
     self.item = item
     self.animal = None
     if animal != None:
         self.animal = SqlHandler.makeCopy(self.session, animal)
     
     self.configure()
     self.createConnections()
     self.setBasicInfo()

开发者ID:mape90，项目名称:VetApp，代码行数:14，代码来源:generictreewidget.py

示例8: updateEndPrice

 def updateEndPrice(self):
     price_ALV1 = self.getALV1Price() * (100+SqlHandler.getALV(1))/100.
     price_ALV2 = self.getALV2Price() * (100+SqlHandler.getALV(2))/100.
     price_ALV3 = self.getALV3Price() * (100+SqlHandler.getALV(3))/100.
     
     self.ui.price_ALV1_total_label.setText('%.2f' % price_ALV1)
     self.ui.ALV1_total.setText('%.2f' % (price_ALV1-self.getALV1Price()))
     
     self.ui.price_ALV2_total_label.setText('%.2f' % price_ALV2)
     self.ui.ALV2_total.setText('%.2f' % (price_ALV2-self.getALV2Price()))
     
     self.ui.price_ALV3_total_label.setText('%.2f' % price_ALV3)
     self.ui.ALV3_total.setText('%.2f' % (price_ALV3-self.getALV3Price()))
     
     self.ui.endPriceLabel.setText('%.2f' % (price_ALV1 + price_ALV2 + price_ALV3))

开发者ID:mape90，项目名称:VetApp，代码行数:15，代码来源:billTab.py

示例9: setSpecie

 def setSpecie(self):
     for specie in SqlHandler.searchSpecie(self.session):
         self.ui.comboBox.addItem(specie.name, specie)
     
     current = self.ui.comboBox.findText(self.parent().specieName())
     if current > 0:
         self.ui.comboBox.setCurrentIndex(current)

开发者ID:mape90，项目名称:VetApp，代码行数:7，代码来源:addNewDialog.py

示例10: init

 def __init__(self, parent=None):
     QDialog.__init__(self, parent=parent)
     self.ui = Ui_LoginDialog()
     self.ui.setupUi(self)
     self.session = SqlHandler.newSession()
     self.configureConnections();
     self.setVets()

开发者ID:mape90，项目名称:VetApp，代码行数:7，代码来源:login_dialog.py

示例11: init

    def __init__(self, parent=None,item=None):
        GenericTab.__init__(self, parent=parent, item=None)
        self.ui = Ui_SummaryTab()
        self.ui.setupUi(self)
        self.returnItem = False
        self.visitanimal = None

        if type(item) is dict:
            if 'owner' in item:
                self.ui.ownerNameLabel.setText(item['owner'].name)
            else:
                logERROR(self, "SummaryTab.init: owner not found from dict")
            if 'visitanimal' in item:
                self.visitanimal = item['visitanimal']
                self.ui.animalNameLabel.setText(item['visitanimal'].animal.name)
            else:
                logERROR(self, "SummaryTab.init: owner not found from dict")
            if 'text' in item:
                self.addText(item['text'])
            else:
                logERROR(self, "SummaryTab.init: text not found from dict")
        else:
            logDEBUG(self, "SummaryTab.init: item is not dict it is: "+ item)
        
        self.session = SqlHandler.newSession()
        
        self.itemSearchEdit = SearchLineEdit(tabcreator=AddNewSummary, 
                                             session=self.session, 
                                             parent=self, 
                                             function=SqlHandler.searchSummary)
        
        self.configure()
        self.configureConnctions()

开发者ID:mape90，项目名称:VetApp，代码行数:33，代码来源:summarytab.py

示例12: genTableRow

 def genTableRow(self, operation):
     counter = 0
     tmp_rows = ''
     tmp_rows += self.genTableRowPrue(name = operation.base.name,
                                     count = operation.count,
                                     type_ = "kpl",
                                     price = operation.price,
                                     alv = SqlHandler.getALV(1))
     counter += 1
     if(hasattr(operation.base, 'item')):
         print("operation.base.item: ", operation.base.item)
         tmp_rows += self.genTableRowPrue(name = ('- ' + operation.base.item.name),
                                          count = operation.count,
                                          type_ = operation.base.item.count_type,
                                          price = operation.base.item.price,
                                          alv = operation.base.item.getALV())
         counter += 1
     if(hasattr(operation, 'items')):
         print("items listing strt")
         for surgeryitem in operation.items:
             total_count = operation.count*surgeryitem.count
             
             tmp_rows += self.genTableRowPrue(name = ('- ' + surgeryitem.item.name),
                                             count = total_count,
                                             type_ = surgeryitem.item.count_type,
                                             price = surgeryitem.item.price,
                                             alv = surgeryitem.item.getALV())
             counter += 1
     
     return (tmp_rows, counter)

开发者ID:mape90，项目名称:VetApp，代码行数:30，代码来源:printFileCreator.py

示例13: setRace

 def setRace(self, newName=''):
     self.ui.raceBox.clear()
     self.ui.raceBox.addItem('', None)
     specie = self.specie()
     if specie != None:
         for race in SqlHandler.searchRace(self.session, specie.id):
             self.ui.raceBox.addItem(race.name, race)

开发者ID:mape90，项目名称:VetApp，代码行数:7，代码来源:searchtab.py

示例14: setColor

 def setColor(self):
     self.ui.colorBox.clear()
     self.ui.colorBox.addItem('', None)
     specie = self.specie()
     if specie != None:
         for color in SqlHandler.searchColor(self.session, specie.id):
             self.ui.colorBox.addItem(color.name, color)

开发者ID:mape90，项目名称:VetApp，代码行数:7，代码来源:searchtab.py

示例15: setVet

 def setVet(self):
     self.ui.billVetBox.clear()
     self.ui.visitVetBox.clear()
     self.ui.visitVetBox.addItem('',None)
     self.ui.billVetBox.addItem('',None)
     for vet_temp in SqlHandler.searchVet(self.session):
         self.ui.visitVetBox.addItem(vet_temp.name, vet_temp)
         self.ui.billVetBox.addItem(vet_temp.name, vet_temp)

开发者ID:mape90，项目名称:VetApp，代码行数:8，代码来源:searchtab.py

示例16: setPostOffice

 def setPostOffice(self):
     for postoffice in SqlHandler.searchPostOffice(self.session):
         self.ui.comboBox.addItem(postoffice.name, postoffice)
     
     current = self.ui.comboBox.findText(self.parent().postOfficeName())
     if current > 0:
         self.ui.comboBox.setCurrentIndex(current)

开发者ID:mape90，项目名称:VetApp，代码行数:7，代码来源:addNewDialog.py

示例17: init

 def __init__(self, parent, item=None, deftype='Item'):
     QDialog.__init__(self,parent=parent)
     self.ui = Ui_ItemCreatorDialog()
     self.ui.setupUi(self)
     self.session = SqlHandler.newSession()
     self.deftype = deftype
     
     self.item = item
     if self.item != None:
         self.item = SqlHandler.makeCopy(self.session, self.item)
         self.session.add(self.item)
     
     self.configure()
     self.configureConnections()
     self.setBasicInfo()
     
     self.selectCorrectItem()

开发者ID:mape90，项目名称:VetApp，代码行数:17，代码来源:itemcreatordialog.py

示例18: setAlv1Names

 def setAlv1Names(self):
     alv = str(SqlHandler.getALV(1))
     self.ui.ALV1_1.setText(alv + '%')
     self.ui.ALV1_2.setText(alv + '%')
     self.ui.ALV1_3.setText(alv + '%')
     self.ui.ALV1_4.setText(alv + '%')
     #self.ui.ALV1_5.setText(alv + '%')
     self.ui.ALV1_6.setText(alv + '%')
     self.ui.ALV1_7.setText(alv + '%')

开发者ID:mape90，项目名称:VetApp，代码行数:9，代码来源:billTab.py

示例19: setVets

 def setVets(self, vet=None): #TODO: select last used vet
     self.ui.vetComboBox.clear()
     
     for vet_temp in SqlHandler.searchVet(self.session):
         self.ui.vetComboBox.addItem(vet_temp.name, vet_temp)
         if vet != None and vet.name == vet_temp.name:
             tmp_index = self.ui.vetComboBox.findText(vet_temp.name)
             if tmp_index >= 0:
                 self.ui.vetComboBox.setCurrentIndex(tmp_index)

开发者ID:mape90，项目名称:VetApp，代码行数:9，代码来源:login_dialog.py

示例20: setSpecie

 def setSpecie(self, newName=''):   
     self.ui.specieComboBox.clear()
     self.ui.specieComboBox.addItem('', None)
     
     for specie in SqlHandler.searchSpecie(self.session):
         self.ui.specieComboBox.addItem(specie.name, specie)
     
     if len(newName):
         self.ui.specieComboBox.setCurrentIndex(self.ui.specieComboBox.findText(newName))

开发者ID:mape90，项目名称:VetApp，代码行数:9，代码来源:itemcreatordialog.py

注：本文中的models.SqlHandler类示例由纯净天空整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。

鲜花

握手

雷人

路过

鸡蛋

该文章已有0人参与评论

请发表评论

全部评论

专题导读

More+

10-27 六六分期app的软件客服如何联系？(六六分期

11-06 可心卡盟:win10系统火狐flash插件崩溃怎么

11-06 亲亲特价:怎么删除回收站图标

11-06 济南大学虚拟社区:鲁大师节能降温的具体办

11-06 xlueops.exe:无线网络安装向导

11-06 女斗合众国:win7系统cf与主机连接不稳定怎

11-06 0xc000022-[cf烟雾头]cf怎么调烟雾头

11-06 qizideyouhuo:应用程序无法正常启动0xc0000

11-06 ipz-185:win7系统vcf文件怎么打开

11-06 傻哥蹦迪:win10系统s4怎么打开usb调试

11-06 八神浩树gtaste:回收站清空了怎么恢复

11-06 妖尾之黑色守护:win10系统电脑没有1440x900

11-06 校园至尊魔王小说:win7系统浏览网页时字体

11-06 女斗合众国:win10系统访问共享文件夹提示请

11-06 tokyo hot n0654:恢复win7系统默认字体一招

11-06 雨酷仙境:设置win7系统转移临时文件夹腾出

11-06 阿穆纳伊之杖:win7系统开始菜单在右边还原

11-06 tunespotting:win10系统火狐flash插件总是

11-06 甘尔葛分析师：计谋网站seo关键词暴涨有什

11-06 蔡贵霖: 计谋网站seo关键词暴涨有什么秘密

11-06 博益网首页:ao3网页版进入不了解决方法

11-06 漏斗子专栏: 网站数据分析小白易懂精华篇

11-06 见证双虹怎么做:win7系统开启telnet命令的

11-06 颾狐蝶蜋:系统资源不足无法完成请求的服务

11-06 国光中学校歌:提交网站到alexa查询详细步骤

11-06 西安有情天:静态网页和动态网页的区别

11-06 红木雅尚斋:外部链接构造对网站的好处

11-06 前官礼遇：防止域名劫持–增强域安全性的10

11-06 密传二转答案: 中文分词算法有哪些

11-06 金泉家园邮编:百度快照劫持的表现及应对方

Python models.State类代码示例发布时间：2022-05-27

Python models.Sporocilo类代码示例发布时间：2022-05-27

Python util.grid_equal函数代码示例

1 Python 入门教程

Python入门教程 Python 是一种解释型、面向对象、动态数据类型的高级程序设计语言。 P

阅读：13803|2022-01-22

2 Python wikiutil.getFrontPage函数代码示例

Python wikiutil.getFrontPage函数代码示例

阅读：10189|2022-05-24

3 Python 简介

Python 简介 Python 是一个高层次的结合了解释性、编译性、互动性和面向对象的脚本

阅读：4085|2022-01-22

4 Python tests.group函数代码示例

Python tests.group函数代码示例

阅读：4041|2022-05-27

5 Python util.check_if_user_has_permission

Python util.check_if_user_has_permission函数代码示例

阅读：3842|2022-05-27

6 Python 操练实例98

Python 练习实例98 Python 100例题目：从键盘输入一个字符串，将小写字母全部转换成大

阅读：3510|2022-01-22

7 Python 环境搭建

Python 环境搭建本章节我们将向大家介绍如何在本地搭建 Python 开发环境。 Py

阅读：3030|2022-01-22

8 Python output.darkgreen函数代码示例

Python output.darkgreen函数代码示例

阅读：2653|2022-05-25

9 Python 基础语法

Python 基础语法 Python 语言与 Perl，C 和 Java 等语言有许多相似之处。但是，也

阅读：2646|2022-01-22

10 Python 中文编码

Python 中文编码前面章节中我们已经学会了如何用 Python 输出 Hello, World!，英文没

阅读：2302|2022-01-22

客服电话

电子邮件

Python models.SqlHandler类代码示例

示例1: __init__

示例2: saveNewItem

示例3: deleteItemFromSearch

示例4: setPrices

示例5: saveDialog

示例6: getData

示例7: __init__

示例8: updateEndPrice

示例9: setSpecie

示例10: __init__

示例11: __init__

示例12: genTableRow

示例13: setRace

示例14: setColor

示例15: setVet

示例16: setPostOffice

示例17: __init__

示例18: setAlv1Names

示例19: setVets

示例20: setSpecie

请发表评论

全部评论

上一篇：

下一篇：

Python util.grid_equal函数代码示例

Python util.get_worker_name函数代码示例

Python util.get_webmention_target函数代

Python util.get_uuid函数代码示例

Python util.get_type_by_name函数代码示例

Python util.grid_equal函数代码示例

Python util.get_worker_name函数代码示例

Python util.get_webmention_target函数代

Python util.get_uuid函数代码示例

Python util.get_type_by_name函数代码示例

Python util.get_stdout函数代码示例

关于我们

产品与服务

解决方案

139-2527-9053

示例1: init

示例7: init

示例10: init

示例11: init

示例17: init