def get_all():
"""Gets all quotes from the database.
Returns:
All quotess from the database.
"""
return db.execute_query("select * from quote", None)
def get_all():
"""Gets all contract items from the database.
Returns:
All contract items from the database.
"""
return db.execute_query("select * from contract_item", None)
def get_all():
"""Gets all requests from the database.
Returns:
All requests from the database.
"""
return db.execute_query("select * from request", None)
def get_quote_by_id(quote_id):
"""Gets a quote from the database using its ID.
Args:
quote_id: The id of the quote item.
Returns:
The quote if it exists.
"""
return db.execute_query("select * from quote where quote_id = %s",
(quote_id, ))
def get_contract_item_by_id(contract_item_id):
"""Gets a contract item from the database using its ID.
Args:
contract_item_id: The id of the contract item.
Returns:
The contract item if it exists.
"""
return db.execute_query("select * from contract_item where c_id = %s",
(contract_item_id, ))
def get_request_by_id(request_id):
"""Gets a request from the database using its ID.
Args:
request_id: The id of the request item.
Returns:
The request if it exists.
"""
return db.execute_query("select * from request where request_id = %s",
(request_id, ))