[sqlalchemy] is it possible to implement this anti-pattern in SQLAlchemy?

2020-05-15 Thread Jonathan Vanasco
I have two classes where one f-keys onto another. Things work perfectly: class Foo(Base): id = Column(Integer, primary_key=True) bar_id = Column(Integer, ForeignKey("bar.id"), nullable=True) bar = relationship( "bar", primaryjoin="Foo.bar_id==Bar.id",

Re: [sqlalchemy] hiding/encrypting the Oracle database connection information?

2020-05-15 Thread Jonathan Vanasco
There are two related concerns on this concept: * protecting your credentials in source code * protecting your credentials on the server For the first concern, I like to use encryption management tools like Blackbox (https://github.com/StackExchange/blackbox) With an encryption management

Re: [sqlalchemy] hiding/encrypting the Oracle database connection information?

2020-05-15 Thread Mike Bayer
that issue is unfortunately one of the great mythological stories of business application development, how to configure an application such that the database credentials are not present in a config file where they can be viewed. the scope of that issue is way outside of SQLAlchemy and

Re: [sqlalchemy] test_types.py

2020-05-15 Thread Mike Bayer
test/sql/test_types.py is part of SQLAlchemy's internal testing for the "types" system. The testing/suite/test_types.py suite is part of SQLAlchemy's exported third party dialect test system which is described at https://github.com/sqlalchemy/sqlalchemy/blob/master/README.dialects.rst . if

[sqlalchemy] hiding/encrypting the Oracle database connection information?

2020-05-15 Thread Terrence-Monroe: Brannon
Hello, what is the recommended way to encrypt/hide the connection information that SA will use to connect to an Oracle database? Related gitter discussion - https://gitter.im/sqlalchemy/community?at=5ebec23f20d9bf305768a247 -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper

[sqlalchemy] test_types.py

2020-05-15 Thread Yeongseon Choe
Hi, When I took over a sqlalchemy, I'm little bit confused about test_types.py It looks likes there are 2 test_types.py in the repository. - sqlalchemy/test/sql/test_types.py / - sqlalchemy/lib/sqlalchemy/testing/suite/test_types.py Could you please explain the difference between these files.