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.

(Continue reading)

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
(Continue reading)

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.

(Continue reading)

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
Oleg Broytman | 13 Feb 16:49 2014
X-Face

SQLObject needs your help!

Hello, everyone! In his yesterday's post
http://www.ianbicking.org/blog/2014/02/saying-goodbye-to-python.html
Ian Bicking mentioned me as the person who saved him from the burden of
maintaining SQLObject. Thank you, Ian! It was an interesting experience
(and an urgent business need at that time).
   Unfortunately now is the worst time to praise me for working on
SQLObject. As everyone can see I wasn't very active the last year(s) and
this year the work stopped completely. I must apologize and explain
myself.
   I failed to build an active community. I am sorry. My communication
skills are perhaps not so good. And I certainly lack community-building
skills.
   Currently I am involved in three big projects, only one of them uses
SQLObject. I am tired and seldom have power to do anything besides my
work. Even worse, said project doesn't generate enough revenue and my
bosses decided to cut it in a month or two. After that I will have even
less incentive to work on SQLObject. I am very very sorry.
   It would be best for SQLObject and the community if someone takes
over the project and revives it. If you'd like, please step up.
   Or, if nobody wants to take the lead, I can continue working as the
integrator. Please send your patches (SourceForge tracker, mail list,
private mail directly to me), I'll test them, apply them and will
release new versions. I can help converting the repository to Mercurial
or git (I prefer git) if there are developers who are interested in
working with a distributed VCS.
   But without your work, dear developers, SQLObject is doomed.

Oleg.
--

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

------------------------------------------------------------------------------
Android apps run on BlackBerry 10
Introducing the new BlackBerry 10.2.1 Runtime for Android apps.
Now with support for Jelly Bean, Bluetooth, Mapview and more.
Get your Android app in front of a whole new audience.  Start now.
http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk

Gmane