for all your work. Congrats on the book(s)!
Steve
On Jul 18, 1:45 pm, Michael Bayer [EMAIL PROTECTED] wrote:
On Jul 18, 2008, at 1:32 PM, shday wrote:
I upgraded from 0.4.3 to 0.4.6 and now I get the error below when
starting my TurboGears app. I'm using reflection and that fails
I upgraded from 0.4.3 to 0.4.6 and now I get the error below when
starting my TurboGears app. I'm using reflection and that fails on the
first table. I had a look at the changelog and tried adding
oracle_resolve_synonyms=True to that table's definition but I got
another error (not shown here).
try:
easy_install --upgrade SQLAlchemy
No need to uninstall.
http://peak.telecommunity.com/DevCenter/EasyInstall#upgrading-a-package
On Feb 15, 7:39 pm, maxi [EMAIL PROTECTED] wrote:
Great Job !!!
How can I upgrade from 0.4.2p3 ? (Or I have to uninstall all previous
version?)
Regards.
Is there any way to use reflection with a read only connection?
I use reflection on an Oracle database with read only permission, no
problems (using SA 0.3.8).
I don't recall seeing SA trying to do a ROLLBACK during reflection
though.
Steve
Forgive the dumb question, but what is the proper SQLAlchemy
recommended way to deal with a situation like this.
Should I see if the object already exists first, or be lazy and try to
write to the database and attempt to catch the exception.
Good question. Personally I think that this
I am getting a new error when using r2607. When I switch back to 3.6
there is no error.
Here is the stack trace:
Page handler: bound method StudyRequestController.default of
srt.controllers.StudyRequestController instance at 0x015D6620
Traceback (most recent call last):
File
be truncated.
On May 7, 2007, at 3:09 PM, shday wrote:
The table is reflected here:
study_request_table = Table('study_request',metadata,
Column('study_request_id',Numeric(precision=6,length=0),
Sequence('study_request_seq'),primary_key=True,nullable=False
No count() anywhere.
On May 7, 3:17 pm, Michael Bayer [EMAIL PROTECTED] wrote:
also is there a count() stuck in there somewhere ? the
tbl_row_count identifier only comes into play when theres count().
On May 7, 2007, at 3:09 PM, shday wrote:
The table is reflected here
I'm getting this error even though I have convert_unicode = True and
the proper NLS_LANG setting:
SQLError: (NotSupportedError) Variable_TypeByValue(): unhandled data
type unicode 'DELETE FROM model_acc_protocol WHERE
model_acc_protocol.model_id = :model_id AND
model_acc_protocol.acc_protocol_id
:04 pm, Michael Bayer [EMAIL PROTECTED] wrote:
On May 3, 2007, at 11:25 AM, shday wrote:
I'm getting this error even though I have convert_unicode = True and
the proper NLS_LANG setting:
SQLError: (NotSupportedError) Variable_TypeByValue(): unhandled data
type unicode 'DELETE FROM
I upgraded to 0.3.6 from 0.3.5 and one of my querys stopped working:
s =
model_table.select(~(model_table.c.therapeutic_area.in_('Respiratory','Diabetes',
'Inflammation','CVD')),
order_by=[model_table.c.model_acronym])
All my other query still work fine.
['model_acronym'] + -
+row['model_name'])[:80]) for row in rs.fetchall()]
On Mar 27, 10:29 am, shday [EMAIL PROTECTED] wrote:
I upgraded to 0.3.6 from 0.3.5 and one of my querys stopped working:
s =
model_table.select(~(model_table.c.therapeutic_area.in_('Respiratory','DiabĀetes',
'Inflammation
tripping up.
On Mar 27, 2007, at 10:35 AM, shday wrote:
Here is the surrounding code:
def model_list(therapeutic_area='All'):
if therapeutic_area == 'All':
s = model_table.select(order_by=[model_table.c.model_acronym])
elif therapeutic_area == 'Other':
s
Okay, I changed the NLS_LANG setting on the oracle client to match
that of the server, and now it works. I found out about it here:
http://www.theserverside.com/discussions/thread.tss?thread_id=14634
On Mar 27, 1:27 pm, shday [EMAIL PROTECTED] wrote:
Hi,
The table is reflected, with one
Foreign key relations *are* reflected. That information is used when
you set-up 'properties'. Notice that you don't have to specify any
keys when you define properties.
SA just doesn't do the 'properties' automatically (by design I think).
Steve
On Feb 16, 12:14 pm, Andreas Jung [EMAIL
PROTECTED] wrote:
im guessing its a value of None that I forgot to check for. try rev.
2321. also you will definitely need to use the trunk for BLOBs in
oracle since the PrefetchingResultProxy fix is only in the trunk.
On Feb 14, 2:02 pm, shday [EMAIL PROTECTED] wrote:
I've been using an Oracle
With rev. 2321 of oracle.py I'm getting the error below when I do the
following:
sr =
session.query(StudyRequest).selectfirst(study_request_table.c.study_request_id
== request_id)
With 3.4 I don't get and error.
Note that I'm only using oracle.py from the trunk, everything else is
3.4
I've been using an Oracle database and reflection (i.e.,
autoload=True). I recently added a BLOB column to the database. I
never did any modification to the Python application code yet. The
application was made using Turbogears and it just serves two forms,
one for inserting records and one for
I still get the error:
Traceback (most recent call last):
File U:/ADA_tools/pickle_tables.py, line 27, in ?
pickle.dump(metadata_to_pickle,pfile)
File C:\Python24\lib\pickle.py, line 1382, in dump
Pickler(file, protocol, bin).dump(obj)
File C:\Python24\lib\pickle.py, line 231, in
whoops...
I've been using IDLE to test this and I guess it has to be reopened in
order for imports to be redone (I was just closing the shell window).
pickle.dump(metadata) works fine now.
But now I get a (recursive?) error when I try to unpickle (and I have
to kill the shell):
import pickle
20 matches
Mail list logo