to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
any sqlalchemy ways of retrieving a list of schemas?
On Nov 30, 1:23 pm, Michael Bayer [EMAIL PROTECTED] wrote:
On Nov 29, 2008, at 6:05 PM, [EMAIL PROTECTED] wrote:
Thanks Michael
If its just a warning and its supposed to continue past it, Why
doesn't it finish reflecting all
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 [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
in it. Is the
reflect bombing out when it hits the above errors?
If so, I will need to try and get sqlalchemy to accept this field
type.
Regards, Jar
On Nov 29, 10:34 pm, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
Hi
I was wondering if there was a way to reflect all schemas in the
metadata, or get
to retrieve the metadata for
the second tables.
Any suggestions on how i can reflect a list of schemas or make it
reflect all the schemas? it didn't like '%' as the schema name.
On Nov 30, 4:42 am, Michael Bayer [EMAIL PROTECTED] wrote:
the type is not recognized but the reflection operation should
--~--~-~--~~~---~--~~
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 [EMAIL PROTECTED]
For more options, visit this group at
http
PROTECTED] wrote:
On Nov 28, 2008, at 6:58 AM, [EMAIL PROTECTED] wrote:
Hi All
I'm writing a program for graphically configuring database schemas.
To do this, I want to use the sqlalchemy schema.py objects to store my
metadata as its changed and modified.
To do this, I think i will need
What was your justification of changing the name of my thread to a
completely different topic instead of starting a new thread?
I don't think thats good etiquette.
On Nov 29, 5:22 am, Doug Farrell [EMAIL PROTECTED] wrote:
Hi all,
I'm having a problem with a new instance of a relation
What was your justification of changing the name of my thread to a
completely different topic instead of starting a new thread?
I don't think thats good etiquette.
On Nov 29, 5:22 am, Doug Farrell [EMAIL PROTECTED] wrote:
Hi all,
I'm having a problem with a new instance of a relation
I got you now
Thank you Simon
--~--~-~--~~~---~--~~
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 [EMAIL
...]
--~--~-~--~~~---~--~~
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 [EMAIL PROTECTED]
For more options, visit
corresponding to the book1 remains there
what should i do to tell sqlalchemy to automatically remove orphan
books
i have tried giving cascade = 'a'',delete-orphan'
but errors comes
thanks and regards
[EMAIL PROTECTED]
Calicut,India
--~--~-~--~~~---~--~~
You received
On Nov 4, 3:36 am, Raoul Snyman [EMAIL PROTECTED] wrote:
Hi Michael,
On Nov 2, 1:07 am, Michael Bayer [EMAIL PROTECTED] wrote:
look into the pool_recycle option described
athttp://www.sqlalchemy.org/docs/05/dbengine.html
I'm also getting these errors, and I have pool_recycle
to store infinity using sqlalchemy with a mysql
backend?
In [128]: sa.__version__
Out[128]: '0.5.0beta4'
[EMAIL PROTECTED]:~ mysql --version
mysql Ver 12.22 Distrib 4.0.24, for pc-solaris2.10 (i386)
--~--~-~--~~~---~--~~
You received this message because you
email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
explicitly??
thx
--~--~-~--~~~---~--~~
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 [EMAIL PROTECTED]
For more
.
--~--~-~--~~~---~--~~
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 [EMAIL PROTECTED]
For more options, visit
I've read the section 'Alternate Collection Implementations' in the
documentation just now.
Sorry for my carelessness.
On 7月3日, 上午11时57分, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
SQLAlchemy creates the relationship as a collection on the parent
object containing instances of the child object
from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
) and
persons(related table one-to-many) and make:
clients = my_function(clients_table, 'anna')
to return me all clients from database, 'anna' works in
2)
How can I generate the fields in or_() statement??
thx
On Jun 27, 3:41 pm, [EMAIL PROTECTED] wrote:
what is multisearch? sort of
patternmatching
, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
')
})
--~--~-~--~~~---~--~~
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 [EMAIL PROTECTED]
For more options
@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
of my
question !
Dominique
--~--~-~--~~~---~--~~
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 [EMAIL PROTECTED
@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
Solvedmy faultthe file i'm reading was latin1... and I was
using the standard open..
now I use:
self.in_file = codecs.open(self.filename, r, latin1)
after that it worked fine...
thanks
On 13 Feb, 16:50, Michael Bayer [EMAIL PROTECTED] wrote:
On Feb 13, 2008, at 2:28 AM, [EMAIL PROTECTED
@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
--~--~-~--~~~---~--~~
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 [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com
this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
://www.sqlalchemy.org/trac/wiki/UsageRecipes/SchemaDisplay
On Jan 5, 2008, at 7:58 PM, [EMAIL PROTECTED] wrote:
Hi Guys,
I was wondering where the function create_schema_graph has gone, or
what
it has changed to. Any assistance would be appreciated.
Let me know,
Morgan
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
.
--~--~-~--~~~---~--~~
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 [EMAIL PROTECTED]
For more options, visit this group
, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
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 [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
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 [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
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 [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
.
--~--~-~--~~~---~--~~
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 [EMAIL PROTECTED]
For more options, visit this group at
http
--~--~-~--~~~---~--~~
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 [EMAIL PROTECTED]
For more options, visit
@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
Hi Michael, sorry about the lack of information; I wasn't clear on
what you were looking for.
The failing constraint is a customer one for email addresses:
CREATE DOMAIN base.email as TEXT CHECK
(VALUE ~ '[EMAIL PROTECTED](\\.[-\\w]+)*\\.\\w{2,4}$');
Thanks again!
Mark
On Oct 1, 5:46
in the query section (1)
what seem to be deferred INSERTS from the commit (3).
How can I turn off the deferred inserts?
Mark
On Sep 25, 9:27 am, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
Hi, I have a newbie question:
I'm parsing a log file in order to record login-times but I'm getting
am, Michael Bayer [EMAIL PROTECTED] wrote:
On Oct 1, 2007, at 11:02 AM, [EMAIL PROTECTED] wrote:
Hi again, I really must be missing something fundamental here as I
cannot seem to solve this problem:
I have a loop that queries one table (without any contraints) and
writes to a second
the commit and the next query is some
reporting of statistics (using sys.stdout).
I'm getting a constraint violation IntegrityError.
Thanks again for any help!
Mark
On Oct 1, 12:47 pm, Michael Bayer [EMAIL PROTECTED] wrote:
On Oct 1, 2007, at 12:12 PM, [EMAIL PROTECTED] wrote:
Hi Michael
email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
query?
Thanks,
Mark
--~--~-~--~~~---~--~~
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 [EMAIL PROTECTED
.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
the following simplified version of what I am working with:
from sqlalchemy import *
db = create_engine('postgres://[EMAIL PROTECTED]:5432/fleettest')
db.echo = True
metadata = BoundMetaData(db)
workorderlines_table = Table('workorderlines', metadata,
Column('workorderlines_rowid
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
and limit/offset come
together
#!/usr/bin/env python
from sqlalchemy import *
import sys, datetime
#init db
#global_connect('mysql://test:[EMAIL PROTECTED]/test')
#engine = create_engine('mysql://test:[EMAIL PROTECTED]/test')
global_connect('sqlite:///tutorial.db')
engine = create_engine('sqlite
windows.
db = create_engine('mssql://./test', module=pyodbc,
module_name='pyodbc')
On Apr 11, 11:50 am, Rick Morrison [EMAIL PROTECTED] wrote:
Last I heard, pyodbc was working on any POSIX system that supports odbc
(most likely via unixodbc or iodbc)
http://sourceforge.net/projects/pyodbc
A simple (too simple?) patch to support SSL connections with MySQL.
Use the following syntax to use it:
mysql://user:[EMAIL PROTECTED]/db?ssl_ca=path-to-ca-file
Tested with SA from svn, mysql-5.0.27, python-2.4.4 and MySQL-
python-1.2.1.
- Terje
Index: lib/sqlalchemy/databases/mysql.py
It would be great. Thank you.
André
On 7 abr, 12:57, Michael Bayer [EMAIL PROTECTED] wrote:
the thing is, we have support for 6 different databases and postgres
is the *only* one where its DBAPI implementation decides to use
Decimal for numeric types. the rest return just floats
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 [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
,
André
--~--~-~--~~~---~--~~
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 [EMAIL PROTECTED]
For more
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 [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
://www.hemorrhoidtreatmentcenter.com
--~--~-~--~~~---~--~~
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 [EMAIL PROTECTED]
For more
to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
isinstance(sel.execute().fetchone().last_mod, \
datetime.datetime)
return isdatetime(selTagged), isdatetime(selText)
sqlite_engine = create_engine('sqlite:///database_test.db')
mysql_engine = create_engine('mysql://[EMAIL PROTECTED]/xxx')
print sqlite_engine, check
works fine!
I tried to switch db engine: it works for sqlite, it doesn't for mysql...
#works
enginedb_test = create_engine('sqlite:///database_test.db')
= (1, datetime.datetime(2007, 1, 17, 14, 33, 21, 483043))
#doen't work
enginedb_test = create_engine('mysql://name:[EMAIL PROTECTED]/dbname
everybody ;)
ciao, lele.
--~--~-~--~~~---~--~~
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 [EMAIL PROTECTED
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
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 [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
, and
arguably sa is more flexible here for different usage modes (although
hibernate's scaling/deployment options, ie. caches are much nicer).
cheers,
kapil
On Dec 9, 11:35 am, flyingfrog [EMAIL PROTECTED] wrote:
Ok, this is my first approach with python + ORM, and i must say i can't
do what
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 [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
fwiw. using private methods on the session, calling session._attach(
instance ) has the nesc. effects of reattaching to the session with the
object marked in the session as dirty.
[EMAIL PROTECTED] wrote:
i'd like to detach an object from a session, modify it, and reattach it
to the session
I have a model like that:
#models.py
import sqlalchemy.mods.threadlocal
from sqlalchemy import *
metadata =
BoundMetaData('mysql://root:[EMAIL PROTECTED]@localhost/django')
metadata.engine.echo = True
wikis = Table('wiki_wiki', metadata,
Column('id', Integer, primary_key=True
--~--~-~--~~~---~--~~
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 [EMAIL PROTECTED]
For more options, visit this group at
http
74 matches
Mail list logo