Plugins/SqlEnterpriseFormatter/formatcreateview.cpp


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26

#include "formatcreateview.h"
#include "parser/ast/sqlitecreateview.h"
#include "parser/ast/sqliteselect.h"

FormatCreateView::FormatCreateView(SqliteCreateView* createView) :
    createView(createView)
{
}

void FormatCreateView::formatInternal()
{
    withKeyword("CREATE");
    if (createView->tempKw)
        withKeyword("TEMP");
    else if (createView->temporaryKw)
        withKeyword("TEMPORARY");

    withKeyword("VIEW");
    if (createView->ifNotExists)
        withKeyword("IF").withKeyword("NOT").withKeyword("EXISTS");

    if (dialect == Dialect::Sqlite3 && !createView->database.isNull())
        withId(createView->database).withIdDot();

    withId(createView->view).withKeyword("AS").withStatement(createView->select).withSemicolon();
}