"""The application's model objects"""

import sqlalchemy as sa
from sqlalchemy import orm
from sqlalchemy import types
from pyfield.model import meta

def init_model(engine):
    #global engine, Session
    sm = orm.sessionmaker(autoflush=True, transactional=True, bind=engine)

    meta.engine = engine
    meta.Session = orm.scoped_session(sm)
    #orm.mapper=    
    """Call me before using any of the tables or classes in the model"""
    ## Reflected tables must be defined and mapped here
    global reflected_insured
    reflected_insured = sa.Table("INSURED", meta.metadata, autoload=True,
                               autoload_with= meta.engine)
    orm.mapper(Insured, reflected_insured)
    
    global reflected_managers
    reflected_managers = sa.Table("MANAGERS", meta.metadata, autoload=True,
                               autoload_with = meta.engine)
    orm.mapper(Managers, reflected_managers)
    
########################################################################
class Insured(object):
    #----------------------------------------------------------------------
    def __str(self):
        return self.title

class Managers(object):
    #----------------------------------------------------------------------
    def __str(self):
        return self.title

AS
BEGIN
  IF (NEW.MID IS NULL) THEN
    NEW.MID = GEN_ID(GEN_MANAGERS_ID,1); ##то-есть, имя генератора-GEN_MANAGERS_ID
END

>>> from sqlalchemy import func
>>> f = func.gend_id(2, 1)
>>> str(f)
'gen_id(:gen_id_1, :gen_id_2)'

        from sqlalchemy.sql import func
        f = func.gen_id("GEN_MANAGERS_ID",1)

SELECT somefunc(arg1, arg2);

f = select(func.somefunc(arg1, arg2))
session.connection().execute(f)

somefunc(arg1, arg2);

f = func.somefunc(arg1, arg2)
session.connection().execute(f)

#----------------------------------------------------------------------
def nextid(gen_name):
    """Get next value of generator 'GEN_NAME'"""
    seq = sa.schema.Sequence(gen_name)
    next_id = meta.engine.execute(seq)
    return next_id

    def index(self): 
        n_id = nextid("GEN_MANAGERS_ID")
        return str(n_id)