Tagged Questions
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 ...
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
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 ...
-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 ...
-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 ...
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
2
votes
1answer
24 views
syncdb doesn't create tables for nested models
I have a Django project with models of the following structure:
my_model/
├── __init__.py
├── models/
├── __init__.py
├── my_model.py
├── my_other_model.py
my_model.py and ...
0
votes
1answer
16 views
change CLIENT_FOUND_ROWS flag in django for mysql-python (MySQLdb)?
I have a problem with MySQL 5.5 INSERT ... ON DUPLICATE KEY UPDATE rows effected mismatch cursor.rowcount in a normal Django project
According to doc:
For INSERT ... ON DUPLICATE KEY UPDATE ...
0
votes
1answer
24 views
Data loaded to MySQL via python disappears
I've looked around to see whether anyone had this problem but looks like not! Basically my problem is as follows:
I try loading data into MYSQL db using the MySQLdb library for python
I seem to ...
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
29 views
Remove CSV formula values during mysql load data infile import
So I'm trying import a .csv file directly into mysql using load data local infile command but I'm running into fields that are remnants an excel formula field and I don't know how to get rid of them. ...
1
vote
0answers
40 views
OperationalError: MySQL Connection not available
I'm using Flask-SQLAlchemy 1.0, Flask 0.10, SQLAlchemy 0.8.2, and Python 2.7.5. I'm connecting to MySQL 5.6 with Oracle's MySQL Connector/Python 1.0.12.
When I restart my web server (either ...
