ViewVC Help
View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing
root/xmltv_parser/trunk/GBPVRProgramDatabaseFixer/SQLLITE.cs
Revision 244 - (view) (download) (annotate) - [select for diffs]
Modified Sun Mar 17 10:48:34 2013 UTC (9 years, 10 months ago) by william
File length: 61317 byte(s)
Diff to previous 243

Revision 243 - (view) (download) (annotate) - [select for diffs]
Modified Sun Mar 17 10:47:45 2013 UTC (9 years, 10 months ago) by william
File length: 61311 byte(s)
Diff to previous 240

Revision 240 - (view) (download) (annotate) - [select for diffs]
Modified Sun Mar 17 10:34:06 2013 UTC (9 years, 10 months ago) by william
File length: 61315 byte(s)
Diff to previous 236

Revision 236 - (view) (download) (annotate) - [select for diffs]
Modified Sun Mar 17 08:20:06 2013 UTC (9 years, 10 months ago) by william
File length: 61226 byte(s)
Diff to previous 233

Revision 233 - (view) (download) (annotate) - [select for diffs]
Modified Sun Mar 17 06:53:55 2013 UTC (9 years, 10 months ago) by william
File length: 61176 byte(s)
Diff to previous 231

Revision 231 - (view) (download) (annotate) - [select for diffs]
Modified Sun Mar 17 05:01:37 2013 UTC (9 years, 10 months ago) by william
File length: 57827 byte(s)
Diff to previous 230

Revision 230 - (view) (download) (annotate) - [select for diffs]
Modified Sun Mar 17 04:14:41 2013 UTC (9 years, 10 months ago) by william
File length: 57366 byte(s)
Diff to previous 229

Revision 229 - (view) (download) (annotate) - [select for diffs]
Modified Sun Mar 17 04:13:59 2013 UTC (9 years, 10 months ago) by william
File length: 57342 byte(s)
Diff to previous 228

Revision 228 - (view) (download) (annotate) - [select for diffs]
Modified Sun Mar 17 04:02:57 2013 UTC (9 years, 10 months ago) by william
File length: 57144 byte(s)
Diff to previous 226
+ update rating when fixing gbpvr programs

Revision 226 - (view) (download) (annotate) - [select for diffs]
Modified Sun Mar 17 03:17:18 2013 UTC (9 years, 10 months ago) by william
File length: 56770 byte(s)
Diff to previous 225

Revision 225 - (view) (download) (annotate) - [select for diffs]
Modified Sun Mar 17 02:58:07 2013 UTC (9 years, 10 months ago) by william
File length: 56770 byte(s)
Diff to previous 224

Revision 224 - (view) (download) (annotate) - [select for diffs]
Modified Sun Mar 17 02:57:19 2013 UTC (9 years, 10 months ago) by william
File length: 56794 byte(s)
Diff to previous 223

Revision 223 - (view) (download) (annotate) - [select for diffs]
Modified Sun Mar 17 02:47:23 2013 UTC (9 years, 10 months ago) by william
File length: 56198 byte(s)
Diff to previous 222

Revision 222 - (view) (download) (annotate) - [select for diffs]
Modified Sun Mar 17 02:40:26 2013 UTC (9 years, 10 months ago) by william
File length: 56198 byte(s)
Diff to previous 221

Revision 221 - (view) (download) (annotate) - [select for diffs]
Modified Sun Mar 17 02:23:17 2013 UTC (9 years, 10 months ago) by william
File length: 56195 byte(s)
Diff to previous 220

Revision 220 - (view) (download) (annotate) - [select for diffs]
Modified Sun Mar 17 01:50:27 2013 UTC (9 years, 10 months ago) by william
File length: 54773 byte(s)
Diff to previous 219

Revision 219 - (view) (download) (annotate) - [select for diffs]
Modified Sun Mar 17 01:43:24 2013 UTC (9 years, 10 months ago) by william
File length: 54772 byte(s)
Diff to previous 218

Revision 218 - (view) (download) (annotate) - [select for diffs]
Modified Sun Mar 17 01:31:28 2013 UTC (9 years, 10 months ago) by william
File length: 54414 byte(s)
Diff to previous 217

Revision 217 - (view) (download) (annotate) - [select for diffs]
Modified Sun Mar 17 01:23:45 2013 UTC (9 years, 10 months ago) by william
File length: 54440 byte(s)
Diff to previous 216

Revision 216 - (view) (download) (annotate) - [select for diffs]
Modified Sun Mar 17 01:15:17 2013 UTC (9 years, 10 months ago) by william
File length: 55901 byte(s)
Diff to previous 215

Revision 215 - (view) (download) (annotate) - [select for diffs]
Modified Sun Mar 17 01:14:21 2013 UTC (9 years, 10 months ago) by william
File length: 55830 byte(s)
Diff to previous 214

Revision 214 - (view) (download) (annotate) - [select for diffs]
Modified Sun Mar 17 01:09:13 2013 UTC (9 years, 10 months ago) by william
File length: 55594 byte(s)
Diff to previous 213

Revision 213 - (view) (download) (annotate) - [select for diffs]
Modified Sun Mar 17 01:01:10 2013 UTC (9 years, 10 months ago) by william
File length: 55594 byte(s)
Diff to previous 211

Revision 211 - (view) (download) (annotate) - [select for diffs]
Modified Sun Mar 17 00:56:06 2013 UTC (9 years, 10 months ago) by william
File length: 55594 byte(s)
Diff to previous 210

Revision 210 - (view) (download) (annotate) - [select for diffs]
Modified Sat Mar 16 23:37:05 2013 UTC (9 years, 10 months ago) by william
File length: 53329 byte(s)
Diff to previous 209

Revision 209 - (view) (download) (annotate) - [select for diffs]
Modified Sat Mar 16 23:36:24 2013 UTC (9 years, 10 months ago) by william
File length: 53331 byte(s)
Diff to previous 208

Revision 208 - (view) (download) (annotate) - [select for diffs]
Modified Sat Mar 16 23:35:42 2013 UTC (9 years, 10 months ago) by william
File length: 53330 byte(s)
Diff to previous 207

Revision 207 - (view) (download) (annotate) - [select for diffs]
Modified Sat Mar 16 23:07:46 2013 UTC (9 years, 10 months ago) by william
File length: 49534 byte(s)
Diff to previous 206

Revision 206 - (view) (download) (annotate) - [select for diffs]
Modified Sat Mar 16 23:01:45 2013 UTC (9 years, 10 months ago) by william
File length: 49534 byte(s)
Diff to previous 204

Revision 204 - (view) (download) (annotate) - [select for diffs]
Modified Sat Mar 16 22:52:22 2013 UTC (9 years, 10 months ago) by william
File length: 49453 byte(s)
Diff to previous 203

Revision 203 - (view) (download) (annotate) - [select for diffs]
Modified Sat Mar 16 22:44:28 2013 UTC (9 years, 10 months ago) by william
File length: 49447 byte(s)
Diff to previous 202

Revision 202 - (view) (download) (annotate) - [select for diffs]
Modified Sat Mar 16 22:36:18 2013 UTC (9 years, 10 months ago) by william
File length: 49319 byte(s)
Diff to previous 201

Revision 201 - (view) (download) (annotate) - [select for diffs]
Modified Sat Mar 16 22:34:30 2013 UTC (9 years, 10 months ago) by william
File length: 49323 byte(s)
Diff to previous 200

Revision 200 - (view) (download) (annotate) - [select for diffs]
Modified Sat Mar 16 22:27:15 2013 UTC (9 years, 10 months ago) by william
File length: 49290 byte(s)
Diff to previous 199

Revision 199 - (view) (download) (annotate) - [select for diffs]
Modified Sat Mar 16 22:25:44 2013 UTC (9 years, 10 months ago) by william
File length: 49290 byte(s)
Diff to previous 197

Revision 197 - (view) (download) (annotate) - [select for diffs]
Modified Sat Mar 16 22:02:01 2013 UTC (9 years, 10 months ago) by william
File length: 48973 byte(s)
Diff to previous 196

Revision 196 - (view) (download) (annotate) - [select for diffs]
Modified Sat Mar 16 21:53:19 2013 UTC (9 years, 10 months ago) by william
File length: 48964 byte(s)
Diff to previous 195

Revision 195 - (view) (download) (annotate) - [select for diffs]
Modified Sat Mar 16 21:44:30 2013 UTC (9 years, 10 months ago) by william
File length: 49455 byte(s)
Diff to previous 194
+ speed-up sqllite insert of several rows at once by using: begin/end transation and setting the max # of items to insert at once, to 500 (which maybe the maximum # of compound insert statements that SqlLite supports)

Revision 194 - (view) (download) (annotate) - [select for diffs]
Modified Sat Mar 16 21:37:29 2013 UTC (9 years, 10 months ago) by william
File length: 49481 byte(s)
Diff to previous 193

Revision 193 - (view) (download) (annotate) - [select for diffs]
Modified Sat Mar 16 21:04:37 2013 UTC (9 years, 10 months ago) by william
File length: 48994 byte(s)
Diff to previous 192

Revision 192 - (view) (download) (annotate) - [select for diffs]
Modified Sat Mar 16 20:14:46 2013 UTC (9 years, 10 months ago) by william
File length: 48676 byte(s)
Diff to previous 191

Revision 191 - (view) (download) (annotate) - [select for diffs]
Modified Sat Mar 16 20:07:53 2013 UTC (9 years, 10 months ago) by william
File length: 48242 byte(s)
Diff to previous 190

Revision 190 - (view) (download) (annotate) - [select for diffs]
Modified Sat Mar 16 19:59:44 2013 UTC (9 years, 10 months ago) by william
File length: 48214 byte(s)
Diff to previous 189

Revision 189 - (view) (download) (annotate) - [select for diffs]
Modified Sat Mar 16 19:56:47 2013 UTC (9 years, 10 months ago) by william
File length: 47827 byte(s)
Diff to previous 188

Revision 188 - (view) (download) (annotate) - [select for diffs]
Modified Sat Mar 16 19:14:11 2013 UTC (9 years, 10 months ago) by william
File length: 51951 byte(s)
Diff to previous 187

Revision 187 - (view) (download) (annotate) - [select for diffs]
Modified Sat Mar 16 19:13:18 2013 UTC (9 years, 10 months ago) by william
File length: 51951 byte(s)
Diff to previous 186

Revision 186 - (view) (download) (annotate) - [select for diffs]
Modified Sat Mar 16 19:12:26 2013 UTC (9 years, 10 months ago) by william
File length: 51960 byte(s)
Diff to previous 185

Revision 185 - (view) (download) (annotate) - [select for diffs]
Modified Sat Mar 16 18:55:49 2013 UTC (9 years, 10 months ago) by william
File length: 46458 byte(s)
Diff to previous 184

Revision 184 - (view) (download) (annotate) - [select for diffs]
Modified Sat Mar 16 18:50:06 2013 UTC (9 years, 10 months ago) by william
File length: 46446 byte(s)
Diff to previous 183

Revision 183 - (view) (download) (annotate) - [select for diffs]
Modified Sat Mar 16 18:30:41 2013 UTC (9 years, 10 months ago) by william
File length: 45205 byte(s)
Diff to previous 182

Revision 182 - (view) (download) (annotate) - [select for diffs]
Modified Sat Mar 16 18:23:11 2013 UTC (9 years, 10 months ago) by william
File length: 43356 byte(s)
Diff to previous 181

Revision 181 - (view) (download) (annotate) - [select for diffs]
Modified Sat Mar 16 17:56:55 2013 UTC (9 years, 10 months ago) by william
File length: 39442 byte(s)
Diff to previous 180

Revision 180 - (view) (download) (annotate) - [select for diffs]
Modified Sat Mar 16 17:41:52 2013 UTC (9 years, 10 months ago) by william
File length: 39343 byte(s)
Diff to previous 179

Revision 179 - (view) (download) (annotate) - [select for diffs]
Modified Sat Mar 16 17:13:23 2013 UTC (9 years, 10 months ago) by william
File length: 36752 byte(s)
Diff to previous 178

Revision 178 - (view) (download) (annotate) - [select for diffs]
Modified Sat Mar 16 16:53:44 2013 UTC (9 years, 10 months ago) by william
File length: 37022 byte(s)
Diff to previous 177

Revision 177 - (view) (download) (annotate) - [select for diffs]
Modified Sat Mar 16 16:52:43 2013 UTC (9 years, 10 months ago) by william
File length: 36969 byte(s)
Diff to previous 176

Revision 176 - (view) (download) (annotate) - [select for diffs]
Modified Sat Mar 16 16:22:43 2013 UTC (9 years, 10 months ago) by william
File length: 35832 byte(s)
Diff to previous 175

Revision 175 - (view) (download) (annotate) - [select for diffs]
Modified Sat Mar 16 16:06:20 2013 UTC (9 years, 10 months ago) by william
File length: 34507 byte(s)
Diff to previous 174

Revision 174 - (view) (download) (annotate) - [select for diffs]
Modified Sat Mar 16 16:03:19 2013 UTC (9 years, 10 months ago) by william
File length: 34413 byte(s)
Diff to previous 173

Revision 173 - (view) (download) (annotate) - [select for diffs]
Modified Sat Mar 16 15:33:25 2013 UTC (9 years, 10 months ago) by william
File length: 28569 byte(s)
Diff to previous 172

Revision 172 - (view) (download) (annotate) - [select for diffs]
Modified Sat Mar 16 15:15:33 2013 UTC (9 years, 10 months ago) by william
File length: 28589 byte(s)
Diff to previous 171

Revision 171 - (view) (download) (annotate) - [select for diffs]
Modified Sat Mar 16 14:31:24 2013 UTC (9 years, 10 months ago) by william
File length: 25925 byte(s)
Diff to previous 170

Revision 170 - (view) (download) (annotate) - [select for diffs]
Modified Sat Mar 16 14:28:56 2013 UTC (9 years, 10 months ago) by william
File length: 25693 byte(s)
Diff to previous 169

Revision 169 - (view) (download) (annotate) - [select for diffs]
Modified Sat Mar 16 14:04:31 2013 UTC (9 years, 10 months ago) by william
File length: 24444 byte(s)
Diff to previous 168

Revision 168 - (view) (download) (annotate) - [select for diffs]
Modified Sat Mar 16 13:57:41 2013 UTC (9 years, 10 months ago) by william
File length: 25189 byte(s)
Diff to previous 167

Revision 167 - (view) (download) (annotate) - [select for diffs]
Modified Sat Mar 16 13:26:09 2013 UTC (9 years, 10 months ago) by william
File length: 24015 byte(s)
Diff to previous 166

Revision 166 - (view) (download) (annotate) - [select for diffs]
Modified Sat Mar 16 13:16:42 2013 UTC (9 years, 10 months ago) by william
File length: 23601 byte(s)
Diff to previous 165

Revision 165 - (view) (download) (annotate) - [select for diffs]
Modified Fri Mar 15 17:33:15 2013 UTC (9 years, 10 months ago) by william
File length: 22366 byte(s)
Diff to previous 164

Revision 164 - (view) (download) (annotate) - [select for diffs]
Modified Fri Mar 15 16:57:50 2013 UTC (9 years, 10 months ago) by william
File length: 21481 byte(s)
Diff to previous 163
+ when filtering GBPVR programs by date-range, generate a list of programs that were filtered-out

Revision 163 - (view) (download) (annotate) - [select for diffs]
Modified Fri Mar 15 16:53:40 2013 UTC (9 years, 10 months ago) by william
File length: 21107 byte(s)
Diff to previous 159
+ filter GBPVR Programs to match the date-range of the XMLTV Programs list

Revision 159 - (view) (download) (annotate) - [select for diffs]
Modified Thu Mar 14 20:26:05 2013 UTC (9 years, 10 months ago) by william
File length: 18620 byte(s)
Diff to previous 157

Revision 157 - (view) (download) (annotate) - [select for diffs]
Modified Thu Mar 14 19:36:01 2013 UTC (9 years, 10 months ago) by william
File length: 15521 byte(s)
Diff to previous 156

Revision 156 - (view) (download) (annotate) - [select for diffs]
Added Thu Mar 14 19:25:17 2013 UTC (9 years, 10 months ago) by william
File length: 14678 byte(s)

Convenience Links

Links to HEAD: (view) (download) (annotate)

Compare Revisions

This form allows you to request diffs between any two revisions of this file. For each of the two "sides" of the diff, enter a numeric revision.

  Diffs between and
  Type of Diff should be a