summaryrefslogtreecommitdiff
path: root/lib/sqlalchemy/databases/sqlite.py
Commit message (Collapse)AuthorAgeFilesLines
* - 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
|
* For sqlite NUMERIC, send Decimal bind values as strings instead of ↵Jason Kirtland2007-08-221-0/+9
| | | | converting to floats.
* - method call removalMike Bayer2007-08-201-6/+2
|
* 1. Module layout. sql.py and related move into a package called "sql".Mike Bayer2007-08-181-23/+18
| | | | | | | | | | | | 2. compiler names changed to be less verbose, unused classes removed. 3. Methods on Dialect which return compilers, schema generators, identifier preparers have changed to direct class references, typically on the Dialect class itself or optionally as attributes on an individual Dialect instance if conditional behavior is needed. This takes away the need for Dialect subclasses to know how to instantiate these objects, and also reduces method overhead by one call for each one. 4. as a result of 3., some internal signatures have changed for things like compiler() (now statement_compiler()), preparer(), etc., mostly in that the dialect needs to be passed explicitly as the first argument (since they are just class references now). The compiler() method on Engine and Connection is now also named statement_compiler(), but as before does not take the dialect as an argument. 5. changed _process_row function on RowProxy to be a class reference, cuts out 50K method calls from insertspeed.py
* added support for string date passthru in sqliteMike Bayer2007-08-161-1/+4
|
* - merged "fasttypes" branch. this branch changes the signatureMike Bayer2007-08-141-31/+43
| | | | | | | | | | | | | of convert_bind_param() and convert_result_value() to callable-returning bind_processor() and result_processor() methods. if no callable is returned, no pre/post processing function is called. - hooks added throughout base/sql/defaults to optimize the calling of bind param/result processors so that method call overhead is minimized. special cases added for executemany() scenarios such that unneeded "last row id" logic doesn't kick in, parameters aren't excessively traversed. - new performance tests show a combined mass-insert/mass-select test as having 68% fewer function calls than the same test run against 0.3. - general performance improvement of result set iteration is around 10-20%.
* auto-commit after LOAD DATA INFILE for mysqlJason Kirtland2007-08-121-1/+3
| | | | caught a couple more uncompiled regexps
* switch (simple) occurences of 'if len(x)' to 'if x': find . -name '*.py' ↵Jonathan Ellis2007-08-031-1/+1
| | | | |xargs perl -pi.bak -e 's/if len\((\S+)\):/if $1:/' && find . -name '*.bak' |xargs rm
* - Dialects can be queried for the server version (sqlite and mysql only with ↵Jason Kirtland2007-08-031-0/+3
| | | | | | | | | | | | | | this commit) - Mark everything in a test suite as failed when setUpAll fails. - Added test coverage for Unicode table names in metadata.reflect() - @testing.exclude() filters out tests by server version - Applied exclude to the test suite, MySQL 4.1 passes again (no XA or SAVEPOINT) - Removed MySQL charset-setting pool hook- charset=utf8&use_unicode=0 works just as well. (Am I nuts? I'd swear this didn't work before.) - Finally migrated some old MySQL-tests into the dialect test module - Corrected 'commit' and 'rollback' logic (and comment) for ancient MySQL versions lacking transactions entirely - Deprecated the MySQL get_version_info in favor of server_version_info - Added a big hunk-o-doc for MySQL.
* - removed import of old sqlite module [ticket:654]Mike Bayer2007-07-291-6/+1
| | | | | - removed sqlite version warning, all tests pass 100% with py2.5's older sqlite lib - fixed dynamic test for py2.5
* engine.table_names()Jonathan Ellis2007-07-291-0/+4
| | | | tested vs sqlite and pg. mssql should also be ok (uses ischema like pg.) others are best-guess based on has_table code.
* merging 0.4 branch to trunk. see CHANGES for details. 0.3 moves to ↵Mike Bayer2007-07-271-19/+22
| | | | maintenance branch in branches/rel_0_3.
* Better quoting of identifiers when manipulating schemasJason Kirtland2007-07-191-1/+2
| | | | Merged from r2981
* Properly escape table names when reflecting for mssql and sqlite [ticket:653]Paul Johnston2007-07-171-3/+3
|
* rearrange sqlite dialect initialization to be able to warn about pysqlite1 ↵Ants Aasma2007-07-141-1/+1
| | | | being too old. fixes #654
* - result.last_inserted_ids() should return a list that is identicallyMike Bayer2007-06-171-1/+3
| | | | | | sized to the primary key constraint of the table. values that were "passively" created and not available via cursor.lastrowid will be None. - sqlite: string PK column inserts dont get overwritten with OID [ticket:603]
* - sqlite better handles datetime/date/time objects mixed and matchedMike Bayer2007-06-171-6/+15
| | | | with various Date/Time/DateTime columns
* include current versions in warning messages. simplify sqlite_ver test; if ↵Jonathan Ellis2007-06-011-3/+3
| | | | a tuple is less than 2,1,3 it is also less than 2,2
* - converted logger.warn() to warnings.warn()Mike Bayer2007-04-211-2/+9
| | | | - implemented #302
* - Promoted mysql's dburl query string helper to util + fixedJason Kirtland2007-04-191-1/+10
| | | | | | - Coercing sqlite connect args provided in query string to their expected type (e.g. 'timeout' as float, fixes #544) - Coerce mysql's client_flag to int too
* - the dialects within sqlalchemy.databases become a setuptoolsMike Bayer2007-04-171-13/+15
| | | | | | entry points. loading the built-in database dialects works the same as always, but if none found will fall back to trying pkg_resources to load an external module [ticket:521]
* - got unicode schemas to work with postgresMike Bayer2007-04-151-0/+3
| | | | | - unicode schema with mysql slightly improved, still cant do has_table - got reflection of unicode schemas working with sqlite, pg, mysql
* - some cleanup of reflection unit testsMike Bayer2007-04-041-3/+0
| | | | | | - removed silly behavior where sqlite would reflect UNIQUE indexes as part of the primary key (?!) - added __contains__ support to ColumnCollection; contains_column() method should be removed
* - merged the "execcontext" branch, refactors engine/dialect codepathsMike Bayer2007-04-021-33/+27
| | | | | | | | | | | | | | | | | | | | - much more functionality moved into ExecutionContext, which impacted the API used by dialects to some degree - ResultProxy and subclasses now designed sanely - merged patch for #522, Unicode subclasses String directly, MSNVarchar implements for MS-SQL, removed MSUnicode. - String moves its "VARCHAR"/"TEXT" switchy thing into "get_search_list()" function, which VARCHAR and CHAR can override to not return TEXT in any case (didnt do the latter yet) - implements server side cursors for postgres, unit tests, #514 - includes overhaul of dbapi import strategy #480, all dbapi importing happens in dialect method "dbapi()", is only called inside of create_engine() for default and threadlocal strategies. Dialect subclasses have a datamember "dbapi" referencing the loaded module which may be None. - added "mock" engine strategy, doesnt require DBAPI module and gives you a "Connecition" which just sends all executes to a callable. can be used to create string output of create_all()/drop_all().
* migrated (most) docstrings to pep-257 format, docstring generator using ↵Mike Bayer2007-02-251-16/+41
| | | | | | straight <pre> + trim() func for now. applies most of [ticket:214], compliemnts of Lele Gaifax
* - added "schema" argument to all has_table() calls, only supported so far by PGMike Bayer2007-02-041-1/+1
| | | | - added basic unit test for PG reflection of tables in an alternate schema
* oracle can conditionally decide if it wants to say "use rowid" in a select ↵Mike Bayer2007-01-241-1/+1
| | | | | | | statement. needs to be tweaked vs. when ROW NUMBER OVER ORDER BY is being used, but currently fixes [ticket:436]
* tweak to support reflecting eqlite columns that didnt specify a typeMike Bayer2007-01-061-2/+6
|
* copyright updateMike Bayer2007-01-051-1/+1
|
* - support for None as precision/length in numeric types for postgres, ↵Mike Bayer2006-12-091-1/+4
| | | | | | sqlite, mysql - postgres reflection fixes: [ticket:349] [ticket:382]
* removed useless lineMike Bayer2006-12-031-1/+0
|
View Lorry Controller Status