DBGrep issueshttps://gitlab.mi.hdm-stuttgart.de/sol-to-the-moon/dbgrep/-/issues2022-02-27T15:16:46+01:00https://gitlab.mi.hdm-stuttgart.de/sol-to-the-moon/dbgrep/-/issues/9Implement Postgres SQL2022-02-27T15:16:46+01:00Müller MarcImplement Postgres SQLWe need to implement scheme selectionWe need to implement scheme selectionhttps://gitlab.mi.hdm-stuttgart.de/sol-to-the-moon/dbgrep/-/issues/5builder2021-11-17T12:31:16+01:00Ennen Chris-RobinbuilderImplement a query builder on top of the client.
See [this stackoverflow post](https://stackoverflow.com/a/54431309/16681067) for info on how to properly do case-insensitive text search in SQL by using the `COLLATE` keyword. _Note: Coll...Implement a query builder on top of the client.
See [this stackoverflow post](https://stackoverflow.com/a/54431309/16681067) for info on how to properly do case-insensitive text search in SQL by using the `COLLATE` keyword. _Note: Collate is not avaialble in knexQuerry builder_
**Regex in the different Databases:**
- MySql: Use REGEXP statement, example: `WHERE aut_name REGEXP '^w';`
- Potgres: LIKE opperator should do it, but better is: ~ see:[this post](https://kb.objectrocket.com/postgresql/how-to-use-regex-in-postgresql-572)
- SQLLite3: Regex is not by default in SQLLite3. _"It defines a REGEXP operator, but this will fail with an error message unless you or your framework define a user function called regexp()"_ [see this post](https://stackoverflow.com/a/8244670)https://gitlab.mi.hdm-stuttgart.de/sol-to-the-moon/dbgrep/-/issues/1CLI args2021-11-10T11:37:30+01:00Ennen Chris-RobinCLI argsImplement the user input interface using [yargs](https://yargs.js.org/).
This should implement all options defined in REQ-1.Implement the user input interface using [yargs](https://yargs.js.org/).
This should implement all options defined in REQ-1.Müller MarcMüller Marchttps://gitlab.mi.hdm-stuttgart.de/sol-to-the-moon/dbgrep/-/issues/2DB connection2021-10-30T18:29:15+02:00Ennen Chris-RobinDB connectionImplement a client for connecting to all databases using [knex](https://knexjs.org/).
The actual implementation should be abstracted away to return a fitting connector based on CLI input parameters.Implement a client for connecting to all databases using [knex](https://knexjs.org/).
The actual implementation should be abstracted away to return a fitting connector based on CLI input parameters.Ennen Chris-RobinEnnen Chris-Robinhttps://gitlab.mi.hdm-stuttgart.de/sol-to-the-moon/dbgrep/-/issues/4TS Doc2021-10-27T17:24:57+02:00Ennen Chris-RobinTS DocIntroduce [TSDoc](https://tsdoc.org/) to generate documentation.Introduce [TSDoc](https://tsdoc.org/) to generate documentation.Ennen Chris-RobinEnnen Chris-Robinhttps://gitlab.mi.hdm-stuttgart.de/sol-to-the-moon/dbgrep/-/issues/3CI/CD2021-10-27T11:10:41+02:00Ennen Chris-RobinCI/CDUse gitlab workflows for CI/CD.Use gitlab workflows for CI/CD.