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 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
