py-linq-sql merge requestshttps://gitlab.obspm.fr/exoplanet/py-linq-sql/-/merge_requests2022-02-15T16:55:29+01:00https://gitlab.obspm.fr/exoplanet/py-linq-sql/-/merge_requests/1FIRST MR : Add class to strucutre the command and basic function2022-02-15T16:55:29+01:00Chosson Ulysseulysse.chosson@obspm.frFIRST MR : Add class to strucutre the command and basic function## [0.11.0] - 2022-02-10
### Added
- Add the `execute()` function to execute a command of a Request objects.
- Add the `min()` function to generate the MIN subcommand of a request.
- Add the `max()` function to generate the MAX subcomman...## [0.11.0] - 2022-02-10
### Added
- Add the `execute()` function to execute a command of a Request objects.
- Add the `min()` function to generate the MIN subcommand of a request.
- Add the `max()` function to generate the MAX subcommand of a request.
- Add the `aand()` function to generate the ADD subcommand of a request.
- Add the `where()` function to generate the WHERE subcommand of a request.
- Add the `ffrom()` function to generate the FROM subcommand of a request.
- Add the `select()` function to generate the SELECT subcommand of a request.
- Add operator function (gt, lt, ge, le, eq, ne) to get the correct operator for quest like : name = "toto" or mass > 50.
- Add class `Request`, `_Command`, `_CommandType` and `MagicDotPath` to construct the request command.
- Add function to close a connection to a database.
- Add functions to connect and get cursor to a data base.https://gitlab.obspm.fr/exoplanet/py-linq-sql/-/merge_requests/2Feature first test2022-02-16T17:45:47+01:00Chosson Ulysseulysse.chosson@obspm.frFeature first test## [0.12.0] - 2022-02-10
### Added
- Add test for the already implemented functions## [0.12.0] - 2022-02-10
### Added
- Add test for the already implemented functionshttps://gitlab.obspm.fr/exoplanet/py-linq-sql/-/merge_requests/3Feature add2022-02-18T12:44:04+01:00Chosson Ulysseulysse.chosson@obspm.frFeature add# [0.13.0] - 2022-02-11
### Added
- Add the `add()` function to generate the INSERT INTO subcommand of a request.# [0.13.0] - 2022-02-11
### Added
- Add the `add()` function to generate the INSERT INTO subcommand of a request.https://gitlab.obspm.fr/exoplanet/py-linq-sql/-/merge_requests/4Feature order by2022-02-18T12:48:50+01:00Chosson Ulysseulysse.chosson@obspm.frFeature order by## [0.15.0] - 2022-02-14
### Added
- Add the `order_by_descending()` function to generate the ORDER_BY [criteria] DESC subcommand of a request.
- Add the `order_by()` function to generate the ORDER_BY [criteria] ASC subcommand of a request.## [0.15.0] - 2022-02-14
### Added
- Add the `order_by_descending()` function to generate the ORDER_BY [criteria] DESC subcommand of a request.
- Add the `order_by()` function to generate the ORDER_BY [criteria] ASC subcommand of a request.https://gitlab.obspm.fr/exoplanet/py-linq-sql/-/merge_requests/5Refactoring new struct2022-02-18T13:33:26+01:00Chosson Ulysseulysse.chosson@obspm.frRefactoring new struct## [0.26.0] - 2022-02-15
### Changed
- Change `execute()` to match the new requests structure.
- Change `add()` to match the new requests structure.
- Change `min()` to match the new requests structure.
- Change `max()` to match the new ...## [0.26.0] - 2022-02-15
### Changed
- Change `execute()` to match the new requests structure.
- Change `add()` to match the new requests structure.
- Change `min()` to match the new requests structure.
- Change `max()` to match the new requests structure.
- Change `aand()` to match the new requests structure.
- Change `where()` to match the new requests structure.
- Change `order_by_descending()` to match the new requests structure.
- Change `order_by()` to match the new requests structure.
- Change `select()` to match the new requests structure.
- Request become SQLEnumerable and a new dataclass is used for connection.
### Deleted
- Delete `ffrom()` which is no longer useful beacause the table is populated in the SQLEnumerable.https://gitlab.obspm.fr/exoplanet/py-linq-sql/-/merge_requests/6Feature sql take2022-02-18T14:13:38+01:00Chosson Ulysseulysse.chosson@obspm.frFeature sql take## [0.27.0] - 2022-02-15
### Added
- Add the `take()` dsl function to execute a LIMIT [OFFSET] subcommand of request.## [0.27.0] - 2022-02-15
### Added
- Add the `take()` dsl function to execute a LIMIT [OFFSET] subcommand of request.https://gitlab.obspm.fr/exoplanet/py-linq-sql/-/merge_requests/7Feature execute2022-02-18T14:44:10+01:00Chosson Ulysseulysse.chosson@obspm.frFeature execute## [0.28.0] - 2022-02-16
### Changed
- Change `execute()` function to match the new request structure and return the correct response (Enumerable in consultation, int in alteration)
## Removed
- Remove `disconnect()` which is no longer ...## [0.28.0] - 2022-02-16
### Changed
- Change `execute()` function to match the new request structure and return the correct response (Enumerable in consultation, int in alteration)
## Removed
- Remove `disconnect()` which is no longer useful. we close cursor and connection separatelyhttps://gitlab.obspm.fr/exoplanet/py-linq-sql/-/merge_requests/8Feature connection psql2022-02-18T18:52:31+01:00Chosson Ulysseulysse.chosson@obspm.frFeature connection psql## [0.29.0] - 2022-02-16
### Chnaged
- Change `db.connect()`, now connect take arguments, `user`, `password`, `host`, `port`, `database`## [0.29.0] - 2022-02-16
### Chnaged
- Change `db.connect()`, now connect take arguments, `user`, `password`, `host`, `port`, `database`https://gitlab.obspm.fr/exoplanet/py-linq-sql/-/merge_requests/9Feature execution tests2022-02-21T18:22:52+01:00Chosson Ulysseulysse.chosson@obspm.frFeature execution tests## [0.20.1] - 2022-02-17
### Added
- Add test for execution of command `add()`.
- Add test for execution of command `take()`.
- Add test for execution of command `min()`.
- Add test for execution of command `max()`.
- Add test for execut...## [0.20.1] - 2022-02-17
### Added
- Add test for execution of command `add()`.
- Add test for execution of command `take()`.
- Add test for execution of command `min()`.
- Add test for execution of command `max()`.
- Add test for execution of command `order_by_descending()`.
- Add test for execution of command `order_by()`.
- Add test for execution of command `and()`.
- Add test for execution of command `where()`.
- Add test for execution of command `select()`.
### Changed
- Change `take()`, `take()` can be take an optional argument to specified the type of the parameter.
- Change test with fixture to connect to db and to get a SQLEnumerable in conftest.py.
### Fixed
- Fix a bug, all request was made on text, now requests are made on the correct type.https://gitlab.obspm.fr/exoplanet/py-linq-sql/-/merge_requests/10Improvment sql sql table2022-02-21T18:45:19+01:00Chosson Ulysseulysse.chosson@obspm.frImprovment sql sql table## [0.21.0] - 2022-02-21
### Changed
- Change how we get the table, now we get the table and we check it before using it## [0.21.0] - 2022-02-21
### Changed
- Change how we get the table, now we get the table and we check it before using ithttps://gitlab.obspm.fr/exoplanet/py-linq-sql/-/merge_requests/11remove folder executable command2022-02-22T16:18:28+01:00Chosson Ulysseulysse.chosson@obspm.frremove folder executable commandhttps://gitlab.obspm.fr/exoplanet/py-linq-sql/-/merge_requests/12Take the column in the lambda2022-02-23T11:34:15+01:00Chosson Ulysseulysse.chosson@obspm.frTake the column in the lambda## [0.22.0] - 2022-02-21
### Changed
- The column is now check before using.
- Change how to get the column, new the column is in the lambda and its the parameter of this lambda and the first element. In this example data is the column :...## [0.22.0] - 2022-02-21
### Changed
- The column is now check before using.
- Change how to get the column, new the column is in the lambda and its the parameter of this lambda and the first element. In this example data is the column :
```python
lambda data: data.a.b
```https://gitlab.obspm.fr/exoplanet/py-linq-sql/-/merge_requests/13typo in MagicDotPath2022-02-23T12:04:44+01:00Chosson Ulysseulysse.chosson@obspm.frtypo in MagicDotPathfix typo in MagicDotPath code (attriubte -> attribute)fix typo in MagicDotPath code (attriubte -> attribute)Pierre-Yves Martinpierre-yves.martin@obspm.frPierre-Yves Martinpierre-yves.martin@obspm.frhttps://gitlab.obspm.fr/exoplanet/py-linq-sql/-/merge_requests/14Add skip to skip the x first objects in return2022-02-23T19:13:36+01:00Chosson Ulysseulysse.chosson@obspm.frAdd skip to skip the x first objects in return## [0.23.0] - 2022-02-23
### Added
- Add the `skip()` function to execute a OFFSET subcommand of request.## [0.23.0] - 2022-02-23
### Added
- Add the `skip()` function to execute a OFFSET subcommand of request.https://gitlab.obspm.fr/exoplanet/py-linq-sql/-/merge_requests/15Doc readme doc2022-02-23T19:18:00+01:00Chosson Ulysseulysse.chosson@obspm.frDoc readme doc## [0.24.0] - 2022-02-23
### Added
- Add a real [README](README.md) with a little documentation.
## Changed
- Change the name of `add()` into `insert()`.## [0.24.0] - 2022-02-23
### Added
- Add a real [README](README.md) with a little documentation.
## Changed
- Change the name of `add()` into `insert()`.https://gitlab.obspm.fr/exoplanet/py-linq-sql/-/merge_requests/17change a docstring and make a case to secure get_path2022-02-25T14:43:31+01:00Chosson Ulysseulysse.chosson@obspm.frchange a docstring and make a case to secure get_pathUpdate docstring of insert,
add a case in get_path for case it is not a MagicDotPath or Tuple of MagicDotPathUpdate docstring of insert,
add a case in get_path for case it is not a MagicDotPath or Tuple of MagicDotPathhttps://gitlab.obspm.fr/exoplanet/py-linq-sql/-/merge_requests/18Improve precommit checks2022-02-25T09:12:29+01:00Pierre-Yves Martinpierre-yves.martin@obspm.frImprove precommit checksMultiple improvement of the pre-commit config to ensure our code and workflow is rock solidMultiple improvement of the pre-commit config to ensure our code and workflow is rock solidhttps://gitlab.obspm.fr/exoplanet/py-linq-sql/-/merge_requests/19Feature element at2022-02-25T17:08:36+01:00Chosson Ulysseulysse.chosson@obspm.frFeature element at## [0.25.0] - 2022-02-25
### Added
- Add the `element_at()` function to execute a LIMIT 1 OFFSET 'n' subcommand of request.## [0.25.0] - 2022-02-25
### Added
- Add the `element_at()` function to execute a LIMIT 1 OFFSET 'n' subcommand of request.https://gitlab.obspm.fr/exoplanet/py-linq-sql/-/merge_requests/20Feature adapt execute2022-03-02T10:47:54+01:00Chosson Ulysseulysse.chosson@obspm.frFeature adapt execute## [0.26.0] - 2022-02-25
### Changed
- Change `execute()` to get the good return type## [0.26.0] - 2022-02-25
### Changed
- Change `execute()` to get the good return typehttps://gitlab.obspm.fr/exoplanet/py-linq-sql/-/merge_requests/21Feature first2022-03-02T10:52:58+01:00Chosson Ulysseulysse.chosson@obspm.frFeature first## [0.27.0] - 2022-02-28
### Added
- Add the `first()` function to execute a LIMIT 1 OFFSET 0 subcommand of request (Its equal to `element_at(0)`). We can give a lambda function to
```python
fisrt(self: SQLEnumerable, fquery: Callable = ...## [0.27.0] - 2022-02-28
### Added
- Add the `first()` function to execute a LIMIT 1 OFFSET 0 subcommand of request (Its equal to `element_at(0)`). We can give a lambda function to
```python
fisrt(self: SQLEnumerable, fquery: Callable = None)
```
for a predicat (use `where()`)