Nopea
(Version 0.0.16)
Purpose
Provides an ORM for MySQL, PostgreSQL and SQLite.
Usage
To use the power of Nopea you need to set up an adaptor and let your classed inherit from nopea.DbObject.
Setting up Adaptor and Connection
from nopea.dbobject import DbObject
from nopea.adaptors.sqlite import SQLiteAdaptor
DbObject = DbObject
DbObject.adaptor = SQLiteAdaptor('nopea.db')
Creating a subclass
class User(DbObject):
name = nopea.CharField(max_length=25)
password = nopea.CharField(max_length=50)
describtion = nopea.TextField()
registered = nopea.DateField()
logins = nopea.IntegerField()
active = nopea.BooleanField(default=True)
Users automatically get an additional id field which is an instance of
nopea.fields.PkField.
Instance methods:
instance.save()
# Simply saves the object. If it is new, it will be created, if it already exists, it will be updated. Depending on whether the instance has an id != None or not.
instance.delete()
# The instance will be delete from the removed from the database. The instance will not be deleted and keep it's original id.
Class methods
User.create_table()
# Function to create tables.
# The class which calls this function will get a table in the database.
Manager operations:
The class provides an interface to create objects: The objects manager.
User.objects.all()
# Returns all objects, unordered
User.objects.get(key=value)
# E.g.: User.objects.get(id=2) Returns one object
User.objects.filter(key=value)
# E.g.: User.objects.filter(active=True) Returns a list of
# objects (like `get` but returns more than one).
# key__lt, key__lte, key__gte and key__gt can be used to limit
# the results. lte means 'lower than equal',
# lt means 'lower than', gte means 'greater than equal' and
# gt means 'greater than'
# E.g. "logins__lt=10". This will return all users with less
# than 10 logins.
# The filters can be combined:
User.objects.filter(logins__gte=10, logins__lte=50)
User.objects.exclude(key=value)
# Returns all results where the the value of the row does not match.
User.objects.create()
# Used to create objects of the calling class.
# Takes fieldnames as kwargs. E.g.
User.objects.create(name='Christian')
# returns the just created object.
User.objects.order_by('name')
# Returns a list of matching object. Can be used with a leading - to
# reverse the order.
User.objects.count()
# Returns the number of mathing rows.
DbObject class methods
DbObject.raw(query, args)
# The builtin SQL injection function.
# It simply executes queries and can be used with arguments.
# It always returns what it fetches. Use it wisely.
DbObject.raw(
"INSERT INTO user (name, description)
VALUES (?, ?)", 'Christian', 'Nopea developer.'
)
License
Nopea is available under the terms of the GPLv3.
Disclaimer
This software comes without any warranty. You use it on your own risk. It may contain bugs, viruses or harm your software and hardware in another way. The developer is not responsible for any consequences which may occur caused by using the software.
1 maintainer
Release files for nopea 0.0.29
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| nopea-0.0.29.tar.gz | 15.1 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| nopea-0.0.29-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 34.5 kB
Release files / nopea-0.0.29.tar.gz
| Download URL | nopea-0.0.29.tar.gz |
|---|---|
| Size | 15.1 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
7803040d0030224082db4a8e1346103bbfa27fbba235f1fdda8c9ce33d6f3c3a
|
|
BLAKE2b-256 checksum How to use checksums |
7cd153d201eb8e52652a2903dba8f48f65c17ffd21e1e3a086ecfc8ab4c5f4b6
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/3.4.1 importlib_metadata/4.5.0 pkginfo/1.7.0 requests/2.25.1 requests-toolbelt/0.9.1 tqdm/4.61.0 CPython/3.9.20
|
Release files / nopea-0.0.29-py3-none-any.whl
| Download URL | nopea-0.0.29-py3-none-any.whl |
|---|---|
| Size | 19.3 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
63a9c2ffa6e5a6eb31423a9e6b836838822e378dbf82f97130c83a51b4611668
|
|
BLAKE2b-256 checksum How to use checksums |
4426ee66ab616dd36613b91a4793d5f8134127068c726b99cf44cb3e1af6c362
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/3.4.1 importlib_metadata/4.5.0 pkginfo/1.7.0 requests/2.25.1 requests-toolbelt/0.9.1 tqdm/4.61.0 CPython/3.9.20
|
