pydal | A pure Python Database Abstraction Layer | SQL Database library

by web2py Python Version: 20240428.2 License: BSD-3-Clause

X-Ray Key Features Code Snippets Community Discussions(1)Vulnerabilities Install Support

kandi X-RAY | pydal Summary

pydal is a Python library typically used in Database, SQL Database applications. pydal has no bugs, it has no vulnerabilities, it has a Permissive License and it has high support. However pydal build file is not available. You can install using 'pip install pydal' or download it from GitHub, PyPI.

pyDAL is a pure Python Database Abstraction Layer. It dynamically generates the SQL/noSQL in realtime using the specified dialect for the database backend, so that you do not have to write SQL code or learn different SQL dialects (the term SQL is used generically), and your code will be portable among different types of databases. pyDAL comes from the original web2py's DAL, with the aim of being compatible with any Python program. pyDAL doesn't require web2py and can be used in any Python context.

Support

Quality

Security

License

Reuse

Support

pydal has a highly active ecosystem.

It has 454 star(s) with 135 fork(s). There are 37 watchers for this library.

There were 8 major release(s) in the last 6 months.

There are 139 open issues and 171 have been closed. On average issues are closed in 260 days. There are 7 open pull requests and 0 closed requests.

It has a negative sentiment in the developer community.

The latest version of pydal is 20240428.2

Quality

pydal has 0 bugs and 0 code smells.

Security

pydal has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.

pydal code analysis shows 0 unresolved vulnerabilities.

There are 0 security hotspots that need review.

License

pydal is licensed under the BSD-3-Clause License. This license is Permissive.

Permissive licenses have the least restrictions, and you can use them in most projects.

Reuse

pydal releases are available to install and integrate.

Deployable package is available in PyPI.

pydal has no build file. You will be need to create the build yourself to build the component from source.

Installation instructions, examples and code snippets are available.

pydal saves you 14832 person hours of effort in developing the same functionality from scratch.

It has 29642 lines of code, 2080 functions and 97 files.

It has medium code complexity. Code complexity directly impacts maintainability of the code.

Top functions reviewed by kandi - BETA

kandi has reviewed pydal and discovered the below as its top functions. This is intended to give you an instant insight into pydal implemented functionality, and help decide if they suit your requirements.

Create a table
Close fileobj
Open a file - like object
Log a message to the database
Parse query
Wrap expression
Create a new ExpressionExpressionExpression object
Generate patterns for a given table
Reconnect the connection
Validate the image
Validate a record
Performs bulk update operation
Return dictionary of db instances
Create a query for this query
Compute the GT
Delete an IMAP mailbox
Validate value
Insert data into the table
Yield subnets from other
Validate a value
Validate a password
Import table from csv file
Build the pipeline query
Delete all uploaded files in a dataset
Validate the value
Collapse IP addresses into network addresses

Get all kandi verified functions for this library.

pydal Key Features

No Key Features are available at this moment for pydal.

pydal Examples and Code Snippets

No Code Snippets are available at this moment for pydal.

Community Discussions

Trending Discussions on pydal

Web2py error "pydal.objects.Expression object" when doing table.field.max()

QUESTION

Web2py error "pydal.objects.Expression object" when doing table.field.max()

Asked 2020-Mar-28 at 00:10

I believe i am following the code here: http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer?search=insert#sum-avg-min-max-and-len

The insert works fine. The max() lines gives an error: pydal.objects.Expression object at 0x0000024D079AF748

What am I doing wrong?

The model:

...

ANSWER

Answered 2020-Mar-28 at 00:10

You're not getting an error. Rather, you are returning two PyDAL Expression objects (the .max() method of a DAL Field object returns an Expression object). If you are then trying to include those objects in your view, they will be converted to strings, and when you convert an arbitrary Python object to a string, you get a default string representation of the object like .

Presumably what you meant to do was to query the database to find the max name (which would be the last one alphabetically) and the max id. To get those values, you can do something like this:

Source https://stackoverflow.com/questions/60886061

Community Discussions, Code Snippets contain sources that include Stack Exchange Network

Vulnerabilities

No vulnerabilities reported

Install pydal

You can install pyDAL using pip:.

Support

Here is a quick example:. The complete documentation is available on http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer.

Find more information at: