Tagged Questions
1
vote
1answer
27 views
Python and MySql - can't get geometry object
Well, I have a python programm which parses files. The data in these files looks like this:
Type=0x21
Label=2428
Data1=(54.67346,59.00001),(54.67415,59.00242),(54.67758,59.00001)
This is my ...
0
votes
1answer
25 views
ImportError: No module named MySQLdb - Debian 6.0
I got a problem in Python while try to import mysql. The beginning of my code is (I'm using monkeyrunner to run script) :
#!/usr/bin/env python
import sys
import MySQLdb
.
.
.
etc
Each time I ...
0
votes
1answer
26 views
Python MySQLdb query returns error when quotes added to the arguments
I am running the following code, which gives me an error
import MySQLdb as mdb
source_sentence = "%Barack Obama%"
filterquery = ""
try:
con = mdb.connect(MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, ...
-2
votes
2answers
29 views
Comparing a python date variable with timestamp from select query
I want to take some action based on comparing two dates. Date 1 is stored in a python variable. Date 2 is retrieved from the database in the select statement. For example I want to retrieve some ...
-1
votes
0answers
42 views
Python-devel for python 2.7 on CentOS
Ok, i want to run django web-application on production VPS. Operation system of the VPS is CentOS. Application code written on Python 2.7. I have already installed Python 2.7 with configured virtual ...
0
votes
0answers
17 views
python import mysqldb error:undefined symbol: __pure_virtual
The same error occurs on both suse linux and ubuntu linux.Just like below:
Python 2.6.8 (unknown, Apr 11 2013, 04:19:30)
[GCC 4.1.2 20070115 (SUSE Linux)] on linux2
Type "help", "copyright", ...
0
votes
2answers
42 views
Reading a delimited text file in python
I have a txt file with many mysql inserts (1.5 million).
I need to read this file with python and divide this file at each ';' for each query and run the query with python. How can I divide this file ...
1
vote
1answer
23 views
Python write to MySQL - no error but no writing
I am trying to write into my localhost MySQL database.
I have created a database named "test", a table called "price_update" and a row called "model"
When I run the script below I get no errors, ...
0
votes
1answer
9 views
Cannot display MySQL latin2_croation_ci characters in Python script
I am trying to apply MySQL records in a Python script. The fields I am concerned with use latin2_croatian_ci collation characters. When I try to print out the following characters,
Karadžić
...
0
votes
1answer
30 views
Python: QSqlDatabase: QMYSQL driver not loaded
I am running python 2.7.3 (python-2.7.3.amd64.msi) from http://www.python.org/getit/
I am using these installers from: http://www.lfd.uci.edu/~gohlke/pythonlibs/
PyQt-Py2.7-x64-gpl-4.9.6-1.exe
...
1
vote
2answers
40 views
Speeding Up CSV Update/Import Into Django Model
I have a large CSV file that I am importing into Django. At the moment, if my math is correct, it will be done in 32 hours! Is it possible to speed this up?
I have a CSV file with ~157,000 rows and ...
0
votes
0answers
38 views
Python log analysis tool/library
I'm looking for a tool/library written in python similar with logstash (ruby + java).
My goals are:
parse all system logs from syslog
parse application specific logs (apache, django, mysql etc.)
...
0
votes
1answer
44 views
password error connecting to mysql database with python 3.3.1
i'm a newbie to python, trying to learn some stuff by writing server scripts which connect to our mysql databases and do some stuff. i have python 3.3.1, and mysql 5.0.96 (community). i installed the ...
0
votes
1answer
23 views
InvalidRequestError: Ambiguous column name '***' in result set, while the request is valid to mysqldb?
My code as following:
s = DBSession()
r = s.query(Food, FoodCategory).filter(Food.category_id == FoodCategory.id).first()
This query raise the exception:
sqlalchemy.exc.InvalidRequestError: ...
0
votes
0answers
25 views
Python MySQLdb MyIsam Waiting for table metadata lock
I'm using 1.2.2 MySQLdb with Python 2.6.6 and MariaDB 5.5.30 on Debian Squeezy.
All tables is using MyIsam engine.
My code is writing some data into temporary table, then inserting it into permanent ...
