reaperes / chok Goto Github PK

Tweepy 를 사용하면 해당 tweet 의 Geo 정보를 가져올 수 있다. 이게 어떤 의미를 뜻하는지 알기 어렵다. 찾아보자.

Github 마스터에 푸시하면 바로 서버로도 배포되게 CI 적용하자.
Jenkins, Travis CI, Drone 정도의 3가지 솔루션이 있음.

코드에 산재 되어 있는 거 같음;;

Firewall 을 설정해 해킹에 대비한다.

• function 으로 묶어서 인풋/아웃풋 값 조정하기

code 에 너무 떡하니 보임? ㅋㅋ

Rate limit exceeded

Traceback (most recent call last):
File "test.py", line 37, in
cur.execute("INSERT INTO test_data VALUES ('%s', '%s')" % (meal, tweet.text))
File "/usr/local/lib/python3.4/dist-packages/pymysql/cursors.py", line 134, in execute
result = self._query(query)
File "/usr/local/lib/python3.4/dist-packages/pymysql/cursors.py", line 282, in _query
conn.query(q)
File "/usr/local/lib/python3.4/dist-packages/pymysql/connections.py", line 768, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python3.4/dist-packages/pymysql/connections.py", line 929, in _read_query_result
result.read()
File "/usr/local/lib/python3.4/dist-packages/pymysql/connections.py", line 1125, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python3.4/dist-packages/pymysql/connections.py", line 893, in _read_packet
packet.check_error()
File "/usr/local/lib/python3.4/dist-packages/pymysql/connections.py", line 369, in check_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python3.4/dist-packages/pymysql/err.py", line 120, in raise_mysql_exception
_check_mysql_exception(errinfo)
File "/usr/local/lib/python3.4/dist-packages/pymysql/err.py", line 112, in _check_mysql_exception
raise errorclass(errno, errorvalue)
pymysql.err.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'm at 꼴통치킨 in 서울특별시 https://t.co/B4nSiXe7V0')' at line 1")