Gert Burger | 25 Aug 10:22 2014
Picon

Indexes with primary key

Hi

Is it possible to create indexes using SQLO that include the current 'Table's primary key?
eg DatabaseIndex(col1, col2, col3, 'id')

Currently SQLO is complaining that the column doesn't exist.

Regards
Gert Burger
------------------------------------------------------------------------------
Slashdot TV.  
Video for Nerds.  Stuff that matters.
http://tv.slashdot.org/
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
Oleg Broytman | 1 Aug 02:36 2014
X-Face

SQLObject 2.0.0a1

Hello!

I'm pleased to announce version 2.0.0a1, the first alpha of branch 2.0 of
SQLObject. This is the first release that was developed after switching from
Subversion to git!

What's new in SQLObject
=======================

Features & Interface
--------------------

* DateTimeCol and TimeCol can read and write values with microseconds.

  WARNING: backward compatibility problem! Date/Time columns created
  with microseconds cannot be read back from SQLite databases (and
  perhaps other backends) with versions of SQLObject older than 1.7.

Minor features
--------------

* Upgrade ez_setup to 5.4.1.

Development
-----------

* Development was switched from Subversion to git.

Contributor for this release is Geoffrey Wossum.

For a more complete list, please see the news:
http://sqlobject.org/News.html

What is SQLObject
=================

SQLObject is an object-relational mapper.  Your database tables are described
as classes, and rows are instances of those classes.  SQLObject is meant to be
easy to use and quick to get started with.

SQLObject supports a number of backends: MySQL, PostgreSQL, SQLite,
Firebird, Sybase, MSSQL and MaxDB (also known as SAPDB).

Where is SQLObject
==================

Site:
http://sqlobject.org

Development:
http://sqlobject.org/devel/

Mailing list:
https://lists.sourceforge.net/mailman/listinfo/sqlobject-discuss

Archives:
http://news.gmane.org/gmane.comp.python.sqlobject

Download:
https://pypi.python.org/pypi/SQLObject/2.0.0a1dev-20140801

News and changes:
http://sqlobject.org/News.html

Oleg.
--

-- 
     Oleg Broytman            http://phdru.name/            phd <at> phdru.name
           Programmers don't die, they just GOSUB without RETURN.

------------------------------------------------------------------------------
Want fast and easy access to all the code in your enterprise? Index and
search up to 200,000 lines of code with a free copy of Black Duck
Code Sight - the same software that powers the world's largest code
search on Ohloh, the Black Duck Open Hub! Try it now.
http://p.sf.net/sfu/bds
Oleg Broytman | 29 Jul 15:34 2014
X-Face

Convert svn to git

Hello! Ready. I created two repositories: "fullhistory" preserves the
entire history from SVN repository, "sqlobject" is the development repo
with those branches that are currently maintained - 1.5, 1.6, 1.7 and
master; those branches preserves their history too; I decided not to cut
history - it's small enough.

   http://sourceforge.net/p/sqlobject/sqlobject
   http://sourceforge.net/p/sqlobject/fullhistory

   https://github.com/sqlobject/sqlobject
   https://github.com/sqlobject/fullhistory

Oleg.
--

-- 
     Oleg Broytman            http://phdru.name/            phd <at> phdru.name
           Programmers don't die, they just GOSUB without RETURN.

------------------------------------------------------------------------------
Infragistics Professional
Build stunning WinForms apps today!
Reboot your WinForms applications with our WinForms controls. 
Build a bridge from your legacy apps to the future.
http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk
Oleg Broytman | 21 Jul 23:57 2014
X-Face

Converting svn to git

Hello, all!

   I've been working for some time behind the scene on converting the
subversion repository to git in hope it helps to revive development a
bit. Now when I'm mostly done I decided to communicate what's going on.

   First, I decided it must be git; git is a clear winner now.

   Second, I want to preserve the entire history, so I decided to
convert entire subversion repository to git. To do that I need a mapping
from svn login names to committers names and email addresses. I
collected them from svn and the mailing list archive. There are exactly
20 committers!
   Today I wrote 18 mail messages (excluding Ian Bicking and me from the
list of committers) asking their permissions to use their names and
emails in the public git repositories. I already get a few errors back;
some mailboxes are no longer available at their original domains; even
worse, some domains are no longer available or don't accept mail.
   One person I have to hunt especially hard -- he used 4 different
email addresses, none of which are now available. Finally I contacted
him via SF.net and he already replied -- the first one of those 18! He
gave me sixths address (-:
   I'm waiting for the other committers. As for unavailable ones -- I'm
afraid I have to use whatever addresses I have for them.

   After the conversion there will be two repositories -- one with full
history and another with a small subset of active branches; currently
these are branches 1.5, 1.6, 1.7 and the trunk^W master.
   I will push these repositories to SF and github; I still value SF as
hosting; with distributed nature of git it's no longer a problem to have
clones/forks/mirrors all over the Net.
   Full history repository will be read-only; the other one is for
development. Repository at SF will be configured to send email
notifications on every push to sqlobject-cvs (heh) mailing list.

   Along with full history and development repositories at github there
will be a documentation repository with generated docs. Actually, it's
already there; docs are visible at http://sqlobject.github.io/ .

   Currently I am developing a git workflow (if there will be any).
Perhaps I preserve the current workflow. With it, master will be the new
trunk with all the latest unstable code; from it stable branches will be
branched off. With such workflow it'd be a bit hard to merge pull
requests directly from github web interface; I think I'll merge them
locally and then push merges.

Oleg.
--

-- 
     Oleg Broytman            http://phdru.name/            phd <at> phdru.name
           Programmers don't die, they just GOSUB without RETURN.

------------------------------------------------------------------------------
Want fast and easy access to all the code in your enterprise? Index and
search up to 200,000 lines of code with a free copy of Black Duck
Code Sight - the same software that powers the world's largest code
search on Ohloh, the Black Duck Open Hub! Try it now.
http://p.sf.net/sfu/bds
Oleg Broytman | 1 Jul 19:48 2014
X-Face

SQLObject 1.7.0b1

Hello!

I'm pleased to announce version 1.7.0b1, the first beta of the upcoming
release of branch 1.7 of SQLObject.

What's new in SQLObject
=======================

* Python 2.5 is no longer supported. The minimal supported version is
  Python 2.6.

* DateTimeCol and TimeCol can read values with microseconds (created by
  SQLObject 2.0) but do not write microseconds back.

* Upgrade ez_setup to 5.3.

* Adapt duplicate error message strings for SQLite 3.8.

Contributors for this release are Geoffrey Wossum and Neil Muller.

For a more complete list, please see the news:
http://sqlobject.org/News.html

What is SQLObject
=================

SQLObject is an object-relational mapper.  Your database tables are described
as classes, and rows are instances of those classes.  SQLObject is meant to be
easy to use and quick to get started with.

SQLObject supports a number of backends: MySQL, PostgreSQL, SQLite,
Firebird, Sybase, MSSQL and MaxDB (also known as SAPDB).

Where is SQLObject
==================

Site:
http://sqlobject.org

Development:
http://sqlobject.org/devel/

Mailing list:
https://lists.sourceforge.net/mailman/listinfo/sqlobject-discuss

Archives:
http://news.gmane.org/gmane.comp.python.sqlobject

Download:
https://pypi.python.org/pypi/SQLObject/1.7.0b1dev-r4758

News and changes:
http://sqlobject.org/News.html

Oleg.
--

-- 
     Oleg Broytman            http://phdru.name/            phd <at> phdru.name
           Programmers don't die, they just GOSUB without RETURN.

------------------------------------------------------------------------------
Open source business process management suite built on Java and Eclipse
Turn processes into business applications with Bonita BPM Community Edition
Quickly connect people, data, and systems into organized workflows
Winner of BOSSIE, CODIE, OW2 and Gartner awards
http://p.sf.net/sfu/Bonitasoft
Goldberg, Arthur P | 16 Jun 22:50 2014

Join with results from both tables

Hi 

I'm just learning sqlobject and find it pretty neat!

Suppose I have this:
from sqlobject import *

class Variant2(SQLObject):
    class sqlmeta:
        style = Style(longID=True)
    ref = StringCol()
    alt = StringCol()
    SubjectID = StringCol() 

class Subject2(SQLObject):
    FamilyID = StringCol()
    IndivID = StringCol( alternateID=True, length=50 )  # do not know if this is long enough
    Sex = StringCol()

connection = connectionForURI(Minerva_URI)
connection.debug = True
sqlhub.processConnection = connection
Variant2.dropTable( True, )
Variant2.createTable()
Subject2.dropTable( True, )
Subject2.createTable()

Variant2( 
    ref = 'A',
    alt = 'C',
    SubjectID = 'Sub1' )
    
Variant2( 
    ref = 'A',
    alt = 'G',
    SubjectID = 'Sub2' )
    
Subject2( FamilyID = '', IndivID = 'Sub1', Sex = '1' )
Subject2( FamilyID = '', IndivID = 'Sub2', Sex = '2' )
    
for var in Variant2.select( 
    """ subject2.indiv_id = Variant2.SubjectID""",
    clauseTables=['subject2']):
    print var

How would I generate a query that joins Variant2 and subject2? Like this:

SELECT Variant2.Variant2_id, Variant2.ref, Variant2.alt, Variant2.AAC, Variant2.SubjectID, subject2.Sex FROM subject2, Variant2 WHERE  subject2.indiv_id = Variant2.SubjectID;

Also, how could I define SubjectID as a foreign key that references indiv_id?

Thanks
Arthur




---
 
Arthur Goldberg
Associate Professor of Psychiatry
Seaver Autism Center and Icahn Institute for Genomics & Multiscale Biology
Icahn School of Medicine at Mount Sinai
Seaver Center, Room ABE-33
Follow us on Twitter  <at> IcahnInstitute




------------------------------------------------------------------------------
HPCC Systems Open Source Big Data Platform from LexisNexis Risk Solutions
Find What Matters Most in Your Big Data with HPCC Systems
Open Source. Fast. Scalable. Simple. Ideal for Dirty Data.
Leverages Graph Analysis for Fast Processing & Easy Data Exploration
http://p.sf.net/sfu/hpccsystems
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
Oleg Broytman | 15 May 17:56 2014
X-Face

SQLObject 1.6.0

Hello!

I'm pleased to announce version 1.6.0, the first stable release of branch
1.6 of SQLObject.

What's new in SQLObject
=======================

Features & Interface
--------------------

* Python 2.4 is no longer supported. The minimal supported version is
  Python 2.5.

* Support for Python 2.5 is declared obsolete and will be removed
  in the next release.

* Upgrade ez_setup to 1.4.2.

* Adapt duplicate error message strings for SQLite 3.8.

Contributor for this release is Neil Muller.

For a more complete list, please see the news:
http://sqlobject.org/News.html

What is SQLObject
=================

SQLObject is an object-relational mapper.  Your database tables are described
as classes, and rows are instances of those classes.  SQLObject is meant to be
easy to use and quick to get started with.

SQLObject supports a number of backends: MySQL, PostgreSQL, SQLite,
Firebird, Sybase, MSSQL and MaxDB (also known as SAPDB).

Where is SQLObject
==================

Site:
http://sqlobject.org

Development:
http://sqlobject.org/devel/

Mailing list:
https://lists.sourceforge.net/mailman/listinfo/sqlobject-discuss

Archives:
http://news.gmane.org/gmane.comp.python.sqlobject

Download:
https://pypi.python.org/pypi/SQLObject/1.6.0

News and changes:
http://sqlobject.org/News.html

Oleg.
--

-- 
     Oleg Broytman            http://phdru.name/            phd <at> phdru.name
           Programmers don't die, they just GOSUB without RETURN.

------------------------------------------------------------------------------
"Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos.
Get unparalleled scalability from the best Selenium testing platform available
Simple to use. Nothing to install. Get started now for free."
http://p.sf.net/sfu/SauceLabs
Oleg Broytman | 1 May 00:17 2014
X-Face

Roadmap to 2.0 (up to the last microsecond)

Hello!

   A big part of my frustration was that I created a backward
incompatible version and didn't know where and how to move further from
there.
   Now I see it was stupid. Such a major incompatibility should only be
introduced in version 2.0. Gradually if possible.

   So my plan currently is:

-- Completely remove support for microseconds from branch 1.6; deprecate
   support for Python 2.5 (format ".%f" for microseconds is only
   supported in 2.6+).
-- Create branch 1.7; drop support for Python 2.5, minimally supported
   version will be 2.6; restore the code to read microseconds (from
   databases created with SO 2.0) but not write them.
-- Create branch 2.0 with full support for microseconds.

PS. I beg your pardon. I said something about microseconds in the
subject but that was only a pun. I cannot promise months, even less
concrete dates. I'm sorry.

Oleg.
--

-- 
     Oleg Broytman            http://phdru.name/            phd <at> phdru.name
           Programmers don't die, they just GOSUB without RETURN.

------------------------------------------------------------------------------
"Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos.  Get 
unparalleled scalability from the best Selenium testing platform available.
Simple to use. Nothing to install. Get started now for free."
http://p.sf.net/sfu/SauceLabs
Oleg Broytman | 13 Apr 14:28 2014
X-Face

SQLObject 1.5.2

Hello!

I'm pleased to announce version 1.5.2, the second bugfix release of branch
1.5 of SQLObject.

What's new in SQLObject
=======================

* Adapt duplicate error message strings for SQLite 3.8.

Contributor for this release is Neil Muller.

For a more complete list, please see the news:
http://sqlobject.org/News.html

What is SQLObject
=================

SQLObject is an object-relational mapper.  Your database tables are described
as classes, and rows are instances of those classes.  SQLObject is meant to be
easy to use and quick to get started with.

SQLObject supports a number of backends: MySQL, PostgreSQL, SQLite,
Firebird, Sybase, MSSQL and MaxDB (also known as SAPDB).

Where is SQLObject
==================

Site:
http://sqlobject.org

Development:
http://sqlobject.org/devel/

Mailing list:
https://lists.sourceforge.net/mailman/listinfo/sqlobject-discuss

Archives:
http://news.gmane.org/gmane.comp.python.sqlobject

Download:
https://pypi.python.org/pypi/SQLObject/1.5.2

News and changes:
http://sqlobject.org/News.html

Oleg.
--

-- 
     Oleg Broytman            http://phdru.name/            phd <at> phdru.name
           Programmers don't die, they just GOSUB without RETURN.

------------------------------------------------------------------------------
Put Bad Developers to Shame
Dominate Development with Jenkins Continuous Integration
Continuously Automate Build, Test & Deployment 
Start a new project now. Try Jenkins in the cloud.
http://p.sf.net/sfu/13600_Cloudbees
Oleg Broytman | 13 Apr 14:29 2014
X-Face

SQLObject 1.6.0b1

Hello!

I'm pleased to announce version 1.6.0b1, the first beta of the upcoming
release of branch 1.6 of SQLObject.

What's new in SQLObject
=======================

Features & Interface
--------------------

* Python 2.4 is no longer supported. The minimal supported version is
  Python 2.5.

* DateTimeCol and TimeCol preserve microseconds. The feature requires
  Python 2.6+ because in Python 2.5 datetime.strptime doesn't support
  '%f' format.

  WARNING: backward compatibility problem! Date/Time columns created
  with microseconds cannot be read back with older versions of
  SQLObject.

* Upgrade ez_setup to 1.4.2.

* Adapt duplicate error message strings for SQLite 3.8.

Contributors for this release are Geoffrey Wossum and Neil Muller.

For a more complete list, please see the news:
http://sqlobject.org/News.html

What is SQLObject
=================

SQLObject is an object-relational mapper.  Your database tables are described
as classes, and rows are instances of those classes.  SQLObject is meant to be
easy to use and quick to get started with.

SQLObject supports a number of backends: MySQL, PostgreSQL, SQLite,
Firebird, Sybase, MSSQL and MaxDB (also known as SAPDB).

Where is SQLObject
==================

Site:
http://sqlobject.org

Development:
http://sqlobject.org/devel/

Mailing list:
https://lists.sourceforge.net/mailman/listinfo/sqlobject-discuss

Archives:
http://news.gmane.org/gmane.comp.python.sqlobject

Download:
https://pypi.python.org/pypi/SQLObject/1.6.0b1dev-r4713

News and changes:
http://sqlobject.org/News.html

Oleg.
--

-- 
     Oleg Broytman            http://phdru.name/            phd <at> phdru.name
           Programmers don't die, they just GOSUB without RETURN.

------------------------------------------------------------------------------
Put Bad Developers to Shame
Dominate Development with Jenkins Continuous Integration
Continuously Automate Build, Test & Deployment 
Start a new project now. Try Jenkins in the cloud.
http://p.sf.net/sfu/13600_Cloudbees
Andrew Philpot | 24 Feb 20:33 2014
Picon

sqlobject back end to Oracle

What is the status of this backend?  I'm being encouraged to deploy an 
sqlobject+MySQL app to an Oracle shop.  Assuming there is nothing 
available, are there other strategies folks have used to bridge this gap?

Andrew

------------------------------------------------------------------------------
Flow-based real-time traffic analytics software. Cisco certified tool.
Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer
Customize your own dashboards, set traffic alerts and generate reports.
Network behavioral analysis & security monitoring. All-in-one tool.
http://pubads.g.doubleclick.net/gampad/clk?id=126839071&iu=/4140/ostg.clktrk

Gmane