Asterisk - The Open Source Telephony Project
18.5.0
Main Page
Related Pages
Modules
+
Namespaces
Namespace List
+
Namespace Members
+
All
a
b
c
d
e
f
g
i
l
m
n
o
p
q
r
s
t
u
v
w
y
+
Functions
b
c
d
e
f
g
i
l
m
n
p
r
s
t
u
v
w
+
Variables
a
b
c
d
e
f
i
l
m
n
o
p
q
r
s
t
w
y
+
Data Structures
Data Structures
Data Structure Index
Class Hierarchy
+
Data Fields
+
All
_
a
b
c
d
e
f
g
h
i
j
k
l
m
n
o
p
q
r
s
t
u
v
w
x
y
z
+
Functions
_
a
c
d
e
f
g
h
i
k
l
m
n
p
r
s
t
u
v
w
+
Variables
_
a
b
c
d
e
f
g
h
i
j
k
l
m
n
o
p
q
r
s
t
u
v
w
x
y
z
Enumerator
Properties
+
Files
File List
+
Globals
+
All
_
a
b
c
d
e
f
g
h
i
j
k
l
m
n
o
p
q
r
s
t
u
v
w
x
y
z
+
Functions
_
a
b
c
d
e
f
g
h
i
j
k
l
m
n
o
p
q
r
s
t
u
v
w
x
y
z
+
Variables
_
a
b
c
d
e
f
g
h
i
j
k
l
m
n
o
p
q
r
s
t
u
v
w
x
y
z
+
Typedefs
a
b
c
d
e
f
g
h
i
j
k
l
m
n
o
p
r
s
t
u
v
w
y
z
+
Enumerations
_
a
b
c
d
e
f
g
h
i
j
k
l
m
n
o
p
q
r
s
t
u
v
w
x
y
+
Enumerator
_
a
b
c
d
e
f
g
h
i
j
k
l
m
n
o
p
q
r
s
t
u
v
w
x
z
+
Macros
_
a
b
c
d
e
f
g
h
i
j
k
l
m
n
o
p
q
r
s
t
u
v
w
x
y
z
Examples
•
All
Data Structures
Namespaces
Files
Functions
Variables
Typedefs
Enumerations
Enumerator
Properties
Macros
Modules
Pages
contrib
ast-db-manage
config
versions
28ab27a7826d_add_srv_lookups_to_identify.py
Go to the documentation of this file.
1
"""add srv_lookups to identify
2
3
Revision ID: 28ab27a7826d
4
Revises: 4468b4a91372
5
Create Date: 2017-01-06 14:53:38.829655
6
7
"""
8
9
# revision identifiers, used by Alembic.
10
revision =
'28ab27a7826d'
11
down_revision =
'4468b4a91372'
12
13
from
alembic
import
op
14
import
sqlalchemy
as
sa
15
from
sqlalchemy.dialects.postgresql
import
ENUM
16
17
YESNO_NAME =
'yesno_values'
18
YESNO_VALUES = [
'yes'
,
'no'
]
19
20
def
upgrade
():
21
############################# Enums ##############################
22
23
# yesno_values have already been created, so use postgres enum object
24
# type to get around "already created" issue - works okay with mysql
25
yesno_values = ENUM(*YESNO_VALUES, name=YESNO_NAME, create_type=
False
)
26
27
op.add_column(
'ps_endpoint_id_ips'
, sa.Column(
'srv_lookups'
, yesno_values))
28
29
30
def
downgrade
():
31
if
op.get_context().bind.dialect.name ==
'mssql'
:
32
op.drop_constraint(
'ck_ps_endpoint_id_ips_srv_lookups_yesno_values'
,
'ps_endpoint_id_ips'
)
33
op.drop_column(
'ps_endpoint_id_ips'
,
'srv_lookups'
)
28ab27a7826d_add_srv_lookups_to_identify.downgrade
def downgrade()
Definition:
28ab27a7826d_add_srv_lookups_to_identify.py:30
28ab27a7826d_add_srv_lookups_to_identify.upgrade
def upgrade()
Definition:
28ab27a7826d_add_srv_lookups_to_identify.py:20
Generated on Sun Aug 8 2021 19:42:56 for Asterisk - The Open Source Telephony Project by
1.8.13