[sqlalchemy] Calling sqlalchemy.func on column

Hi all, I have Sqlite table from which I can execute HEX to convert value to HEX. CREATE TABLE hosts( name TEXT, mac INTEGER, ipv4 INTEGER, } Running query "select HEX(mac) from hosts" give me address in HEX format. Now I am using Sqlalchemy.orm to read the

[sqlalchemy] Re: mysql, use password from my.cnf file

Hi , Iam trying to use from sqlalchemy.engine.url import URL myDB = URL(drivername='mysql', host='localhost', database='my_database_name', query={ 'read_default_file' : '/path/to/.my.cnf' } ) engine = create_engine(name_or_url= myDB) but it is not working form me. The error I am

[sqlalchemy] using sqlalchemy to track changes in database

Hi All, Can any body help me how Sqlalchemy can be used to identify changes in database? I mean how to identify that some rows got delete or added after particular time.? Thanks Balaji -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To

[sqlalchemy] identifying changes in database

Hi , I am new to the database world. I need to provide mechanism so that cache can check that what is changed in database. Now for per table basis I need to add something so that I can track what changed. Adding timestamp column to table I can check what is created and updated but for it

[sqlalchemy] In ORM relationship list don't get refreshed even after refreshing

Hi all, I am using simple SQLALCHEMY implementation. I have two classes Svc, Mani class Svc(Base): ''' class to map 'service' table in database ''' __tablename__ = 'svc' __table_args__ = {'autoload': True} manis = relationship('Mani') What I found that upon