FilesExpand file tree

 master

/

Sample 1.1.py

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

97 lines (69 loc) · 2.57 KB

 master

/

Sample 1.1.py

Copy path

Top

File metadata and controls

• Code
• Blame

97 lines (69 loc) · 2.57 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

91

92

93

94

95

96

97

from __future__ import (absolute_import, division, print_function)

import sys

import os

from odm2api.ODMconnection import dbconnection

import pprint

from odm2api.ODM1_1_1.services import SeriesService

__author__ = 'stephanie'

this_file = os.path.realpath(__file__)

directory = os.path.dirname(this_file)

sys.path.insert(0, directory)

# ----------------------------------------

conns = [

#connection to the ODM1 database

dbconnection.createConnection('mysql', 'jws.uwrl.usu.edu', 'odm', "ODM", "ODM123!!", 1.1),

#connection to the ODM2 database

dbconnection.createConnection('mssql', '(local)', 'odm2', 'ODM', 'odm', 2.0)]

for conn in conns:

pp = pprint.PrettyPrinter(indent=8)

print

print "************************************************"

print "\t\tODM2 -> ODM1 Demo: "

print "************************************************"

print

odm1service = SeriesService(conn)

pp.pprint(conn)

print

print "************************************************"

print "\t\tUnits: get_all_units()"

print "************************************************"

print

pp.pprint(odm1service.get_unit_by_id(321))

print

print "************************************************"

print "\t\tSites: get_all_sites()"

print "************************************************"

print

pp.pprint(odm1service.get_all_sites())

print

print "************************************************"

print "\t\tMethods: get_all_methods()"

print "************************************************"

print

pp.pprint(odm1service.get_method_by_id(8))

print

print "************************************************"

print "\t\tVariables: get_all_variables()"

print "************************************************"

print

pp.pprint(odm1service.get_variable_by_id(10))

print

print "************************************************"

print "\t\tData Sources: get_all_Source()"

print "************************************************"

print

pp.pprint(odm1service.get_all_sources())

print

print "************************************************"

print "\t\tSeries: get_all_series()"

print "************************************************"

print

ser = odm1service.get_all_series()

pp.pprint(ser)

print

print "************************************************"

print "\t\tData Values: get_all_DataValues()"

print "************************************************"

print

pp.pprint(odm1service.get_values_by_series(ser[0].id))

print "The end"