I rely heavily on the version_id_col feature and I would like to be
able to either explicitly increment the version, or have the version
incremented when a relationship changes. The issue here is that a
change in a relationship is a semantic change to the parent record and
should conflict with oth
Hi Joel,
Although my application is deployed on the web it was written with the
goal of being redeployable as a desktop app, and to this end I have
been able to abstract away the web details so that I can code my
application very similarly to a desktop app.
The relevance here is that all database
Hello,
I'm a happy user of sqlalchemy on small personal projects of my own
(http://bitbucket.org/jbmohler/pyhacc is one of them which is not
ready for use yet). At my day job we are in the process of evaluating
platforms for a rewrite of our small business accounting system. We
expect this rewri
Thank you for taking the time to reply.
The application I am writing takes input from the user to define the
table name, number of columns, types etc... I tried formatting the
inputs in a list and then passing the list elements to Table(). I kept
getting error messages. I abandoned this approach an
On Jul 23, 2010, at 2:07 PM, cropr wrote:
> I am trying to add a Column definition using a metaclass but things
> aren't working as expected
>
> I am using something like the code below
>
> class MyMeta(DeclarativeMeta):
>def __init__(cls, name, bases, attrdict):
>setattr(cls, 'titl
I am trying to add a Column definition using a metaclass but things
aren't working as expected
I am using something like the code below
class MyMeta(DeclarativeMeta):
def __init__(cls, name, bases, attrdict):
setattr(cls, 'title', Column(types.String(80))
DeclarativeMeta.__ini
The version of SQLAlchemy and pymssql is very significant here.Older
pymssqls didn't really support unicode at all. The current one, unclear, we
have basic dialect support for the latest pymssql in 0.6 but it hasn't been
strongly tested.
There is of course very good support for pyodbc whic
Hi everyone,
I'm trying to write a small script to get all the table names from
SQLServer database (with pymssql). Up to now the script is really
simple:
engine = create_engine("mssql+pymssql://user:passw...@db_host/
db_name", encoding="cp1252")
metadata = MetaData(engine, reflect=True)
tabs = me
That shouldn't be too hard...
When creating a Table as shown in the tutorial, you can provide any
number of columns.
You can later modify an existing Table object; there's an
append_column method. See:
http://www.sqlalchemy.org/docs/reference/sqlalchemy/schema.html#tables-and-columns
Nebur
--
Yo