summaryrefslogtreecommitdiff
path: root/lib/sqlalchemy/databases/sqlite.py
Commit message (Collapse)AuthorAgeFilesLines
* merge 0.6 series to trunk.Mike Bayer2009-08-061-646/+0
|
* Corrected the SQLite SLBoolean type so that it properly treats 1 only as ↵Michael Trier2009-05-051-1/+1
| | | | True. Fixes #1402
* Corrected the sqlite float type so that it properly gets reflected as a ↵Michael Trier2009-04-131-1/+1
| | | | SLFloat type. Fixes #1273.
* Added indexed to the list of reserved keywords (added in 3.6.4). Fixes #1358.Michael Trier2009-04-041-1/+1
|
* extract() is now dialect-sensitive and supports SQLite and others.Jason Kirtland2009-03-301-0/+22
|
* - Fixed SQLite reflection methods so that non-presentMike Bayer2009-03-171-5/+10
| | | | | | | cursor.description, which triggers an auto-cursor close, will be detected so that no results doesn't fail on recent versions of pysqlite which raise an error when fetchone() called with no rows present.
* happy new yearMike Bayer2009-01-121-1/+1
|
* identified the SQLite changes which affect default reflectionMike Bayer2009-01-031-4/+1
|
* send a NASA probe to the buildbotMike Bayer2009-01-031-1/+4
|
* sqlite reflection now stores the actual DefaultClause value for the column.Michael Trier2009-01-021-4/+4
|
* - Reflected foreign keys will properly locateMike Bayer2008-12-261-1/+1
| | | | | | | | | | | | | | | | | | | | | | | their referenced column, even if the column was given a "key" attribute different from the reflected name. This is achieved via a new flag on ForeignKey/ForeignKeyConstraint called "link_to_name", if True means the given name is the referred-to column's name, not its assigned key. [ticket:650] - removed column types from sqlite doc, we aren't going to list out "implementation" types since they aren't significant and are less present in 0.6 - mysql will report on missing reflected foreign key targets in the same way as other dialects (we can improve that to be immediate within reflecttable(), but it should be within ForeignKeyConstraint()). - postgres dialect can reflect table with an include_columns list that doesn't include one or more primary key columns
* removed the "create_execution_context()" method from dialects and replacedMike Bayer2008-12-191-17/+1
| | | | with a more succinct "dialect.execution_ctx_cls" member
* - added sphinx handler to allow __init__ methods throughMike Bayer2008-12-171-0/+115
| | | | | | - sqlite module documentation - some corrections to pool docs - the example in URL.translate_connect_args() never made any sense anyway so removed it
* - Simplified the check for ResultProxy "autoclose without results"Mike Bayer2008-11-041-5/+0
| | | | | | to be based solely on presence of cursor.description. All the regexp-based guessing about statements returning rows has been removed [ticket:1212].
* Modifications to allow the backends to control the behavior of an empty ↵Michael Trier2008-10-201-19/+2
| | | | insert. If supports_empty_insert is True then the backend specifically supports the 'insert into t1 () values ()' syntax. If supports_default_values is True then the backend supports the 'insert into t1 default values' syntax. If both are false then the backend has no support for empty inserts at all and an exception gets raised. Changes here are careful to not change current behavior except where the current behavior was failing to begin with.
* - 0.5.0rc3, dohMike Bayer2008-10-181-3/+0
| | | | | | | | | | | | - The internal notion of an "OID" or "ROWID" column has been removed. It's basically not used by any dialect, and the possibility of its usage with psycopg2's cursor.lastrowid is basically gone now that INSERT..RETURNING is available. - Removed "default_order_by()" method on all FromClause objects. - profile/compile/select test is 8 function calls over on buildbot 2.4 for some reason, will adjust after checking the results of this commit
* - String's (and Unicode's, UnicodeText's, etc.) convert_unicoderel_0_5rc2Mike Bayer2008-10-121-3/+31
| | | | | | | logic disabled in the sqlite dialect, to adjust for pysqlite 2.5.0's new requirement that only Python unicode objects are accepted; http://itsystementwicklung.de/pipermail/list-pysqlite/2008-March/000018.html
* genericized the relationship between bind_processor() and _bind_processor() ↵Mike Bayer2008-09-191-9/+22
| | | | a little more
* - Overhauled SQLite date/time bind/result processingMike Bayer2008-09-191-42/+34
| | | | | | to use regular expressions and format strings, rather than strptime/strftime, to generically support pre-1900 dates, dates with microseconds. [ticket:968]
* - The 'length' argument to all Numeric types has been renamedMike Bayer2008-08-241-1/+1
| | | | | | | | | | | | | | | | to 'scale'. 'length' is deprecated and is still accepted with a warning. [ticket:827] - The 'length' argument to MSInteger, MSBigInteger, MSTinyInteger, MSSmallInteger and MSYear has been renamed to 'display_width'. [ticket:827] - mysql._Numeric now consumes 'unsigned' and 'zerofill' from the given kw, so that the same kw can be passed along to Numeric and allow the 'length' deprecation logic to still take effect - added testlib.engines.all_dialects() to return a dialect for every db module - informix added to sqlalchemy.databases.__all__. Since other "experimental" dbs like access and sybase are there, informix should be as well.
* Raised an error when sqlite version does not support default values. ↵Michael Trier2008-07-291-2/+8
| | | | Addresses #909 in a purposeful way.
* - Removed 2.3 set emulations/enhancements.Jason Kirtland2008-07-151-1/+1
| | | | (sets.Set-based collections & DB-API returns still work.)
* - SQLite Date, DateTime, and Time types only accept PythonMike Bayer2008-07-091-4/+3
| | | | | | | | datetime objects now, not strings. If you'd like to format dates as strings yourself with SQLite, use a String type. If you'd like them to return datetime objects anyway despite their accepting strings as input, make a TypeDecorator around String - SQLA doesn't encourage this pattern.
* - re-fixed the fix to the prefixes fixMike Bayer2008-07-061-7/+1
| | | | | - removed ancient descriptor() functions from dialects; replaced with Dialect.name - removed similarly ancient sys.modules silliness in Engine.name
* merge r4889, SQLite Float type, from 0.4 branchMike Bayer2008-07-021-1/+14
|
* - Modified SQLite's representation of "microseconds" toMike Bayer2008-06-271-3/+10
| | | | | | | | | | | match the output of str(somedatetime), i.e. in that the microseconds are represented as fractional seconds in string format. [ticket:1090] - implemented a __legacy_microseconds__ flag on DateTimeMixin which can be used per-class or per-type instances to get the old behavior, for compatibility with existing SQLite databases encoded by a previous version of SQLAlchemy. - will implement the reverse legacy behavior in 0.4.
* - Implemented generic CHAR_LENGTH for sqlite (-> LENGTH())Jason Kirtland2008-05-191-1/+2
| | | | - Updated .requires for firebird
* Columns now have default= and server_default=. PassiveDefault fades away.Jason Kirtland2008-05-141-2/+2
|
* r4695 merged to trunk; trunk now becomes 0.5.Mike Bayer2008-05-091-11/+11
| | | | 0.4 development continues at /sqlalchemy/branches/rel_0_4
* refactor of default_paramstyle, use paramstyle argument on Dialect to changeMatt Harrison2008-04-071-1/+2
|
* - Invalid SQLite connection URLs now raise an error.Jason Kirtland2008-02-231-0/+7
|
* - Enabled schema support on SQLite, added the temporary table namespace to ↵Jason Kirtland2008-02-051-12/+43
| | | | | | table name reflection - TODO: add sqlite to the standard alternate schema tests. a little tricky, because unlike CREATE SCHEMA, an ATTACH DATABASE won't survive a pool dispose...
* - fixed reflection of Time columns on sqliteJason Kirtland2008-02-011-27/+29
|
* - some consolidation of tests in select.py, movedMike Bayer2008-02-011-1/+8
| | | | | | | other tests to more specific modules - added "now()" as a generic function; on SQLite and Oracle compiles as "CURRENT_TIMESTAMP"; "now()" on all others [ticket:943]
* - Warnings are now issued as SAWarning instead of RuntimeWarning; ↵Jason Kirtland2008-01-111-4/+8
| | | | | | util.warn() wraps this up. - SADeprecationWarning has moved to exceptions. An alias remains in logging until 0.5.
* Include column name in length-less String warning (more [ticket:912])Jason Kirtland2008-01-101-16/+15
|
* redid the _for_ddl String/Text deprecation warning correctly [ticket:912]Mike Bayer2008-01-091-1/+1
|
* - changed name of TEXT to Text since its a "generic" type; TEXT name isMike Bayer2008-01-051-2/+2
| | | | | | | deprecated until 0.5. The "upgrading" behavior of String to Text when no length is present is also deprecated until 0.5; will issue a warning when used for CREATE TABLE statements (String with no length for SQL expression purposes is still fine) [ticket:912]
* happy new yearMike Bayer2008-01-011-1/+1
|
* - sqlite SLDate type will not erroneously render "microseconds" portionMike Bayer2007-12-201-1/+4
| | | | of a datetime or time object when sent to the DB.
* - auto-reconnect support improved; a Connection can now automaticallyMike Bayer2007-12-191-0/+3
| | | | | | | | | | reconnect after its underlying connection is invalidated, without needing to connect() again from the engine. This allows an ORM session bound to a single Connection to not need a reconnect. Open transactions on the Connection must be rolled back after an invalidation of the underlying connection else an error is raised. Also fixed bug where disconnect detect was not being called for cursor(), rollback(), or commit().
* - named_with_column becomes an attributeMike Bayer2007-11-251-5/+2
| | | | | | | | | - cleanup within compiler visit_select(), column labeling - is_select() removed from dialects, replaced with returns_rows_text(), returns_rows_compiled() - should_autocommit() removed from dialects, replaced with should_autocommit_text() and should_autocommit_compiled() - typemap and column_labels collections removed from Compiler, replaced with single "result_map" collection. - ResultProxy uses more succinct logic in combination with result_map to target columns
* added REAL to reflection listMike Bayer2007-10-311-0/+1
|
* - sqlite will reflect "DECIMAL" as a numeric columnMike Bayer2007-10-221-0/+1
|
* Fixed empty (zero column) sqlite inserts, allowing inserts onJason Kirtland2007-10-191-0/+15
| | | | autoincrementing single column tables.
* - added test coverage for unknown type reflection, fixedMike Bayer2007-10-181-3/+3
| | | | sqlite/mysql handling of type reflection for unknown types
* - sqlite housekeeping- added dialect test & moved tests there, pruned the ↵Jason Kirtland2007-10-111-9/+20
| | | | dialect's reserved words.
* - fixed sqlite reflection of BOOL/BOOLEAN [ticket:808]Mike Bayer2007-10-051-0/+2
|
* add sqlite reserved words listAnts Aasma2007-09-171-0/+9
|
* Housekeeping.Jason Kirtland2007-08-221-14/+11
|
View Lorry Controller Status