def _get_all_sequences(self, data_dict):
debug_message('generating sequences')
sequences = []
for name in data_dict.sequence_names:
min_value, max_value, step, cycled, ordered, cache_size = data_dict.sequences[name]
seq = OracleSequence(name, min_value, max_value, step, cycled, ordered, cache_size)
sequences.append(seq)
self.ddlSource.getDDLScript('SEQUENCE', name)
return sequences
def _get_all_jobs(self, data):
debug_message('generating jobs')
jobs = []
for job, log_user, priv_user, schema_user, total_time, broken, interval, failures, what in data.jobs:
jobs.append(OracleJob(job, log_user, priv_user, schema_user, total_time, broken, interval, failures, what))
return jobs
if __name__ == '__main__':
import cx_Oracle
import orasdict
from osdconfig import OSDConfig
#connection = cx_Oracle.connect('s0/asgaard')
cfg = OSDConfig()
cfg.connection = cx_Oracle.connect('s0/asgaard')
cfg.dictionary = orasdict.OraSchemaDataDictionary(cfg)
schema = OracleSchema(cfg)
