Tagged Questions
0
votes
1answer
11 views
django MySQLdb not syncing
Running syncdb, following tutorial at http://www.youtube.com/watch?v=srHZoj3ASmk
Not sure what this error means and googling it seems to not produce anything useful.
...
1
vote
0answers
12 views
MySQL (mariaDB) Connection Error with SqlAlchemy
Hello I have a mariaDB database on a Ubuntu server running in a virtual box.
With 'Sequal Pro' i can connect without any problems (with the ssh option).
Port forwarding like this: HOST 127.0.0.1 3306 ...
1
vote
1answer
25 views
Twisted - Using a Deferred for another sql query
I've got a twisted based network application. Now I would like to implement a new database design but I''m getting stuck with the Deferred object.
I write sessions into my database by using this two ...
1
vote
2answers
25 views
Writing Data into MySQL Table with Python
I am trying to output data into a MySQL Database.
I can create the database and connect to it (after a lot of problems).
Now I want to write Data into the database. I use the following Code:
...
0
votes
1answer
35 views
Database for NLP project [closed]
Can someone advise on what database is better for storing textual information such as part of speech sequences, dependencies, sentences used in NLP project written in python. Now this information is ...
-2
votes
0answers
29 views
updating all rows in a mysql table using function [closed]
I have a mysql table with approximately 1 million rows
i want to update every row of a column with a value that is the output of a python function which uses data from one of the other columns in the ...
1
vote
3answers
35 views
What are the options for storing Python long integers in MySQL?
I need to represent instances of Python "Long integer" in MySQL. I wonder what the most appropriate SQL data type I should use.
The Python documentation (v2.7) says (for numbers.Integral):
Long ...
0
votes
3answers
46 views
Using Python to insert in MySQL database, but gets stuck on commas in data
The Python code I have looks like this
f = open('data.tsv', 'r')
for line in f:
a = line.split("\t")
e_id = a[1]
name = a[2]
start = a[3]
end = a[4]
loc = a[5]
tags = ...
0
votes
0answers
18 views
Alembic detects changes but produces empty migration with --autogenerate
I'm trying to get alembic working auto-producing migrations with the --autogenerate flag.
When I run alembic -n mydbname --autogenerate -m "my message" I get something like:
INFO ...
0
votes
1answer
24 views
Openshift django-mysql database contains no table?
on localhost django automatically creates some table in the database, how to do the same on openshift server, I have even alter deploy script, even then it creates no table in the database.
0
votes
1answer
35 views
Python MySQL Update taking 10-12 seconds to update about 1000 records
I have something along the lines of:
while True:
variables are set - Each loop the variables are different.
sql = sql statement with above variables
send sql to MySQL server
I am able ...
3
votes
1answer
22 views
how can i ensure innodb thread safety
I have an InnoDB table which lists a bunch of files which need to be processed.
The python script which handles the processing basically does this:
get next file which has status = 'unprocessed'
...
0
votes
1answer
31 views
MySQL dymanic query in Python
Can anyone tell me the proper way in which I can execute dynamic MySQL queries in Python?
I want to do dynamic queries for both CREATE and INSERT statement. I have referred another post here:
MySQL ...
0
votes
1answer
15 views
Trouble with ERROR 1146 in MySQL
So I'm doing a basic MySQL tutorial using Python and I first used the following code to create a simple database.
import MySQLdb as mdb
con = mdb.connect('localhost', 'testuser', 'test623', ...
0
votes
1answer
41 views
Remote query in MySQL using python
How can I query a remote MySQL database, write a select query and insert into my local mysql database using python?
