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]
)
