def delete_all_redo():
user_name = Environment.get_user_name()
search = Search("sthpw/transaction_log")
search.add_order_by("timestamp")
search.add_filter("type", "redo")
search.add_filter("login", user_name)
transaction_logs = search.do_search()
for transaction_log in transaction_logs:
transaction_log.delete()
def delete_all_redo():
user_name = Environment.get_user_name()
search = Search("sthpw/transaction_log")
search.add_order_by("timestamp")
search.add_filter("type", "redo")
search.add_filter("login", user_name)
transaction_logs = search.do_search()
for transaction_log in transaction_logs:
transaction_log.delete()
def get_by_ticket(ticket):
search = Search(TransactionState)
search.add_filter("ticket", ticket)
state = search.get_sobject()
# create the state data for this ticket
if not state:
state = SObjectFactory.create(TransactionState.SEARCH_TYPE)
state.set_value("ticket", ticket)
data = Xml()
data.create_doc("state")
state.set_value("data", data.to_string() )
state.commit()
return state
def get_by_ticket(ticket):
search = Search(TransactionState)
search.add_filter("ticket", ticket)
state = search.get_sobject()
# create the state data for this ticket
if not state:
state = SObjectFactory.create(TransactionState.SEARCH_TYPE)
state.set_value("ticket", ticket)
data = Xml()
data.create_doc("state")
state.set_value("data", data.to_string())
state.commit()
return state
def get(cls, user_name=None, namespace=None, time_interval=None):
search = Search("sthpw/transaction_log")
if user_name:
search.add_filter("login", user_name)
if namespace:
search.add_filter("namespace", namespace)
if time_interval and time_interval != 'NONE':
from sql import Select
search.add_where(Select.get_interval_where(time_interval))
search.add_order_by("timestamp desc")
search.set_limit(100)
sobjects = search.do_search()
return sobjects
def get(cls, user_name=None, namespace=None, time_interval=None):
search = Search("sthpw/transaction_log")
if user_name:
search.add_filter("login", user_name)
if namespace:
search.add_filter("namespace", namespace)
if time_interval and time_interval != 'NONE':
from sql import Select
search.add_where(Select.get_interval_where(time_interval))
search.add_order_by("timestamp desc")
search.set_limit(100)
sobjects = search.do_search()
return sobjects
def get_next_redo():
from pyasm.biz import Project
namespace = Project.get_project_code()
user_name = Environment.get_user_name()
search = Search("sthpw/transaction_log")
search.add_filter("login", user_name)
search.add_filter("namespace", namespace)
search.add_filter("type", "redo")
search.add_order_by("timestamp")
sobject = search.get_sobject()
return sobject
def get_next_redo():
from pyasm.biz import Project
namespace = Project.get_project_code()
user_name = Environment.get_user_name()
search = Search("sthpw/transaction_log")
search.add_filter("login", user_name)
search.add_filter("namespace", namespace)
search.add_filter("type", "redo")
search.add_order_by("timestamp")
sobject = search.get_sobject()
return sobject
def get_last(type=None):
#namespace = SearchType.get_project()
from pyasm.biz import Project
namespace = Project.get_project_code()
user_name = Environment.get_user_name()
search = Search("sthpw/transaction_log")
search.add_filter("login", user_name)
search.add_filter("namespace", namespace)
if type:
search.add_filter("type", type)
search.add_order_by("timestamp desc")
sobject = search.get_sobject()
return sobject
def get_last(type=None):
#namespace = SearchType.get_project()
from pyasm.biz import Project
namespace = Project.get_project_code()
user_name = Environment.get_user_name()
search = Search("sthpw/transaction_log")
search.add_filter("login", user_name)
search.add_filter("namespace", namespace)
if type:
search.add_filter("type", type)
search.add_order_by("timestamp desc")
sobject = search.get_sobject()
return sobject
