helpers.go 9.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377
  1. package gocql
  2. func ptrOfType(t *TypeInfo) interface{} {
  3. switch t.Type {
  4. case TypeVarchar, TypeAscii:
  5. return new(string)
  6. case TypeBigInt, TypeCounter, TypeTimestamp:
  7. return new(int64)
  8. case TypeBlob:
  9. return new([]byte)
  10. case TypeBoolean:
  11. return new(bool)
  12. case TypeFloat:
  13. return new(float32)
  14. case TypeDouble:
  15. return new(float64)
  16. case TypeInt:
  17. return new(int32)
  18. case TypeUUID, TypeTimeUUID:
  19. return new(UUID)
  20. case TypeList, TypeSet:
  21. switch t.Elem.Type {
  22. case TypeVarchar, TypeAscii:
  23. return new([]string)
  24. case TypeBigInt, TypeCounter, TypeTimestamp:
  25. return new([]int64)
  26. case TypeBlob:
  27. return new([][]byte)
  28. case TypeBoolean:
  29. return new([]bool)
  30. case TypeFloat:
  31. return new([]float32)
  32. case TypeDouble:
  33. return new([]float64)
  34. case TypeInt:
  35. return new([]int32)
  36. case TypeUUID, TypeTimeUUID:
  37. return new([]UUID)
  38. }
  39. return new([][]byte)
  40. case TypeMap:
  41. switch t.Key.Type {
  42. case TypeVarchar, TypeAscii:
  43. switch t.Elem.Type {
  44. case TypeVarchar, TypeAscii:
  45. return new(map[string]string)
  46. case TypeBigInt, TypeCounter, TypeTimestamp:
  47. return new(map[string]int64)
  48. case TypeBlob:
  49. return new(map[string][]byte)
  50. case TypeBoolean:
  51. return new(map[string]bool)
  52. case TypeFloat:
  53. return new(map[string]float32)
  54. case TypeDouble:
  55. return new(map[string]float64)
  56. case TypeInt:
  57. return new(map[string]int32)
  58. case TypeUUID, TypeTimeUUID:
  59. return new(map[string]UUID)
  60. }
  61. case TypeBigInt, TypeCounter, TypeTimestamp:
  62. switch t.Elem.Type {
  63. case TypeVarchar, TypeAscii:
  64. return new(map[int64]string)
  65. case TypeBigInt, TypeCounter, TypeTimestamp:
  66. return new(map[int64]int64)
  67. case TypeBlob:
  68. return new(map[int64][]byte)
  69. case TypeBoolean:
  70. return new(map[int64]bool)
  71. case TypeFloat:
  72. return new(map[int64]float32)
  73. case TypeDouble:
  74. return new(map[int64]float64)
  75. case TypeInt:
  76. return new(map[int64]int32)
  77. case TypeUUID, TypeTimeUUID:
  78. return new(map[int64]UUID)
  79. }
  80. case TypeBlob:
  81. switch t.Elem.Type {
  82. case TypeVarchar, TypeAscii:
  83. return new(map[string]string)
  84. case TypeBigInt, TypeCounter, TypeTimestamp:
  85. return new(map[string]int64)
  86. case TypeBlob:
  87. return new(map[string][]byte)
  88. case TypeBoolean:
  89. return new(map[string]bool)
  90. case TypeFloat:
  91. return new(map[string]float32)
  92. case TypeDouble:
  93. return new(map[string]float64)
  94. case TypeInt:
  95. return new(map[string]int32)
  96. case TypeUUID, TypeTimeUUID:
  97. return new(map[string]UUID)
  98. }
  99. case TypeBoolean:
  100. switch t.Elem.Type {
  101. case TypeVarchar, TypeAscii:
  102. return new(map[bool]string)
  103. case TypeBigInt, TypeCounter, TypeTimestamp:
  104. return new(map[bool]int64)
  105. case TypeBlob:
  106. return new(map[bool][]byte)
  107. case TypeBoolean:
  108. return new(map[bool]bool)
  109. case TypeFloat:
  110. return new(map[bool]float32)
  111. case TypeDouble:
  112. return new(map[bool]float64)
  113. case TypeInt:
  114. return new(map[bool]int32)
  115. case TypeUUID, TypeTimeUUID:
  116. return new(map[bool]UUID)
  117. }
  118. case TypeFloat:
  119. switch t.Elem.Type {
  120. case TypeVarchar, TypeAscii:
  121. return new(map[float32]string)
  122. case TypeBigInt, TypeCounter, TypeTimestamp:
  123. return new(map[float32]int64)
  124. case TypeBlob:
  125. return new(map[float32][]byte)
  126. case TypeBoolean:
  127. return new(map[float32]bool)
  128. case TypeFloat:
  129. return new(map[float32]float32)
  130. case TypeDouble:
  131. return new(map[float32]float64)
  132. case TypeInt:
  133. return new(map[float32]int32)
  134. case TypeUUID, TypeTimeUUID:
  135. return new(map[float32]UUID)
  136. }
  137. case TypeDouble:
  138. switch t.Elem.Type {
  139. case TypeVarchar, TypeAscii:
  140. return new(map[float64]string)
  141. case TypeBigInt, TypeCounter, TypeTimestamp:
  142. return new(map[float64]int64)
  143. case TypeBlob:
  144. return new(map[float64][]byte)
  145. case TypeBoolean:
  146. return new(map[float64]bool)
  147. case TypeFloat:
  148. return new(map[float64]float32)
  149. case TypeDouble:
  150. return new(map[float64]float64)
  151. case TypeInt:
  152. return new(map[float64]int32)
  153. case TypeUUID, TypeTimeUUID:
  154. return new(map[float64]UUID)
  155. }
  156. case TypeInt:
  157. switch t.Elem.Type {
  158. case TypeVarchar, TypeAscii:
  159. return new(map[int32]string)
  160. case TypeBigInt, TypeCounter, TypeTimestamp:
  161. return new(map[int32]int64)
  162. case TypeBlob:
  163. return new(map[int32][]byte)
  164. case TypeBoolean:
  165. return new(map[int32]bool)
  166. case TypeFloat:
  167. return new(map[int32]float32)
  168. case TypeDouble:
  169. return new(map[int32]float64)
  170. case TypeInt:
  171. return new(map[int32]int32)
  172. case TypeUUID, TypeTimeUUID:
  173. return new(map[int32]UUID)
  174. }
  175. case TypeUUID, TypeTimeUUID:
  176. switch t.Elem.Type {
  177. case TypeVarchar, TypeAscii:
  178. return new(map[UUID]string)
  179. case TypeBigInt, TypeCounter, TypeTimestamp:
  180. return new(map[UUID]int64)
  181. case TypeBlob:
  182. return new(map[UUID][]byte)
  183. case TypeBoolean:
  184. return new(map[UUID]bool)
  185. case TypeFloat:
  186. return new(map[UUID]float32)
  187. case TypeDouble:
  188. return new(map[UUID]float64)
  189. case TypeInt:
  190. return new(map[UUID]int32)
  191. case TypeUUID, TypeTimeUUID:
  192. return new(map[UUID]UUID)
  193. }
  194. }
  195. default:
  196. return new([]byte)
  197. }
  198. return new(map[string]string)
  199. }
  200. func dereference(i interface{}) interface{} {
  201. switch i.(type) {
  202. case *string:
  203. return *i.(*string)
  204. case *int64:
  205. return *i.(*int64)
  206. case *[]byte:
  207. return *i.(*[]byte)
  208. case *bool:
  209. return *i.(*bool)
  210. case *float32:
  211. return *i.(*float32)
  212. case *float64:
  213. return *i.(*float64)
  214. case *int32:
  215. return *i.(*int32)
  216. case *UUID:
  217. return *i.(*UUID)
  218. case *[]string:
  219. return *i.(*[]string)
  220. case *[]int64:
  221. return *i.(*[]int64)
  222. case *[][]byte:
  223. return *i.(*[][]byte)
  224. case *[]bool:
  225. return *i.(*[]bool)
  226. case *[]float32:
  227. return *i.(*[]float32)
  228. case *[]float64:
  229. return *i.(*[]float64)
  230. case *[]int32:
  231. return *i.(*[]int32)
  232. case *[]UUID:
  233. return *i.(*[]UUID)
  234. case *map[string]string:
  235. return *i.(*map[string]string)
  236. case *map[string]int64:
  237. return *i.(*map[string]int64)
  238. case *map[string][]byte:
  239. return *i.(*map[string][]byte)
  240. case *map[string]bool:
  241. return *i.(*map[string]bool)
  242. case *map[string]float32:
  243. return *i.(*map[string]float32)
  244. case *map[string]float64:
  245. return *i.(*map[string]float64)
  246. case *map[string]int32:
  247. return *i.(*map[string]int32)
  248. case *map[string]UUID:
  249. return *i.(*map[string]UUID)
  250. case *map[int64]string:
  251. return *i.(*map[int64]string)
  252. case *map[int64]int64:
  253. return *i.(*map[int64]int64)
  254. case *map[int64][]byte:
  255. return *i.(*map[int64][]byte)
  256. case *map[int64]bool:
  257. return *i.(*map[int64]bool)
  258. case *map[int64]float32:
  259. return *i.(*map[int64]float32)
  260. case *map[int64]float64:
  261. return *i.(*map[int64]float64)
  262. case *map[int64]int32:
  263. return *i.(*map[int64]int32)
  264. case *map[int64]UUID:
  265. return *i.(*map[int64]UUID)
  266. case *map[bool]string:
  267. return *i.(*map[bool]string)
  268. case *map[bool]int64:
  269. return *i.(*map[bool]int64)
  270. case *map[bool][]byte:
  271. return *i.(*map[bool][]byte)
  272. case *map[bool]bool:
  273. return *i.(*map[bool]bool)
  274. case *map[bool]float32:
  275. return *i.(*map[bool]float32)
  276. case *map[bool]float64:
  277. return *i.(*map[bool]float64)
  278. case *map[bool]int32:
  279. return *i.(*map[bool]int32)
  280. case *map[bool]UUID:
  281. return *i.(*map[bool]UUID)
  282. case *map[float32]string:
  283. return *i.(*map[float32]string)
  284. case *map[float32]int64:
  285. return *i.(*map[float32]int64)
  286. case *map[float32][]byte:
  287. return *i.(*map[float32][]byte)
  288. case *map[float32]bool:
  289. return *i.(*map[float32]bool)
  290. case *map[float32]float32:
  291. return *i.(*map[float32]float32)
  292. case *map[float32]float64:
  293. return *i.(*map[float32]float64)
  294. case *map[float32]int32:
  295. return *i.(*map[float32]int32)
  296. case *map[float32]UUID:
  297. return *i.(*map[float32]UUID)
  298. case *map[float64]string:
  299. return *i.(*map[float64]string)
  300. case *map[float64]int64:
  301. return *i.(*map[float64]int64)
  302. case *map[float64][]byte:
  303. return *i.(*map[float64][]byte)
  304. case *map[float64]bool:
  305. return *i.(*map[float64]bool)
  306. case *map[float64]float32:
  307. return *i.(*map[float64]float32)
  308. case *map[float64]float64:
  309. return *i.(*map[float64]float64)
  310. case *map[float64]int32:
  311. return *i.(*map[float64]int32)
  312. case *map[float64]UUID:
  313. return *i.(*map[float64]UUID)
  314. case *map[int32]string:
  315. return *i.(*map[int32]string)
  316. case *map[int32]int64:
  317. return *i.(*map[int32]int64)
  318. case *map[int32][]byte:
  319. return *i.(*map[int32][]byte)
  320. case *map[int32]bool:
  321. return *i.(*map[int32]bool)
  322. case *map[int32]float32:
  323. return *i.(*map[int32]float32)
  324. case *map[int32]float64:
  325. return *i.(*map[int32]float64)
  326. case *map[int32]int32:
  327. return *i.(*map[int32]int32)
  328. case *map[int32]UUID:
  329. return *i.(*map[int32]UUID)
  330. case *map[UUID]string:
  331. return *i.(*map[UUID]string)
  332. case *map[UUID]int64:
  333. return *i.(*map[UUID]int64)
  334. case *map[UUID][]byte:
  335. return *i.(*map[UUID][]byte)
  336. case *map[UUID]bool:
  337. return *i.(*map[UUID]bool)
  338. case *map[UUID]float32:
  339. return *i.(*map[UUID]float32)
  340. case *map[UUID]float64:
  341. return *i.(*map[UUID]float64)
  342. case *map[UUID]int32:
  343. return *i.(*map[UUID]int32)
  344. case *map[UUID]UUID:
  345. return *i.(*map[UUID]UUID)
  346. default:
  347. return i
  348. }
  349. }
  350. // SliceMap is a helper function to make the API easier to use
  351. // returns the data from the query in the form of []map[string]interface{}
  352. func (iter *Iter) SliceMap() ([]map[string]interface{}, error) {
  353. if iter.err != nil {
  354. return nil, iter.err
  355. }
  356. interfacesToScan := make([]interface{}, 0)
  357. for _, column := range iter.Columns() {
  358. i := ptrOfType(column.TypeInfo)
  359. interfacesToScan = append(interfacesToScan, i)
  360. }
  361. dataToReturn := make([]map[string]interface{}, 0)
  362. for iter.Scan(interfacesToScan...) {
  363. m := make(map[string]interface{})
  364. for i, column := range iter.Columns() {
  365. m[column.Name] = dereference(interfacesToScan[i])
  366. }
  367. dataToReturn = append(dataToReturn, m)
  368. }
  369. if iter.err != nil {
  370. return nil, iter.err
  371. }
  372. return dataToReturn, nil
  373. }