SQLObject

https://www.sqlobject.org/#documentation

Admin

SQLObject is an Object Relational Manager that provides an object interface to your database, with...

Tokens:445

Snippets:5

Trust Score:9.1

Update:6 months ago

Show doc for...

Tokens:

Raw

### Define and Create SQLObject Class

Source: https://www.sqlobject.org

Demonstrates how to define a simple SQLObject class representing a database table and then create the corresponding table in the database. It requires the `sqlobject` library and a database connection.

```python
from sqlobject import *

sqlhub.processConnection = connectionForURI('sqlite:/:memory:')

class Person(SQLObject):
    fname = StringCol()
    mi = StringCol(length=1, default=None)
    lname = StringCol()

Person.createTable()
```

--------------------------------

### Interact with SQLObject Instances

Source: https://www.sqlobject.org

Shows how to create instances of a SQLObject class, access and modify their attributes, retrieve instances by ID, and compare instances. This assumes a SQLObject class and table have already been set up.

```python
p = Person(fname="John", lname="Doe")
print(p)
p.mi = 'Q'
p2 = Person.get(1)
print(p2)
print(p is p2)
```

--------------------------------

### Perform Queries with SQLObject

Source: https://www.sqlobject.org

Illustrates how to query SQLObject instances using different methods. It covers selecting records based on attribute values and counting records that match specific criteria. This requires a defined SQLObject class and data.

```python
p3 = Person.selectBy(lname="Doe")[0]
print(p3)
pc = Person.select(Person.q.lname=="Doe").count()
print(pc)
```

Tokens:

Raw