def getEmptyRecord(self): isFirst = not bool(self.items()) result = CInDocTableModel.getEmptyRecord(self) result.append(QtSql.QSqlField('diagnosis_id', QtCore.QVariant.Int)) result.append(QtSql.QSqlField('diagnosisType_id', QtCore.QVariant.Int)) result.append(QtSql.QSqlField('speciality_id', QtCore.QVariant.Int)) result.append(QtSql.QSqlField('person_id', QtCore.QVariant.Int)) result.append(QtSql.QSqlField('dispanser_id', QtCore.QVariant.Int)) result.append(QtSql.QSqlField('hospital', QtCore.QVariant.Int)) result.append(QtSql.QSqlField('healthGroup_id', QtCore.QVariant.Int)) result.append(QtSql.QSqlField('setDate', QtCore.QVariant.DateTime)) result.append(QtSql.QSqlField('endDate', QtCore.QVariant.DateTime)) result.append(QtSql.QSqlField('payStatus', QtCore.QVariant.Int)) result.setValue('diagnosisType_id', QtCore.QVariant(self.getDiagnosisTypeId(isFirst))) if isFirst: if self._parent.inheritResult == True: result.setValue( 'result_id', toVariant( CEventEditDialog.defaultDiagnosticResultId.get( self._parent.eventPurposeId))) else: result.setValue('result_id', toVariant(None)) return result
def getEmptyRecord(self): newRecord = super(CDestinationsModel, self).getEmptyRecord() for col in self._cols: newRecord.append(QtSql.QSqlField(col.fieldName())) for col in self._hiddenCols: newRecord.append(QtSql.QSqlField(col)) return newRecord
def get_record(tooth_id, section, state_id): rec = QtSql.QSqlRecord() rec.append(QtSql.QSqlField('id', QtCore.QVariant.ULongLong)) rec.append(QtSql.QSqlField('tooth_id', QtCore.QVariant.ULongLong)) rec.append(QtSql.QSqlField('section', QtCore.QVariant.String)) rec.append(QtSql.QSqlField('state_id', QtCore.QVariant.ULongLong)) rec.append(QtSql.QSqlField('deleted', QtCore.QVariant.Bool)) rec.setValue('tooth_id', tooth_id) rec.setValue('section', section) rec.setValue('state_id', state_id) return rec
def handle_rcvd_record(self, r): # Create QSqlRecord object record = QtSql.QSqlRecord() record.append(QtSql.QSqlField("timestamp")) record.append(QtSql.QSqlField("component")) record.append(QtSql.QSqlField("verbosity")) record.append(QtSql.QSqlField("message")) record.setValue(0, r['asctime']) record.setValue(1, r['module']) record.setValue(2, r['levelname']) record.setValue(3, r['message']) # Insert record self.insert_record(record)
def run(self): # Parse log message ts, verb, comp, msg = self.parse_logmsg() # Create record record = QtSql.QSqlRecord() record.append(QtSql.QSqlField("timestamp")) record.append(QtSql.QSqlField("component")) record.append(QtSql.QSqlField("verbosity")) record.append(QtSql.QSqlField("message")) record.setValue(0, ts) record.setValue(1, comp) record.setValue(2, verb) record.setValue(3, msg) # Insert record self.parent.insertRecordSignal.emit(record)
def newRecord(self, fields=None, otherRecord=None): record = QtSql.QSqlRecord() for field in self.fields: if fields and field.field.name() not in fields: continue record.append(QtSql.QSqlField(field.field)) if otherRecord and otherRecord.contains(field.field.name()) and field != self._idField: record.setValue(field.field.name(), otherRecord.value(field.field.name())) return record
def addItems(self, issueFormList): self.removeRows(0, len(self._items)) for issueForm in issueFormList: newRecord = super(CIssueFormTableModel, self).getEmptyRecord() for col in self._cols: newRecord.append(QtSql.QSqlField(col.fieldName())) if col.fieldName() == 'issueForm': newRecord.setValue(col.fieldName(), issueForm) self.addRecord(newRecord)
def addItems(self, mnnList): self.removeRows(0, len(self._items)) for mnn in mnnList: newRecord = super(CMNNTableModel, self).getEmptyRecord() for col in self._cols: newRecord.append(QtSql.QSqlField(col.fieldName())) if col.fieldName() == 'mnn': newRecord.setValue(col.fieldName(), mnn) self.addRecord(newRecord)
def prepareDiagnostics(self, eventTypeId): includedGroups = [] db = QtGui.qApp.db tableEventTypeDiagnostic = db.table('EventType_Diagnostic') tableEvenType = db.table('EventType') records = QtGui.qApp.db.getRecordList(tableEventTypeDiagnostic.innerJoin(tableEvenType, tableEvenType['id'].eq(tableEventTypeDiagnostic['eventType_id'])), cols=['EventType_Diagnostic.*', tableEvenType['scene_id']], where=tableEventTypeDiagnostic['eventType_id'].eq(eventTypeId), order=[tableEventTypeDiagnostic['idx'], tableEventTypeDiagnostic['id']]) model = self.__modelDiagnostics self.boolPersonSpecialityId = False if len(records) else True for record in records: if self.recordAcceptable(record): target = model.getEmptyRecord() target.append(QtSql.QSqlField('scene_id', QtCore.QVariant.Int)) target.append(QtSql.QSqlField('defaultHealthGroup_id', QtCore.QVariant.Int)) target.append(QtSql.QSqlField('defaultMedicalGroup_id', QtCore.QVariant.Int)) target.append(QtSql.QSqlField('defaultMKB', QtCore.QVariant.String)) target.setValue('speciality_id', record.value('speciality_id')) target.setValue('visitType_id', record.value('visitType_id')) target.setValue('actuality', record.value('actuality')) target.setValue('selectionGroup', record.value('selectionGroup')) target.setValue('defaultHealthGroup_id', record.value('defaultHealthGroup_id')) target.setValue('defaultMedicalGroup_id', record.value('defaultMedicalGroup_id')) target.setValue('defaultMKB', record.value('defaultMKB')) target.setValue('defaultGoal_id', record.value('defaultGoal_id')) target.setValue('service_id', record.value('service_id')) target.setValue('scene_id', record.value('scene_id')) selectionGroup = forceInt(record.value('selectionGroup')) if selectionGroup <= 0: target.setValue('include', QtCore.QVariant(0)) elif selectionGroup == 1: target.setValue('include', QtCore.QVariant(1)) elif selectionGroup in includedGroups : target.setValue('include', QtCore.QVariant(0)) else: if forceRef(record.value('speciality_id')) == self.personSpecialityId: target.setValue('include', QtCore.QVariant(1)) includedGroups.append(selectionGroup) if forceRef(record.value('speciality_id')) == self.personSpecialityId: self.boolPersonSpecialityId = True model.items().append(target) model.reset()
def _saveToSqlRecord(sqlRecordInfo, record, sourceData): for fieldName in sqlRecordInfo.keys(): if not record.contains( fieldName) and sqlRecordInfo[fieldName][0] is not None: record.append( QtSql.QSqlField(fieldName, sqlRecordInfo[fieldName][0])) # получение значение поля через соответствующее свойство (указанное в _sqlRecordInfo) value = sqlRecordInfo[fieldName][1].__get__(sourceData) record.setValue(fieldName, toVariant(value)) return record
def empty_record(): rec = QtSql.QSqlRecord() rec.append(QtSql.QSqlField('id', QtCore.QVariant.ULongLong)) rec.append(QtSql.QSqlField('formula_id', QtCore.QVariant.ULongLong)) rec.append(QtSql.QSqlField('number', QtCore.QVariant.String)) rec.append(QtSql.QSqlField('is_deciduous', QtCore.QVariant.Bool)) rec.append(QtSql.QSqlField('status_id', QtCore.QVariant.ULongLong)) rec.append(QtSql.QSqlField('mobility', QtCore.QVariant.ULongLong)) rec.append(QtSql.QSqlField('deleted', QtCore.QVariant.Bool)) return rec
def __init__(self, database, tableName, field, fieldType=None): self.database = database # type: CDatabase self.tableName = tableName if isinstance(field, QtSql.QSqlField): self.fieldName = database.escapeFieldName(field.name()) self.field = field self.isSurrogate = False elif isinstance(field, (basestring, QString)): self.fieldName = forceString(field) self.field = QtSql.QSqlField( field, fieldType if isinstance(fieldType, QVariant.Type) else QVariant.String) self.isSurrogate = True
def getEmptyRecord(self, propertyTypeCellsSettings=None): if not propertyTypeCellsSettings: propertyTypeCellsSettings = {} record = self._table.newRecord() for col in self._cols: if not col.fieldName() in self._dbFieldNamesList: record.append(QtSql.QSqlField(col.fieldName(), col.valueType())) for name in self._propertyColsNames: isActive = propertyTypeCellsSettings.get(name, False) if not isActive: record.setValue(name, QtCore.QVariant(u'----')) return record
def loadItems(self, masterId): db = QtGui.qApp.db cols = ['id', 'master_id', 'actionType_id', 'selectionGroup'] table = db.table('rbJobType_ActionType') cond = [ table['master_id'].eq(masterId), table['actionType_id'].notInlist(self._existsActionTypeIdList) ] self._items = db.getRecordList(table, cols, cond, ['id']) for item in self._items: item.append(QtSql.QSqlField('checked', QtCore.QVariant.Bool)) item.append(QtSql.QSqlField('amount', QtCore.QVariant.Double)) selectionGroup = forceInt(item.value('selectionGroup')) groupItemList = self._cacheItemsByGroup.setdefault( selectionGroup, []) groupItemList.append(item) if selectionGroup == 1 or (selectionGroup and len(groupItemList) == 1): item.setValue('checked', QtCore.QVariant(True)) self.reset()
def record(self): """This method return in a QSqlRecord the fields (rows) of the last query""" if DEBUG_MODE: print "$$ -> LlampexResult.record() (crear QSqlRecord())" info = QtSql.QSqlRecord() if not self.isActive() or not self.isSelect(): return info global pg2qttype for field in self.fields: f = QtSql.QSqlField(field[0], pg2qttype[field[1]]) info.append(f) #if DEBUG_MODE: # print "$$ -> field:", field #if DEBUG_MODE: # print "$$ <<< LlampexResult.record()" return info
def getNewRecord(): rec = QtSql.QSqlRecord() id_field = QtSql.QSqlField('id', QtCore.QVariant.ULongLong) id_field.setAutoValue(True) rec.append(id_field) rec.append(QtSql.QSqlField('client_id', QtCore.QVariant.ULongLong)) rec.append(QtSql.QSqlField('amount', QtCore.QVariant.ULongLong)) rec.append(QtSql.QSqlField('note', QtCore.QVariant.String)) rec.append(QtSql.QSqlField('tissueType_id', QtCore.QVariant.ULongLong)) rec.append(QtSql.QSqlField('unit_id', QtCore.QVariant.ULongLong)) rec.append(QtSql.QSqlField('number', QtCore.QVariant.String)) rec.append(QtSql.QSqlField('status', QtCore.QVariant.ULongLong)) rec.append(QtSql.QSqlField('datetimeTaken', QtCore.QVariant.DateTime)) rec.append(QtSql.QSqlField('execPerson_id', QtCore.QVariant.ULongLong)) rec.append(QtSql.QSqlField('externalId', QtCore.QVariant.String)) return rec
def create_person(self, person, person_id=None): rec = QtSql.QSqlRecord() rec.append(QtSql.QSqlField('code', QtCore.QVariant.String)) rec.setValue('code', QtCore.QVariant(person['TabNumber'])) rec.append(QtSql.QSqlField('federalCode', QtCore.QVariant.String)) rec.setValue('federalCode', QtCore.QVariant(person['TabNumber'])) rec.append(QtSql.QSqlField('regionalCode', QtCore.QVariant.String)) rec.setValue('regionalCode', QtCore.QVariant(person['TabNumber'])) rec.append(QtSql.QSqlField('firstName', QtCore.QVariant.String)) rec.setValue('firstName', QtCore.QVariant(person['Name'])) rec.append(QtSql.QSqlField('lastName', QtCore.QVariant.String)) rec.setValue('lastName', QtCore.QVariant(person['Surname'])) rec.append(QtSql.QSqlField('patrName', QtCore.QVariant.String)) rec.setValue('patrName', QtCore.QVariant(person['Patroname'])) rec.append(QtSql.QSqlField('sex', QtCore.QVariant.Int)) rec.setValue('sex', QtCore.QVariant(person['Sex'])) rec.append(QtSql.QSqlField('post_id', QtCore.QVariant.Int)) if person['PostGUID'] in self.posts: rec.setValue('post_id', QtCore.QVariant(self.posts[person['PostGUID']])) rec.append(QtSql.QSqlField('speciality_id', QtCore.QVariant.Int)) if person['SpecialityGUID'] in self.specialities: rec.setValue( 'speciality_id', QtCore.QVariant(self.specialities[person['SpecialityGUID']])) rec.append(QtSql.QSqlField('orgStructure_id', QtCore.QVariant.Int)) if person['SubdivisionGUID'] in self.org_structures: rec.setValue( 'orgStructure_id', QtCore.QVariant( self.org_structures[person['SubdivisionGUID']])) rec.append(QtSql.QSqlField('SNILS', QtCore.QVariant.String)) rec.setValue('SNILS', QtCore.QVariant(person['SNILS'])) rec.append(QtSql.QSqlField('birthDate', QtCore.QVariant.Date)) rec.setValue('birthDate', QtCore.QVariant(person['DateBirth'])) rec.append(QtSql.QSqlField('syncGUID', QtCore.QVariant.String)) rec.setValue('syncGUID', QtCore.QVariant(person['GUID'])) if person['DateEnd']: rec.append(QtSql.QSqlField('retired', QtCore.QVariant.Int)) rec.append(QtSql.QSqlField('retireDate', QtCore.QVariant.Date)) rec.setValue('retired', QtCore.QVariant(1)) rec.setValue('retireDate', QtCore.QVariant(person['DateEnd'])) if person_id: rec.append(QtSql.QSqlField('id', QtCore.QVariant.Int)) rec.setValue('id', QtCore.QVariant(person_id)) rec.append(QtSql.QSqlField('org_id', QtCore.QVariant.Int)) rec.setValue('org_id', QtCore.QVariant(QtGui.qApp.currentOrgId())) return rec
def __init__(self, name, fieldType): super(CField, self).__init__() self.database = None self.tableName = '' self.fieldName = name self.field = QtSql.QSqlField(name, fieldType)
def getNewRecord(cls): record = QtSql.QSqlRecord() for fieldName, fieldType in cls.fields: record.append(QtSql.QSqlField(fieldName, fieldType)) return record
def getEmptyRecord(self): record = CRecordListModel.getEmptyRecord(self) record.append(QtSql.QSqlField('id', QtCore.QVariant.Int)) return record
def empty_record(): rec = QtSql.QSqlRecord() rec.append(QtSql.QSqlField('id', QtCore.QVariant.ULongLong)) rec.append(QtSql.QSqlField('event_id', QtCore.QVariant.ULongLong)) rec.append(QtSql.QSqlField('is_deciduous', QtCore.QVariant.Bool)) return rec
def getEmptyRecord(self): result = CInDocTableModel.getEmptyRecord(self) result.append(QtSql.QSqlField('payable', QtCore.QVariant.Int)) result.setValue('amount', QtCore.QVariant(1.0)) result.setValue('cash', QtCore.QVariant(self.wholeEventForCash)) return result
def loadData(self, eventId, dateBegin, dateEnd, doctorMode): self._items = [] if not eventId: self.reset() return db = QtGui.qApp.db stmt = u''' CALL getEventDrugDestinations('%(eventId)s', '%(dateBegin)s', '%(dateEnd)s', '%(doctorMode)d') ''' % { 'eventId': eventId, 'dateBegin': dateBegin.toString('yyyy-MM-dd'), 'dateEnd': dateEnd.toString('yyyy-MM-dd'), 'doctorMode': 1 if doctorMode else 0 } query = db.query(stmt) while query.next(): record = query.record() takeDate = forceString(record.value('takeDate')) takeDate = takeDate.split(',') takeDose = forceString(record.value('takeDose')) takeDose = takeDose.split(',') takeTime = forceString(record.value('takeTime')) takeTime = takeTime.split(',') stmtUnit = u''' SELECT rbUnit.code FROM rbUnit WHERE rbUnit.id = %(id)s ''' % { 'id': forceInt(record.value('drugMeasureUnit_id')) } queryUnit = QtGui.qApp.db.query(stmtUnit) if queryUnit.first(): recordUnit = queryUnit.record() unit = '(' + forceString(recordUnit.value('code')) + ')' else: unit = '' destinationItems = [] for dose in takeDose: item = dose + ' ' + unit if dose else '' destinationItems.append(item) i = 0 if len(takeDate) > 1: date = QtCore.QDate(forceInt(takeDate[0][:4]), forceInt(takeDate[0][5:7]), forceInt(takeDate[0][8:])) date = date.addDays(1) endDate = QtCore.QDate(forceInt(takeDate[1][:4]), forceInt(takeDate[1][5:7]), forceInt(takeDate[1][8:])) while date != endDate: date = date.addDays(1) i += 1 record.append(QtSql.QSqlField('interval')) record.setValue('interval', toVariant(i)) itemDose = '' i = 0 for date in takeDate: curDate = date[8:] + '.' + date[5:7] + '.' + date[:4] for time in takeTime: curTime = time[:5] itemDose += '(' + curDate + ' ' + curTime + ') ' + destinationItems[ i] + '; ' i += 1 record.append(QtSql.QSqlField('receivingTime')) record.setValue('receivingTime', toVariant(itemDose)) self._items.append(record) self.reset()