[Asterisk-code-review] added oracle support (asterisk[master])

[HZMI8gkCvPpom0tM]

HZMI8gkCvPpom0tM has uploaded a new change for review.

  https://gerrit.asterisk.org/947

Change subject: added oracle support
......................................................................

added oracle support

Change-Id: I47573945733815bef6d8e0cf7ff07d2fe7f51387
---
M contrib/ast-db-manage/config/versions/371a3bf4143e_add_user_eq_phone_option_to_pjsip.py
1 file changed, 12 insertions(+), 6 deletions(-)


  git pull ssh://gerrit.asterisk.org:29418/asterisk refs/changes/47/947/1

diff --git a/contrib/ast-db-manage/config/versions/371a3bf4143e_add_user_eq_phone_option_to_pjsip.py b/contrib/ast-db-manage/config/versions/371a3bf4143e_add_user_eq_phone_option_to_pjsip.py
index 145d6be..f46a336 100644
--- a/contrib/ast-db-manage/config/versions/371a3bf4143e_add_user_eq_phone_option_to_pjsip.py
+++ b/contrib/ast-db-manage/config/versions/371a3bf4143e_add_user_eq_phone_option_to_pjsip.py
@@ -18,13 +18,19 @@
 YESNO_VALUES = ['yes', 'no']
 
 def upgrade():
-    ############################# Enums ##############################
+	currentcontext = op.get_context()
+	if currentcontext.bind.dialect.name != 'oracle':
+		############################# Enums ##############################
 
-    # yesno_values have already been created, so use postgres enum object
-    # type to get around "already created" issue - works okay with mysql
-    yesno_values = ENUM(*YESNO_VALUES, name=YESNO_NAME, create_type=False)
+		# yesno_values have already been created, so use postgres enum object
+		# type to get around "already created" issue - works okay with mysql
+		yesno_values = ENUM(*YESNO_VALUES, name=YESNO_NAME, create_type=False)
 
-    op.add_column('ps_endpoints', sa.Column('user_eq_phone', yesno_values))
+		op.add_column('ps_endpoints', sa.Column('user_eq_phone', yesno_values))
+	if currentcontext.bind.dialect.name == 'oracle':
+
+		op.add_column('ps_endpoints', sa.Column('user_eq_phone', sa.Enum(*YESNO_VALUES, name='psepYnNusereqphone')))
+		
 
 def downgrade():
-    op.drop_column('ps_endpoints', 'user_eq_phone')
+	op.drop_column('ps_endpoints', 'user_eq_phone')

-- 
To view, visit https://gerrit.asterisk.org/947
To unsubscribe, visit https://gerrit.asterisk.org/settings

Gerrit-MessageType: newchange
Gerrit-Change-Id: I47573945733815bef6d8e0cf7ff07d2fe7f51387
Gerrit-PatchSet: 1
Gerrit-Project: asterisk
Gerrit-Branch: master
Gerrit-Owner: HZMI8gkCvPpom0tM <fuxfwgc4a2i1gr at gmail.com>