def setup_class(cls):
cls.tm1 = TM1Service(**config['tm1srv01'])
# chore properties
cls.chore_name1 = 'TM1py_unittest_chore_' + str(uuid.uuid4())
cls.chore_name2 = 'TM1py_unittest_chore_' + str(uuid.uuid4())
cls.start_time = datetime.now()
cls.frequency_days = int(random.uniform(0, 355))
cls.frequency_hours = int(random.uniform(0, 23))
cls.frequency_minutes = int(random.uniform(0, 59))
cls.frequency_seconds = int(random.uniform(0, 59))
cls.frequency = ChoreFrequency(days=cls.frequency_days, hours=cls.frequency_hours,
minutes=cls.frequency_minutes, seconds=cls.frequency_seconds)
cls.tasks = [ChoreTask(0, process_name1, parameters=[{'Name': 'pRegion', 'Value': 'UK'}]),
ChoreTask(1, process_name1, parameters=[{'Name': 'pRegion', 'Value': 'FR'}]),
ChoreTask(2, process_name1, parameters=[{'Name': 'pRegion', 'Value': 'CH'}])]
p1 = Process(name=process_name1)
p1.add_parameter('pRegion', 'pRegion (String)', value='US')
if cls.tm1.processes.exists(p1.name):
cls.tm1.processes.delete(p1.name)
cls.tm1.processes.create(p1)
p2 = Process(name=process_name2)
p2.add_parameter('pRegion', 'pRegion (String)', value='UK')
if cls.tm1.processes.exists(p2.name):
cls.tm1.processes.delete(p2.name)
cls.tm1.processes.create(p2)
def setup_class(cls):
p1 = Process(name=process_name1)
p1.add_parameter('pRegion', 'pRegion (String)', value='US')
if cls.tm1.processes.exists(p1.name):
cls.tm1.processes.delete(p1.name)
cls.tm1.processes.create(p1)
p2 = Process(name=process_name2)
p2.add_parameter('pRegion', 'pRegion (String)', value='UK')
if cls.tm1.processes.exists(p2.name):
cls.tm1.processes.delete(p2.name)
cls.tm1.processes.create(p2)
def setUpClass(cls):
"""
Establishes a connection to TM1 and creates objects to use across all tests
"""
# Connection to TM1
cls.config = configparser.ConfigParser()
cls.config.read(Path(__file__).parent.joinpath('config.ini'))
cls.tm1 = TM1Service(**cls.config['tm1srv01'])
# create processes
p1 = Process(name=PROCESS_NAME1)
p1.add_parameter('pRegion', 'pRegion (String)', value='US')
if cls.tm1.processes.exists(p1.name):
cls.tm1.processes.delete(p1.name)
cls.tm1.processes.create(p1)
p2 = Process(name=PROCESS_NAME2)
p2.add_parameter('pRegion', 'pRegion (String)', value='UK')
if cls.tm1.processes.exists(p2.name):
cls.tm1.processes.delete(p2.name)
cls.tm1.processes.create(p2)
# chore properties
cls.start_time = datetime.now()
cls.frequency_days = int(random.uniform(0, 355))
cls.frequency_hours = int(random.uniform(0, 23))
cls.frequency_minutes = int(random.uniform(0, 59))
cls.frequency_seconds = int(random.uniform(0, 59))
cls.frequency = ChoreFrequency(days=cls.frequency_days,
hours=cls.frequency_hours,
minutes=cls.frequency_minutes,
seconds=cls.frequency_seconds)
cls.tasks = [
ChoreTask(0,
PROCESS_NAME1,
parameters=[{
'Name': 'pRegion',
'Value': 'UK'
}]),
ChoreTask(1,
PROCESS_NAME1,
parameters=[{
'Name': 'pRegion',
'Value': 'FR'
}]),
ChoreTask(2,
PROCESS_NAME1,
parameters=[{
'Name': 'pRegion',
'Value': 'CH'
}])
]
def setUpClass(cls):
"""
Establishes a connection to TM1 and creates objects to use across all tests
"""
# Connection to TM1
cls.config = configparser.ConfigParser()
cls.config.read(Path(__file__).parent.joinpath('config.ini'))
cls.tm1 = TM1Service(**cls.config['tm1srv01'])
# create processes
p1 = Process(name=cls.process_name1)
p1.add_parameter('pRegion', 'pRegion (String)', value='US')
if cls.tm1.processes.exists(p1.name):
cls.tm1.processes.delete(p1.name)
cls.tm1.processes.create(p1)
p2 = Process(name=cls.process_name2)
p2.add_parameter('pRegion', 'pRegion (String)', value='UK')
if cls.tm1.processes.exists(p2.name):
cls.tm1.processes.delete(p2.name)
cls.tm1.processes.create(p2)
"""
Create a TI process in TM1
"""
from TM1py.Objects import Process
from TM1py.Services import TM1Service
# connection to TM1 Server
with TM1Service(address='localhost', port=12354, user='******', password='******', ssl=True) as tm1:
process_name = 'TM1py process'
# create new Process in python
p_ascii = Process(name=process_name,
datasource_type='ASCII',
datasource_ascii_delimiter_char=',',
datasource_data_source_name_for_server=r'C:\Data\file.csv',
datasource_data_source_name_for_client=r'C:\Data\file.csv')
# variables
p_ascii.add_variable('v_1', 'Numeric')
p_ascii.add_variable('v_2', 'Numeric')
p_ascii.add_variable('v_3', 'Numeric')
p_ascii.add_variable('v_4', 'Numeric')
# parameters
p_ascii.add_parameter(name='pCompanyCode', prompt='', value='DE04')
# code
p_ascii.prolog_procedure = "sText = 'IBM Cognos TM1';"
# create process on TM1 Server
tm1.processes.create(p_ascii)
