def __repr__(self):
if self._quote:
expr = ' '.join(
map(str, [self.left, self.op,
quote(str(self.right))]))
else:
expr = ' '.join(map(str, [self.left, self.op, self.right]))
return '%s' % expr
def tuplize_dict(adict):
klist, vlist = [], []
for k,v in adict.items():
klist.append(k)
if type(v) in [int, long]:
vlist.append(str(v))
else:
vlist.append(quote(v))
return tuple(map(make_tuple, [klist, vlist]))
def tuplize_dict(adict):
klist, vlist = [], []
for k, v in adict.items():
klist.append(k)
if type(v) in [int, long]:
vlist.append(str(v))
else:
vlist.append(quote(v))
return tuple(map(make_tuple, [klist, vlist]))
def to_tsv(self, table, key=None):
self.stmt.table = table
query = self.stmt.select(order=key)
tsv = file(join(self.path, table + '.tsv'), 'w')
self.cursor.execute(query)
fields = [x[0] for x in self.cursor.description]
tsv.write('\t'.join(map(quote, fields)) + '\n')
row = self.cursor.fetchone()
while row:
line = []
for field in row:
if field == None:
field = 'NULL'
else:
field = str(field)
line.append(quote(field))
tsv.write('\t'.join(line) + '\n')
row = self.cursor.fetchone()
tsv.close()
def to_tsv(self, table, key=None):
self.stmt.table = table
query = self.stmt.select(order=key)
tsv = file(join(self.path, table + '.tsv'), 'w')
self.cursor.execute(query)
fields = [x[0] for x in self.cursor.description]
tsv.write('\t'.join(map(quote, fields))+'\n')
row = self.cursor.fetchone()
while row:
line = []
for field in row:
if field == None:
field = 'NULL'
else:
field = str(field)
line.append(quote(field))
tsv.write('\t'.join(line)+'\n')
row = self.cursor.fetchone()
tsv.close()
def _double_clause_(self, key):
return '%s and %s = %s' %(self._single_clause_(), self.__key_field__, quote(key))
def _single_clause_(self, key):
return '%s = %s' % (self.__key_field__, quote(key))
def _set_eq_(key, value):
return "%s = %s" %(key, quote(str(value)))
def _cond_expr(item, operator):
return '%s %s %s' %(item[0], operator, quote(str(item[1])))
def _double_clause_(self, key):
return '%s and %s = %s' % (self._single_clause_(), self.__key_field__,
quote(key))
def _single_clause_(self, key):
return '%s = %s' % (self.__key_field__, quote(key))
def _cond_expr(item, operator):
return '%s %s %s' % (item[0], operator, quote(item[1]))
def _set_eq_(key, value):
return "%s = %s" % (key, quote(str(value)))
def __repr__(self):
if self._quote:
expr = ' '.join(map(str, [self.left, self.op, quote(str(self.right))]))
else:
expr = ' '.join(map(str, [self.left, self.op, self.right]))
return '%s' %expr
def _single_clause_(self):
return '%s = %s' % (self.__main_field__, quote(self.__main_value__))
def _cond_expr(item, operator):
return "%s %s %s" % (item[0], operator, quote(item[1]))
def _single_clause_(self):
return '%s = %s' % (self.__main_field__, quote(self.__main_value__))
