def select_2(): series = sqlalchemy.select( ["*"], from_obj=[sqlalchemy.text("generate_series(0, 0)") ]).alias('series') return sqlalchemy.select(sql.reorder_columns([ sql.gL("'menu/'").label('help_id'), sql.gL("null").label('menuid'), sql.gL("null").label('fullname'), sql.gL("'Aplikační menu '").label('title'), sql.gL("null").label('description'), sql.gL("null").label('menu_help'), sql.gL("null").label('spec_name'), sql.gL("null").label('spec_description'), sql.gL("null").label('spec_help'), sql.gL("null::int").label('page_id'), sql.gL("null::int").label('parent'), sql.gL("null::int").label('ord'), sql.gL("null").label('content'), sql.gL("text2ltree('999999')").label('position'), sql.gL("(select count(*) from e_pytis_menu)").label( 'position_nsub'), sql.gL("false").label('changed'), sql.gL("false").label('removed') ], [ 'help_id', 'menuid', 'fullname', 'title', 'description', 'menu_help', 'spec_name', 'spec_description', 'spec_help', 'page_id', 'parent', 'ord', 'content', 'position', 'position_nsub', 'changed', 'removed' ]), from_obj=[series])
def select_1(): h = sql.t.EvPytisHelp.alias("h") u = sqlalchemy.select(["*"], from_obj=["pytis_view_user_menu()"]).alias("u") return sqlalchemy.select( sql.reorder_columns( cls._exclude(h), [ "help_id", "menuid", "fullname", "title", "description", "menu_help", "spec_name", "spec_description", "spec_help", "page_id", "parent", "ord", "content", "position", "position_nsub", "changed", "removed", ], ), from_obj=[h.join(u, sql.gR("h.menuid = u.menuid"))], )
def select_2(): h = sql.t.EvPytisHelp.alias("h") return sqlalchemy.select( sql.reorder_columns( cls._exclude(h), [ "help_id", "menuid", "fullname", "title", "description", "menu_help", "spec_name", "spec_description", "spec_help", "page_id", "parent", "ord", "content", "position", "position_nsub", "changed", "removed", ], ), from_obj=[h], whereclause="h.menuid is null", )
def select_1(): m = sql.t.EPytisMenu.alias('m') a_ = sql.t.CPytisMenuActions.alias('a') mh = sql.t.EPytisHelpMenu.alias('mh') sh = sql.t.EPytisHelpSpec.alias('sh') return sqlalchemy.select( sql.reorder_columns( [sql.gL("'menu/'||m.menuid").label('help_id'), m.c.menuid.label('menuid'), m.c.fullname.label('fullname'), m.c.title.label('title'), m.c.help.label('description'), mh.c.content.label('menu_help'), a_.c.spec_name.label('spec_name'), sh.c.description.label('spec_description'), sh.c.help.label('spec_help'), sql.gL("null::int").label('page_id'), sql.gL("null::int").label('parent'), sql.gL("null").label('ord'), sql.gL("null").label('content'), sql.gL("text2ltree('999999')||subpath(m.position, 1)").label('position'), sql.gL("(select count(*)-1 from e_pytis_menu where position <@ m.position)") .label('position_nsub'), sql.gL("coalesce(mh.changed, false) or coalesce(sh.changed, false)") .label('changed'), sql.gL("coalesce(mh.removed, false) or coalesce(sh.removed, false)") .label('removed')], ['help_id', 'menuid', 'fullname', 'title', 'description', 'menu_help', 'spec_name', 'spec_description', 'spec_help', 'page_id', 'parent', 'ord', 'content', 'position', 'position_nsub', 'changed', 'removed']), from_obj=[m.join(a_, a_.c.fullname == m.c.fullname). outerjoin(mh, mh.c.fullname == a_.c.fullname). outerjoin(sh, sh.c.spec_name == a_.c.spec_name)], whereclause='nlevel(position) >= 2' )
def select_1(): m = sql.t.EPytisMenu.alias("m") a_ = sql.t.CPytisMenuActions.alias("a") mh = sql.t.EPytisHelpMenu.alias("mh") sh = sql.t.EPytisHelpSpec.alias("sh") return sqlalchemy.select( sql.reorder_columns( [ sql.gL("'menu/'||m.menuid").label("help_id"), m.c.menuid.label("menuid"), m.c.fullname.label("fullname"), m.c.title.label("title"), m.c.help.label("description"), mh.c.content.label("menu_help"), a_.c.spec_name.label("spec_name"), sh.c.description.label("spec_description"), sh.c.help.label("spec_help"), sql.gL("null::int").label("page_id"), sql.gL("null::int").label("parent"), sql.gL("null").label("ord"), sql.gL("null").label("content"), sql.gL("text2ltree('999999')||subpath(m.position, 1)").label("position"), sql.gL("(select count(*)-1 from e_pytis_menu where position <@ m.position)").label( "position_nsub" ), sql.gL("coalesce(mh.changed, false) or coalesce(sh.changed, false)").label("changed"), sql.gL("coalesce(mh.removed, false) or coalesce(sh.removed, false)").label("removed"), ], [ "help_id", "menuid", "fullname", "title", "description", "menu_help", "spec_name", "spec_description", "spec_help", "page_id", "parent", "ord", "content", "position", "position_nsub", "changed", "removed", ], ), from_obj=[ m.join(a_, a_.c.fullname == m.c.fullname) .outerjoin(mh, mh.c.fullname == a_.c.fullname) .outerjoin(sh, sh.c.spec_name == a_.c.spec_name) ], whereclause="nlevel(position) >= 2", )
def select_2(): h = sql.t.EvPytisHelp.alias('h') return sqlalchemy.select( sql.reorder_columns(cls._exclude(h), ['help_id', 'menuid', 'fullname', 'title', 'description', 'menu_help', 'spec_name', 'spec_description', 'spec_help', 'page_id', 'parent', 'ord', 'content', 'position', 'position_nsub', 'changed', 'removed']), from_obj=[h], whereclause='h.menuid is null' )
def select_1(): h = sql.t.EvPytisHelp.alias('h') u = sqlalchemy.select(["*"], from_obj=["pytis_view_user_menu()"]).alias('u') return sqlalchemy.select( sql.reorder_columns(cls._exclude(h), ['help_id', 'menuid', 'fullname', 'title', 'description', 'menu_help', 'spec_name', 'spec_description', 'spec_help', 'page_id', 'parent', 'ord', 'content', 'position', 'position_nsub', 'changed', 'removed']), from_obj=[h.join(u, sql.gR('h.menuid = u.menuid'))] )
def select_1(): stmt = sqlalchemy.text("select * from pytis_view_user_menu()") u = stmt.columns(sqlalchemy.Column( 'menuid', sqlalchemy.Integer()), ).alias('u') h = sql.t.EvPytisHelp.alias('h') return sqlalchemy.select( sql.reorder_columns(cls._exclude(h), [ 'help_id', 'menuid', 'fullname', 'title', 'description', 'menu_help', 'spec_name', 'spec_description', 'spec_help', 'page_id', 'parent', 'ord', 'content', 'position', 'position_nsub', 'changed', 'removed' ]), from_obj=[h.join(u, h.c.menuid == u.c.menuid)])
def select_2(): series = sqlalchemy.select(["*"], from_obj=["generate_series(0, 0)"]).alias("series") return sqlalchemy.select( sql.reorder_columns( [ sql.gL("'menu/'").label("help_id"), sql.gL("null").label("menuid"), sql.gL("null").label("fullname"), sql.gL("'Aplikační menu '").label("title"), sql.gL("null").label("description"), sql.gL("null").label("menu_help"), sql.gL("null").label("spec_name"), sql.gL("null").label("spec_description"), sql.gL("null").label("spec_help"), sql.gL("null::int").label("page_id"), sql.gL("null::int").label("parent"), sql.gL("null::int").label("ord"), sql.gL("null").label("content"), sql.gL("text2ltree('999999')").label("position"), sql.gL("(select count(*) from e_pytis_menu)").label("position_nsub"), sql.gL("false").label("changed"), sql.gL("false").label("removed"), ], [ "help_id", "menuid", "fullname", "title", "description", "menu_help", "spec_name", "spec_description", "spec_help", "page_id", "parent", "ord", "content", "position", "position_nsub", "changed", "removed", ], ), from_obj=[series], )
def select_3(): p = sql.t.EPytisHelpPages.alias("p") return sqlalchemy.select( sql.reorder_columns( cls._exclude(p) + [ sql.gL("'page/'||page_id").label("help_id"), sql.gL("null").label("menuid"), sql.gL("null").label("fullname"), sql.gL("null").label("menu_help"), sql.gL("null").label("spec_name"), sql.gL("null").label("spec_description"), sql.gL("null").label("spec_help"), sql.gL("(select count(*)-1 from e_pytis_help_pages " "where position <@ p.position)").label( "position_nsub" ), sql.gL("false").label("changed"), sql.gL("false").label("removed"), ], [ "help_id", "menuid", "fullname", "title", "description", "menu_help", "spec_name", "spec_description", "spec_help", "page_id", "parent", "ord", "content", "position", "position_nsub", "changed", "removed", ], ), from_obj=[p], )
def select_3(): p = sql.t.EPytisHelpPages.alias('p') return sqlalchemy.select( sql.reorder_columns( cls._exclude(p) + [sql.gL("'page/'||page_id").label('help_id'), sql.gL("null").label('menuid'), sql.gL("null").label('fullname'), sql.gL("null").label('menu_help'), sql.gL("null").label('spec_name'), sql.gL("null").label('spec_description'), sql.gL("null").label('spec_help'), sql.gL("(select count(*)-1 from e_pytis_help_pages " "where position <@ p.position)").label('position_nsub'), sql.gL("false").label('changed'), sql.gL("false").label('removed')], ['help_id', 'menuid', 'fullname', 'title', 'description', 'menu_help', 'spec_name', 'spec_description', 'spec_help', 'page_id', 'parent', 'ord', 'content', 'position', 'position_nsub', 'changed', 'removed']), from_obj=[p] )