with Python 3.4.3, so that
should be the latest. I'll try first to update some other packages on
that machine with pip.
Had similar issue with wxPython-Phoenix and pip with 3.4.0 was very far
behind, don't know about 3.4.3.
pip 6.0.8 and setuptools 12.2 fixed it for me
Werner
--
You received
?
Is this a recent change as I don't seem to get this on 0.9.3, below is
with Python 3.4 and 0.9.7.
Werner
class Currency(DeclarativeBase, mix.StandardColumnMixin):
__tablename__ = u'currency'
name = sa.Column(sa.Unicode(length=50), nullable=False, index=True)
code = sa.Column(sa.Unicode
Hi Michael,
Yes, I am using the old naming recipe, adjusted it to check for
_unnamed_ as a temp fix until I can move to the new way of doing it.
Thanks for the fast answer
Werner
On 1/30/2015 18:27, Michael Bayer wrote:
Werner werner...@gmx.ch wrote:
I am getting the following exception
Hi,
Just for the archive.
Got an answer on stackoverflow:
http://stackoverflow.com/questions/28047911/how-to-set-some-context-variable-for-a-user-connection/28061244#28061244
On 1/19/2015 16:59, Werner wrote:
Hi,
I like to move to eventually support PGSQL 9.3+ as an alternative engine
googling and looking at the PG documentation I can't find something
similar, probably just using the wrong terminology:-( .
Anyone can give me a tip of where to look?
Thanks
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To unsubscribe from
there?
sqlalchemy.readthedocs.org/en/rel_0_9/core/defaults.html
Is more documentation available for the class Column?
http://sqlalchemy.readthedocs.org/en/rel_0_9/core/metadata.html#sqlalchemy.schema.Column
Werner
--
You received this message because you are subscribed to the Google Groups
the laptop;-) .
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy
/sqlalchemy/wiki/UsageRecipes/NamingConventions
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send
Hi Rich,
On 7/30/2014 15:04, Rich Shepard wrote:
On Wed, 30 Jul 2014, Werner wrote:
I don't like using 'name' columns as primary keys I would instead use an
'id' column and would set 'index=True' on the name column.
Werner,
The use of natural keys (such as a vehicle VIN, the US's SSN
at the column length
2. when would 'property.columns' contain more then one element
Thanks
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr
On 21/11/2013 15:02, Stefane Fermigier wrote:
Hi Lars,
Are you working on the tool, or on the application whose schema is
depicted on the tool ?
Assuming it is a tool this would be very nice.
Can it read an existing SA model?
Werner
--
You received this message because you are subscribed
Michael,
On 03/10/2013 23:05, Michael Bayer wrote:
On Oct 3, 2013, at 5:42 AM, Werner werner.bru...@sfr.fr wrote:
...
The relation setup for the classes involved, and I suspect
Vintage.drinkinfo/Cellarbook.drinkinfo ones:
Vintage.vintadd = sao.relationship('Vintadd', uselist=False
guess/think that I have a relation setup incorrectly which creates
this effect, but I can not put my finger on it.
Appreciate any hint.
Werner
The relation setup for the classes involved, and I suspect
Vintage.drinkinfo/Cellarbook.drinkinfo ones:
Vintage.vintadd = sao.relationship('Vintadd
On 03/10/2013 11:42, Werner wrote:
Hi,
I have a problem that when I add a record to 'cellarbook' using the
following code the 'old' cellarbook entry is dropped from the db.
oldCB = session.query(db.Cellarbook).get(7)
newCB = db.Cellarbook()
# set some data from existing dbitem
newCB.cellar
are having.
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy
/trac/wiki/UsageRecipes/NamingConventions
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send
them as a new table when you
issue metadata.create_all(), is there a convenient way around this,
without having to pass a list of tables to create_all?
Maybe this recipe will help.
http://www.sqlalchemy.org/trac/wiki/UsageRecipes/Views
Werner
--
You received this message because you
Thanks this is really neat.
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email
contributors who helped with this release.
SQLAlchemy 0.8.2 is available on the Download Page:
http://www.sqlalchemy.org/download.html
Thanks for adding the retaining flag for Firebird - you are way to
fast for me:)
Werner
--
You received this message because you are subscribed to the Google Groups
it at the
time as it is good fit for small desktop application due to its embedded
engine and years ago PG didn't have a Windows build.
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To unsubscribe from this group and stop receiving emails from
released. Are you doing commit retaining in
some way - not even sure you can do this via SQLalchemy.
If you haven't already seen this it might help you find the real cause.
http://www.ibphoenix.com/resources/documents/general/doc_67
Werner
--
You received this message because you are subscribed
Hi,
On 04/06/2013 08:26, Werner wrote:
Hi,
I am looking at Dabo's ReportDesigner/Writer to do reporting (looked
at others like PythonReports and Geraldo) but both have problems with
large text blobs.
It wants the data as:
Dabo's reportwriter wants dataset-like structures, which
individual labels:
s.query(A.id, B.name, C.name.label(c_name), ...)
Great, thanks for the quick reply
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy
():
print row.__dict__['name']
Is using row.__dict__ the correct way or are there other ways?
Best regards
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To unsubscribe from this group and stop receiving emails from it, send an email
of my code
Anyone has a hint on where I am going wrong with all this?
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com
On 29/04/2013 13:29, Werner wrote:
Hi,
I am using the above to set the user language and I am sure this
worked for me, but it doesn't any more, in the mean time I upgraded to
0.8.1 (was on 0.7.8) and I wonder where things changed.
In a simple test like this it still works:
session.execute
the default, which is English.
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy
.
Can someone please explain why the above commit would someone cause the
context not to stick.
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy
connection, but will check this again tomorrow.
As always thanks for your time and explanation.
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr
the doc for querying, e.g. the following if you
use the ORM.
http://sqlalchemy.readthedocs.org/en/rel_0_8/orm/tutorial.html#querying
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To unsubscribe from this group and stop receiving emails from
On 26/04/2013 17:07, Claudio Freire wrote:
On Fri, Apr 26, 2013 at 12:06 PM, Werner werner.bru...@sfr.fr wrote:
On 26/04/2013 16:41, alonn wrote:
so not to load too much into memory I should do something like:
for i in session.query(someobject).filter(idsomething)
print i
I'm guessing
/CHANGELOG.txt
You can find new doc here:
https://colanderalchemy.readthedocs.org/en/latest/
BTW, the colander link on the following page does not work.
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To unsubscribe from this group and stop receiving
On 09/04/2013 14:29, Werner wrote:
...
Wineracku.combrack = sao.relationship('Wineracku',
remote_side=[Wineracku.id],
cascade=all, delete,
delete-orphan,
single_parent=True)
Wineracku.combrack = sao.relationship
deletion of w2 or w3
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy
==Wineracku.id'))
What am I doing wrong?
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send
Hi,
Found it in the doc, the Adjacency List Relationship is what I wanted.
http://docs.sqlalchemy.org/en/latest/orm/relationships.html#adjacency-list-relationships
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To unsubscribe from
, but there are obviously reasons to put it in a db. You might want
to read some of the other posts on stackoverflow, e.g.:
http://stackoverflow.com/questions/3748/storing-images-in-db-yea-or-nay
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group
.
What about rst2pdf instead of going via LaTex?
http://techtonik.rainforce.org/2010/05/sphinx-pdf-with-rst2pdf.html
I used on smallish docs, so don't know how it will do with SQLAlchemy.
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group
(self, self.type)
as you can see I am on 0.7.9.
I am not an expert on these things but shouldn't you maybe use the
following instead of hybrid_property:
http://docs.sqlalchemy.org/en/latest/orm/inheritance.html
Werner
--
You received this message because you are subscribed to the Google Groups
).
Can you give more detail on how a . (point/full stop) in user data
corrupted your database.
A point is valid data in lots of situations, so should not cause you
problems.
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post
in a varchar column?
I am pretty sure that the . is not your problem.
Provide more details and hopefully someone can help you identify your
real problem.
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email
.
Not an expert, but above is using the SA orm which requires a primary
key, you need to define the table using:
http://sqlalchemy.readthedocs.org/en/rel_0_8/core/schema.html#metadata-describing
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group
i.fk_authuser_id
print i.authuser.name
The output is:
Main Cellar
1
default
Special Reserve
1
--- attribute error NoneType object has no attribute 'name'
I am still on 0.7.9.
What am I doing wrong?
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy
:-) .
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group
Michael,
Thanks for the quick reply.
I am just about only using the ORM (and I like it a lot), so I won't
bother with all this.
Sorry for having wasted your time
Werner
On 20/10/2012 22:26, Michael Bayer wrote:
You can google around for better info on this, as I've not done Windows C
I use Firebird SQL, and like has a pretty bad performance compared to
starting with, as the later uses an index if one is available.
When using someklass.somecolumn.startswith('value') SA uses like,
what would have to be done to use starting with instead for the
Firebird dialect?
Werner
On 20/04/2012 10:36, Werner wrote:
I use Firebird SQL, and like has a pretty bad performance compared
to starting with, as the later uses an index if one is available.
When using someklass.somecolumn.startswith('value') SA uses like,
what would have to be done to use starting with instead
Michael,
On 20/04/2012 12:21, Michael Bayer wrote:
On Apr 20, 2012, at 4:51 AM, Werner wrote:
On 20/04/2012 10:36, Werner wrote:
I use Firebird SQL, and like has a pretty bad performance compared to starting
with, as the later uses an index if one is available.
When using
within Python.
reportlab/platypus looks promising, except that I can't find any GUI
with which to generate the layout of a listing.
Ideally it should be something a 'semi' technical end user could use too.
Is there such a thing?
Werner
--
You received this message because you are subscribed
BY ((SELECT COUNT(BOTTAG.TAGNO) FROM
BOTTAG WHERE BOTTAG.FK_WINERACKIT_ID = WINERACKIT.ID)),
AVAILCAPACITY COMPUTED BY (CAPACITY-USEDCAPACITY)
Thanks in advance for some pointers on how to do this.
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy
).
Or why not do it at the type level ? Can you just make a UserDefinedType here
?
Will look into these.
2463 might be nicer.
and will keep watching this one in case it does make it into 0.8.
Thanks
Werner
On Apr 9, 2012, at 1:36 PM, Werner wrote:
Is there a way in SA 0.7.6
)?
Werner
P.S.
Python 2.7.2 and SA 0.7.2 on Win 7
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To view this discussion on the web visit
https://groups.google.com/d/msg/sqlalchemy/-/WZ0HHOqitBQJ.
To post to this group, send email to sqlalchemy
but it doesn't seem to affect rollback.
Is there way to suppress the reloading of all the items and only load
the one affected by the changes by using expire(instance) or
refresh(instance)?
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group
?
https://github.com/pmakowski/fdb
Copied Philip and Pavel as I am not sure that they read this list and
they are would be much better qualified and responding to any technical
questions.
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post
On 23/03/2012 18:59, Philip Jenvey wrote:
On Mar 23, 2012, at 1:13 AM, werner wrote:
On 23/03/2012 05:53, Philip Jenvey wrote:
Hey all,
SQLAlchemy is looking to get involved in this year's Google Summer of Code[1].
We'd like to encourage students to visit our GSoC page on the wiki[2
#mapper-sql-expressions
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options
samples using UserDefinedType and
TypeDecorator, looked at the UsageRecipes and the documentation but
obviously can't quit put it together for my use.
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email
in dialect 3.
Is there an alternative which would work for both FB and Postgresql?
Werner
P.S.
The above query generates the following:
2012-01-16 17:41:56,696 INFO sqlalchemy.engine.base.Engine SELECT
cellarbook.id AS cellarbook_id, cellarbook.maturityfirst AS
cellarbook_maturityfirst
Michael,
On 01/16/2012 05:53 PM, Michael Bayer wrote:
On Jan 16, 2012, at 11:46 AM, werner wrote:
I would like to do this type of thing:
namesandvar = column_property(names + + variety)
and use it e.g. like:
query(db.Cellarbook).filter(db.Drinkinfo.namesandvar.contains(u'menu
=fore, surn=surn)
Hope this helps
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more
hints on this, even further pointers on what else to read
in the doc.
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy
have to sit down and benchmark different combinations.
Thanks a lot
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy
On 11/04/2011 03:11 AM, Mark Erbaugh wrote:
On Nov 3, 2011, at 3:31 PM, werner wrote:
Mark,
On 11/03/2011 07:18 PM, Mark Erbaugh wrote:
Using the query object count() method generates a sub-query (as per the docs).
The docs say to use func.count to avoid the subquery. func.count seems
of words, maybe there is a solution
which doesn't need count() at all:-) .
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email
On 09/09/2011 05:07 PM, Michael Bayer wrote:
On Sep 9, 2011, at 11:01 AM, werner wrote:
Tracking down where one forgot to use u'' e.g.:
somemodelinstance.somecol = 'somevalue'
instead of:
somemodelinstance.somecol = u'somevalue'
is sometimes not that easy to track down as the warning
?
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http
import table.
I'd appreciate any tips on how to get this to work.
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr
Michael,
On 09/07/2011 05:10 PM, Michael Bayer wrote:
On Sep 7, 2011, at 4:40 AM, werner wrote:
or:
Region_LV.language = sao.relationship('Language',
primaryjoin=Country_LV.fk_language_id==Language.id,
foreign_keys=[Country_LV.__table__.c.fk_language_id
On 09/07/2011 05:58 PM, Michael Bayer wrote:
On Sep 7, 2011, at 11:53 AM, werner wrote:
Michael,
On 09/07/2011 05:10 PM, Michael Bayer wrote:
On Sep 7, 2011, at 4:40 AM, werner wrote:
or:
Region_LV.language = sao.relationship('Language',
primaryjoin
think it is, same
with objects being dealt with.You're looking to reveal the problem much
farther up the chain of events basically.
Thanks Michael
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email
)
self.Getds().flush()
Anyone can give me some pointers of what I could possibly do wrong which
would cause the instance not being persistent.
Many thanks in advance as I am hitting my head on trying to recreate
this problem for some time now.
Werner
--
You received this message because
.
On Aug 14, 2011, at 3:54 AM, werner wrote:
A few of my user run into this exception when they use a dialog to create a new
wine purchase.
Fri Aug 05 10:24:56 2011 Version: 3.2.182.9
wxV: 2.8.11.0 (msw-unicode) *
Traceback (most recent call last):
File dialognewwine.pyo
it out either how to do it in
on_table_attach.
Would appreciate any tips on this.
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email
On 08/12/2011 02:18 PM, werner wrote:
I can't figure out how I could adapt the pk_col function on this page
http://www.sqlalchemy.org/trac/wiki/UsageRecipes/NamingConventions to
handle the Sequence definition needed for e.g. Firebird.
At the point when Column is instantiated I don't have
On 08/12/2011 04:46 PM, Michael Bayer wrote:
On Aug 12, 2011, at 9:04 AM, werner wrote:
On 08/12/2011 02:18 PM, werner wrote:
I can't figure out how I could adapt the pk_col function on this page
http://www.sqlalchemy.org/trac/wiki/UsageRecipes/NamingConventions to handle
the Sequence
Conor,
On 07/27/2011 05:54 PM, Conor wrote:
On 07/27/2011 10:42 AM, werner wrote:
I like to use a stored procure which needs a input parameter in
something like this:
seltest = db.sa.select([id,
name]).select_from(db.sa.func.someStoredProc(2)).alias()
seltestm = db.sao.mapper(ATest
= session.query(seltestm).get(73)
tried using functools.partial but I get a InterfaceError exception.
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from
On 05/07/2011 07:27 PM, Michael Trier wrote:
On Sat, May 7, 2011 at 11:11 AM, werner wbru...@free.fr
mailto:wbru...@free.fr wrote:
Just FYI,
I am installing things on Ubuntu 10.10 (Maverick) and when I do this:
easy_install.main(['-Zmad', sitePKG, sqlalchemy==0.6.8])
Maybe I'm
Just FYI,
On 05/08/2011 09:46 AM, werner wrote:
...
easy_install.main(['-Zmad', sitePKG, sqlalchemy])
But this gets me 0.6.6.
Gets 0.6.6 if I do the above on Ubuntu 10.10 Maverick, just did the same
in a VirtualBox/Win 7 machine and I get 0.6.7.
Werner
--
You received this message
sqlalchemy==0.6, I get 0.6.3
With sqlalchemy==0.6.6 I did get 0.6.6 which is fine for what I am
doing at the moment.
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com
On 04/26/2011 03:24 PM, Mike Conley wrote:
If you only want to change the SQLAlchemy version and use easy install
tools, I have done it by altering the sqlalchemy path in
site_packages/easy-install.pth
Or do this before you import SQLAlchemy:
I find that easier than setting up virtual
pkg_resources.require(sqlalchemy) # get latest version
##pkg_resources.require(sqlalchemy==0.5.8) # get specific version
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com
bit - so don't
know if it would work.
Anyhow you should better ask kinterbasdb questions on the FB driver list.
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe
TEXT NOT NULL,
lookup_text TEXT NOT NULL
);
You might want to look at these threads.
i10n of data
internationalization of content
A few different approaches to this problem were discussed in them.
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy
?
Werner
P.S. Using SA 0.6.5
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit
yet.
You are on kinterbasdb 3.3.0? If not you can get it from here:
http://www.firebirdsql.org/index.php?op=develsub=python
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalch...@googlegroups.com
the View Current DBAPI Support link on the above page gives a page
not found error.
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send
the blob’s character set ID
available.
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com
: 'FBDialect_kinterbasdb' object has no attribute 'DATETIME'
What am I doing wrong here? And is there a cleaner way of doing this,
i.e. get the dialect currently used instead of using a hard coded dialect.
On 20/09/2010 23:52, werner wrote:
I am trying to automatically generate the stored
/same code I assume meta.create_all(engine) is using to
generate create table (can't yet figure out where/how this is all
done) and ideally this should work not only for Firebird engine.
Hope this is clearer.
Thanks for looking at all this.
Werner
--
You received this message because you
way to get at dbapi from e.g. an instance?
Isn't there some more elegant way then doing
connection.engine.dialect.dbapi?
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalch...@googlegroups.com
/UsageRecipes.
If there is interest to further enhance this and get it to SQLAlchemy
standard of code I would very much like to help but I am not good enough
a coder to actually do the work or I would definitely need a lot of hand
holding and coaching.
Werner
--
You received this message because you
, reference_column, Base
i.e. change ref_column to reference_column
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr
recipe from/with a stored procedure?
The view definition in Firebird SQL is:
CREATE OR ALTER VIEW COUNTRIES_LV(
ID,
NAME,
ISO2,
ISO3,
TELCODE,
CREATED_AT,
UPDATED_AT)
AS
select * from countries_lp;
countries_lp being the stored procedure.
Werner
--
You received
Hi Nil,
On 14/09/2010 21:58, NiL wrote:
Hi Werner,
many thanks for your rich reply.
I'm going to try an elixir implementation for now. If you want follow
the thread of the same title in the elixir mailing list.
Thanks for letting me know.
One of the things which disturb me about SA
for me at the moment.
- http://rwec.co.uk/blog/2009/11/atomic-translations-part-1/
- http://rwec.co.uk/blog/2009/12/atomic-translations-part-2/
Hope some of this is useful to you
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post
Michael,
On 06/09/2010 19:42, Michael Bayer wrote:
On Sep 6, 2010, at 1:23 PM, werner wrote:
Michael,
Thanks for the fast reply.
On 06/09/2010 15:53, Michael Bayer wrote:
engine = create_engine(...)
m = MetaData()
t = Table('foo', m, autoload=True, autoload_with=engine) #--- boom
MINWITH and MAXWIDTH which have default
-1. FYI, when I change this to '0' and then back to '-1' it becomes
DEFAULT -1 and doesn't cause the exception anymore.
Werner
/**/
/* Generated by IBExpert 06/09
/ormtutorial.html
http://www.sqlalchemy.org/docs/ormtutorial.html#creating-table-class-and-mapper-all-at-once-declaratively
Hope this helps
Werner
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalch
On 24/08/2010 15:53, werner wrote:
Hi,
On 24/08/2010 10:14, Dobrysmak wrote:
Hi guys.
I've got a little problem with the sqlalchemy syntax.
I've got two tables with relations:
Table_Goups
id int(4) PrimaryKey not null,
name varchar(50) not null;
and
Table_User
id int(4) Primary Key
1 - 100 of 235 matches
Mail list logo