本文整理匯總了Python中geoprocessing.business_logic.business_objects.store.Store.store_format方法的典型用法代碼示例。如果您正苦於以下問題:Python Store.store_format方法的具體用法?Python Store.store_format怎麽用?Python Store.store_format使用的例子?那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類geoprocessing.business_logic.business_objects.store.Store
的用法示例。
在下文中一共展示了Store.store_format方法的2個代碼示例,這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚,您的評價將有助於係統推薦出更棒的Python代碼示例。
示例1: get_matched_open_store_from_db
# 需要導入模塊: from geoprocessing.business_logic.business_objects.store import Store [as 別名]
# 或者: from geoprocessing.business_logic.business_objects.store.Store import store_format [as 別名]
def get_matched_open_store_from_db(address_id, company_id, phone, store_format):
statement = '''
select
s.store_id,
s.company_id,
s.address_id,
s.phone_number,
s.store_format,
s.company_generated_store_number,
s.note,
s.opened_date,
s.assumed_opened_date
from stores s
where s.address_id = %d and s.company_id = %d and s.phone_number %s and s.store_format %s
and s.closed_date is null and s.assumed_closed_date is null''' % (address_id, company_id, select_clean_up_string(phone), select_clean_up_string(store_format))
db_store_params = sql_execute(statement)
if len(db_store_params) > 0:
db_store = Store()
db_store.store_id = db_store_params[0].store_id
db_store.company_id = db_store_params[0].company_id
db_store.address_id = db_store_params[0].address_id
db_store.phone_number = db_store_params[0].phone_number
db_store._opened_date = db_store_params[0].opened_date
db_store._assumed_opened_date = db_store_params[0].assumed_opened_date
db_store.store_format = db_store_params[0].store_format
db_store.company_generated_store_number = db_store_params[0].company_generated_store_number
db_store.note = db_store_params[0].note
return db_store
else:
return None
示例2: get_matched_open_store_from_db_by_core_store_id
# 需要導入模塊: from geoprocessing.business_logic.business_objects.store import Store [as 別名]
# 或者: from geoprocessing.business_logic.business_objects.store.Store import store_format [as 別名]
def get_matched_open_store_from_db_by_core_store_id(core_store_id):
statement = '''
select
s.store_id,
s.company_id,
s.address_id,
s.phone_number,
s.store_format,
s.company_generated_store_number,
s.note,
s.opened_date,
s.assumed_opened_date
from stores s
where core_store_id = '%s' and s.closed_date is null and s.assumed_closed_date is null''' % core_store_id
db_store_params = sql_execute(statement)
if len(db_store_params) > 0:
db_store = Store()
db_store.store_id = db_store_params[0].store_id
db_store.company_id = db_store_params[0].company_id
db_store.address_id = db_store_params[0].address_id
db_store.phone_number = db_store_params[0].phone_number
db_store._opened_date = db_store_params[0].opened_date
db_store._assumed_opened_date = db_store_params[0].assumed_opened_date
db_store.store_format = db_store_params[0].store_format
db_store.company_generated_store_number = db_store_params[0].company_generated_store_number
db_store.note = db_store_params[0].note
return db_store
else:
return None