storm and posgresql no support uppercase
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Storm |
New
|
Undecided
|
Unassigned |
Bug Description
storm and posgresql no support uppercase
\d "HorometroUpdate"
Columna | Tipo | Modificadores
-------
CodigoUnidad | character varying(50) | not null
Date | timestamp with time zone | not null
tz | interval(6) | not null
HorometroUpdate | integer | not null
PrevHorometroU
UIDL | character varying(50) | not null
Índices:
«HorometroU
class HorometroUpdate
__storm_table__ = "HorometroUpdate"
__storm_
CodigoUnidad = Unicode()
Date = DateTime()
tz = TimeDelta()
HorometroUpdate = Int()
PrevHoromet
UIDL = Unicode()
unit = Reference(
reportAppUser = Reference(UIDL, ReportAppUser.uidl)
...
...
...
r.count()
[21:05:49.883532] EXECUTE: 'SELECT COUNT(*) FROM HorometroUpdate WHERE HorometroUpdate
[21:05:49.885037] ERROR: no existe la relación «horometroupdate»
-------
ProgrammingError Traceback (most recent call last)
/home/miuler/
/home/share/
1205 def count(self, expr=Undef, distinct=False):
1206 """Get the number of objects represented by this ResultSet."""
-> 1207 return int(self.
1208
1209 def max(self, expr):
/home/share/
1194 else:
1195 select = Select(expr, tables=
-> 1196 result = self._store.
1197 value = result.get_one()[0]
1198 variable_factory = getattr(column, "variable_factory", None)
/home/share/
255 return result
256
--> 257 return Connection.
258
259 def raw_execute(self, statement, params):
/home/share/
201 params = state.parameters
202 statement = convert_
--> 203 raw_cursor = self.raw_
204 if noresult:
205 self._check_
/home/share/
265 # psycopg breaks with unicode statements.
266 statement = statement.
--> 267 return Connection.
268
269 def to_database(self, params):
/home/share/
282 args = (statement,)
283 try:
--> 284 self._check_
285 except Exception, error:
286 trace("
/home/share/
323 """Run the given function, checking for database disconnections."""
324 try:
--> 325 return function(*args, **kwargs)
326 except DatabaseError, exc:
327 if self.is_
ProgrammingError: no existe la relación «horometroupdate»
Storm tiene problemas con las tablas que están en mayuscula, esto es lo que ejecuta:
[21:05:49.883532] EXECUTE: 'SELECT COUNT(*) FROM HorometroUpdate WHERE HorometroUpdate .CodigoUnidad = %s AND HorometroUpdate ."Date" = %s', (u'CSD1', datetime. datetime( 2009, 3, 3, 21, 5, 46, 292525, tzinfo= tzoffset( '-5', -18000)))
y el sistema debería generar esto: e"."CodigoUnida d" = %s AND "HorometroUpdat e"."Date" = %s', (u'CSD1', datetime. datetime( 2009, 3, 3, 21, 5, 46, 292525, tzinfo= tzoffset( '-5', -18000)))
[21:05:49.883532] EXECUTE: 'SELECT COUNT(*) FROM "HorometroUpdate" WHERE "HorometroUpdat