Package Health Score

73 / 100

security
No known security issues
popularity
Small
maintenance
Sustainable
community
Active

Popularity

Small

GitHub Stars: 5.34K
Forks: 707
Contributors: 110

Direct Usage Popularity

Based on project statistics from the GitHub repository for the PyPI package py-linq-sql, we found that it has been starred 5,341 times.

Security

No known security issues

Security and license risk for latest version

Release Date: Jan 24, 2024
Direct Vulnerabilities: 0
C
0
H
0
M
0
L
Indirect Vulnerabilities: 0
C
0
H
0
M
0
L
License Risk: 0
H
0
M
0
L

All security vulnerabilities belong to production dependencies of direct and indirect packages.

License

MIT

Security Policy

We found a way for you to contribute to the project! Looks like py-linq-sql is missing a security policy.

You can connect your project's repository to Snyk to stay up to date on security alerts and receive automatic fix pull requests.

Keep your project free of vulnerabilities with Snyk

Maintenance

Sustainable

Commit Frequency

Open Issues: 8
Open PR: 3
Last Release: 10 months ago
Last Commit: 14 days ago

Further analysis of the maintenance status of py-linq-sql based on released PyPI versions cadence, the repository activity, and other data points determined that its maintenance is Sustainable.

We found that py-linq-sql demonstrates a positive version release cadence with at least one new version released in the past 12 months.

As a healthy sign for on-going project maintenance, we found that the GitHub repository had at least 1 pull request or issue interacted with by the community.

Community

Active

Readme: Yes
Contributing.md: No
Code of Conduct: No
Contributors: 110
Funding: Yes

A good and healthy external contribution signal for py-linq-sql project, which invites more than one hundred open source maintainers to collaborate on the repository.

We found a way for you to contribute to the project! Looks like py-linq-sql is missing a Code of Conduct.

Embed Package Health Score Badge

Keep your project healthy

Check your requirements.txt

Ensure all the packages you're using are healthy and well-maintained

Snyk Vulnerability Scanner

Get health score & security insights directly in your IDE

Package

Python Versions Compatibility: >=3.10,<4.0.0

Age: 2 years
Latest Release: 10 months ago
Dependencies: 10 Direct
Versions: 17
Maintainers: 2
Wheels: OS Independent

Readme

maintenance open issue

Py-Linq-SQL

A Python module used for interacting with sql database using LINQ syntax. The project is under EUPL License v1.2.

Py-linq-sql allows you to go from (SQLAlchemy using direct text query):

conn.execute(
  text(
    """SELECT "data"-&gt;'obj'-&gt;'name' as name """
    """FROM "objects" """
    """WHERE "data"-&gt;'obj'-&gt;&gt;'name' == "earth" """
    """AND CAST("data"-&gt;'obj'-&gt;'mass' &gt; 0.5 AS Decimal) """
    """LIMIT 1 OFFSET 2"""
  )
)

to the safer and easier to read:

sqle = (
  SQLEnumerable(conn, "objects")  # objects is the name of the table
  .select(lambda x: {"name": x.data.obj.name})  # data is a JSONB column
  .where(lambda x: x.data.obj.mass &gt; 0.5)  # data is a JSONB column
  .skip(2)
  .take(1)  # this is the last part of the query, till there nothing is executed
  .execute()  # now we ask for the whole query to be executed on the DB server
)

Pro :

all the query expression are expressed in pure python expression
easy support of JSON database using a simple object notation
very difficult to have an SQL injection (only the names of the tables are strings)
standardized syntax/API of LINQ (used in java, C# and many .net languages)
very fast: even very long and complex queries are executed in one single query on the server
no need to define a class for every table in the DB as you would do in an ORM here you write query assuming the tables, columns and fields exist, if not then you get a clear error about it
results are pylinq Enumerable that are themselves queryable in same way but locally
all kinds of join (inner, outer and full, with or without intersections) are easy to use and combine with any kind of query

Cons :

currently only support PostgresQL

Any feedback is welcome see Contributing.

Contacts

Author: Ulysse CHOSSON (LESIA)
Maintainer: Ulysse CHOSSON (LESIA)
Email:
Contributors:
- Pierre-Yves MARTIN (LESIA)

Table of Content

Py-Linq-SQL

Install

For all specific commands to this project, we use just. You need to install it.

After you can install the dependencies:

$ just install
pwd
/home/uchosson/Documents/py-linq-sql
poetry install --no-dev --remove-untracked
Installing dependencies from lock file
Warning: The lock file is not up to date with the latest changes in pyproject.toml.
You may be getting outdated dependencies. Run update to update them.

No dependencies to install or update

Installing the current project: py-linq-sql (0.109.0)

And if you need to develop the project, install development dependencies:

$ just install-all
pwd
/home/uchosson/Documents/py-linq-sql
poetry install --remove-untracked
Installing dependencies from lock file
Warning: The lock file is not up to date with the latest changes in pyproject.toml.
You may be getting outdated dependencies. Run update to update them.

No dependencies to install or update

Installing the current project: py-linq-sql (0.109.0)
npm install

up to date, audited 8 packages in 793ms

1 package is looking for funding
  run `npm fund` for details

found 0 vulnerabilities
sudo npm install markdownlint-cli2 --global

changed 36 packages, and audited 37 packages in 2s

8 packages are looking for funding
  run `npm fund` for details

found 0 vulnerabilities

and the pre-commit dependencies:

$ just preinstall
pwd
/home/uchosson/Documents/py-linq-sql
pre-commit clean
Cleaned /home/uchosson/.cache/pre-commit.
pre-commit autoupdate
Updating https://github.com/pre-commit/pre-commit-hooks ...
[INFO] Initializing environment for https://github.com/pre-commit/pre-commit-hooks.
already up to date.
Updating https://github.com/pre-commit/pre-commit-hooks ... already up to date.
Updating https://github.com/pycqa/isort ...
[INFO] Initializing environment for https://github.com/pycqa/isort.
already up to date.
Updating https://github.com/ambv/black ...
[INFO] Initializing environment for https://github.com/ambv/black.
already up to date.
Updating https://github.com/codespell-project/codespell ...
[INFO] Initializing environment for https://github.com/codespell-project/codespell.
already up to date.
Updating https://github.com/sqlfluff/sqlfluff ...
[INFO] Initializing environment for https://github.com/sqlfluff/sqlfluff.
updating 1.1.0 -&gt; 1.2.1.
Updating https://github.com/pycqa/flake8 ...
[INFO] Initializing environment for https://github.com/pycqa/flake8.
already up to date.
Updating https://github.com/DavidAnson/markdownlint-cli2 ...
[INFO] Initializing environment for https://github.com/DavidAnson/markdownlint-cli2.
already up to date.
pre-commit install --hook-type pre-merge-commit
pre-commit installed at .git/hooks/pre-merge-commit
pre-commit install --hook-type pre-push
pre-commit installed at .git/hooks/pre-push
pre-commit install --hook-type post-rewrite
pre-commit installed at .git/hooks/post-rewrite
pre-commit install-hooks
[INFO] Installing environment for https://github.com/pre-commit/pre-commit-hooks.
[INFO] Once installed this environment will be reused.
[INFO] This may take a few minutes...
[INFO] Installing environment for https://github.com/pycqa/isort.
[INFO] Once installed this environment will be reused.
[INFO] This may take a few minutes...
[INFO] Installing environment for https://github.com/ambv/black.
[INFO] Once installed this environment will be reused.
[INFO] This may take a few minutes...
[INFO] Installing environment for https://github.com/codespell-project/codespell.
[INFO] Once installed this environment will be reused.
[INFO] This may take a few minutes...
[INFO] Installing environment for https://github.com/sqlfluff/sqlfluff.
[INFO] Once installed this environment will be reused.
[INFO] This may take a few minutes...
[INFO] Installing environment for https://github.com/pycqa/flake8.
[INFO] Once installed this environment will be reused.
[INFO] This may take a few minutes...
[INFO] Installing environment for https://github.com/DavidAnson/markdownlint-cli2.
[INFO] Once installed this environment will be reused.
[INFO] This may take a few minutes...
pre-commit install
pre-commit installed at .git/hooks/pre-commit

Implemented functions

LINQ functions

LINQ documentation

All function make before an .execute() are executed by the database server.

MDPA = MagicDotPathAggregate

Method Name	Description	Output
all	Return True if all elements match the predicate.	SQLEnumerable
any	Return True if any elements match the predicate.	SQLEnumerable
avg	Aggregation function to get the average of the predicate.	MDPA
contains	Return True if at least one element match the predicate.	SQLEnumerable
concat	Aggregation function to concat a predicate.	MDPA
count	Return the number of line in a table.	SQLEnumerable
count	Aggregation function to count a predicate.	MDPA
distinct	Return all elements that are not duplicate.	SQLEnumerable
element_at	Return the element at the specific index.	SQLEnumerable
element_at_or_default	Return the element at the specific index or None if index > len.	SQLEnumerable
except	Returns all elements except elements from another SQLEnumerable.	SQLEnumerable
first	Return the first element match the predicate.	SQLEnumerable
first_or_default	Return the first element match the predicate or None if none match.	SQLEnumerable
group_by	Return the selection group by a predicate.	SQLEnumerable
group_join	Return the join between 2 selections group by a predicate.	SQLEnumerable
intersect	Return the intersection between 2 selections.	SQLEnumerable
join	Return the join between 2 selections.	SQLEnumerable
last	Return the last element match the predicate.	SQLEnumerable
last_or_default	Return the last element match the predicate or None if none match.	SQLEnumerable
max	Return the max element.	SQLEnumerable
max	Aggregate function to get the max of predicate.	MDPA
min	Return the min element.	SQLEnumerable
min	Aggregate function to get the min of predicate.	MDPA
order_by	Return the selection order by key(s).	SQLEnumerable
order_by_descending	Return the selection order by descending by key(s).	SQLEnumerable
select	Return a selection of elements.	SQLEnumerable
single	Return the only element match the predicate.	SQLEnumerable
single_or_default	Return the only element match the predicate or None if many matches.	SQLEnumerable
skip	Return the selection minus X first elements.	SQLEnumerable
skip_last	Return the selection minus X last elements.	SQLEnumerable
sum	Aggregation function to get the sum of a predicate.	MDPA
take	Return X first element of the selection.	SQLEnumerable
take_last	Return X last element of the selection.	SQLEnumerable
union	Return the union between 2 selections.	SQLEnumerable
where	Return the selection with all elements match the predicate.	SQLEnumerable

For more information see the detailed documentation.

Custom functions

Method Name	Description	Output
delete	Delete data in a SQL table.	SQLEnumerable
execute	Execute a request from an SQLEnumerable.	Enumerable or int or bool or dict
insert	Insert data in a SQL table.	SQLEnumerable
simple_insert	Insert data in a relationnal SQL table with kwargs.	SQLEnumerable
update	Update data in a table.	SQLEnumerable

Not implemented functions

LINQ functions

Method Name	Description
append	Not implemented
default_if_empty	Not implemented
empty	Not implemented
prepend	Not implemented
range	Not implemented
repeat	Not implemented
reverse	Not implemented
select_many	Not implemented
skip_while	Not implemented
take_while	Not implemented
to_dictionary	Not implemented
to_list	Not implemented
zip	Not implemented

Py-Linq functions

Method Name	Description
add	Not implemented
median	Not implemented

Py-Linq link

Contributing and info for developers

Full documentation

Py-LINQ-SQL Documentation

py-linq-sql dependencies

dotmap psycopg py-linq pyyaml rich six strenum toml types-pyyaml types-toml

FAQs

What is py-linq-sql?

A Python module used for interacting with sql database using LINQ syntax. Visit Snyk Advisor to see a full health score report for py-linq-sql, including popularity, security, maintenance & community analysis.

Is py-linq-sql popular?

The python package py-linq-sql receives a total of 180 weekly downloads. As such, py-linq-sql popularity was classified as small. Visit the popularity section on Snyk Advisor to see the full health analysis.

Is py-linq-sql well maintained?

We found indications that py-linq-sql maintenance is sustainable demonstrating some project activity. We saw a total of 110 open source contributors collaborating on the project. See the full package health analysis to learn more about the package maintenance status.

Is py-linq-sql safe to use?

The python package py-linq-sql was scanned for known vulnerabilities and missing license, and no issues were found. Thus the package was deemed as safe to use. See the full health analysis review.

Last updated on 7 November-2024, at 15:16 (UTC).

Build a secure application checklist

Select a recommended open source package

Minimize your risk by selecting secure & well maintained open source packages

DONE

Scan your app for vulnerabilities

Scan your application to find vulnerabilities in your: source code, open source dependencies, containers and configuration files

SCAN NOW

Fix identified vulnerabilities

Easily fix your code by leveraging automatically generated PRs

AUTO FIX

Monitor for new issues

New vulnerabilities are discovered every day. Get notified if your application is affected

MONITOR APP

py-linq-sql

A Python module used for interacting with sql database using LINQ syntax. For more information about how to use this package see README

Ensure you're using the healthiest python packages

Package Health Score

Popularity

Direct Usage Popularity

Security

Security and license risk for latest version

Maintenance

Commit Frequency

Community

Embed Package Health Score Badge

Keep your project healthy

Check your requirements.txt

Snyk Vulnerability Scanner

Package

Readme

Py-Linq-SQL

Contacts

Table of Content

Install

Implemented functions

LINQ functions

Custom functions

Not implemented functions

LINQ functions

Py-Linq functions

Contributing and info for developers

Full documentation

py-linq-sql dependencies

FAQs

What is py-linq-sql?

Is py-linq-sql popular?

Is py-linq-sql well maintained?

Is py-linq-sql safe to use?

Build a secure application checklist

Select a recommended open source package

Scan your app for vulnerabilities

Fix identified vulnerabilities

Monitor for new issues

Package Health Score

Direct Usage Popularity

Security and license risk for latest version

Commit Frequency

Embed Package Health Score Badge

Keep your project healthy

Check your requirements.txt

Snyk Vulnerability Scanner

Readme

Py-Linq-SQL

Contacts

Table of Content

Install

Implemented functions

LINQ functions

Custom functions

Not implemented functions

LINQ functions

Py-Linq functions

Contributing and info for developers

Full documentation

py-linq-sql dependencies

FAQs

What is py-linq-sql?

Is py-linq-sql popular?

Is py-linq-sql well maintained?

Is py-linq-sql safe to use?

Build a secure application checklist

Select a recommended open source package

Scan your app for vulnerabilities

Source Code

Open Source

Container

Config

Fix identified vulnerabilities

Monitor for new issues