def myregister(self):
print("회원 가입.. ")
db = DbConnect('192.168.0.68', 'orcl', 'scott', 'tiger', '1521')
resultLIst = db.execute(
'select * from emp') # 리턴값이 리스트인 것을 resultList에 담음
for x in resultList:
print(x)
self.parent.close()
def checkDbConnection(self): try: print 'checking db connection.' dbConn = DbConnect() #self.__db__ = DbConnect() if dbConn.connect() == True: self.__db__ = dbConn self.createTMSDevice() except Exception, e: self.__db__ = None print 'Unable to connect to db.. retrying... ' + str(e)
class HttpServer:
app = Flask(__name__)
dbConnection = None
def __init__(self):
self.dbConnection = DbConnect()
def start(self):
"""Starts the HttpServer"""
self.app.run()
@app.route('/')
def get_home(self):
return "The server is up! :D"
@app.route('/api/bill', methods=['POST'])
def get_bill(self):
url = request.args.get('url')
if self.dbConnection.is_bill_exist(url):
billAnalyser = BillAnalyser(url)
bill = billAnalyser.getBillSummary()
self.dbConnection.add_bill(bill)
return jsonify(bill)
def __init__(self , config):
self.dbConfig = config
self.languages = ['java', 'python', 'c#', 'c++', 'php', 'c',
'ruby', 'ruby-on-rails', 'javascript', 'jquery',
'asp.net', 'objective-c','sql', 'xml', 'perl',
'cocoa', 'delphi', 'node.js',
'scala', 'visual-c++']
self.langString = ''
for language in self.languages:
self.langString += "1 as "+ language+", "
self.langString =self.langString[0:len(self.langString)-2]
self.postsFields = "id, AcceptedAnswerId, ParentId, CreationDate, Score, ViewCount, Body, OwnerUserId, OwnerDisplayName, LastEditorUserId, LastEditorDisplayName, LastEditDate, LastActivityDate, Title, Tags, AnswerCount, CommentCount, FavouriteCount, ClosedDate, CommunityOwnedDate"
self.fields = "Tag, PostId, AcceptedAnswerId, ParentId, CreationDate, Score, ViewCount, Body, OwnerUserId, OwnerDisplayName, LastEditorUserId, LastEditorDisplayName, LastEditDate, LastActivityDate, Title, Tags, AnswerCount, CommentCount, FavouriteCount, ClosedDate, CommunityOwnedDate"
self.valStr=""
for field in self.fields.split(","):
self.valStr += "'%s',"
self.valStr = self.valStr[0:len(self.valStr)-2]
self.dbConnect =DbConnect(self.dbConfig)
Session, self.engine = self.dbConnect.openConnection()
self.session = Session()
class DataLoad():
def __init__(self , config):
self.dbConfig = config
self.languages = ['java', 'python', 'c#', 'c++', 'php', 'c',
'ruby', 'ruby-on-rails', 'javascript', 'jquery',
'asp.net', 'objective-c','sql', 'xml', 'perl',
'cocoa', 'delphi', 'node.js',
'scala', 'visual-c++']
self.langString = ''
for language in self.languages:
self.langString += "1 as "+ language+", "
self.langString =self.langString[0:len(self.langString)-2]
self.postsFields = "id, AcceptedAnswerId, ParentId, CreationDate, Score, ViewCount, Body, OwnerUserId, OwnerDisplayName, LastEditorUserId, LastEditorDisplayName, LastEditDate, LastActivityDate, Title, Tags, AnswerCount, CommentCount, FavouriteCount, ClosedDate, CommunityOwnedDate"
self.fields = "Tag, PostId, AcceptedAnswerId, ParentId, CreationDate, Score, ViewCount, Body, OwnerUserId, OwnerDisplayName, LastEditorUserId, LastEditorDisplayName, LastEditDate, LastActivityDate, Title, Tags, AnswerCount, CommentCount, FavouriteCount, ClosedDate, CommunityOwnedDate"
self.valStr=""
for field in self.fields.split(","):
self.valStr += "'%s',"
self.valStr = self.valStr[0:len(self.valStr)-2]
self.dbConnect =DbConnect(self.dbConfig)
Session, self.engine = self.dbConnect.openConnection()
self.session = Session()
#Base.metadata.create_all(self.engine)
def loadData(self, start=0, end=10338371):
i=0;
window = 1000
j=i+window
count = i
keepLoading = True
while keepLoading:
keepLoading=False
#
# self.session.query(Questions).outerjoin(AcceptedAnswers).\
#... filter(Questions.acceptedAnswerId==AcceptedAnswers.id).\
#... all()
for row in self.session.query(Questions)[i:j]:
keepLoading=True
self.insertRow(row)
count +=1
i=j
j=j+window
print "done", count
def insertRow(self, row):
tags = self.processRow(row) # clean tags.
lang = ''
for tag in tags:
if tag in self.languages:
lang = tag
if lang.lower()== 'c#':
lang = 'cSharp'
elif lang.lower()=='c++':
lang = 'cPP'
elif lang.lower() == 'ruby-on-rails':
lang = 'ruby_on_rails'
elif lang.lower() == 'asp.net':
lang = 'asp_dot_net'
elif lang.lower() == 'objective-c':
lang = 'objective_c'
elif lang.lower() == 'node.js':
lang = 'node_dot_js'
elif lang.lower() == 'visual-c++':
lang = 'visual_cPP'
break;
try:
for tag in tags:
self.addTagPost(row, lang=lang, tag=tag)
self.session.commit()
except Exception , e:
print "ERROR: ", sys.exc_info()
self.writeToFile(str(sys.exc_info()))
def __init__(self):
self.dbConnection = DbConnect()
from os import environ
from flask import Flask, jsonify
from BillAnalyser import BillAnalyser
from DbConnect import DbConnect
from flask import request
from flask_cors import CORS, cross_origin
app = Flask(__name__)
cors = CORS(app)
app.config['CORS_HEADERS'] = 'Content-Type'
dbConnection = DbConnect()
@app.route('/api/bill', methods=['GET', 'POST'])
@cross_origin()
def get_bill():
url = request.args.get('url')
if dbConnection.is_bill_exist(url):
billAnalyser = BillAnalyser(url)
bill = billAnalyser.getBillSummary()
dbConnection.add_bill(bill)
return jsonify(dict(bill))
return jsonify({})
@app.route('/')
def get_home():
return "The server is up! :D"
# If Docker crashes try commenting/uncommenting the line below
