Skip to content
GitLab
Projects Groups Snippets
  • /
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in / Register
  • T torque-postgresql
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 6
    • Issues 6
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 1
    • Merge requests 1
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Packages and registries
    • Packages and registries
    • Package Registry
    • Infrastructure Registry
  • Monitor
    • Monitor
    • Incidents
  • Analytics
    • Analytics
    • Value stream
    • CI/CD
    • Repository
  • Wiki
    • Wiki
  • Snippets
    • Snippets
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar
  • Carlos
  • torque-postgresql
  • Wiki
  • TODO

TODO · Changes

Page history
Updated TODO (markdown) authored Aug 14, 2018 by Carlos's avatar Carlos
Hide whitespace changes
Inline Side-by-side
TODO.md
View page @ 05b6a89e
...@@ -60,6 +60,9 @@ Following the PostgreSQL features list on [this page](https://www.postgresql.org ...@@ -60,6 +60,9 @@ Following the PostgreSQL features list on [this page](https://www.postgresql.org
- [ ] DOCS!!! - [ ] DOCS!!!
- [ ] Auxiliary Statements - [ ] Auxiliary Statements
- [ ] Table Inheritance - [ ] Table Inheritance
- [ ] Dynamic Attribute
- [x] Dynamic Attribute
- [x] Create a way to manually load CTE data
- [x] CTE queries (auxiliary statements) - [x] CTE queries (auxiliary statements)
- [x] Improve performance by saving `@base_table ||= base_table` and `@query_table ||= query_table` - [x] Improve performance by saving `@base_table ||= base_table` and `@query_table ||= query_table`
- [x] Allow access to `table` and `table_name` from the class scope - [x] Allow access to `table` and `table_name` from the class scope
...@@ -67,7 +70,8 @@ Following the PostgreSQL features list on [this page](https://www.postgresql.org ...@@ -67,7 +70,8 @@ Following the PostgreSQL features list on [this page](https://www.postgresql.org
- [x] Allows `select: {column: :expose}` extra option to `with` command - [x] Allows `select: {column: :expose}` extra option to `with` command
- [x] Allows `join: {column: :cte_column}` to do extra filters when using `with` command - [x] Allows `join: {column: :cte_column}` to do extra filters when using `with` command
- [x] Allows `cte.polymorphic 'name'` so it can identify both id and type columns - [x] Allows `cte.polymorphic 'name'` so it can identify both id and type columns
- [x] Accept Proc as query when configuring the CTE, but asks the source table Class or Name - [x] Allows `requires` setting to create dependecy between CTEs
- [x] Accept Proc as the query when configuring the CTE, but asks the source table Class or Name
- [x] Allows query to be a string too - [x] Allows query to be a string too
- [x] Allows `with` to receive extra parameters and send to the Proc or format the string with `%` - [x] Allows `with` to receive extra parameters and send to the Proc or format the string with `%`
- [x] Table Inheritance [DOCS](https://www.postgresql.org/docs/9.1/static/ddl-inherit.html) - [x] Table Inheritance [DOCS](https://www.postgresql.org/docs/9.1/static/ddl-inherit.html)
...@@ -78,10 +82,10 @@ Following the PostgreSQL features list on [this page](https://www.postgresql.org ...@@ -78,10 +82,10 @@ Following the PostgreSQL features list on [this page](https://www.postgresql.org
- [x] Relation method `only` to affect the FROM operator - [x] Relation method `only` to affect the FROM operator
- [x] Identify inherited models using `physically_inherited?` - [x] Identify inherited models using `physically_inherited?`
- [x] Create a method to identify all possible child tables - [x] Create a method to identify all possible child tables
- [ ] Associate this information for each individual connection - [x] Associate this information for each individual connection
- [ ] Method to correctly cast the records - [x] Method to correctly cast the records
- [ ] Cast a single record - [x] Cast a single record
- [ ] Cast multiple records (use a relation function and association) - [x] Cast multiple records
## next versions ## next versions
...@@ -90,7 +94,11 @@ Following the PostgreSQL features list on [this page](https://www.postgresql.org ...@@ -90,7 +94,11 @@ Following the PostgreSQL features list on [this page](https://www.postgresql.org
- [ ] Table Inheritance - [ ] Table Inheritance
- [ ] Enum - [ ] Enum
- [ ] Composite - [ ] Composite
- [ ] Dynamic Attribute
- [ ] Load one or more attributes with the same query
- [ ] CTE queries (auxiliary statements) - [ ] CTE queries (auxiliary statements)
- [ ] Identify conflicting table names during `merge` and add a new alias
- [ ] Accept Arel::SelectManager as the query when configuring the CTE
- [x] Allows `requires` setting to create dependecy between CTEs - [x] Allows `requires` setting to create dependecy between CTEs
- [ ] Create a subclass from ActiveRecord::Relation for internal references - [ ] Create a subclass from ActiveRecord::Relation for internal references
- [ ] Turn the dependent into a relation so it could be used on the query - [ ] Turn the dependent into a relation so it could be used on the query
...@@ -100,8 +108,8 @@ Following the PostgreSQL features list on [this page](https://www.postgresql.org ...@@ -100,8 +108,8 @@ Following the PostgreSQL features list on [this page](https://www.postgresql.org
- [ ] Enables `path` - [ ] Enables `path`
- [ ] Enables `depth` - [ ] Enables `depth`
- [ ] Table Inheritance - [ ] Table Inheritance
- [ ] Create a method `type` that can identify the model that created that entry - [ ] Load only extras columns for `cast_inheritance`
- [ ] Create a method `typed` that gets the entry as the model that created it - [ ] Calculate the columns that need to be used as attributes for `discriminate_class_for_record`
- [ ] Enum - [ ] Enum
- [ ] Allow generator to postgre cast enum to integer [DOCS](http://stackoverflow.com/a/12347716/7321983) - [ ] Allow generator to postgre cast enum to integer [DOCS](http://stackoverflow.com/a/12347716/7321983)
- [ ] Accept `pluralize: true` and `singularize: true` to create the enum methods - [ ] Accept `pluralize: true` and `singularize: true` to create the enum methods
......
Clone repository
  • Wiki
  • Configuring

Data types

  • Enum
  • Interval

Querying

  • Distinct On
  • Auxiliary Statements