PythonHelpers/TableToInsertSP.py at main · jaycewhite/PythonHelpers · GitHub

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
import re
from HelperFuncs import *
lines = parseTableToLines()

for line in lines:
    outputStr = '   @'
    result = re.search('\\[(.*)\\]',line)
    split = line.split()
    if result:
        name = result.group(1)
    else:
        name = split[0]
    outputStr += name + ' '
    typeStr = split[1].upper()

    if '(' in typeStr:
        resultType = re.search('\([^\)]+\)', line)
        if resultType:
            typeSplit = typeStr.split('(')
            typeStr = typeSplit[0] + resultType.group(0)
    outputStr += typeStr

    if 'null' in split[2].lower():
        outputStr += ' = NULL'

    outputStr += ','

    print(outputStr)

input("Enter to for assignments")

for line in lines:
    outputStr = '   '
    result = re.search('\\[(.*)\\]',line)
    split = line.split()
    if result:
        name = result.group(1)
    else:
        name = split[0]
    outputStr += name + ' = @' + name + ','
    print(outputStr)

input("Enter for value pairs")

print('(')
for line in lines:
    outputStr = '   ['
    result = re.search('\\[(.*)\\]',line)
    split = line.split()
    if result:
        name = result.group(1)
    else:
        name = split[0]
    outputStr += name + '],'
    print(outputStr)
print(')')

print('VALUES')
print('(')

for line in lines:
    outputStr = '   @'
    result = re.search('\\[(.*)\\]',line)
    split = line.split()
    if result:
        name = result.group(1)
    else:
        name = split[0]
    outputStr += name + ','
    print(outputStr)
print(')')
input("Enter to close")