Tagged Questions
1
vote
0answers
24 views
Inherited Methods How do I make super methods available?
I have a class (which works [or appears to]) to run an sql query. Code is below. If I inherit from object and do not use super, it works fine.
I am learning about inserting methods from super classes ...
0
votes
0answers
42 views
I am unable to compare stock prices scraped from web and stored in mysql database
I want to see the difference between stock prices scraped from AAPL.htm page and
stock data base stored in MySQL.
I am able to get the scraped data from html file in get_price function, and I am ...
-1
votes
1answer
77 views
MariaDB dynamically adding columns to existing table
I have a python scrypt that looks for data from the web. Sometimes this can create the need for new tables to be added to an existing table. I'm using pymysql and I've tried some examples found online ...
1
vote
0answers
72 views
How to properly stay connected to MySQL database using pymysql with Tweepy Streaming API?
I'm using Tweepy's Streaming API to listen to tweets for an upcoming event. There are keywords specified to listen to and write to my database hosted on a server(gearhost).
However, when there are no ...
0
votes
0answers
17 views
mysqld clogging up memory: Ubuntu
We have some python programs scheduled and run by airflow that talks to mysql server in another node. We tunnel to the mysql server and connect to it with pymsql library(Python3.6).
Over a period of ...
0
votes
0answers
79 views
How to handle the Loss connection error and BaseSSHTunnelForwarderError: Could not establish session to SSH gateway
This is my code shown below that i use to connect to the database and get some tables. I have used this for a while without problem but recently I keep on getting this two errors after it runs for a ...
0
votes
1answer
397 views
Python/MySQL: “Truncated incorrect double value…” on a simple text insert
I've got a problem with a presumably simple text insert into a MySQL database from Python. The text is a HTML string, with which I want to update an existing row based on this rows primary key. I'm ...
2
votes
1answer
390 views
how to configure django with mysql using pymysql (python 3.5)
having much trouble getting mysql(5.6) to connect with django (1.11) using python 3.5.2 in ubuntu(16.04) venv. im trying to use pymysql because it works great with flask applications, just not django ...
0
votes
0answers
307 views
Python SqlAlchemy | Error On Create Table
I'm a beginner of "Python with SqlAlchemy".
I try the following to create the table in "MySQL" Database.
My Code is :
import pandas as pd
from sqlalchemy import create_engine
from sqlalchemy ...
0
votes
1answer
182 views
use multiprocessing to query in same mysqldb connnect , block?
abort MySQLdb.
I know many process not use same connect, Because this will be a problem .
BUT, run the under code , mysql request is block , then many process start to query sql at the same time , ...
1
vote
1answer
158 views
Selenium search data from a table element
I m trying to find and fill form with Selenium but I have to select id from a mysql table. There is no problem to fetchone item with mysql. The problem is when I add variable to selenium code, it ...
1
vote
1answer
1k views
Use Python list in SQL query for column names
I have a bunch of column names in a Python list. Now I need to use that list as the column names in a SELECT statement. How can I do that?
pythonlist = ['one', 'two', 'three']
SELECT pythonlist FROM ...
0
votes
0answers
88 views
Python setuptools: How to define installation time conditional dependencies for dist package?
I make dist packeges of my module, which depends on MySQL-python. I realized, that some users don't have MySQL installed, and therefore it's easier for them to install pymysql (python based client) as ...
7
votes
1answer
6k views
Mock a MySQL database in Python
I use Python 3.4 from the Anaconda distribution. Within this distribution, I found the pymysql library to connect to an existing MySQL database, which is located on another computer.
import pymysql
...
1
vote
2answers
433 views
Celery, Django and PyMySQL
I have a django application hooked to a MySQL database, which uses PyMySQL rather than MySQLdb. See the popular answer on this question for more details on that.
Now, it is necessary for me to create ...
3
votes
1answer
848 views
Proper way to use PyMySql in a memory efficient generator
I want to write a generator function that will run on a memory limited system that uses PyMySql (or MySQLDb) to return the results of a select query one at a time. The following works:
#execute a ...
5
votes
3answers
13k views
Installing PyMySQL on a Windows 7 machine
I am not a python user and though I have used MySQL, I'm not an expert. Also, I'm mainly a Windows user and I don't know much about running command line scripts. So this might be a stupid question ...
0
votes
0answers
518 views
mysql play crazy with pymysql
I've something very strage with mysql 5.5, python 2.7, pymysql, os x 10.6.8
I've a mysql table id, name, fuzzy. I've generated a python list like
cursor.execute('select id, SOUNDEX(name) from ...
33
votes
4answers
35k views
What is PyMySQL and how does it differ from MySQLdb? Can it affect Django deployment?
I just solved some problems in my Django 1.3 app by using PyMySQL instead of MySQLdb. I followed this tutorial on how to make the switch: http://web-eng-help.blogspot.com/2010/09/install-mysql-5-for-...
