GOFIGURE2  0.9.0
 All Classes Namespaces Files Functions Variables Typedefs Enumerations Enumerator Properties Friends Macros Groups Pages
CreateDataBaseHelper.h
Go to the documentation of this file.
1 /*=========================================================================
2  Authors: The GoFigure Dev. Team.
3  at Megason Lab, Systems biology, Harvard Medical school, 2009-11
4 
5  Copyright (c) 2009-11, President and Fellows of Harvard College.
6  All rights reserved.
7 
8  Redistribution and use in source and binary forms, with or without
9  modification, are permitted provided that the following conditions are met:
10 
11  Redistributions of source code must retain the above copyright notice,
12  this list of conditions and the following disclaimer.
13  Redistributions in binary form must reproduce the above copyright notice,
14  this list of conditions and the following disclaimer in the documentation
15  and/or other materials provided with the distribution.
16  Neither the name of the President and Fellows of Harvard College
17  nor the names of its contributors may be used to endorse or promote
18  products derived from this software without specific prior written
19  permission.
20 
21  THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
22  "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO,
23  THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
24  PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS
25  BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY,
26  OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT
27  OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS;
28  OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY,
29  WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE
30  OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF
31  ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
32 
33 =========================================================================*/
34 #ifndef __CreateDataBaseHelper_h
35 #define __CreateDataBaseHelper_h
36 
37 #include <vector>
38 #include <string>
39 #include "itkMacro.h"
40 #include "vtkMySQLDatabase.h"
41 
42 #include "QGoIOConfigure.h"
43 
44 QGOIO_EXPORT bool IsDatabaseOfGoFigureType(
45  vtkMySQLDatabase *DataBaseConnector);
46 
47 QGOIO_EXPORT bool DoesDatabaseExit(std::string ServerName, std::string login,
48  std::string Password, std::string DBName);
49 
50 QGOIO_EXPORT void Query(vtkMySQLDatabase *DataBaseConnector,
51  std::string queryScript);
52 
53 QGOIO_EXPORT bool CreateGoFigureDataBase(
54  std::string ServerName, std::string login,
55  std::string Password, std::string DBName);
56 
57 QGOIO_EXPORT bool CreateDataBase(vtkMySQLDatabase *DataBaseConnector,
58  std::string DBName);
59 
60 QGOIO_EXPORT void CreateTables(
61  vtkMySQLDatabase *DataBaseConnector);
62 
63 QGOIO_EXPORT void CreateForeignKeys(
64  vtkMySQLDatabase *DataBaseConnector);
65 
66 QGOIO_EXPORT std::string CellTypeTable();
67 
68 QGOIO_EXPORT std::string AuthorTable();
69 
70 QGOIO_EXPORT std::string SubCellularTypeTable();
71 
72 QGOIO_EXPORT std::string CoordinateTable();
73 
74 QGOIO_EXPORT std::string ColorTableScript();
75 
76 QGOIO_EXPORT std::string MicroscopeTable();
77 
78 QGOIO_EXPORT std::string ProjectTable();
79 
80 QGOIO_EXPORT std::string ImagingSessionTable();
81 
82 QGOIO_EXPORT std::string TrackFamilyTable();
83 
84 QGOIO_EXPORT std::string TrackTable();
85 
86 QGOIO_EXPORT std::string MeshTable();
87 
88 QGOIO_EXPORT std::string ContourTable();
89 
90 QGOIO_EXPORT std::string ChannelTable();
91 
92 QGOIO_EXPORT std::string ImageTable();
93 
94 QGOIO_EXPORT std::string LineageTable();
95 
96 QGOIO_EXPORT std::string BookmarkTable();
97 
98 QGOIO_EXPORT std::string IntensityTable();
99 
100 QGOIO_EXPORT std::string ValueTypeTable();
101 
102 QGOIO_EXPORT std::string CalculatedValueTable();
103 
104 QGOIO_EXPORT std::string ValuePerVectorCoordTable();
105 
106 QGOIO_EXPORT std::string MeshValueTable();
107 
108 QGOIO_EXPORT std::string TrackValueTable();
109 
110 QGOIO_EXPORT std::string ImageValueTable();
111 
112 QGOIO_EXPORT std::string ImagingSessionValueTable();
113 
114 QGOIO_EXPORT std::string ContourValueTable();
115 
116 QGOIO_EXPORT std::string LineageValueTable();
117 
118 std::string ProjectFK();
119 
120 std::string ImagingSessionFKMicroscopeName();
121 
122 std::string ImagingSessionFKProjectName();
123 
124 std::string ImagingSessionFKCoordIDMin();
125 
126 std::string ImagingSessionFKCoordIDMax();
127 
128 std::string TrackFamilyFKTrackIDDaughter1();
129 
130 std::string TrackFamilyFKTrackIDDaughter2();
131 
132 std::string TrackFamilyFKTrackIDMother();
133 
134 std::string TrackFKColor();
135 
136 std::string TrackFKLineage();
137 
138 std::string TrackFKCoordIDMax();
139 
140 std::string TrackFKCoordIDMin();
141 
142 std::string TrackFKTrackFamily();
143 
144 std::string TrackFKImagingSession();
145 
146 std::string MeshFKImagingSession();
147 
148 std::string MeshFKTrackID();
149 
150 std::string MeshFKColor();
151 
152 std::string MeshFKCoordIDMin();
153 
154 std::string MeshFKCoordIDMax();
155 
156 std::string MeshFKSubCellType();
157 
158 std::string MeshFKCellType();
159 
160 std::string ContourFKImagingSession();
161 
162 std::string ContourFKCoordIDMin();
163 
164 std::string ContourFKCoordIDMax();
165 
166 std::string ContourFKMesh();
167 
168 std::string ChannelFKColor();
169 
170 std::string ChannelFKImagingSession();
171 
172 std::string ImageFKChannel();
173 
174 std::string ImageFKCoordIDMin();
175 
176 std::string ImageFKImagingSession();
177 
178 std::string LineageFKImagingSession();
179 
180 std::string LineageFKTrackRoot();
181 
182 std::string LineageFKColor();
183 
184 std::string LineageFKCoordIDMin();
185 
186 std::string LineageFKCoordIDMax();
187 
188 std::string BookmarkFKCoord();
189 
190 std::string BookmarkFKImagingSession();
191 
192 std::string IntensityFKChannel();
193 
194 std::string IntensityFKMesh();
195 
197 
198 std::string CalculatedValueFKValueType();
199 
200 std::string MeshValueFKCalculatedValue();
201 
202 std::string MeshValueFKMesh();
203 
204 std::string TrackValueFKCalculatedValue();
205 
206 std::string TrackValueFKTrack();
207 
208 std::string ImageValueFKCalculatedValue();
209 
210 std::string ImageValueFKImage();
211 
213 
215 
216 std::string ContourValueFKCalculatedValue();
217 
218 std::string ContourValueFKContour();
219 
220 std::string LineageValueFKCalculatedValue();
221 
222 std::string LineageValueFKLineage();
223 
224 #endif
std::string ImagingSessionFKMicroscopeName()
QGOIO_EXPORT std::string ContourValueTable()
QGOIO_EXPORT std::string MicroscopeTable()
QGOIO_EXPORT std::string ValuePerVectorCoordTable()
QGOIO_EXPORT std::string ValueTypeTable()
QGOIO_EXPORT std::string ImagingSessionTable()
QGOIO_EXPORT std::string LineageTable()
std::string MeshFKSubCellType()
std::string LineageFKImagingSession()
QGOIO_EXPORT std::string ImageValueTable()
std::string TrackValueFKTrack()
QGOIO_EXPORT void CreateForeignKeys(vtkMySQLDatabase *DataBaseConnector)
std::string MeshFKTrackID()
std::string ContourValueFKCalculatedValue()
std::string ContourFKCoordIDMin()
QGOIO_EXPORT std::string CalculatedValueTable()
std::string MeshFKColor()
QGOIO_EXPORT std::string AuthorTable()
std::string ContourValueFKContour()
QGOIO_EXPORT std::string MeshTable()
std::string TrackFamilyFKTrackIDDaughter2()
std::string ChannelFKColor()
std::string LineageFKColor()
QGOIO_EXPORT std::string LineageValueTable()
std::string MeshValueFKMesh()
QGOIO_EXPORT std::string SubCellularTypeTable()
std::string ContourFKMesh()
QGOIO_EXPORT std::string ImagingSessionValueTable()
QGOIO_EXPORT bool DoesDatabaseExit(std::string ServerName, std::string login, std::string Password, std::string DBName)
std::string IntensityFKChannel()
std::string ContourFKImagingSession()
std::string LineageFKTrackRoot()
QGOIO_EXPORT std::string CellTypeTable()
QGOIO_EXPORT bool CreateDataBase(vtkMySQLDatabase *DataBaseConnector, std::string DBName)
std::string TrackFKLineage()
std::string ImageFKImagingSession()
std::string ValueperVectorCoordFKCalculatedValue()
std::string ProjectFK()
std::string ImageValueFKCalculatedValue()
QGOIO_EXPORT std::string ColorTableScript()
std::string ImagingSessionFKProjectName()
std::string MeshFKCellType()
QGOIO_EXPORT std::string ChannelTable()
std::string LineageFKCoordIDMax()
QGOIO_EXPORT std::string CoordinateTable()
QGOIO_EXPORT std::string MeshValueTable()
QGOIO_EXPORT std::string IntensityTable()
std::string ImagingSessionFKCoordIDMin()
std::string TrackValueFKCalculatedValue()
QGOIO_EXPORT std::string TrackValueTable()
std::string ImagingSessionValueFKImagingSession()
QGOIO_EXPORT bool IsDatabaseOfGoFigureType(vtkMySQLDatabase *DataBaseConnector)
QGOIO_EXPORT void CreateTables(vtkMySQLDatabase *DataBaseConnector)
QGOIO_EXPORT std::string ImageTable()
QGOIO_EXPORT bool CreateGoFigureDataBase(std::string ServerName, std::string login, std::string Password, std::string DBName)
std::string BookmarkFKImagingSession()
std::string MeshValueFKCalculatedValue()
QGOIO_EXPORT std::string BookmarkTable()
std::string BookmarkFKCoord()
std::string ContourFKCoordIDMax()
std::string ImagingSessionValueFKCalculatedValue()
std::string MeshFKCoordIDMin()
std::string LineageValueFKLineage()
std::string ChannelFKImagingSession()
std::string TrackFKCoordIDMin()
std::string ImageFKCoordIDMin()
QGOIO_EXPORT std::string ProjectTable()
std::string TrackFKCoordIDMax()
std::string MeshFKCoordIDMax()
QGOIO_EXPORT std::string TrackFamilyTable()
std::string TrackFamilyFKTrackIDMother()
QGOIO_EXPORT std::string ContourTable()
std::string MeshFKImagingSession()
std::string CalculatedValueFKValueType()
std::string TrackFKImagingSession()
QGOIO_EXPORT void Query(vtkMySQLDatabase *DataBaseConnector, std::string queryScript)
std::string ImageValueFKImage()
std::string TrackFamilyFKTrackIDDaughter1()
std::string TrackFKTrackFamily()
std::string LineageValueFKCalculatedValue()
std::string IntensityFKMesh()
std::string ImagingSessionFKCoordIDMax()
QGOIO_EXPORT std::string TrackTable()
std::string LineageFKCoordIDMin()
std::string ImageFKChannel()
std::string TrackFKColor()