MCPcopy
hub / github.com/sqlalchemy/sqlalchemy / get_view_definition

Method get_view_definition

lib/sqlalchemy/dialects/mssql/base.py:3489–3507  ·  view source on GitHub ↗
(
        self, connection, viewname, dbname, owner, schema, **kw
    )

Source from the content-addressed store, hash-verified

3487 @reflection.cache
3488 @_db_plus_owner
3489 def get_view_definition(
3490 self, connection, viewname, dbname, owner, schema, **kw
3491 ):
3492 view_def = connection.execute(
3493 sql.text(
3494 "select mod.definition "
3495 "from sys.sql_modules as mod "
3496 "join sys.views as views on mod.object_id = views.object_id "
3497 "join sys.schemas as sch on views.schema_id = sch.schema_id "
3498 "where views.name=:viewname and sch.name=:schname"
3499 ).bindparams(
3500 sql.bindparam("viewname", viewname, ischema.CoerceUnicode()),
3501 sql.bindparam("schname", owner, ischema.CoerceUnicode()),
3502 )
3503 ).scalar()
3504 if view_def:
3505 return view_def
3506 else:
3507 raise exc.NoSuchTableError(f"{owner}.{viewname}")
3508
3509 def _temp_table_name_like_pattern(self, tablename):
3510 # LIKE uses '%' to match zero or more characters and '_' to match any

Callers

nothing calls this directly

Calls 3

scalarMethod · 0.45
executeMethod · 0.45
bindparamsMethod · 0.45

Tested by

no test coverage detected