Hi
My app is using SQLAlchemy0.5.6.
I have a class defined as follows.
class EmailSetup(DeclarativeBase):
__tablename__ = 'emailsetup'
id = Column(Unicode(50), primary_key=True)
mail_server=Column(Unicode(255))
description=Column(String(200))
port = Column(Integer)
Hi
I am using SA-oracle for my application.
I need to write an oracle query in which i need to use BITAND
oracle bitwise operator
function.
Is SA provides this functionality?
DECODE(BITAND(task_calendars.day ,day1)))
The SA QUERY is
SELECT task_calendars.cal_id AS
Hi
I am using Oracle with SQLalchemy in my application.
1. The SQLalchemy documentation gives the following as the connect
string for Oracle
sqlalchemy.url=oracle://user:passw...@localhost:1521/
SID_name
2. The above connect string does not seem to work in my
application.
Hi
I am using oracle/mysql and sqlalchemy for a project I am working on.
I have a query executed like this
SELECT table_entity_id, table_entity_type, table_avail_state,
table_monit_state, table_transient_state, table_transient__1,
table_owner, table_timestamp, table_description FROM (SELECT
Hi
I am using oracle/mysql and sqlalchemy for a project I am working on.
I am using lockmode in SA query,while generating an ORACLE query it
causes trouble.
The class definition is like this:
class AvailState(Base):
MONITORING = 1
NOT_MONITORING = 0
__tablename__ = 'avail_current'
package names. sorry about that.)
In mysql same code generates a single select for update query.
in oracle it translates into 3 nested queries.
thnx again
On Wed, May 26, 2010 at 9:53 AM, Michael Bayer mike...@zzzcomputing.comwrote:
On May 26, 2010, at 9:16 AM, dhanil anupurath wrote:
Hi
I
Hi
thanks for the quick reply and pointing me in the right direction.
it seems the error is actually related to the operator.
is there anything SA can do on this issue?
In the meantime i am going to change my query.
thanks again..
--
You received this message because you are subscribed to
Hi
SORRY for the delay to reply.
Here is what my definitions.
These are my class and table definitions:
class Task(DeclarativeBase):
task_id = Column(Integer,Sequence('id_
seq'), primary_key=True)
task_type = Column(Unicode(50), default=to_unicode('Task'))
name =
Hi
task = Task(u'Task',\
{'quiet':False}, [], {}, None, u'admin')
model.DBSession.merge(task)
in my database the following query will try to select the above task
object and result in error
DBSession.query(TaskCalendar).options(eagerload('task')).\
Hi
I am having a trouble with SA-oracle-Blob datatype.
Here I have a test program like this.
import pkg_resources
pkg_resources.require(cx-Oracle=5.0.3)
import cx_Oracle
import sqlalchemy
from sqlalchemy.sql import select
Hi
I am having a trouble with SA-oracle-Blob datatype.
Here I have a test program like this.
import pkg_resources
pkg_resources.require(cx-Oracle=5.0.3)
import cx_Oracle
import sqlalchemy
from sqlalchemy.sql import select
Hi
This is my class definition
class TaskCalendar(DeclarativeBase):
__tablename__ = 'task_calendars1'
cal_id = Column(Integer,Sequence('id_seq'), primary_key=True)
task_id = Column(Integer, ForeignKey('tasks.task_id'))
dow = Column(Integer)
month = Column(Integer)
day =
Hi
I am using sqlalchemy in my TurboGears application.
some of my classes has columns with Pickletype dataType.
these get converted to BLOB dataType in the database.
I was using mySql till recently and everything was working fine.
Now i am shifting to oracle. Tables are getting created properly.
THANK YOU
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group
Hi,
I need help in setting up Oracle under TG/sqlalchemy environment.
I believe the issue is more of a SQLAlchemy issue and that is why i
am posting here.
Here's what i have done.
1.Installed TG2 and Sqlalchemy.
2.Installed Oracle Express 10g.
3.confirmed that I am able
HI
I have been using the oracle database for my appliaction.
i set the environment variables as
export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/
server
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export ORACLE_SID=XE
I started the
Am geting the error for using ORACLE database for MYSQL its fine.
the out put tracebackl is geting as.
Traceback (most recent call last):
File /root/tg2env/bin/paster, line 7, in ?
sys.exit(
File /root/tg2env/lib/python2.4/site-packages/PasteScript-1.7.3-
I am using Sqlalchemy with Oracle backend in my project.
I am running into listener issues with the Oracle database.
Here are the steps that I am following:
1. My connection string.
sqlalchemy.url=oracle://root::password@localhost:1521/orcdb
2. Environment variables .
export
Am using the Oracle database to my project after setu is done i have
an error ...
The tracebacks are the following.
File /root/tg2env/lib/python2.4/site-packages/SQLAlchemy-0.5.6-
py2.4.egg/sqlalchemy/schema.py, line 1796, in create_all
bind.create(self, checkfirst=checkfirst,
SQLPLUS shows no error .
I am able to connect to oracle database.
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to
20 matches
Mail list logo