本文整理汇总了Python中query.Query.getColumnValues方法的典型用法代码示例。如果您正苦于以下问题:Python Query.getColumnValues方法的具体用法?Python Query.getColumnValues怎么用?Python Query.getColumnValues使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类query.Query
的用法示例。
在下文中一共展示了Query.getColumnValues方法的2个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Python代码示例。
示例1: Report
# 需要导入模块: from query import Query [as 别名]
# 或者: from query.Query import getColumnValues [as 别名]
#.........这里部分代码省略.........
recordForm. addRow([bookForm, subTables])
return recordForm.getTable()
def buildBookForm(self, bookData):
'''Accepts bookData, which may be blank.
Builds book form. If bookData !None pre-populates form with default
values from bookData.
returns book form HTML table
'''
#initialze book from table
bookForm = HtmlTable(border=1, cellpadding=3)
bookForm.addHeader(['Field', 'Entry'])
#loop through display names (the ordered list of column names)
#for each: determine the default value and form type
for column, display in self.display_names:
form_type = self.columns[column][0]['form_type']
if self.report == 'edit' and bookData !=None:
default = bookData[0][column]
else:
default = None
#buld a form field of the correct type
if form_type == 'text':
if default == None:
default = ''
form_field = self.forms.getTextField(column, default)
elif form_type == 'drop_down':
#pull in the values from the home table to make a
#list of options
options = self.query.getColumnValues(column)
form_field = self.forms.getDropDown(column, default, options)
elif form_type == 'radio_static':
if default == None and column == 'published':
default = 1
#pull in status radio options from metadata
options = self.columns[column][0]['radio_options']
form_field =self.forms.getStaticRadio(column, default, options)
elif form_type == 'datepicker':
if default == None:
default = ''
form_field = self.forms.getJQueryUI(column, default, form_type)
elif form_type == 'autocomplete':
if default == None:
default = ''
form_field =self.forms.getAutoComplete(column, default)
else:
#debug feature that will make a cell in the table declare
#what form type it thinks it should be if the form type is not
#found above
form_field = form_type
#add the display name and form field as a new row in the book form
bookForm.addRow([display, form_field])
return bookForm.getTable()
示例2: Report
# 需要导入模块: from query import Query [as 别名]
# 或者: from query.Query import getColumnValues [as 别名]
#.........这里部分代码省略.........
Returns composite table of all above sub-parts.
'''
if self.report == 'edit' and book_id != None:
where = 'book.book_id =' + str(book_id)
bookData = self.query.getData('edit', where)
bookTable = HtmlTable(border=1, cellpadding=3)
bookTable.addHeader(['Field', 'Entry'])
for column, display in self.display_names:
form_type = self.columns[column][0]['form_type']
if self.report == 'edit':
default = bookData[0][column]
else:
default = None
if column == 'author' or column == 'when_read':
pass
else:
#use general methods to build forms
if form_type == 'text':
if default == None:
default = ''
form_field = self.forms.getTextField(column, default)
elif form_type == 'drop_down':
#pull in the values from the home table to make a
#list of options
options = self.query.getColumnValues(column)
form_field = \
self.forms.getDropDown(column, default, options)
elif form_type == 'radio_static':
if default == None and column == 'published':
default = 1
options = self.columns[column][0]['radio_options']
form_field =\
self.forms.getStaticRadio(column, default, options)
elif form_type == 'datepicker':
if default == None:
default = ''
form_field =\
self.forms.getJQueryUI(column, default, form_type)
elif form_type == 'autocomplete':
if default == None:
default = ''
form_field =\
self.forms.getAutoComplete(column, default)
else:
form_field = form_type
bookTable.addRow([display, form_field])