Warn
POD ERRORS here is normal because DBIx::POS::Template used.
Mojolicious::Plugin::RoutesAuthDBI::POS::OAuth2
¡ ¡ ¡ ALL GLORY TO GLORIA ! ! !
NAME
Mojolicious::Plugin::RoutesAuthDBI::POS::OAuth2 - POS dict for OAuth2.
DB DESIGN DIAGRAM
See https://github.com/mche/Mojolicious-Plugin-RoutesAuthDBI/blob/master/Diagram.svg
SYNOPSIS
my $pos = Mojolicious::Plugin::RoutesAuthDBI::POS::OAuth2->new(template=>{tables=>{...}});
my $sth = $dbh->prepare($pos->{'foo'});Methods
One new()
new()
Input args for new:
template - hashref
Vars for template system of POS-statements.
SEE ALSO
SQL definitions
update oauth site
update "{% $schema %}"."{% $tables{oauth_sites} %}"
set conf = ?
where name =?
returning *;new oauth site
insert into "{% $schema %}"."{% $tables{oauth_sites} %}" (name,conf) values (?,?)
returning *;update oauth user
update "{% $schema %}"."{% $tables{oauth_users} %}"
set profile = ?, profile_ts=now()
where site_id =? and user_id=?
returning 1::int as "old", *;new oauth user
insert into "{% $schema %}"."{% $tables{oauth_users} %}" (profile, site_id, user_id) values (?,?,?)
returning 1::int as "new", *;profile by oauth user
select p.*
from "{% $schema %}"."{% $tables{profiles} %}" p
join "{% $schema %}"."{% $tables{refs} %}" r on p.id=r.id1
where r.id2=?;check profile oauth
Только один сайт на профиль
select o.*
from "{% $schema %}"."{% $tables{profiles} %}" p
join "{% $schema %}"."{% $tables{refs} %}" r on p.id=r.id1
join "{% $schema %}"."{% $tables{oauth_users} %}" o on o.id=r.id2
where p.id=? and o.site_id=?18 POD Errors
The following errors were encountered while parsing the POD:
- Around line 63:
Unknown directive: =name
- Around line 65:
Unknown directive: =desc
- Around line 67:
Unknown directive: =sql
- Around line 76:
Unknown directive: =name
- Around line 78:
Unknown directive: =desc
- Around line 80:
Unknown directive: =sql
- Around line 87:
Unknown directive: =name
- Around line 89:
Unknown directive: =desc
- Around line 91:
Unknown directive: =sql
- Around line 100:
Unknown directive: =name
- Around line 102:
Unknown directive: =desc
- Around line 104:
Unknown directive: =sql
- Around line 111:
Unknown directive: =name
- Around line 113:
Unknown directive: =desc
- Around line 115:
Unknown directive: =sql
- Around line 126:
Unknown directive: =name
- Around line 128:
Unknown directive: =desc
- Around line 132:
Unknown directive: =sql