batok

 File "prueba.py", line 3, in <module>
    engine = sa.create_engine("mssql+pymssql://foo:bar@host/pruebas" )
  File "/home/smartics/myenv/lib/python2.6/site-packages/SQLAlchemy-0.6beta1-py2.6.egg/sqlalchemy/engine/__init__.py", line 223, in create_engine
    return strategy.create(*args, **kwargs)
  File "/home/smartics/myenv/lib/python2.6/site-packages/SQLAlchemy-0.6beta1-py2.6.egg/sqlalchemy/engine/strategies.py", line 57, in create
    for k in util.get_func_kwargs(dialect_cls.dbapi):
AttributeError: type object 'MSDialect_pymssql' has no attribute 'dbapi'

batok

 gunicorn_paster --workers=2 development.ini
Traceback (most recent call last):
  File "/Users/director/dev/pylons_envs/mydevenv/bin/gunicorn_paster", line 8, in <module>
    load_entry_point('gunicorn==0.4', 'console_scripts', 'gunicorn_paster')()
  File "/Users/director/dev/pylons_envs/mydevenv/lib/python2.6/site-packages/gunicorn/main.py", line 249, in run_paster
    main(__usage__, get_app)
  File "/Users/director/dev/pylons_envs/mydevenv/lib/python2.6/site-packages/gunicorn/main.py", line 92, in main
    app = get_app(parser, opts, args)
  File "/Users/director/dev/pylons_envs/mydevenv/lib/python2.6/site-packages/gunicorn/main.py", line 235, in get_app
    host = opts.host or ctx.local_conf.get('host', '127.0.0.1')

batok

import sqlalchemy as sa
from sqlalchemy.orm import Mapper, sessionmaker
class Example(object):
        def __init__(self, field_value):
                self.field_value = field_value
        def __repr__(self):
                return "< Example( field_value = %s ) >" % self.field_value

engine = sa.create_engine( "sqlite://", echo = True)
meta = sa.MetaData()

batok

from sqlalchemy.ext.declarative import declarative_base
from history_meta import VersionedMeta, VersionedListener
from sqlalchemy import create_engine, Column, Integer, String, ForeignKey, DateTime
from sqlalchemy.orm import clear_mappers, compile_mappers, sessionmaker, deferred, MapperExtension
from sqlalchemy.sql.expression import text
from datetime import datetime
import time

engine = create_engine("postgresql+pg8000://postgres@localhost:25432/pruebas")
Base = declarative_base(metaclass=VersionedMeta, bind=engine)

batok

from sqlalchemy.ext.declarative import declarative_base
from history_meta import VersionedMeta, VersionedListener
from sqlalchemy import create_engine, Column, Integer, String, ForeignKey
from sqlalchemy.orm import clear_mappers, compile_mappers, sessionmaker, deferred
if True:
        engine = create_engine("postgresql+pg8000://postgres@localhost:25432/pruebas")
        Base = declarative_base(metaclass=VersionedMeta, bind=engine)
        Session = sessionmaker(extension=VersionedListener())

class SomeTable(Base):

batok

#This can be useful in controller methods of turbogears when you don't have a Table object defined
#if you know a query returns one tuple ( row ) this is useful
#assuming you have a globlal sqlalchemy or connection called conn2 and that you have python 2.6

from collections import namedtuple
@expose("bla.bla.template")
def mycontrollermethod(self)
   fields = "username, real_name, email"
   sql = "select %s from users where username = 'Whatever'" % fields
   nt = namedtuple("anything here",fields)

batok

from sqlalchemy import create_engine, Table, Column, Integer, String, DateTime,MetaData
from sqlalchemy.sql.expression import text
from sqlalchemy.orm import mapper, sessionmaker, validates
from sqlalchemy.orm.util import class_mapper
from sqlalchemy.ext.declarative import declarative_base

class Usuarios(object):
        pass

engine = create_engine("mssql://elusuario:[email protected]:1433/pruebas")

batok

engine = create_engine( url )

#extrayendo conexion desde el engine y haciendo las cosas como siempre
#ojo que yendose por aqui se pierde el logging que se pretende al principio
#El cursor que se usa en DBAPI no se utiliza para nada en sqlalchemy
conn = engine.connect()
cu = conn.connection.cursor()
cu.execute( "select count(*) from usuarios")
row = cu.fetchone()
print int(row[0])

batok

class DlgNivelesTabuladoresConceptos(g_sc.SizedDialog):
	def __init__(self, datos = None ):
		g_sc.SizedDialog.__init__(self, None, -1, "Niveles de Tabuladores", size = ( 800, 600 ), style=wx.DEFAULT_DIALOG_STYLE | wx.RESIZE_BORDER)
		self.SetExtraStyle( wx.WS_EX_VALIDATE_RECURSIVELY)
		self.datos = datos
		pane = self.GetContentsPane()
		pane.SetSizerType("form")
		self.id_mensual = wx.NewId()
		self.id_formula_exento = wx.NewId()
		self.id_exento = wx.NewId()

batok

if int(row2[1]) == 1:
					if int(row2[2]) > 0:
						dias = int(row2[2])
						if self.parent.IdEmpresa == 3 and dia_fecha_final == 31 and dias == 15:
							dias += 1
						if self.parent.IdEmpresa == 3 and mes_fecha_final == 2 and dias == 15 and dia_fecha_final in (28,29):
							dias = final_menos_inicial
					else:
						dias = int(row2[3])
						if mes_fecha_final not in mesesbimestre[bimestre]: