On 12-02-2013 13:29, shaung wrote:
On Tuesday, February 12, 2013 7:18:37 PM UTC+9, Simon King wrote:
If you add echo='debug' to your create_engine call, SA will log all
calls to the database and rows returned, which might give you an idea
of where all the time is being spent.
Thank
On 17-05-2012 14:23, Matteo Boscolo wrote:
Hi All,
I'm looking for a good web framework to show my sqlalchemy information
on the web.
I google and I found several solution like piramid,django,
glashammer,flask but I' do not know exactly witch is the more simple for
sqlalchemy.
could you give me
-2012 12:39, Robert Forkel wrote:
sqlalchemy.sql.expression.func may work for this:
from sqlalchemy.sql.expression import func
...
q_doc.filter(func.substring(model.Doc.FileNameStr, 22, 1)==search_str)
...
2012/3/8 Timuçin Kızılay:
I have a query contains SUBSTRING in where clause:
Select top
I have a query contains SUBSTRING in where clause:
Select top 100 * from _Doc
where SUBSTRING(_Doc.FileNameStr, 22, 1) = '2'
---
This query runs on mssql but I need to use that query from sa.
I could not find anything like this in SA documentatin.
Here is what I tried so far:
q_doc = dbsess
On 05-03-2012 11:29, Chris Withers wrote:
Hi All,
What's now the best way to connect to a Microsoft SQL Server instance
from a linux box? What's the recommended driver?
cheers,
Chris
I'm using pyodbc and freetds packages to connect to existing mssql
server 2008 running on windows.
here
I think, reversing the sort and getting the first record will do.
20-07-2011 16:32, Krishnakant Mane yazmış:
Hello all,
Subject line says it all.
Basically what I want to do is to get last record from a result set.
I am dealing with a situation where given a date I need to know the last
record
I'm using SA with turbogears 2.x framework and in development mode when
I turn on all the logging I can see the generated SA queries in the
paste web server console. And one line after the generated query, there
is a line which shows the parameters.
here is a sample output:
---
Hi,
I'm trying to rewrite an application using Turbogears 2.x framework.
There is a query in that application, which works fine on ms-sql server:
here is the query:
-
select
Firma_ID = Firma.ID,
Firma_Kod = Firma.Kod,
Firma_Ad = Firma.Unvan,
Nakliye_Tutar = Sum(Sv.Nakliye
lt;4c481c75.4090...@savaskarsitlari.org>
On Thursday, July 22, 2010 12:24:53 Timuçin Kızılay wrote:
Diez B. Roggisch yazmış:
> On Thursday, July 22, 2010 11:47:13 Timuçin Kızılay wrote:
>> I'm trying to make a query like this:
>>
>> prc_filter = 24
>>
>&g
I'm using sqlalchemy with turbogears framework.
I have some tables and some complex queries with lots of joins and
filters. is tehere a simple way to make those queries like views and use
those views in other more complex queries like they are tables?
--
You received this message because you
Dan @ Austria yazmış:
Hi,
i m a developer with some experience in python and django - a
framework i realy like. However, i just read the sqlalchemy docu and i
think the orm seems to be really professional.
Is sqlalchemy the most prominent orm for python? Is it suitable to
write larger enterpri
11 matches
Mail list logo