Example #1
0
 def run(self, opts, args, api):
     message, language = args
     context = opts.context
     name = opts.name
     hash = Message.hash(message)
     query = 'message.hash = %s'
     args = [hash]
     if context is not None:
         query += ' AND message.context = %s'
         args.append(context)
     else:
         query += ' AND message.context IS NULL'
     if name is not None:
         query += ' AND message.name = %s'
         args.append(name)
     else:
         query += ' AND message.name IS NULL'
     query += ' AND language = %s'
     args.append(language)
     model = api.models.model('draco')
     transaction = model.transaction()
     join = (Translation, 'translation',
             MessageTranslationRelationship, 'INNER')
     result = transaction.select(Translation, query, args, join=join)
     if result:
         transaction.delete(result[0])
         transaction.commit()
     else:
         self.error('translation does not exist')
         self.exit(1)
Example #2
0
 def run(self, opts, args, api):
     message = args[0]
     context = opts.context or None
     name = opts.name or None
     model = api.models.model('draco')
     transaction = model.transaction()
     hash = Message.hash(message)
     query = 'hash = %s'
     args = [hash]
     if context is not None:
         query += ' AND context = %s'
         args.append(context)
     else:
         query += ' AND context IS NULL'
     if name is not None:
         query += ' AND name = %s'
         args.append(name)
     else:
         query += ' AND name IS NULL'
     result = transaction.select(Message, query, args)
     if result:
         transaction.delete(result[0])
         transaction.commit()
     else:
         self.error('message does not exist')
         self.exit(1)
Example #3
0
 def translate(self, message, languages, context=None, name=None):
     """Translate `message'."""
     hash = Message.hash(message)
     cacheid = (hash, context, name) + tuple(languages)
     translation = self.m_cache.get(cacheid)
     if translation:
         return translation
     # All translations are looked up where the corresponding message
     # matches `message' or `name', and that match any of the languages
     # specified in `languages'. If no results are found, `message' itself
     # is returned. If results are found, they are ordered by applying the
     # criteria mentioned below and the first entry is returned:
     # 1. Translations where the message name matched.
     # 2. Translations where the message id matched.
     # 3. Translations that have a language earlier in the `languages' list.
     # 4. Translations where the context matched.
     transaction = self.m_models.model('draco').transaction('shared')
     where = '(message.hash = %s'
     args = [hash]
     if name:
         where += ' OR message.name = %s'
         args.append(name)
     where += ')'
     array = ','.join(['%s'] * len(languages))
     where += ' AND language IN (%s)' % array
     args += languages
     # Ordering on columns that can contain NULL values: testing whether a
     # NULL value is equal to something always returns NULL, and therefore
     # we need to weed those out in the ordering test.
     order = []
     if name is not None:
         order.append('message.name = %s AND NOT name IS NULL DESC')
         args.append(name)
     else:
         order.append('message.name IS NULL DESC')
     order.append('message.hash = %s DESC')
     args.append(hash)
     order += ['language=%s DESC'] * len(languages)
     args += languages
     if context:
         order.append('message.context = %s AND NOT context IS NULL DESC')
         args.append(context)
     order = ','.join(order)
     join = (Translation, 'translation',
             MessageTranslationRelationship, 'INNER')
     result = transaction.select(Translation, where, args,
                                 order=order, join=join)
     if result:
         translation = result[0]['translation']
     else:
         translation = message
     self.m_cache.add(cacheid, translation)
     return translation
Example #4
0
 def run(self, opts, args, api):
     message = args[0]
     name = opts.name or None
     context = opts.context or None
     model = api.models.model('draco')
     transaction = model.transaction()
     hash = Message.hash(message)
     message = Message(hash=hash, context=context, name=name,
                       message=message)
     try:
         transaction.insert(message)
         transaction.commit()
     except ModelError, err:
         self.error(err)
         self.exit(1)
Example #5
0
 def run(self, opts, args, api):
     message, language, translation = args
     context = opts.context
     name = opts.name
     model = api.models.model('draco')
     transaction = model.transaction()
     result = transaction.select(Language, 'language=%s', (language,))
     if not result:
         self.error('language does not exist: %s' % language)
         self.exit(1)
     hash = Message.hash(message)
     query = 'hash = %s'
     args = [hash]
     if context is not None:
         query += ' AND context = %s'
         args.append(context)
     else:
         query += ' AND context IS NULL'
     if name is not None:
         query += ' AND name = %s'
         args.append(name)
     else:
         query += ' AND name IS NULL'
     result = transaction.select(Message, query, tuple(args))
     if not result:
         self.error('message does not exist')
         self.exit(1)
     else:
         message = result[0]
     trobj = message.translation(language)
     if trobj:
         trobj['translation'] = translation
     else:
         trobj = Translation(translation=translation, orig_hash=hash)
         transaction.insert(trobj)
         relationship = MessageTranslationRelationship()
         relationship.set_role('message', message)
         relationship.set_role('translation', trobj)
         relationship['language'] = language
         transaction.insert(relationship)
     transaction.commit()