Tagged Questions
0
votes
2answers
20 views
Do database access generators return new rows that are added while using them?
More specifically, if I iterate through a database using a python db api which emulates a generator giving me one row at a time, will the generator also return new rows that I create in the meantime?
...
3
votes
0answers
14 views
Threading and SQLAlchemy Sessions
I know this question has been asked a few times, but I'm still unsure about the usage of scoped_session with threading. Basically, I have an application with 10 worker threads. I have one Engine with ...
-2
votes
0answers
39 views
What type of database is most well-suited for storing a lot of real-world data acquired via python? [on hold]
I've got a setup that I use to acquire testing data via a serial port (force data, for what it's worth) and a camera. Currently, I am just keeping the data in memory as my tests are only a few minutes ...
0
votes
1answer
28 views
How can I reach one of results from database in Python
I'm trying to get some infos fro database in Python. Im new in it and I, unfortunatelly, wasted a lot of time for that. I expect that my problem is really simple.
I have sth like that to fetch data:
...
0
votes
1answer
23 views
which engine should use for gaming site with heavy traffic and updates and inserrtion [on hold]
Hi. I am developing a gaming site in which there will be a heavy updates and insertion regularly in the database.
Currently i am using the MyISAM engine and the speed of insertion and updates take ...
-2
votes
1answer
37 views
select particular field in python
Hi i need to fetch all rows for particular field from database right now i am using
mygame.objects.all()
which fetches all fields say
x ,y , z and so on
and so on but i need to select ...
2
votes
2answers
45 views
increase insertion speed in python
I have a script in django which i am running on terminal to update the field values in database ,
there is about 3000 records to be updated , it updated but it takes so much time.
Here is the code:
...
-1
votes
1answer
30 views
Inputing values into MySQL from Python
I have 2 questions:
I was trying to input values into a MySQL table, I kept on getting an error when I tried to input date type object in MySQL.
MySQL expects this;
Settlement DATE DEFAULT NULL
...
0
votes
1answer
16 views
MySQL table to Python list of lists using fetchall()
how can I transform this table:
ID ITEM_CODE
--------------------
1 1AB
1 22S
1 1AB
2 67R
2 225
3 YYF
3 1AB
3 ...
-1
votes
1answer
49 views
_mysql_exceptions.ProgrammingError: (1064, “You have an error in your SQ L syntax; right syntax to use near ')' at line 1”)
Python MySQL Statement returning Error
def _conditional_insert(self, tx, item):
tx.execute('select * from table where text1 = %s', (item['text1'], ))
result = tx.fetchone()
if result:
...
0
votes
1answer
22 views
IntegrityError #1062 in django.db.utils - Duplicate entry for key 2
Using Py2.6, FreeTDS to import data from a MSSQL database and drop into MySQL.
I have a table with a unique key that I think needs to be changed. It should not be unique, and is not the id key.
...
0
votes
3answers
27 views
update null field with integer in django Python
HI i have a field in database whose value is null = true but i need to update it timely with the integers .I am running this script on terminal
getW = get_HomeTeam_myworld.w
getL = ...
0
votes
1answer
25 views
importing timestamps + data from mysql to python and plotting time-series
I have a mysql table that I want to access and extract data from. The table is structured as seen here:
| Id | datestamp | timestamp | bloodSugar | carbohydrates | insuline |
| 1 | 2013-08-05 | ...
0
votes
3answers
49 views
Is there a simple method for executing command line statements, in windows, from within python?
I've searched high and low for a simple explanation of how to execute command line, in windows, from within python.
The subprocess package seems to be the answer, but I do not appear to be ...
0
votes
1answer
31 views
From MySQL table to Python list
I have this table in mysql, where I have the occurrences (CNT column) of each ITEM for each distinct ID:
ID ITEM CNT
---------------------
01 093 4
01 129F 2
01 AB56 ...
