Is there any way to use the SQL Command CREATE VIEW in Django?
If I Try To use regular syntax, or use
from django.db import connection
...
with connection.cursor()
...
I get the Error:
Incorrect syntax near the keyword 'VIEW'.
-
What error did you getuser8193706– user81937062022-01-29 09:40:43 +00:00Commented Jan 29, 2022 at 9:40
-
Edited the ErrorAmitai– Amitai2022-01-29 09:46:59 +00:00Commented Jan 29, 2022 at 9:46
-
Post the SQL query that you are using. Also check if using a migration is suitable for your case stackoverflow.com/questions/66853070/…Francisco Puga– Francisco Puga2022-01-29 09:48:58 +00:00Commented Jan 29, 2022 at 9:48
Add a comment
|
1 Answer
as usual creating view in sql is look like below:
create view in SQL named Test:
from django.db import connection
...
...
def createView(self):
with connection.cursor() as cursor:
cursor.execute('DROP VIEW IF EXISTS dbo.Test')
cursor.execute("CREATE VIEW Test AS \
SELECT column1, column2, column3, ...\
FROM some_table_name \
WHERE condition")
Check your syntax with mine, if still has problem please place your whole code here.
