Python-сообщество

res = Session.execute("SELECT OUT_NUNITCODE FROM PR_ASSIGN_NUNITCODE(:IN_NCONT)", ('1995'))

Session.execute("SELECT OUT_NUNITCODE FROM PR_ASSIGN_NUNITCODE(:IN_NCONT)").params(IN_NCONT = '1995').first()

CREATE OR ALTER PROCEDURE PR_ASSIGN_NUNITCODE (
    in_ncont VARCHAR(4)) ##Входящая переменная (цифры, хоть и varchar - это специально)
RETURNS (
    out_nunitcode VARCHAR(2)) ##Выходящая 
AS
DECLARE VARIABLE v_i_nunitcode INTEGER; ##
begin
  /* Procedure Text */
  for select max(cast(contracts.nunitcode as integer))
  from contracts
  where contracts.ncont = :in_ncont
  into :v_i_nunitcode ## Рабочая - обязательно надо куда-нить делать into
  do
  begin
    out_nunitcode = cast((v_i_nunitcode+1) as varchar(2));
    suspend; ## т.е. Return как бы...
  end
end^

SET TERM ; ^

COMMENT ON PROCEDURE PR_ASSIGN_NUNITCODE IS
'Íàçíà÷àåò ìàêñèìàëüíûé íîìåð +1 ôèëèàëà';

    def qry(self, id=None):
        res = Session.execute("SELECT OUT_NUNITCODE FROM PR_ASSIGN_NUNITCODE(?)", (id))

        for row in res:
            print id
            print row.out_nunitcode
        return u'сработало'

 ⇝  AttributeError: 'list' object has no attribute 'keys'
View as:   Interactive (full)  |  Text (full)  |  XML (full)
clear this
clear this
Module pyfield.controllers.contracts:201 in qry         view
<<      #----------------------------------------------------------------------
           def qry(self, id=None):
               res = Session.execute("SELECT OUT_NUNITCODE FROM PR_ASSIGN_NUNITCODE(?)", (id))
               print id
               #for row in res:
>>  res = Session.execute("SELECT OUT_NUNITCODE FROM PR_ASSIGN_NUNITCODE(?)", (id))
Module sqlalchemy.orm.scoping:121 in do         view
<<  def instrument(name):
           def do(self, *args, **kwargs):
               return getattr(self.registry(), name)(*args, **kwargs)
           return do
       for meth in Session.public_methods:
>>  return getattr(self.registry(), name)(*args, **kwargs)
Module sqlalchemy.orm.session:755 in execute         view
<<          return self.__connection(engine, close_with_result=True).execute(
                   clause, params or {})
      
           def scalar(self, clause, params=None, mapper=None):
>>  clause, params or {})
Module sqlalchemy.engine.base:824 in execute         view
<<          for c in type(object).__mro__:
                   if c in Connection.executors:
                       return Connection.executors[c](self, object, multiparams, params)
               else:
                   raise exc.InvalidRequestError("Unexecutable object type: " + str(type(object)))
>>  return Connection.executors[c](self, object, multiparams, params)
Module sqlalchemy.engine.base:866 in _execute_clauseelement         view
<<          params = self.__distill_params(multiparams, params)
               if params:
                   keys = params[0].keys()
               else:
                   keys = []
>>  keys = params[0].keys()
AttributeError: 'list' object has no attribute 'keys'

##To retrieve a result set from a stored procedure with KInterbasDB, use code such as this:

cur.execute("select output1, output2 from the_proc(?, ?)", (input1, input2))

# Ordinary fetch code here, such as:
for row in cur:
    ... # process row

con.commit() # If the procedure had any side effects, commit them.

return Session.execute("SELECT OUT_NUNITCODE FROM PR_ASSIGN_NUNITCODE(:in_ncont)", {'in_ncont' : id}).fetchone()