I am connecting to a MySQL db using sqlalchemy and TLS 1.2 is enforced
server side. I connect by setting my URI to the correct connection string
and adding the ?ssl=true flag at the end. However I am getting an error
that the TLS version does not meet the minimum requirements of the server.
My
e] {}
> INFO [sqlalchemy.engine.base.Engine]
> CREATE TABLE users_permissions (
> users_id BIGINT NOT NULL,
> permissions_id BIGINT NOT NULL,
> PRIMARY KEY (users_id, permissions_id),
> FOREIGN KEY(permissions_id) REFERENCES permissions (id),
> FOREIGN KE
),
FOREIGN KEY(permissions_id) REFERENCES permissions (id)
)
My mistake is to have mixed in my mind the information of the object
mapping and the relational constraints of the database.
But why Alembic can’t create this model in auto-generation mode?
Best regards
Le jeu. 13 déc. 2018 à 18:12, patrick
previously ( there is no unique constraint matching given keys for
referenced table "users_roles").
I will send you the CREATE TABLE statements by email in a moment.
Best regards,
Patrick
Le mer. 12 déc. 2018 à 19:40, Mike Bayer a
écrit :
> On Wed, Dec 12, 2018 at 1:01 PM patrick payet wro
I had a SQLAlchemy model like -
class User(DeclarativeBase):
__tablename__ = 'users'
id = Column(BigInteger, primary_key=True)
email = Column(String(100), unique=True, nullable=False)
name = Column(String(100), nullable=False)
hashed_password = Column(String(100),
For some reason Pandas is returning NULL values from Oracle into "nan"
instead of "NaN" or "None"
so I have to check for this and change it to "None" or else SQLAlchemy
inserts a "~" instead of NULL
to my Oracle database.
What's up with that? Anybody else have this happen?
if
On Monday, November 9, 2015 at 1:50:36 PM UTC-8, Michael Bayer wrote:
>
> On 11/09/2015 03:10 PM, Patrick Lewis wrote:
>
> > Is this an issue, or am I misunderstanding the doc?
>
> the documentation was ambiguous. I have corrected the paragraph as
> follows:
>
&
Engine INSERT INTO
person (name) VALUES (?)
2015-11-09 20:00:30,045 INFO sqlalchemy.engine.base.Engine ('P Body',)
In handler, p:
session.dirty: IdentitySet([])
session.info: {'RENAMED': True}
Is this an issue, or am I misunderstanding the doc?
Thanks,
Patrick
--
You received this m
manually.
--
Patrick
--
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
, patrick wrote:
Well it's something between the two. The instance variable
compressed will always be NULL when adding or updating an instance,
but I want it to infer a value from another instance variable. When
inserting... the value of 'compressed' in the sql statement needs to
be the raw SQL
Yes, but then my descriptor is washed away. I'm trying to make it
like a column property on 'get' and a descriptor enabled property on
'set'.
On Mar 25, 3:27 pm, Michael Bayer mike...@zzzcomputing.com wrote:
patrick wrote:
In the past I assigned
Matrix.text=column_property(select
Bayer mike...@zzzcomputing.com wrote:
patrick wrote:
Hey,
I'm trying to create dynamic defaults for columns ala http://
www.sqlalchemy.org/docs/metadata.html#context-sensitive-default-funct
MySQL has COMPRESS and UNCOMPRESS functions that I'm trying to
leverage. I don't want
Hey,
I'm trying to create dynamic defaults for columns ala http://
www.sqlalchemy.org/docs/metadata.html#context-sensitive-default-functions.
MySQL has COMPRESS and UNCOMPRESS functions that I'm trying to
leverage. I don't want to compress with python's zlib because I have
legacy tables that
I am just learning the basics of Sqlalchemy, I am reading through the
O'Reilly book.
I was just wondering if anyone is using Sqlalchemy for desktop applications?
Does anyone know of specific problems I might have doing so?
Thanks in advance-Patrick
On Mar 3, 2008, at 11:23 AM, Michael Bayer wrote:
On Mar 3, 2008, at 11:56 AM, Patrick Hartling wrote:
hash(Works())
hash(Works2())
# Raises TypeError with Python 2.6 because Fails is deemed
unhashable.
hash(Fails())
Does anyone know of a workaround for this issue? So far
I used to be able to select from a mysql date column using a
datetime object; where the timestamp would be ignored because the DB
schema isn't using the datetime column type.
query = Table.query().filter(Table.c.date == datetime(2007, 1, 1))
The mysql log shows the select being generated like
. Please specify the 'onclause' of this join explicitly.
Unfortunately, when creating the mapper, I can't specify an onclause to the
mapper. Any help on how I would accomplish this and get my such a structure
in SQLAlchemy?
Thanks!
--Patrick
--~--~-~--~~~---~--~~
You
, Michael Bayer [EMAIL PROTECTED] wrote:
On May 24, 2007, at 10:02 AM, Patrick McKinnon wrote:
sqlalchemy.exceptions.ArgumentError: Cant locate any foreign key
columns in primary join condition 'attribute.child_id = child.id AND
child.parent_id = parent.id' for relationship 'Parent.attributes
(
child = relation(Child, backref=backref('attributes')),
)
)
metadata.create_all()
p = Parent()
--
Any ideas?
Thanks!
-Patrick
--~--~-~--~~~---~--~~
You received
On Feb 4, 5:54 am, [EMAIL PROTECTED] wrote:
I'm trying to create a mapped object where I don't know what the
exact constructor arguments of the object might be. I was trying
to use the inspect module to get the right arguments, but it looks
like the mapper is redefining the original
Hi,
I'm trying to create a mapped object where I don't know what the
exact constructor arguments of the object might be. I was trying to
use the inspect module to get the right arguments, but it looks like
the mapper is redefining the original class __init__. Any thoughts as
to how I might
After upgrading sqlite to the most recent version (3.3.10), my problem
went away and everything works as expected.
Thanks for the help, and sorry for the noise.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
I reran the above with a postgres database, and it all worked as
expected.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com
To
Thanks, I will give that a try.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to
Ok, that works for me, too. But, if I rework it how I think the test
suite is running things, I get the same error.
http://paste.turbogears.org/paste/832
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
sqlalchemy
A minor revision (made user1 global)
http://paste.turbogears.org/paste/833
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com
To
26 matches
Mail list logo