Tagged Questions
4
votes
4answers
7k views
django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module: No module named MySQLdb
The problem Im facing while trying to connect to database for mysql. I have also given the database settings that i have used.
Traceback (most recent call last):
File "manage.py", line 10, in ...
4
votes
4answers
2k views
Django's syncdb fails with MySQL errno: 150
First off, here's my current setup:
Django : version 1.3
MySQL : version 4.0.18 (not my 1st choice...)
When I run syncdb, I get the following error:
Creating tables ...
Creating table ...
4
votes
7answers
3k views
How to convert SQL Query result to PANDAS Data Structure?
Any help on this problem will be greatly appreciated. So basically I want to run a query to my SQL database and store the returned data as Pandas data structure. I have attached code for query. I am ...
-5
votes
1answer
24 views
Python read from txt and save into mysql
I need some help with my weather station. I would like to save all results into mysql database, but at the moment i've got all results in txt files.
Can you help me to write a script in python, to ...
15
votes
8answers
15k views
MySQL-db lib for Python 3.x?
So, looking for a mysql-db-lib that is compatible with py3k/py3.0/py3000, any ideas? Google turned up nothing.
0
votes
1answer
20 views
Import CSV and create Temp Table to store results
So, I've imported a CSV file, which could have any number of columns and rows. I'd like to store the results in a temporary Table, eg: "TEMP_30f3724fc226e058" instead of working off the CSV file ...
1
vote
2answers
34 views
Poor MySQL performance on EC2 Micro instance
I have one small webapp, which uses Pyhon/Flask and a MySQL db for storage of data. I have a studentsdatabase, which has around 3 thousand rows. When trying to load that page, the loading takes very ...
0
votes
0answers
15 views
How do I write customized emails to users in my MySQL table? [on hold]
What I need to do:
As new users are inserted to the table, I'd like to send them a welcome email. I'd also like to be able to send particular emails to users that match a specific query. The email ...
1
vote
1answer
24 views
Python character formatting with mySQL raw db query giving me problems
I'm having a problem with trying to install a search function on my web application. The problem is with the following code. I've tried the following two queries but python gives me an error that I ...
-2
votes
1answer
21 views
Python MySQL won't work
I installed python mysqldb with command: apt-get install python-mysqldb, everything was fine but I cannot open any python script with:
import mysqldb
I still get information:
ImportError: No ...
1
vote
1answer
29 views
Order_by in sqlalchemy with outer join
I have the following sqlalchemy queries:
score = Scores.query.group_by(Scores.email).order_by(Scores.date).subquery()
students = db.session.query(Students, ...
0
votes
1answer
27 views
django - count new occurrence of value in columns [on hold]
I have a table in mysql, here is the columns
CallDate|caller-id|duration|time billed|dst
I want to count the number of just new caller-id in system between dates,
i make use django ORM and i dont ...
0
votes
1answer
31 views
How mysql is ordering textual data?
This is the query result from some dataset of articles ordered by article title ascending with limit 10 in MySQL. Encoding is set to utf8_unicode_ci.
'GTA 5' Sells $800 Million In One Day
'Infinity ...
0
votes
3answers
43 views
Django + MySQL + Ubuntu = Error
I connect the MySQL database to the project by Django. In the settings.py file, I prescribe the following:
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': ...
-2
votes
0answers
25 views
Which Python Framework and ORM for REST API and Facebook Integration? [on hold]
I will be designing a REST based API for a cross-platform back end that will serve both desktop Facebook users as well as mobile users. It will handle operations such as user creation, retrieval of ...
facebook