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
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
|
// ****************************************************************************
// copyright (c) 2000-2005 Horst Knorr <hk_classes@knoda.org>
// This file is part of the hk_sqlite3classes library.
// This file may be distributed and/or modified under the terms of the
// GNU Library Public License version 2 as published by the Free Software
// Foundation and appearing in the file COPYING included in the
// packaging of this file.
// This file is provided AS IS with NO WARRANTY OF ANY KIND, INCLUDING THE
// WARRANTY OF DESIGN, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.
// ****************************************************************************
//$Revision: 1.2 $
#include "hk_sqlite3view.h"
#include "hk_database.h"
hk_sqlite3view::hk_sqlite3view(hk_sqlite3database* db,hk_presentation* p)
:hk_sqlite3datasource(db,p)
{
}
hk_sqlite3view::enum_datasourcetypes hk_sqlite3view::type() const
{
return ds_view;
}
bool hk_sqlite3view::driver_specific_load_view()
{ cerr <<"driver_specific_load_view: "<<name()<<endl;
hk_string s="SELECT sql as viewselect FROM sqlite_master where type='view' and name='"+name()+"'";
hk_datasource* r=p_database->new_resultquery();
if (!r) return false;
r->set_sql(s);
r->enable();
hk_column* c=r->column_by_name("viewselect");
if (!c)
{
delete r;
show_warningmessage(hk_translate("View definition could not be loaded"));
return false;
}
s=c->asstring();
hk_string upper=string2upper(s);
unsigned int p=upper.find("CREATE VIEW");
if (p!=hk_string::npos)
{
p=upper.find(" AS ");
if (p!=hk_string::npos) s=s.substr(p+4);
}
p=s.find_last_not_of(" \\t\\n");
if (p!=hk_string::npos && s[p]==';')
s.replace(p,1,"");
p_viewsql=s;
cerr <<"setze sql="<<sql()<<endl;
delete r;
return true;
}
|
