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
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
|
/* -*- Mode: Vala; indent-tabs-mode: t; c-basic-offset: 4; tab-width: 4 -*- */
/*
* libgdadata
* Copyright (C) Daniel Espinosa Ortiz 2011 <esodan@gmail.com>
*
* libgda is free software: you can redistribute it and/or modify it
* under the terms of the GNU Lesser General Public License as published
* by the Free Software Foundation, either version 3 of the License, or
* (at your option) any later version.
*
* libgda is distributed in the hope that it will be useful, but
* WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
* See the GNU Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public License
* along with this program. If not, see <http://www.gnu.org/licenses/>.
*/
using Gee;
using Gda;
namespace GdaData
{
public interface DbTable : Object, DbObject, DbNamedObject
{
public abstract DbCatalog catalog { get; set; }
public abstract DbSchema schema { get; set; }
public abstract TableType table_type { get; set; }
public abstract Collection<DbRecord> records { owned get; }
public abstract Collection<DbTable> depends { owned get; }
public abstract Collection<DbTable> referenced { owned get; }
public abstract Collection<DbFieldInfo> fields { owned get; }
public abstract Collection<DbFieldInfo> primary_keys { owned get; }
public abstract void set_field (DbFieldInfo field) throws Error;
public abstract DbFieldInfo get_field (string name) throws Error;
public virtual bool compatible (DbTable table)
{
foreach (DbFieldInfo f in fields) {
foreach (DbFieldInfo ft in table.fields) {
if (ft.name == f.name) {
if (!f.compatible (ft)) {
return false;
break;
}
}
}
}
return true;
}
public virtual bool equivalent (DbTable table)
{
// At least all fields are located in table and are equivalent
foreach (DbFieldInfo f in fields) {
bool found = false;
foreach (DbFieldInfo ft in table.fields) {
if (f.name == ft.name) {
found = true;
if (!f.equivalent (ft))
return false;
break;
}
}
if (!found)
return false;
}
return true;
}
public enum TableType {
NONE,
BASE_TABLE,
VIEW,
LOCAL_TEMPORARY,
SYSTEM_TABLE,
GLOBAL_TEMPORARY,
ALIAS,
SYNONYM;
public static TableType from_string (string str)
{
if (str == "BASE TABLE")
return TableType.BASE_TABLE;
if (str == "VIEW")
return TableType.VIEW;
if (str == "LOCAL TEMPORARY")
return TableType.LOCAL_TEMPORARY;
if (str == "SYSTEM TABLE")
return TableType.SYSTEM_TABLE;
if (str == "GLOBAL TEMPORARY")
return TableType.GLOBAL_TEMPORARY;
if (str == "ALIAS")
return TableType.ALIAS;
if (str == "SYNONYM")
return TableType.SYNONYM;
return TableType.NONE;
}
}
}
errordomain DbTableError {
READ_ONLY,
FIELD
}
}
|
