
Research
/Security News
Contagious Interview Campaign Escalates With 67 Malicious npm Packages and New Malware Loader
North Korean threat actors deploy 67 malicious npm packages using the newly discovered XORIndex malware loader.
(Version 0.5.1)
Purpose
Provides an ORM for SQLite.
To use the power of myorm you need to set up an adaptor and let your classed inherit from myorm.DbObject.
For example:
DbObject = myorm.DbObject DbObject.adaptor = myorm.SQLiteAdaptor(database='database.db')
class User(DbObject):
name = myorm.CharField(max_length=25)
password = myorm.CharField(max_length=50)
describtion = myorm.TextField()
registered = myorm.DateField()
logins = myorm.IntegerField()
active = myorm.BooleanField(default=True)
Users automatically get an additional id which is an instance if myorm.PkField.
Instance methods:
- .save()
- Simply saves the object. If it is new, it will be created, if it already exists, it will be updated.
- .delete()
Class methods
- .create_table()
- Function to create tables.
The class which calls this function will get a table in the database.
It DOES NOT provide migrations (at the moment), it simply creates a table.
The class provides an interface to create objects: The objects manager. It is available as in User.objects.get()
Manager operations:
User.objects
- .all()
- Returns all objects, unordered
- .get(key=value)
- E.g.: User.objects.get(id=2)
Returns one object
- .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).
- .exclude(key=value)
- .create()
- Used to create objects of the calling class. Takes fieldnames as kwargs. E.g. User.objects.create(name='Christian', ..)
It returns the just created object.
- .oder_by('name')
- .count()
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.
E.g. DbObject.raw("INSERT INTO user (name, description) VALUES (?, ?)", 'Christian', 'myorm developer.')
myorm is available under the terms of the GPLv3.
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.
FAQs
Provides a simple ORM for MySQL, PostgreSQL and SQLite.
We found that myorm demonstrated a healthy version release cadence and project activity because the last version was released less than a year ago. It has 1 open source maintainer collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Research
/Security News
North Korean threat actors deploy 67 malicious npm packages using the newly discovered XORIndex malware loader.
Security News
Meet Socket at Black Hat & DEF CON 2025 for 1:1s, insider security talks at Allegiant Stadium, and a private dinner with top minds in software supply chain security.
Security News
CAI is a new open source AI framework that automates penetration testing tasks like scanning and exploitation up to 3,600× faster than humans.