view is used to create views. In SQLite a view can only be queried. INSERT, DELETE and UPDATE will fail on a view
More...
#include <view.hpp>
Public Member Functions |
| view (connection &con) |
| constructor
|
| ~view () |
| destructor
|
void | create (bool temporary, std::string const &alias, std::string const &sql_query) |
| creates a view
|
void | create (bool temporary, std::string const &database, std::string const &alias, std::string const &sql_query) |
| creates a view
|
void | drop (std::string const &alias) |
| drops a view
|
void | drop (std::string const &database, std::string const &alias) |
| drops a view
|
Detailed Description
view is used to create views. In SQLite a view can only be queried. INSERT, DELETE and UPDATE will fail on a view
Definition at line 39 of file view.hpp.
Constructor & Destructor Documentation
constructor
- Parameters
-
con | a reference to the connection object which should be used |
Member Function Documentation
void sqlite::view::create |
( |
bool |
temporary, |
|
|
std::string const & |
alias, |
|
|
std::string const & |
sql_query |
|
) |
| |
creates a view
- Parameters
-
temporary | if this parameter is true the view will be present until drop will be called or the database was closed |
alias | the name of this view which should be used |
sql_query | the SQL statement which represents the view |
void sqlite::view::create |
( |
bool |
temporary, |
|
|
std::string const & |
database, |
|
|
std::string const & |
alias, |
|
|
std::string const & |
sql_query |
|
) |
| |
creates a view
- Parameters
-
temporary | if this parameter is true the view will be present until drop will be called or the database was closed |
database | name of the database where the view should be created in |
alias | the name of this view which should be used |
sql_query | the SQL statement which represents the view |
void sqlite::view::drop |
( |
std::string const & |
alias | ) |
|
drops a view
- Parameters
-
alias | name of the view which should be dropped |
void sqlite::view::drop |
( |
std::string const & |
database, |
|
|
std::string const & |
alias |
|
) |
| |
drops a view
- Parameters
-
database | name of the database where the view was created in |
alias | name of the view which should be dropped |
Member Data Documentation
The documentation for this struct was generated from the following file: