def test_tags2str(self): self.assertEqual(data.tags2str(["a"]), "a") self.assertEqual(data.tags2str(["a", "b"]), "a b") self.assertEqual(data.tags2str(["b", "a"]), "a b") self.assertRaises(ValueError, data.tags2str, "") self.assertRaises(ValueError, data.tags2str, None) self.assertRaises(ValueError, data.tags2str, 4) self.assertRaises(ValueError, data.tags2str, ("a", "b")) self.assertRaises(TypeConversionError, data.tags2str, ["a", "!"]) self.assertRaises(TypeConversionError, data.tags2str, ["-", "*"])
def test_tags2str(self): self.assertEqual(data.tags2str(['a']), 'a') self.assertEqual(data.tags2str(['a','b']), 'a b') self.assertEqual(data.tags2str(['b','a']), 'a b') self.assertRaises(ValueError, data.tags2str, '') self.assertRaises(ValueError, data.tags2str, None) self.assertRaises(ValueError, data.tags2str, 4) self.assertRaises(ValueError, data.tags2str, ('a','b')) self.assertRaises(TypeConversionError, data.tags2str, ['a','!']) self.assertRaises(TypeConversionError, data.tags2str, ['-','*'])
def ctags(input_): """ Returns a string safe for use in a sql statement @param: input_ @type input_: Anything @return: 'NULL', or input_ string >>> print ctags('') NULL >>> print ctags('linux git foo') 'foo git linux' """ if input_ in [None, '']: return 'NULL' if isinstance(input_, list): input_ = ' '.join(input_) tags = data.tags2str(data.str2tags(input_)) return "'%s'" % tags.lower()
def ctags(string): """ Returns a string safe for use in a sql statement :param: string :type string: Anything :rtype: ``NULL``, or :class:`str` >>> from chula.db import functions >>> print functions.ctags('') NULL >>> print functions.ctags('linux git foo') 'foo git linux' """ if string in [None, '']: return 'NULL' if isinstance(string, list): string = ' '.join(string) tags = data.tags2str(data.str2tags(string)) return "'%s'" % tags.lower()