def main():
commentcollector.printcomments(fileID)
comments = commentcollector.getcomments(fileID)
# comments_collector_DB.addToDB(comments)
# tu jest problem:
# zawiesza sie przy wykonywaniu polecen z konsoli
print(json.dumps(comments))
import mysql.connector
import sshtunnel
import commentcollector
import json
from datetime import datetime
commentslist = commentcollector.getcomments(
'1IPDyDzqnCR2VQf1liPh-j_5eUEjQmz9ABnFNAYPZ4sI')
text_aaa = "aaaaaaa"
sshtunnel.SSH_TIMEOUT = 5.0
sshtunnel.TUNNEL_TIMEOUT = 5.0
_username = '******'
_password = '******'
_bind_address = 'gcc.mysql.pythonanywhere-services.com'
_bid_port = int(3306)
db_user = '******'
db_password = '******'
db_host = '127.0.0.1'
db_target = 'gcc$google_comments_DB'
with sshtunnel.SSHTunnelForwarder(
('ssh.pythonanywhere.com'),
ssh_username='******',
ssh_password=_password,
remote_bind_address=(_bind_address, _bid_port)) as tunnel:
connection = mysql.connector.connect(
user='******',
password=db_password,
host=db_host,
from __future__ import print_function
import commentcollector
import json
import comments_collector_DB
from flask import Flask
from flask import render_template
app = Flask(__name__)
fileID = '1IPDyDzqnCR2VQf1liPh-j_5eUEjQmz9ABnFNAYPZ4sI'
json_comments = commentcollector.getcomments(fileID)
# comments_collector_DB.addToDB(json_comments)
comments=json.dumps(json_comments)
@app.route('/')
def index() -> str:
return str(comments)
@app.route("/about")
def about():
return render_template("about.html")
@app.route("/sourceselection")
def sourceselection():
return "You went to gcc.pythonanywhere.com/sourceselection"
if __name__ == "__main__":
import mysql.connector
import sshtunnel
import commentcollector
item = commentcollector.getcomments('18qODvBsWxVJyp7G3ui5_77rl53D-NEIPunxWRBa882Q')
sshtunnel.SSH_TIMEOUT = 5.0
sshtunnel.TUNNEL_TIMEOUT = 5.0
_username = '******'
_password = '******'
_bind_address = 'gcc.mysql.pythonanywhere-services.com'
_bid_port = int(3306)
db_user = '******'
db_password = '******'
db_host = '127.0.0.1'
db_target = 'gcc$google_comments_DB'
with sshtunnel.SSHTunnelForwarder(
('ssh.pythonanywhere.com'),
ssh_username='******', ssh_password=_password,
remote_bind_address=(_bind_address, _bid_port)
) as tunnel:
connection = mysql.connector.connect(
user='******', password=db_password,
host=db_host, port=tunnel.local_bind_port,
database=db_target,
)
sql_insert_query = '"INSERT INTO json_test VALUES %s"'