本文整理汇总了Python中z3c.saconfig.Session.execute方法的典型用法代码示例。如果您正苦于以下问题:Python Session.execute方法的具体用法?Python Session.execute怎么用?Python Session.execute使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类z3c.saconfig.Session
的用法示例。
在下文中一共展示了Session.execute方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Python代码示例。
示例1: render
# 需要导入模块: from z3c.saconfig import Session [as 别名]
# 或者: from z3c.saconfig.Session import execute [as 别名]
def render(self):
dbtable_surveys = 'statistics_surveys'
info_surveys = self.getSurveysInfo()
# write to db
session = Session()
session.execute('''DELETE FROM %s;''' % dbtable_surveys)
def clean(value):
if isinstance(value, basestring):
return safe_unicode(value).strip().encode('utf-8')
return value
def pg_format(value):
if value is None:
return 'NULL'
if isinstance(value, datetime):
return "TIMESTAMP '%s'" % value.isoformat()
return "'%s'" % value
for line in info_surveys:
insert = '''INSERT INTO %s VALUES %s;''' % \
(dbtable_surveys, '(%s)' % ', '.join(map(pg_format,
map(clean, line))))
session.execute(insert)
datamanager.mark_changed(session)
transaction.get().commit()
from pprint import pformat
return "Written:\n" + pformat(info_surveys)
示例2: enable_longer_zodb_paths
# 需要导入模块: from z3c.saconfig import Session [as 别名]
# 或者: from z3c.saconfig.Session import execute [as 别名]
def enable_longer_zodb_paths(context):
session = Session()
session.execute(
"ALTER TABLE %s ALTER COLUMN zodb_path TYPE varchar(512);" %
model.SurveyTreeItem.__table__.name
)
datamanager.mark_changed(session)
示例3: test_not_nullable
# 需要导入模块: from z3c.saconfig import Session [as 别名]
# 或者: from z3c.saconfig.Session import execute [as 别名]
def test_not_nullable(self):
import mock
from z3c.saconfig import Session
session = Session()
session.execute('CREATE TABLE account (password TEXT)')
session.execute = mock.Mock()
self.allow_empty_password()
self.assertTrue(not session.execute.called)
示例4: test_column_not_present
# 需要导入模块: from z3c.saconfig import Session [as 别名]
# 或者: from z3c.saconfig.Session import execute [as 别名]
def test_column_not_present(self):
import mock
from z3c.saconfig import Session
session = Session()
session.execute('CREATE TABLE risk (foo INT)')
session.execute = mock.Mock()
self.add_skip_evaluation_to_model()
self.assertTrue(session.execute.called)
示例5: add_actionplan_reference
# 需要导入模块: from z3c.saconfig import Session [as 别名]
# 或者: from z3c.saconfig.Session import execute [as 别名]
def add_actionplan_reference(context):
session = Session()
inspector = Inspector.from_engine(session.bind)
columns = [c['name']
for c in inspector.get_columns(ActionPlan.__table__.name)]
if 'reference' not in columns:
log.info('Adding reference column for action plans')
session.execute('ALTER TABLE action_plan ADD COLUMN reference TEXT')
示例6: test_nullable
# 需要导入模块: from z3c.saconfig import Session [as 别名]
# 或者: from z3c.saconfig.Session import execute [as 别名]
def test_nullable(self):
import mock
from z3c.saconfig import Session
session = Session()
session.execute('CREATE TABLE action_plan (foo INT)')
session.execute = mock.Mock()
self.add_actionplan_reference()
session.execute.assert_called_once_with(
'ALTER TABLE action_plan ADD COLUMN reference TEXT')
示例7: increase_sessions_path_column
# 需要导入模块: from z3c.saconfig import Session [as 别名]
# 或者: from z3c.saconfig.Session import execute [as 别名]
def increase_sessions_path_column(context):
session = Session()
if TableExists(session, "session"):
session.execute(
"ALTER TABLE session ALTER COLUMN zodb_path TYPE varchar(512)")
model.metadata.create_all(session.bind, checkfirst=True)
datamanager.mark_changed(session)
transaction.get().commit()
log.info("Increased the size of column zodb_path in table session.")
示例8: alter_time_column
# 需要导入模块: from z3c.saconfig import Session [as 别名]
# 或者: from z3c.saconfig.Session import execute [as 别名]
def alter_time_column(context):
session = Session()
if TableExists(session, "statistics_login"):
session.execute(
"ALTER TABLE statistics_login ALTER COLUMN time SET DEFAULT CURRENT_TIMESTAMP")
model.metadata.create_all(session.bind, checkfirst=True)
datamanager.mark_changed(session)
transaction.get().commit()
log.info("Changed default for column 'time' to current timestamp")
示例9: drop_constraint_no_duplicates_in_tree
# 需要导入模块: from z3c.saconfig import Session [as 别名]
# 或者: from z3c.saconfig.Session import execute [as 别名]
def drop_constraint_no_duplicates_in_tree(context):
session = Session()
if TableExists(session, "tree"):
session.execute(
"ALTER TABLE tree DROP CONSTRAINT no_duplicates")
model.metadata.create_all(session.bind, checkfirst=True)
datamanager.mark_changed(session)
transaction.get().commit()
log.info("Removed the constraint `no_duplicates` from table tree.")
示例10: add_od_version_column
# 需要导入模块: from z3c.saconfig import Session [as 别名]
# 或者: from z3c.saconfig.Session import execute [as 别名]
def add_od_version_column(context):
session = Session()
if column_exists(session, 'od_link', 'version'):
return
transaction.get().commit()
session.execute('ALTER TABLE od_link ADD COLUMN version INT DEFAULT 0 NOT NULL')
datamanager.mark_changed(session)
transaction.get().commit()
log.info("Added new column 'version' to table 'od_link'")
示例11: add_wp_column_to_company
# 需要导入模块: from z3c.saconfig import Session [as 别名]
# 或者: from z3c.saconfig.Session import execute [as 别名]
def add_wp_column_to_company(context):
session = Session()
if TableExists(session, "company"):
session.execute(
"ALTER TABLE company ADD workers_participated bool DEFAULT NULL")
model.metadata.create_all(session.bind, checkfirst=True)
datamanager.mark_changed(session)
transaction.get().commit()
log.info("Added new column 'workers_participated' to table 'company'")
示例12: allow_empty_password
# 需要导入模块: from z3c.saconfig import Session [as 别名]
# 或者: from z3c.saconfig.Session import execute [as 别名]
def allow_empty_password(context):
session = Session()
inspector = Inspector.from_engine(session.bind)
columns = inspector.get_columns(Account.__table__.name)
password = [c for c in columns if c['name'] == 'password'][0]
if not password['nullable']:
log.info('Dropping NOT NULL constraint for account.password')
session.execute(
'ALTER TABLE account ALTER COLUMN password DROP NOT NULL')
datamanager.mark_changed(session)
示例13: add_column_for_custom_risks
# 需要导入模块: from z3c.saconfig import Session [as 别名]
# 或者: from z3c.saconfig.Session import execute [as 别名]
def add_column_for_custom_risks(context):
session = Session()
inspector = Inspector.from_engine(session.bind)
columns = [c['name']
for c in inspector.get_columns(model.Risk.__table__.name)]
if 'is_custom_risk' not in columns:
log.info('Adding is_custom_risk column for risks')
session.execute(
"ALTER TABLE %s ADD is_custom_risk BOOL NOT NULL DEFAULT FALSE" %
model.Risk.__table__.name)
datamanager.mark_changed(session)
示例14: add_skip_evaluation_to_model
# 需要导入模块: from z3c.saconfig import Session [as 别名]
# 或者: from z3c.saconfig.Session import execute [as 别名]
def add_skip_evaluation_to_model(context):
session = Session()
inspector = Inspector.from_engine(session.bind)
columns = [c['name']
for c in inspector.get_columns(model.Risk.__table__.name)]
if 'skip_evaluation' not in columns:
log.info('Adding skip_evaluation column for risks')
session.execute(
"ALTER TABLE %s ADD skip_evaluation BOOL DEFAULT 'f' NOT NULL" %
model.Risk.__table__.name)
datamanager.mark_changed(session)
示例15: removeChildren
# 需要导入模块: from z3c.saconfig import Session [as 别名]
# 或者: from z3c.saconfig.Session import execute [as 别名]
def removeChildren(self):
session = Session()
if self.path:
filter = sql.and_(SurveyTreeItem.session_id == self.session_id,
SurveyTreeItem.path.like(self.path + "%"),
SurveyTreeItem.id != self.id)
else:
filter = sql.and_(SurveyTreeItem.session_id == self.session_id,
SurveyTreeItem.id != self.id)
session.execute(SurveyTreeItem.__table__.delete().where(filter))
self.session.touch()
datamanager.mark_changed(session)