def submit_success(self, appstruct): """ Insert config informations into database """ # la table config étant un stockage clé valeur # le merge_session_with_post ne peut être utilisé dbdatas = Config.query().all() log.debug(u"Cae configuration submission") log.debug(appstruct) new_dbdatas = merge_config_datas(dbdatas, appstruct) for dbdata in new_dbdatas: log.debug(dbdata.name) if dbdata in dbdatas: self.dbsession.merge(dbdata) else: self.dbsession.add(dbdata) # If we set the contribution_cae value, we want it to be the default # for every company that has no contribution value set if dbdata.name == 'contribution_cae': for comp in Company.query(): if comp.contribution is None: comp.contribution = dbdata.value self.dbsession.merge(comp) self.dbsession.flush() self.request.session.flash(self.validation_msg) return HTTPFound(self.request.route_path("admin_cae"))
def migrate_datas(): from autonomie_base.models.base import DBSESSION from autonomie.models.config import Config session = DBSESSION() Config.query().filter_by(app='autonomie', name='invoice_number_template').delete() prefix = session.query(Config.value).filter_by( app='autonomie', name='invoiceprefix', ).scalar() or '' default_format = Config(app='autonomie', name='invoice_number_template', value=prefix + '{SEQYEAR}') session.add(default_format) session.flush()
def migrate_datas(): from autonomie_base.models.base import DBSESSION from autonomie.models.config import Config session = DBSESSION() Config.query().filter_by( app='autonomie', name='invoice_number_template' ).delete() prefix = session.query(Config.value).filter_by( app='autonomie', name='invoiceprefix', ).scalar() or '' default_format = Config( app='autonomie', name='invoice_number_template', value=prefix + '{SEQYEAR}' ) session.add(default_format) session.flush()
def migrate_datas(): from autonomie_base.models.base import DBSESSION from autonomie.models.config import Config session = DBSESSION() from alembic.context import get_bind conn = get_bind() deprecated_conf_keys = [ 'compte_cgscop', 'compte_cg_debiteur', 'compte_cg_organic', 'compte_cg_debiteur_organic', 'compte_cg_assurance', 'taux_assurance', 'taux_cgscop', 'taux_contribution_organic', 'sage_assurance', 'sage_cgscop', 'sage_organic', ] q = Config.query().filter(Config.name.in_(deprecated_conf_keys)) q.delete(synchronize_session=False) session.flush()