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 ImageFKCoordIDMin()
std::string LineageValueFKCalculatedValue()
std::string TrackValueFKTrack()
std::string MeshTable()
std::string LineageValueTable()
std::string ContourValueTable()
std::string BookmarkTable()
std::string ImagingSessionFKProjectName()
std::string ChannelFKImagingSession()
std::string CoordinateTable()
std::string ValuePerVectorCoordTable()
std::string SubCellularTypeTable()
std::string ContourValueFKCalculatedValue()
std::string IntensityFKChannel()
std::string ColorTableScript()
void CreateTables(vtkMySQLDatabase *DataBaseConnector)
std::string ValueperVectorCoordFKCalculatedValue()
std::string ProjectTable()
std::string ChannelTable()
std::string BookmarkFKImagingSession()
std::string TrackFKColor()
std::string ImagingSessionFKCoordIDMax()
std::string ImageValueFKCalculatedValue()
std::string ImagingSessionValueFKCalculatedValue()
std::string LineageTable()
std::string ImageValueFKImage()
std::string MeshFKImagingSession()
std::string ImageFKImagingSession()
std::string CalculatedValueFKValueType()
std::string AuthorTable()
bool CreateDataBase(vtkMySQLDatabase *DataBaseConnector, std::string DBName)
std::string ContourFKCoordIDMin()
std::string ImagingSessionFKCoordIDMin()
std::string MeshFKTrackID()
std::string ContourValueFKContour()
std::string ContourFKCoordIDMax()
std::string LineageFKColor()
std::string ImagingSessionFKMicroscopeName()
std::string ImageTable()
std::string MeshFKSubCellType()
std::string MeshFKCoordIDMax()
std::string LineageFKCoordIDMin()
std::string TrackFKCoordIDMax()
std::string LineageFKTrackRoot()
std::string LineageValueFKLineage()
std::string MeshFKCoordIDMin()
std::string MeshValueFKMesh()
std::string BookmarkFKCoord()
std::string ChannelFKColor()
std::string ProjectFK()
std::string CalculatedValueTable()
void CreateForeignKeys(vtkMySQLDatabase *DataBaseConnector)
std::string ImagingSessionValueFKImagingSession()
std::string TrackFamilyFKTrackIDDaughter1()
std::string IntensityTable()
std::string CellTypeTable()
std::string ImagingSessionTable()
std::string TrackFamilyFKTrackIDDaughter2()
std::string ImageFKChannel()
std::string MeshFKCellType()
std::string ImageValueTable()
std::string TrackFKTrackFamily()
std::string TrackFKCoordIDMin()
std::string MeshFKColor()
void Query(vtkMySQLDatabase *DataBaseConnector, std::string queryScript)
std::string TrackFamilyTable()
std::string LineageFKImagingSession()
std::string ContourFKImagingSession()
std::string ValueTypeTable()
std::string ContourFKMesh()
std::string MeshValueTable()
std::string TrackFamilyFKTrackIDMother()
std::string ContourTable()
std::string TrackFKImagingSession()
std::string LineageFKCoordIDMax()
std::string MeshValueFKCalculatedValue()
std::string ImagingSessionValueTable()
std::string TrackValueFKCalculatedValue()
bool CreateGoFigureDataBase(std::string ServerName, std::string login, std::string Password, std::string DBName)
bool DoesDatabaseExit(vtkMySQLDatabase *DataBaseConnector, std::string DBName)
bool IsDatabaseOfGoFigureType(vtkMySQLDatabase *DatabaseConnector)
std::string TrackValueTable()
std::string IntensityFKMesh()
std::string TrackFKLineage()
std::string TrackTable()
std::string MicroscopeTable()