/Raven.Database/Storage/Esent/SchemaUpdates/Updates/From37To38.cs

https://github.com/samueldjack/ravendb · C# · 282 lines · 242 code · 35 blank · 5 comment · 0 complexity · b4933ad23d80831e582b7ff769c2600f MD5 · raw file 

    

  1. // -----------------------------------------------------------------------

    2. 

  2. //  <copyright file="From37To38.cs" company="Hibernating Rhinos LTD">

    3. 

  3. //      Copyright (c) Hibernating Rhinos LTD. All rights reserved.

    4. 

  4. //  </copyright>

    5. 

  5. // -----------------------------------------------------------------------

    6. 

  6. using Microsoft.Isam.Esent.Interop;

    7. 

  7. using Raven.Database.Impl;

    8. 

  8. 

    9. 

  9. namespace Raven.Storage.Esent.SchemaUpdates.Updates

    10. 

  10. {

    11. 

  11. 	public class From37To38 : ISchemaUpdate

    12. 

  12. 	{

    13. 

  13. 		public string FromSchemaVersion { get { return "3.7"; } }

    14. 

  14. 

    15. 

  15. 		public void Init(IUuidGenerator generator)

    16. 

  16. 		{

    17. 

  17. 		}

    18. 

  18. 

    19. 

  19. 		public void Update(Session session, JET_DBID dbid)

    20. 

  20. 		{

    21. 

  21. 			Api.JetDeleteTable(session, dbid, "mapped_results"); // just kill the old table, we won't use the data anyway

    22. 

  22. 			CreateMapResultsTable(session, dbid);

    23. 

  23. 			CreateReduceResultsTable(session, dbid);

    24. 

  24. 			CreateScheduledReductionsTable(session, dbid);

    25. 

  25. 			SchemaCreator.UpdateVersion(session, dbid, "3.8");

    26. 

  26. 		}

    27. 

  27. 

    28. 

  28. 

    29. 

  29. 		private void CreateScheduledReductionsTable(Session session, JET_DBID dbid)

    30. 

  30. 		{

    31. 

  31. 			JET_TABLEID tableid;

    32. 

  32. 			Api.JetCreateTable(session, dbid, "scheduled_reductions", 1, 80, out tableid);

    33. 

  33. 			JET_COLUMNID columnid;

    34. 

  34. 

    35. 

  35. 			Api.JetAddColumn(session, tableid, "id", new JET_COLUMNDEF

    36. 

  36. 			{

    37. 

  37. 				coltyp = JET_coltyp.Long,

    38. 

  38. 				grbit = ColumndefGrbit.ColumnFixed | ColumndefGrbit.ColumnAutoincrement | ColumndefGrbit.ColumnNotNULL

    39. 

  39. 			}, null, 0, out columnid);

    40. 

  40. 

    41. 

  41. 			Api.JetAddColumn(session, tableid, "view", new JET_COLUMNDEF

    42. 

  42. 			{

    43. 

  43. 				cbMax = 2048,

    44. 

  44. 				coltyp = JET_coltyp.LongText,

    45. 

  45. 				cp = JET_CP.Unicode,

    46. 

  46. 				grbit = SchemaCreator.ColumnNotNullIfOnHigherThanWindowsXp()

    47. 

  47. 			}, null, 0, out columnid);

    48. 

  48. 

    49. 

  49. 			Api.JetAddColumn(session, tableid, "reduce_key", new JET_COLUMNDEF

    50. 

  50. 			{

    51. 

  51. 				coltyp = JET_coltyp.LongText,

    52. 

  52. 				cp = JET_CP.Unicode,

    53. 

  53. 				grbit = SchemaCreator.ColumnNotNullIfOnHigherThanWindowsXp()

    54. 

  54. 			}, null, 0, out columnid);

    55. 

  55. 

    56. 

  56. 			Api.JetAddColumn(session, tableid, "etag", new JET_COLUMNDEF

    57. 

  57. 			{

    58. 

  58. 				cbMax = 16,

    59. 

  59. 				coltyp = JET_coltyp.Binary,

    60. 

  60. 				grbit = ColumndefGrbit.ColumnNotNULL | ColumndefGrbit.ColumnFixed

    61. 

  61. 			}, null, 0, out columnid);

    62. 

  62. 

    63. 

  63. 			Api.JetAddColumn(session, tableid, "timestamp", new JET_COLUMNDEF

    64. 

  64. 			{

    65. 

  65. 				coltyp = JET_coltyp.DateTime,

    66. 

  66. 				grbit = ColumndefGrbit.ColumnNotNULL | ColumndefGrbit.ColumnFixed

    67. 

  67. 			}, null, 0, out columnid);

    68. 

  68. 

    69. 

  69. 			Api.JetAddColumn(session, tableid, "bucket", new JET_COLUMNDEF

    70. 

  70. 			{

    71. 

  71. 				coltyp = JET_coltyp.Long,

    72. 

  72. 				grbit = ColumndefGrbit.ColumnFixed | ColumndefGrbit.ColumnNotNULL

    73. 

  73. 			}, null, 0, out columnid);

    74. 

  74. 

    75. 

  75. 			Api.JetAddColumn(session, tableid, "level", new JET_COLUMNDEF

    76. 

  76. 			{

    77. 

  77. 				coltyp = JET_coltyp.Long,

    78. 

  78. 				grbit = ColumndefGrbit.ColumnFixed | ColumndefGrbit.ColumnNotNULL

    79. 

  79. 			}, null, 0, out columnid);

    80. 

  80. 

    81. 

  81. 			SchemaCreator.CreateIndexes(session, tableid,

    82. 

  82. 				new JET_INDEXCREATE

    83. 

  83. 				{

    84. 

  84. 					szIndexName = "by_id",

    85. 

  85. 					szKey = "+id\0\0",

    86. 

  86. 					grbit = CreateIndexGrbit.IndexPrimary

    87. 

  87. 				},

    88. 

  88. 				new JET_INDEXCREATE

    89. 

  89. 				{

    90. 

  90. 					szIndexName = "by_view",

    91. 

  91. 					szKey = "+view\0\0",

    92. 

  92. 					grbit = CreateIndexGrbit.IndexDisallowNull

    93. 

  93. 				},

    94. 

  94. 				new JET_INDEXCREATE

    95. 

  95. 				{

    96. 

  96. 					szIndexName = "by_view_level_reduce_key_and_bucket",

    97. 

  97. 					szKey = "+view\0+level\0+reduce_key\0+bucket\0\0",

    98. 

  98. 				});

    99. 

  99. 		}

    100. 

  100. 

    101. 

  101. 		private void CreateMapResultsTable(Session session, JET_DBID dbid)

    102. 

  102. 		{

    103. 

  103. 			JET_TABLEID tableid;

    104. 

  104. 			Api.JetCreateTable(session, dbid, "mapped_results", 1, 80, out tableid);

    105. 

  105. 			JET_COLUMNID columnid;

    106. 

  106. 

    107. 

  107. 			Api.JetAddColumn(session, tableid, "id", new JET_COLUMNDEF

    108. 

  108. 			{

    109. 

  109. 				coltyp = JET_coltyp.Long,

    110. 

  110. 				grbit = ColumndefGrbit.ColumnFixed | ColumndefGrbit.ColumnAutoincrement | ColumndefGrbit.ColumnNotNULL

    111. 

  111. 			}, null, 0, out columnid);

    112. 

  112. 

    113. 

  113. 			Api.JetAddColumn(session, tableid, "view", new JET_COLUMNDEF

    114. 

  114. 			{

    115. 

  115. 				cbMax = 2048,

    116. 

  116. 				coltyp = JET_coltyp.LongText,

    117. 

  117. 				cp = JET_CP.Unicode,

    118. 

  118. 				grbit = SchemaCreator.ColumnNotNullIfOnHigherThanWindowsXp()

    119. 

  119. 			}, null, 0, out columnid);

    120. 

  120. 

    121. 

  121. 			Api.JetAddColumn(session, tableid, "document_key", new JET_COLUMNDEF

    122. 

  122. 			{

    123. 

  123. 				cbMax = 2048,

    124. 

  124. 				coltyp = JET_coltyp.LongText,

    125. 

  125. 				cp = JET_CP.Unicode,

    126. 

  126. 				grbit = SchemaCreator.ColumnNotNullIfOnHigherThanWindowsXp()

    127. 

  127. 			}, null, 0, out columnid);

    128. 

  128. 

    129. 

  129. 			Api.JetAddColumn(session, tableid, "reduce_key", new JET_COLUMNDEF

    130. 

  130. 			{

    131. 

  131. 				coltyp = JET_coltyp.LongText,

    132. 

  132. 				cp = JET_CP.Unicode,

    133. 

  133. 				grbit = SchemaCreator.ColumnNotNullIfOnHigherThanWindowsXp()

    134. 

  134. 			}, null, 0, out columnid);

    135. 

  135. 

    136. 

  136. 			Api.JetAddColumn(session, tableid, "data", new JET_COLUMNDEF

    137. 

  137. 			{

    138. 

  138. 				coltyp = JET_coltyp.LongBinary,

    139. 

  139. 				grbit = ColumndefGrbit.ColumnTagged

    140. 

  140. 			}, null, 0, out columnid);

    141. 

  141. 

    142. 

  142. 			Api.JetAddColumn(session, tableid, "etag", new JET_COLUMNDEF

    143. 

  143. 			{

    144. 

  144. 				cbMax = 16,

    145. 

  145. 				coltyp = JET_coltyp.Binary,

    146. 

  146. 				grbit = ColumndefGrbit.ColumnNotNULL | ColumndefGrbit.ColumnFixed

    147. 

  147. 			}, null, 0, out columnid);

    148. 

  148. 

    149. 

  149. 			Api.JetAddColumn(session, tableid, "timestamp", new JET_COLUMNDEF

    150. 

  150. 			{

    151. 

  151. 				coltyp = JET_coltyp.DateTime,

    152. 

  152. 				grbit = ColumndefGrbit.ColumnNotNULL | ColumndefGrbit.ColumnFixed

    153. 

  153. 			}, null, 0, out columnid);

    154. 

  154. 

    155. 

  155. 			Api.JetAddColumn(session, tableid, "bucket", new JET_COLUMNDEF

    156. 

  156. 			{

    157. 

  157. 				coltyp = JET_coltyp.Long,

    158. 

  158. 				grbit = ColumndefGrbit.ColumnFixed | ColumndefGrbit.ColumnNotNULL

    159. 

  159. 			}, null, 0, out columnid);

    160. 

  160. 

    161. 

  161. 			SchemaCreator.CreateIndexes(session, tableid,

    162. 

  162. 				new JET_INDEXCREATE

    163. 

  163. 				{

    164. 

  164. 					szIndexName = "by_id",

    165. 

  165. 					szKey = "+id\0\0",

    166. 

  166. 					grbit = CreateIndexGrbit.IndexPrimary

    167. 

  167. 				},

    168. 

  168. 				new JET_INDEXCREATE

    169. 

  169. 				{

    170. 

  170. 					szIndexName = "by_view_and_doc_key",

    171. 

  171. 					szKey = "+view\0+document_key\0\0",

    172. 

  172. 					grbit = CreateIndexGrbit.IndexDisallowNull

    173. 

  173. 				},

    174. 

  174. 				new JET_INDEXCREATE

    175. 

  175. 				{

    176. 

  176. 					szIndexName = "by_view",

    177. 

  177. 					szKey = "+view\0\0",

    178. 

  178. 					grbit = CreateIndexGrbit.IndexDisallowNull

    179. 

  179. 				},

    180. 

  180. 				new JET_INDEXCREATE

    181. 

  181. 				{

    182. 

  182. 					szIndexName = "by_view_and_etag",

    183. 

  183. 					szKey = "+view\0-etag\0\0",

    184. 

  184. 				},

    185. 

  185. 				new JET_INDEXCREATE

    186. 

  186. 				{

    187. 

  187. 					szIndexName = "by_view_reduce_key_and_bucket",

    188. 

  188. 					szKey = "+view\0+reduce_key\0+bucket\0\0",

    189. 

  189. 				});

    190. 

  190. 		}

    191. 

  191. 

    192. 

  192. 		private void CreateReduceResultsTable(Session session, JET_DBID dbid)

    193. 

  193. 		{

    194. 

  194. 			JET_TABLEID tableid;

    195. 

  195. 			Api.JetCreateTable(session, dbid, "reduce_results", 1, 80, out tableid);

    196. 

  196. 			JET_COLUMNID columnid;

    197. 

  197. 

    198. 

  198. 			Api.JetAddColumn(session, tableid, "id", new JET_COLUMNDEF

    199. 

  199. 			{

    200. 

  200. 				coltyp = JET_coltyp.Long,

    201. 

  201. 				grbit = ColumndefGrbit.ColumnFixed | ColumndefGrbit.ColumnAutoincrement | ColumndefGrbit.ColumnNotNULL

    202. 

  202. 			}, null, 0, out columnid);

    203. 

  203. 

    204. 

  204. 			Api.JetAddColumn(session, tableid, "view", new JET_COLUMNDEF

    205. 

  205. 			{

    206. 

  206. 				cbMax = 2048,

    207. 

  207. 				coltyp = JET_coltyp.LongText,

    208. 

  208. 				cp = JET_CP.Unicode,

    209. 

  209. 				grbit = SchemaCreator.ColumnNotNullIfOnHigherThanWindowsXp()

    210. 

  210. 			}, null, 0, out columnid);

    211. 

  211. 

    212. 

  212. 			Api.JetAddColumn(session, tableid, "reduce_key", new JET_COLUMNDEF

    213. 

  213. 			{

    214. 

  214. 				coltyp = JET_coltyp.LongText,

    215. 

  215. 				cp = JET_CP.Unicode,

    216. 

  216. 				grbit = SchemaCreator.ColumnNotNullIfOnHigherThanWindowsXp()

    217. 

  217. 			}, null, 0, out columnid);

    218. 

  218. 

    219. 

  219. 			Api.JetAddColumn(session, tableid, "data", new JET_COLUMNDEF

    220. 

  220. 			{

    221. 

  221. 				coltyp = JET_coltyp.LongBinary,

    222. 

  222. 				grbit = ColumndefGrbit.ColumnTagged

    223. 

  223. 			}, null, 0, out columnid);

    224. 

  224. 

    225. 

  225. 			Api.JetAddColumn(session, tableid, "etag", new JET_COLUMNDEF

    226. 

  226. 			{

    227. 

  227. 				cbMax = 16,

    228. 

  228. 				coltyp = JET_coltyp.Binary,

    229. 

  229. 				grbit = ColumndefGrbit.ColumnNotNULL | ColumndefGrbit.ColumnFixed

    230. 

  230. 			}, null, 0, out columnid);

    231. 

  231. 

    232. 

  232. 			Api.JetAddColumn(session, tableid, "timestamp", new JET_COLUMNDEF

    233. 

  233. 			{

    234. 

  234. 				coltyp = JET_coltyp.DateTime,

    235. 

  235. 				grbit = ColumndefGrbit.ColumnNotNULL | ColumndefGrbit.ColumnFixed

    236. 

  236. 			}, null, 0, out columnid);

    237. 

  237. 

    238. 

  238. 			Api.JetAddColumn(session, tableid, "bucket", new JET_COLUMNDEF

    239. 

  239. 			{

    240. 

  240. 				coltyp = JET_coltyp.Long,

    241. 

  241. 				grbit = ColumndefGrbit.ColumnFixed | ColumndefGrbit.ColumnNotNULL

    242. 

  242. 			}, null, 0, out columnid);

    243. 

  243. 

    244. 

  244. 			Api.JetAddColumn(session, tableid, "source_bucket", new JET_COLUMNDEF

    245. 

  245. 			{

    246. 

  246. 				coltyp = JET_coltyp.Long,

    247. 

  247. 				grbit = ColumndefGrbit.ColumnFixed | ColumndefGrbit.ColumnNotNULL

    248. 

  248. 			}, null, 0, out columnid);

    249. 

  249. 

    250. 

  250. 			Api.JetAddColumn(session, tableid, "level", new JET_COLUMNDEF

    251. 

  251. 			{

    252. 

  252. 				coltyp = JET_coltyp.Long,

    253. 

  253. 				grbit = ColumndefGrbit.ColumnFixed | ColumndefGrbit.ColumnNotNULL

    254. 

  254. 			}, null, 0, out columnid);

    255. 

  255. 

    256. 

  256. 			SchemaCreator.CreateIndexes(session, tableid,

    257. 

  257. 						  new JET_INDEXCREATE

    258. 

  258. 						  {

    259. 

  259. 							  szIndexName = "by_id",

    260. 

  260. 							  szKey = "+id\0\0",

    261. 

  261. 							  grbit = CreateIndexGrbit.IndexPrimary

    262. 

  262. 						  },

    263. 

  263. 						  new JET_INDEXCREATE

    264. 

  264. 						  {

    265. 

  265. 							  szIndexName = "by_view",

    266. 

  266. 							  szKey = "+view\0\0",

    267. 

  267. 							  grbit = CreateIndexGrbit.IndexDisallowNull

    268. 

  268. 						  },

    269. 

  269. 						  new JET_INDEXCREATE

    270. 

  270. 						  {

    271. 

  271. 							  szIndexName = "by_view_level_reduce_key_and_bucket",

    272. 

  272. 							  szKey = "+view\0+level\0+reduce_key\0+bucket\0\0",

    273. 

  273. 						  },

    274. 

  274. 						  new JET_INDEXCREATE

    275. 

  275. 						  {

    276. 

  276. 							  szIndexName = "by_view_level_reduce_key_and_source_bucket",

    277. 

  277. 							  szKey = "+view\0+level\0+reduce_key\0+source_bucket\0\0",

    278. 

  278. 						  });

    279. 

  279. 		}

    280. 

  280. 

    281. 

  281. 	}

    282. 

  282. }
    283.