Welcome to Ormstorm’s documentation!

ORMStorm is a small library for easy work with databases.

Features

• Simplicity: The library is very simple, and it won’t take long to learn it.

• Coding speed: Integrating the library into your projects won’t take long.

• Dynamic: Unlike others, this library will allow you to very quickly create new tables and add databases to them.

Simple usage

from ormstorm import Table, Types, Column, create_session


class ExampleTable(Table):
    __tablename__ = "example"

    id = Column(Types.INTEGER, primary_key=True, autoincrement=True)
    text = Column(Types.STRING)


LocalSession = create_session("example.sqlite3", [ExampleTable])

with LocalSession() as session:
    session.insert(ExampleTable(text="Hello, world!"))

Contents

• Installation
  • From PyPi
    • Typical installation
    • Installing the selected version
    • Upgrading an installed library
  • From GitHub
• Session
  • Session
    • Session.clear()
    • Session.close()
    • Session.count()
    • Session.create()
    • Session.delete()
    • Session.drop()
    • Session.execute()
    • Session.exists()
    • Session.insert()
    • Session.select()
    • Session.update()
  • create_session()
  • Usage
• Column
  • Column
  • Usage
• Table
  • DynamicTable
    • DynamicTable.add()
    • DynamicTable.columns()
  • Table
    • Table.columns()
  • Usage
• Magic Filters
  • MagicFilter
  • Usage
  • All Operators
• Constants
  • Types
    • Types.BIGINT
    • Types.BLOB
    • Types.BOOLEAN
    • Types.CHAR
    • Types.DATE
    • Types.DATETIME
    • Types.DECIMAL
    • Types.DOUBLE
    • Types.INT
    • Types.INTEGER
    • Types.NONE
    • Types.NUMERIC
    • Types.REAL
    • Types.STRING
    • Types.TEXT
    • Types.TIME
    • Types.TIMESTAMP
    • Types.VARCHAR

Indices and tables

• Index

• Module Index