Tagged Questions

-1
votes
1answer
73 views

Extracting with Python [closed]

I am currently working on a python program that extracts information from a stock website http://markets.usatoday.com/custom/usatoday-com/html-mktscreener.asp I need to extract all the columns ...
1
vote
2answers
41 views

UnicodeEncodeError and inserting a data into db

I have a Python scraper which scraper a web site and inserts a data into MySql db. All of a sudden I got an error of UnicodeEncodeError: 'latin-1' codec can't encode character u'\u20ac' in position ...
0
votes
1answer
16 views

Passing est datetime to MySql

In MySql db there is column of type DATETIME. I need to select the records by this column -- ones that are less than current est date. I used the code from Python - datetime of a specific timezone to ...
0
votes
1answer
31 views

Inserting double quotes into MySql db

I need to insert a value which contains double quotes into MySql db: import MySQLdb cursor = db.cursor() sql_pattern = 'INSERT INTO Table(column1, column2, column3....) VALUES("{0}".....)' ...
0
votes
2answers
18 views

Python: Single Quotes Showing up in my Database

I'm doing some python programming, inserting data into a MYSQL database for a project. I've been doing the coding, but noticed an odd artifact; Whenever I insert string data, my database includes the ...
-12
votes
0answers
69 views

What is the best python / pyqt forum? [closed]

Stackoverflow is clearly one of the best places to ask programming questions. But, I would like to get and share information on python & pyqt. Specifically, I have created a simple python ...
0
votes
0answers
25 views

MySQLdb undefined - import MySQLdb

So I have this application called Openfreezer. I have followed the instructions perfectly to make their web application work... and it does. But now when I play around with it and it starts calling ...
0
votes
1answer
27 views

Inserting datetime into MySql db

I have a datetime value which is made by strptime function import MySQLdb a = time.strptime('my date', "%b %d %Y %H:%M") There is a column in MySql db of type DATETIME. When I try to insert this ...
0
votes
1answer
40 views

How to use regx in django query

In the database image names are saved in the below format. +------------+------------+------------+-----------+ | adv_images | start_date | end_date | id | ...
0
votes
1answer
31 views

Insert dictionary keys values into a MySQL database

I have executed this code to insert a dictionary into my table in database, d = {'err': '0', 'tst': '0', 'Type o': 'FTP', 'recip': 'ADMIN', 'id': '101', 'origin': 'REPORT', 'Type recip': 'SMTP', ...
0
votes
2answers
29 views

Possible MySQL authentication issue with python package (PyMySQL3)

I actually found a blog post that pretty much sums up my problem. Its at http://simon04.net/2013/03/python3-mysql/ The blog post is the most clear but to summarize: I'm currently trying to access a ...
0
votes
0answers
36 views

SQLAlchemy error MySQL server has gone away

Error OperationalError: (OperationalError) (2006, 'MySQL server has gone away') i'm already received this error when i coded project on Flask, but i cant understand why i get this error. I have code ...
8
votes
5answers
689 views
+500

Can't connect to local MySQL server through socket '/tmp/mysql.sock

When I attempted to connect to a local MySQL server during my test suite, it fails with the error: OperationalError: (2002, "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)") ...
0
votes
0answers
9 views

Select/Update/Insert on TastyPie Bulk (PATCH) Request Based on Index?

Can I tell TastyPie to (in order) SELECT, UPDATE or INSERT a resource entry during a bulk (PATCH) insert? The trick to the question is the UPDATE portion. By default TastyPie will SELECT an ...
-3
votes
1answer
44 views

I have a PYTHON code that i want it to run after, lets say, every 30 min? [closed]

Want to run code for python every 30 min. any implementation inside the code or enter data into mysql database from python code every 30min

1 2 3 4 5 … 158
15 30 50 per page