Tagged Questions
0
votes
1answer
16 views
How to store python dictionary in to mysql DB through python
I am trying to store the the following dictionary in to mysql DB by converting the dictionary in to string and then trying to insert but I am getting following error.How to solve this or is any other ...
-1
votes
0answers
15 views
how to extract where part in sql using re in python?
Here is the scenario:
I want to retrieve the where part accurately in a SQL using python. For sql like this:
str = """
select "where" , count(*) as cnt from cdo_oplog
where pt < '#{end_time}' ...
0
votes
0answers
11 views
PyMySQL install permission denied
I have Python 2.7, Mysql 5.6 and Mac OSX 10.9, which are all running fine on their own.
I am just wanting to allow python to access my mysql tables (and I am very new at this, so be gentle).
I am ...
0
votes
1answer
27 views
What is wrong with my MySQLdb module for python?
I have installed MySQL for python, but am not quite sure if it worked. I went on python and typed:
import MySQLdb
and the error displayed was:
>>> import MySQLdb
Traceback (most recent ...
0
votes
0answers
9 views
Does MySQLdb Cursors not support empty iterator?
cur.executemany(sql, rows)
I have rows as empty iterator, it triggers an error.
If I do cur.executemany(sql, list(rows)) then it works fine.
File ...
0
votes
0answers
18 views
Doesnt print result of mysql query using Python 2.7
I have a query that looks like this, there are some instances that it will print just fine and sometimes it will not. I optimized my mysql server because sometimes a warning occurs: "Mysql got away, ...
0
votes
1answer
27 views
Python: Converting MySQL datetime to datetime for format
Bit of a newbie here.
I have a program which takes results from a MySQL database.
It picks out the fields Id and ship_date, the query searches only for returned records based on a given Id.
The ...
0
votes
1answer
22 views
Import of .csv file from linux to windows MYSQl
I need a shell script that must import latest ".csv" file into mysql...
My case is--->i need to import the latest ".csv" file from linux to windows mysql i.e my ".csv" files will be stored in a path ...
1
vote
0answers
35 views
MySQL - Execute stored procedure asynchronously
Question
How can I execute a stored procedure in MySQL, asynchronously? I want to be able to call my procedure and have it silently run in the background, without the caller having to wait for it to ...
0
votes
0answers
33 views
Python peewee insert multiple records into multiple tables at once
Overview
I have a relational MySQL InnoDB database. I currently have code in place to add data to my database, using the peewee ORM in Python 2.6.6. The problem is that because of all of my foreign ...
-2
votes
1answer
26 views
Error “indefined reference to” while compiling MYSQL Program
Im trying to compile my program that uses MYSQL Library.
These are my includes:
#include <stdio.h>
#include <string.h>
#include <stdlib.h>
#include <time.h>
#include ...
1
vote
2answers
27 views
How to convert list of nested dictionaries into string and vice versa
I need to store a list of nested dictionaries in MySQL. The only way I see is to convert it to the string and store it in a TEXT field. The challenge is how to convert it back from string?
for ...
-1
votes
1answer
23 views
Python BeautifulSoup Empty Rows in CSV File
I am working on a scraper to pull street names and zip codes from a site and all of that is working great and it builds a CSV file just fine for me. But when I open the CSV file in Excel the file will ...
2
votes
0answers
25 views
Explicit Master-Master DB setup with Flask and SQLAlchemy, hopefully with Flask-SQLAlchemy
I want to use an explicit master-master DB setup together with Flask and SQLAlchemy, hopefully this is supported with Flask-SQLAlchemy.
I want to be able to do something like the following code ...
0
votes
1answer
29 views
python 3.x no module named sqlalchemy after installation
I'm trying to install sqlalchemy to interact with mysql database for my python 3.x with ubuntu 12.04, but then when I import the sqlalchemy it says no module named sqlalchemy. This is what i did with ...
