· 8 years ago · Aug 31, 2018, 06:56 PM
1using System;
2using System.Collections.Generic;
3using System.Linq;
4using System.Text;
5using System.Threading.Tasks;
6
7using System.Data.SQLite;
8
9namespace SQLiteTest
10{
11 class Program
12 {
13 #region RACE テーブル作æˆç”¨ SQL
14 const string tableCreateSQL_RACE =
15 "CREATE TABLE IF NOT EXISTS RACE (" +
16 "RecordSpec CHAR(2)," +
17 "DataKubun CHAR(1)," +
18 "MakeDate CHAR(8)," +
19 "Year CHAR(4)," +
20 "MonthDay CHAR(4)," +
21 "JyoCD CHAR(2)," +
22 "Kaiji CHAR(2)," +
23 "Nichiji CHAR(2)," +
24 "RaceNum CHAR(2)," +
25 "YoubiCD CHAR(1)," +
26 "TokuNum CHAR(4)," +
27 "Hondai CHAR(60)," +
28 "Fukudai CHAR(60)," +
29 "Kakko CHAR(60)," +
30 "HondaiEng CHAR(120)," +
31 "FukudaiEng CHAR(120)," +
32 "KakkoEng CHAR(120)," +
33 "Ryakusyo10 CHAR(20)," +
34 "Ryakusyo6 CHAR(12)," +
35 "Ryakusyo3 CHAR(6)," +
36 "Kubun CHAR(1)," +
37 "Nkai CHAR(3)," +
38 "GradeCD CHAR(1)," +
39 "GradeCDBefore CHAR(1)," +
40 "SyubetuCD CHAR(2)," +
41 "KigoCD CHAR(3)," +
42 "JyuryoCD CHAR(1)," +
43 "JyokenCD1 CHAR(3)," +
44 "JyokenCD2 CHAR(3)," +
45 "JyokenCD3 CHAR(3)," +
46 "JyokenCD4 CHAR(3)," +
47 "JyokenCD5 CHAR(3)," +
48 "JyokenName CHAR(60)," +
49 "Kyori CHAR(4)," +
50 "KyoriBefore CHAR(4)," +
51 "TrackCD CHAR(2)," +
52 "TrackCDBefore CHAR(2)," +
53 "CourseKubunCD CHAR(2)," +
54 "CourseKubunCDBefore CHAR(2)," +
55 "Honsyokin1 CHAR(8)," +
56 "Honsyokin2 CHAR(8)," +
57 "Honsyokin3 CHAR(8)," +
58 "Honsyokin4 CHAR(8)," +
59 "Honsyokin5 CHAR(8)," +
60 "Honsyokin6 CHAR(8)," +
61 "Honsyokin7 CHAR(8)," +
62 "HonsyokinBefore1 CHAR(8)," +
63 "HonsyokinBefore2 CHAR(8)," +
64 "HonsyokinBefore3 CHAR(8)," +
65 "HonsyokinBefore4 CHAR(8)," +
66 "HonsyokinBefore5 CHAR(8)," +
67 "Fukasyokin1 CHAR(8)," +
68 "Fukasyokin2 CHAR(8)," +
69 "Fukasyokin3 CHAR(8)," +
70 "ukasyokin4 CHAR(8)," +
71 "Fukasyokin5 CHAR(8)," +
72 "FukasyokinBefore1 CHAR(8)," +
73 "FukasyokinBefore2 CHAR(8)," +
74 "FukasyokinBefore3 CHAR(8)," +
75 "HassoTime CHAR(4)," +
76 "HassoTimeBefore CHAR(4)," +
77 "TorokuTosu CHAR(2)," +
78 "SyussoTosu CHAR(2)," +
79 "NyusenTosu CHAR(2)," +
80 "TenkoCD CHAR(1)," +
81 "SibaBabaCD CHAR(1)," +
82 "DirtBabaCD CHAR(1)," +
83 "LapTime1 CHAR(3)," +
84 "LapTime2 CHAR(3)," +
85 "LapTime3 CHAR(3)," +
86 "LapTime4 CHAR(3)," +
87 "LapTime5 CHAR(3)," +
88 "LapTime6 CHAR(3)," +
89 "LapTime7 CHAR(3)," +
90 "LapTime8 CHAR(3)," +
91 "LapTime9 CHAR(3)," +
92 "LapTime10 CHAR(3)," +
93 "LapTime11 CHAR(3)," +
94 "LapTime12 CHAR(3)," +
95 "LapTime13 CHAR(3)," +
96 "LapTime14 CHAR(3)," +
97 "LapTime15 CHAR(3)," +
98 "LapTime16 CHAR(3)," +
99 "LapTime17 CHAR(3)," +
100 "LapTime18 CHAR(3)," +
101 "LapTime19 CHAR(3)," +
102 "LapTime20 CHAR(3)," +
103 "LapTime21 CHAR(3)," +
104 "LapTime22 CHAR(3)," +
105 "LapTime23 CHAR(3)," +
106 "LapTime24 CHAR(3)," +
107 "LapTime25 CHAR(3)," +
108 "SyogaiMileTime CHAR(4)," +
109 "HaronTimeS3 CHAR(3)," +
110 "HaronTimeS4 CHAR(3)," +
111 "HaronTimeL3 CHAR(3)," +
112 "HaronTimeL4 CHAR(3)," +
113 "Corner1 CHAR(1)," +
114 "Syukaisu1 CHAR(1)," +
115 "Jyuni1 CHAR(70)," +
116 "Corner2 CHAR(1)," +
117 "Syukaisu2 CHAR(1)," +
118 "Jyuni2 CHAR(70)," +
119 "Corner3 CHAR(1)," +
120 "Syukaisu3 CHAR(1)," +
121 "Jyuni3 CHAR(70)," +
122 "Corner4 CHAR(1)," +
123 "Syukaisu4 CHAR(1)," +
124 "Jyuni4 CHAR(70)," +
125 "RecordUpKubun CHAR(1)," +
126 "PRIMARY KEY(Year, MonthDay, JyoCD, Kaiji, Nichiji, RaceNum)" +
127 ")";
128 #endregion
129 #region UMA‗RACE テーブル作æˆç”¨ SQL
130 const string tableCreateSQL_UMA_RACE =
131 "CREATE TABLE IF NOT EXISTS UMA_RACE(" +
132 "RecordSpec CHAR(2)," +
133 "DataKubun CHAR(1)," +
134 "MakeDate CHAR(8)," +
135 "Year CHAR(4)," +
136 "MonthDay CHAR(4)," +
137 "JyoCD CHAR(2)," +
138 "Kaiji CHAR(2)," +
139 "Nichiji CHAR(2)," +
140 "RaceNum CHAR(2)," +
141 "Wakuban CHAR(1)," +
142 "Umaban CHAR(2)," +
143 "KettoNum CHAR(10)," +
144 "Bamei CHAR(36)," +
145 "UmaKigoCD CHAR(2)," +
146 "SexCD CHAR(1)," +
147 "HinsyuCD CHAR(1)," +
148 "KeiroCD CHAR(2)," +
149 "Barei CHAR(2)," +
150 "TozaiCD CHAR(1)," +
151 "ChokyosiCode CHAR(5)," +
152 "ChokyosiRyakusyo CHAR(8)," +
153 "BanusiCode CHAR(6)," +
154 "BanusiName CHAR(64)," +
155 "Fukusyoku CHAR(60)," +
156 "reserved1 CHAR(60)," +
157 "Futan CHAR(3)," +
158 "FutanBefore CHAR(3)," +
159 "Blinker CHAR(1)," +
160 "reserved2 CHAR(1)," +
161 "KisyuCode CHAR(5)," +
162 "KisyuCodeBefore CHAR(5)," +
163 "KisyuRyakusyo CHAR(8)," +
164 "KisyuRyakusyoBefore CHAR(8)," +
165 "MinaraiCD CHAR(1)," +
166 "MinaraiCDBefore CHAR(1)," +
167 "BaTaijyu CHAR(3)," +
168 "ZogenFugo CHAR(1)," +
169 "ZogenSa CHAR(3)," +
170 "IJyoCD CHAR(1)," +
171 "NyusenJyuni CHAR(2)," +
172 "KakuteiJyuni CHAR(2)," +
173 "DochakuKubun CHAR(1)," +
174 "DochakuTosu CHAR(1)," +
175 "Time CHAR(4)," +
176 "ChakusaCD CHAR(3)," +
177 "ChakusaCDP CHAR(3)," +
178 "ChakusaCDPP CHAR(3)," +
179 "Jyuni1c CHAR(2)," +
180 "Jyuni2c CHAR(2)," +
181 "Jyuni3c CHAR(2)," +
182 "Jyuni4c CHAR(2)," +
183 "Odds CHAR(4)," +
184 "Ninki CHAR(2)," +
185 "Honsyokin CHAR(8)," +
186 "Fukasyokin CHAR(8)," +
187 "reserved3 CHAR(3)," +
188 "reserved4 CHAR(3)," +
189 "HaronTimeL4 CHAR(3)," +
190 "HaronTimeL3 CHAR(3)," +
191 "KettoNum1 CHAR(10)," +
192 "Bamei1 CHAR(36)," +
193 "KettoNum2 CHAR(10)," +
194 "Bamei2 CHAR(36)," +
195 "KettoNum3 CHAR(10)," +
196 "Bamei3 CHAR(36)," +
197 "TimeDiff CHAR(4)," +
198 "RecordUpKubun CHAR(1)," +
199 "DMKubun CHAR(1)," +
200 "DMTime CHAR(5)," +
201 "DMGosaP CHAR(4)," +
202 "DMGosaM CHAR(4)," +
203 "DMJyuni CHAR(2)," +
204 "KyakusituKubun CHAR(1)," +
205 "PRIMARY KEY(Year, MonthDay, JyoCD, Kaiji, Nichiji, RaceNum, Umaban, KettoNum)" +
206 ")";
207 #endregion
208 static void Main(string[] args)
209 {
210 var connection = new SQLiteConnection("Data Source=JVData.sqlite;");
211
212 // RACE テーブル作æˆ
213 var RACE_TABLE_CREATE_CMD = connection.CreateCommand();
214 RACE_TABLE_CREATE_CMD.CommandText = tableCreateSQL_RACE;
215
216 connection.Open();
217 RACE_TABLE_CREATE_CMD.ExecuteNonQuery();
218 connection.Close();
219
220 // UMA_RACE テーブル作æˆ
221 var UMA_RACE_TABLE_CREATE_CMD = connection.CreateCommand();
222 UMA_RACE_TABLE_CREATE_CMD.CommandText = tableCreateSQL_UMA_RACE;
223
224 connection.Open();
225 UMA_RACE_TABLE_CREATE_CMD.ExecuteNonQuery();
226 connection.Close();
227 }
228 }
229}