CODEWITHSUNDEEP
sql-serverormsqlalchemy
Peter
Peter

Reputation: 337

Unwanted square brackets inserted in SQL statement from ORM

I'm trying to make a simple select on my table mapped with sqlalchemy but I can't get it to match the exact table name.

As I noticed, the output of this:

class Users(base):
    __tablename__ = "users"
[...]

was 

[Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'users'

And I tried to fix the error by explicitly writing the database I'm refering to

class Users(base):
    __tablename__ = "[homework-3-cc-database].users"
[...]

giving the output:

[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near ']'.

I noticed that it inserted some square brackets, unwanted. Here is their SQL statement:

[SQL: SELECT TOP 1 [[homework-3-cc-database].users].user_id AS [[homework-3-cc-database].users_user_id] 
FROM [[homework-3-cc-database].users]]

This statement, ran from DataGrip works just fine:

SELECT TOP 1 [homework-3-cc-schema].users.user_id 
FROM [homework-3-cc-schema].users

Do you have any suggestions regarding how should I fix this?

Upvotes: 1

Views: 250

Answers (1)

Peter
Peter

Reputation: 337

I had to specify the schema name in the following way:

__table_args__ = {"schema": "homework-3-cc-schema"}

Upvotes: 1

Related Questions