active_data_frame/active_data_frame.todo at master · wouterken/active_data_frame · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
Priorities:
  ☐ Ensure delete/clear works
  ☐ rmatrix tests
  ☐ Update README.md
  ☐ Support SQLite + MySQL, MonetDB

  ✔ Use MMAP of status/enums @done (18-04-03 19:21)
 ✔ Generator creates A migration and data_frame and block classes. Block/DataFrame classes have a type, a period unit and a period length @done (17-01-12 10:29)
 ✔ Type is: @done (17-01-12 10:29)
   ✔ Bit @done (17-01-12 10:29)
   ✔ Short @done (17-01-12 10:29)
   ✔ Int @done (17-01-12 10:29)
   ✔ Long @done (17-01-12 10:29)
   ✔ Float @done (17-01-12 10:29)
   ✔ Double @done (17-01-12 10:29)

 ✔ Insert useful metadata into block type class. @done (17-01-12 19:43)
   ✔ Number of columns @done (17-01-12 19:43)
   ✔ Column getters @done (17-01-12 19:43)
   ✔ Column setters @done (17-01-12 19:43)
   ✔ Select SQL @done (17-01-12 19:43)

 ✔ DataBlock and DataDataFrame provides: @done (17-01-12 19:43)
   ✔ #[] @done (17-01-12 19:43)
   ✔ #[]= @done (17-01-12 19:43)
   ✔ #self.matrix(columns:, *time, period_unit: period_length: default derive from first) @done (17-01-12 19:43)
   ✔ #self.avg @done (17-01-12 19:43)
   ✔ #self.sum @done (17-01-12 19:43)
   ✔ #self.count_zero @done (17-01-12 19:43)
   ✔ #self.where @done (17-01-12 19:43)
   ✔ #self.max @done (17-01-12 19:43)
   ✔ #self.min @done (17-01-12 19:43)
 ✔ Bulk service can bulk insert and update (Implement for PostgreSQL first) @done (17-01-12 19:43)
 ✔ Time helper service @done (17-01-12 19:43)

 Thoughts:
   ✔ Can extract non-contiguous columns at once (Optimise) @done (17-01-14 09:40)
   ✔ Extract doesn't use from, count. Use either: @done (17-01-14 09:40)
         ✔ [from..to] @done (17-01-14 09:40)
         ✔ [from1, from2, from3] @done (17-01-14 09:40)
 ✔ Class can define column mapper array (create reverse object to index hash from this) @done (17-01-14 21:46)
 ✔ Column mapper function is used in column_mapper for results @done (17-01-14 21:46)
 ✔ Row mapper will translate ActiveRecord items to indices @done (17-01-14 21:46)
 ✔ Add column and row maps to results @done (17-01-14 21:46)

✔ Add where queries based on column names. @done (17-01-16 09:21)
   ✔ E.g @done (17-01-16 09:21)
      ✔ Iris.where(Iris.columns.sepal_length == 3).or(Iris.columns.petal_length < 3) @done (17-01-16 09:21)

✔ Rename to active data frame @done (17-01-24 18:28)
✔ Add option to name columns and rows RMatrix (For printing) @done (17-02-27 09:20)
✔ Finish RMatrix @done (17-03-02 09:01)

RMatrix:
   ✔ Ensure assignment works @done (18-04-03 18:58)
   ✔ Raw is simply a copy of self without mappings @done (18-04-03 18:58)
ActiveDataFrame:
    ✔ dimensions_minimum @done (18-04-03 18:58)
    ✔ dimensions_maximum @done (18-04-03 18:58)
    ✔ dimensions_sum @done (18-04-03 18:58)
    ✔ dimensions_average @done (18-04-03 18:58)