s 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
-~--~~~~--~~--~--~---
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 p
ys 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 th
for c in t.columns:
print "\t" + c.name
I get a partial listing which as two different schemas 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, "[EM
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
-~--~~~~--~~--~--~---
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 proble
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 proble
AIL 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 a
, Jar
--~--~-~--~~~---~--~~
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
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
session.querry(Stock).filter(id=100).one()
>>> print ins.stock.books
[ ...]
--~--~-~--~~~---~--~~
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
ns_book_1)
ins_book_4 = Book('Book4')
ins_stock.books.add(ins_book_4)
flush()
in the table the row 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
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
>
>
list'")
Is there a way 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)
--~--~-~--~~~---~--~
is so ugly hack.
Is it some better way of doing this?
Sorry for my bad English :)
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@goo
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
> obj
.
--~--~-~--~~~---~--~~
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,
e a way to not specify the "join filters" 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 unsu
thanks in advance
Nathan
--~--~-~--~~~---~--~~
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
ted table one-to-one) 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, [EMAI
qlalchemy" 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
-~--~~~~--~~--~--~---
avel
--~--~-~--~~~---~--~~
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/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
On 13 mai, 00:04, Michael Bayer <[EMAIL PROTECTED]> wrote:
> Hey -
>
> I wrote you a reasonable test application using your tables.
...
> hope this helps.
Mike,
Of course it helps !!
Thank you very much for your help and your time.
I really appreciate.
I am going to test a
On 12 mai, 19:16, Michael Bayer <[EMAIL PROTECTED]> wrote:
> lets all repeat the mantra"association tables with any columns
> beyond the two foreign keys use the association object pattern". I
> guess its a little too wordy to be catchy. Documented
> athttp:
er(AskAss, self.poser, properties = {
# Ask Association between questions and users
'users': relation(User, backref = 'ask')
})
self.answerMapper = mapper(AnswerAss, self.answer, properties = {
# ManyToMany AnswerAssocia
roup, 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
-~--~~~~--~~--~--~---
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
-~--~~~~--~~--~--~---
sn't
work either
Thanks in advance for any hints and sorry for the low level of my
question !
Dominique
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send emai
ups.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:
> O
s 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
-~--~~~~--~~--~--~---
adding the
> object to the session, as this will calculate the primary index. Then you can
> simply set col_num = mk_arb_seq(primary_index).
>
> Best Regards,
> Hermann
>
>
>
--~--~-~--~~~---~--~~
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/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
>
> http://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 as
"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
-~--~~~~--~~--~--~---
columns and it would be
quite an undertaking to change all of these. Thanks for you help.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchem
orderstatus_table)
Thanks,
Curtis
--~--~-~--~~~---~--~~
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/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
uot; 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://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/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/group
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
-~--~~~~--~~--~--~---
=False.
Regards, Pierre-yves.
--~--~-~--~~~---~--~~
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 PROT
ciated.
J
--~--~-~--~~~---~--~~
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
mail 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
-~--~~~~--~~--~--~---
e 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
-~--~~~~--~~--~--~---
t;test user"
e = Event()
e.title = "test event"
u.events.append(e)
u.events
e.users
u.participations
e.participations
session.save(u)
session.save(e)
session.flush()
session.clear()
u = session.query(User).get(1)
e = session.query(Event).get(1)
u.participations
e.participations
--~--~
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
-~--~~~~--~~--~--~---
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
-~--~~~~--~~--~--~---
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
etween 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 PROTEC
11:49 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 t
ons 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
Hi Michael, thanks for the help!
The documentation mentions that this option over-rides the per-engine
configuration but I couldn't find a create_engine option to set this.
Any reference would be greatly appreciated!
Mark
On Sep 28, 4:03 pm, Michael Bayer <[EMAIL PROTECTED]> wrote:
his group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
ng a subsequent 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
oogle 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
-~--~~~~--~~--~--~---
('This is another test');
commit;
Here is a test script that throws an error when retrieving the rows of
CLOBs with a fetchall:
#!/usr/bin/python
from sqlalchemy import create_engine
import cx_Oracle
db = create_engine("oracle://user:[EMAIL PROTECTED]");
conn = db.connect()
proxy
ment=None,optional=False)}
running 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('workorderline
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')
d 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
-~--~~~~--~~--~--~---
qlalchemy" 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
-~--~~~~--~~--~--~---
Original
Message
From: "allan bailey" <[EMAIL PROTECTED]>
Or, can anyone recommend another sqlalchemy wrapper for twisted?
There is another wrapper, you can try it:
http://developer.berlios.de/projects/nadba
d use 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 unixodb
How does one explicitly choose one of the connectors?
I would like to specify one explicitly for testing purposes, but I
don't know how. (in the create engine perhaps?)
On Apr 21, 8:16 am, Paul Johnston <[EMAIL PROTECTED]> wrote:
> Rick,
>
> I agree,pyodbcis certain
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=
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
Thanks a bunch Michael, you really saved my day.
Keep up the very good work.
Thanks again.
Sebastien
Michael Bayer wrote:
> On Apr 18, 2007, at 11:43 AM, [EMAIL PROTECTED] wrote:
>
>
>> Hi Guys,
>>
>> I am trying to do this simple update query :
>>
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/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
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. th
ernal hack.
Regards,
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
ect
AttributeError: '_BooleanExpression' object has no attribute 'has_key'
Script terminated.
--~--~-~--~~~---~--~----~
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/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
This query runs fine without server_side_cursors = True
Any suggestions?
--~--~-~--~~~---~--~~
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 fr
://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
cause 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 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
-~--~~~~--~~--~--~---
qlalchemy" 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
-~--~~~~--~~--~--~---
;last_mod':types.DateTime})
def isdatetime(sel):
return isinstance(sel.execute().fetchone().last_mod, \
datetime.datetime)
return isdatetime(selTagged), isdatetime(selText)
sqlite_engine = create_engine('sqlite:///database_test.db')
mysql_engin
e label() youre creating above, i thought perhaps it might
not but i added a test case in 2206 that shows it does.
Yes, the test 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')
~~---~--~~
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/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
s a set.
Any advice?
Thanks in advance,
and happy gnu year 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
gle 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
-~--~~~~--~~--~--~---
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/grou
st 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/
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
-~--~~~~--~~--~--~---
from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
lalchemy@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
-~--~~~~--~~--~--~---
rnate does, 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
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
-~--~~~~--~~--~--~---
le which you can treat
> mostly like a table:
>
> telephone_book = telephone_basic.
> join(firstnames,
> firstnames.c.id==telephone_basic.fname_id).
>join(lastnames,
> lastnames.c.id==telephone_basic.lname_id).select(use_label
ot;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
-~--~~~~--~~--~--~---
TEXT );
sqlite> .schema photo_tags
CREATE TABLE photo_tags ( photo_id INTEGER,tag_id
INTEGER );
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post
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
is 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
-~--~~~~--~~--~--~---
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
I have some code like that:
from sqlalchemy import *
db = create_engine('mysql://[EMAIL PROTECTED]/wiki)
metadata = BoundMetaData(db)
wikis = Table('wiki_wiki', metadata, autoload=True)
# These are the empty classes that will become our data classes
class Wiki(object):
p
ds,
Dmitry
--~--~-~--~~~---~--~~
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
hemy import *
db =
create_engine('mysql://root:[EMAIL PROTECTED]@localhost:3306/quan_user')
db.echo = False # Try changing this to True and see what happens
metadata = BoundMetaData(db, quote=True)
users = Table('users', metadata,
Column('user_id', Integer, primar
hemy import *
db =
create_engine('mysql://root:[EMAIL PROTECTED]@localhost:3306/quan_user')
db.echo = False # Try changing this to True and see what happens
metadata = BoundMetaData(db, quote=True)
users = Table('users', metadata,
Column('user_id', Integ
100 matches
Mail list logo