def get_shot_list_from_scene(scene_name): shot_list = [] from drTank.util import shotgun_session as ss api = ss().api() shot_dicts = api.find_one("Scene", [["code", "is", scene_name]], ["shots"])["shots"] for dict in shot_dicts: shot_list.append(dict["name"]) return shot_list
def refill_from_shotgun(self): bg_color = QtGui.QColor(0,0,0) bg_color.setHsv(89, 24, 230) id_font = QtGui.QFont("Sans Serif", 9, 10) id_font.setBold(True) self.tableWidget.hideColumn(0) self.tableWidget.horizontalHeader().setStretchLastSection(True) header_list = ["id", "sg_department", "code", "sg_date_and_time", "description"] api = ss().api() all_playlist = api.find( "Playlist", [], header_list ) row_index = 0 for each_playlist in all_playlist: self.tableWidget.insertRow(row_index) self.tableWidget.verticalHeader().resizeSection(row_index, 22) for column_index in range(5): wItem = QtGui.QTableWidgetItem() #wItem.setSizeHint(QtCore.QSize(-1, 20)) # restrict the users from accidentally editing the value in the cell wItem.setFlags( QtCore.Qt.ItemIsEnabled | QtCore.Qt.ItemIsSelectable ) self.tableWidget.setItem(row_index, column_index, wItem) # set text for each row, write "-" if the corresponding value in shotgun field says None or '' # be aware about [Department], [sg_date_and_time], they'r composed by 2 levels of dictionary try: if column_index == 0: id_string = str(each_playlist[header_list[column_index]]) if len(id_string) == 1: id_string = "0" + id_string self.tableWidget.item(row_index, column_index).setText( id_string ) self.tableWidget.item(row_index, column_index).setBackgroundColor( bg_color ) self.tableWidget.item(row_index, column_index).setFont(id_font) elif column_index == 1: self.tableWidget.item(row_index, column_index).setText( each_playlist[header_list[column_index]]["name"] ) elif column_index == 3: timeObject = each_playlist[ header_list[column_index] ] time_string = str(timeObject.date()) + " " + str(timeObject.time()) self.tableWidget.item(row_index, column_index).setText( time_string ) else: self.tableWidget.item(row_index, column_index).setText( each_playlist[ header_list[column_index]] ) except: self.tableWidget.item(row_index, column_index).setText( "............" ) row_index += 1
def refill_from_shotgun(self): bg_color = QtGui.QColor(0, 0, 0) bg_color.setHsv(89, 24, 230) id_font = QtGui.QFont("Sans Serif", 9, 10) id_font.setBold(True) self.tableWidget.hideColumn(0) self.tableWidget.horizontalHeader().setStretchLastSection(True) header_list = [ "id", "sg_department", "code", "sg_date_and_time", "description" ] api = ss().api() all_playlist = api.find("Playlist", [], header_list) row_index = 0 for each_playlist in all_playlist: self.tableWidget.insertRow(row_index) self.tableWidget.verticalHeader().resizeSection(row_index, 22) for column_index in range(5): wItem = QtGui.QTableWidgetItem() #wItem.setSizeHint(QtCore.QSize(-1, 20)) # restrict the users from accidentally editing the value in the cell wItem.setFlags(QtCore.Qt.ItemIsEnabled | QtCore.Qt.ItemIsSelectable) self.tableWidget.setItem(row_index, column_index, wItem) # set text for each row, write "-" if the corresponding value in shotgun field says None or '' # be aware about [Department], [sg_date_and_time], they'r composed by 2 levels of dictionary try: if column_index == 0: id_string = str( each_playlist[header_list[column_index]]) if len(id_string) == 1: id_string = "0" + id_string self.tableWidget.item(row_index, column_index).setText(id_string) self.tableWidget.item( row_index, column_index).setBackgroundColor(bg_color) self.tableWidget.item(row_index, column_index).setFont(id_font) elif column_index == 1: self.tableWidget.item(row_index, column_index).setText( each_playlist[header_list[column_index]]["name"]) elif column_index == 3: timeObject = each_playlist[header_list[column_index]] time_string = str(timeObject.date()) + " " + str( timeObject.time()) self.tableWidget.item( row_index, column_index).setText(time_string) else: self.tableWidget.item(row_index, column_index).setText( each_playlist[header_list[column_index]]) except: self.tableWidget.item(row_index, column_index).setText("............") row_index += 1