Tagged Questions

0
votes
1answer
13 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
24 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
14 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
62 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
24 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
26 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
38 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
30 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
1answer
23 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
33 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
2answers
604 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
7 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
0
votes
1answer
25 views

Issues with DB connections in Flask Framework

I am new to flask framework and I have just created app in it but now i am struggling with DB connections in flask. I want to connect my app with MySQL. For that I have follow this link ...
1
vote
0answers
26 views

Django with MySQL: DatabaseError (1406, “Data too long for column 'name' at row 1”)

I have a Django webapp, currently been testing with SQLite but now want to deploy and use MySQL, and I'm getting this error. I am getting this error right when using python manage.py syncdb: You ...

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