summaryrefslogtreecommitdiff
path: root/lib/sqlalchemy/dialects/sqlite
Commit message (Collapse)AuthorAgeFilesLines
...
* Add some `Sphinx` paragraph level versions informations markups,Mike Bayer2012-06-081-6/+4
| | | | such as ``.. versionadded::``, ``.. versionchanged::`` and ``.. deprecated::``.
* add a note about sqlites lack of concurrency by design, [ticket:2447]Mike Bayer2012-05-171-0/+32
|
* - [feature] Added SQLite execution optionMike Bayer2012-05-041-10/+17
| | | | | | | "sqlite_raw_colnames=True", will bypass attempts to remove "." from column names returned by SQLite cursor.description. [ticket:2475]
* - [feature] Inspector.get_primary_keys() isMike Bayer2012-04-241-2/+2
|\ | | | | | | | | | | | | | | deprecated; use Inspector.get_pk_constraint(). Courtesy Diana Clarke. [ticket:2422] - restored default get_primary_keys()/get_pk_constraint() wrapper to help maintain compatibility with third party dialects created against 0.6 or 0.7
| * deprecate inspector.get_primary_keys() in favor of inspector.get_pk_constraint()Diana Clarke2012-04-021-2/+2
| | | | | | | | - see #2422
* | - [feature] the SQLite date and time typesMike Bayer2012-04-241-43/+85
|\ \ | |/ |/| | | | | | | | | | | | | | | | | have been overhauled to support a more open ended format for input and output, using name based format strings and regexps. A new argument "microseconds" also provides the option to omit the "microseconds" portion of timestamps. Thanks to Nathan Wright for the work and tests on this. [ticket:2363]
| * Improve SQLite DATETIME storage format handling [ticket:2363]Nathan Wright2012-03-121-43/+85
| | | | | | | | | | | | | | | | | | | | | | | | | | | | This breaks backwards compatibility with old SQLite DATETIME, DATE, and TIME storage_format strings. Formatting now occurs with named instead of positional parameters. The regexp argument can still use positional arguments, but named groupings are also supported. This means that you can omit fields and change the order of date fields as desired. SQLite's DATETIME and TIME also gained a truncate_microseconds argument. This is shorthand for modifying the format string. Fortunately the str_to_datetime and str_to_time processors written in C already support omitting microseconds, so we don't have to resort to python processing for this case.
* | typoes in lib/sqlalchemy/dialectsDiana Clarke2012-03-171-6/+6
|/
* - [bug] A significant change to how labelingMike Bayer2012-02-051-15/+10
| | | | | | | | | | | | | | is applied to columns in SELECT statements allows "truncated" labels, that is label names that are generated in Python which exceed the maximum identifier length (note this is configurable via label_length on create_engine()), to be properly referenced when rendered inside of a subquery, as well as to be present in a result set row using their original in-Python names. [ticket:2396] - apply pep8 to test_labels
* then merge thisMike Bayer2012-01-281-1/+1
|\
| * - [feature] Dialect-specific compilers now raiseMike Bayer2012-01-281-1/+1
| | | | | | | | | | | | | | | | CompileException for all type/statement compilation issues, instead of InvalidRequestError or ArgumentError. The DDL for CREATE TABLE will re-raise CompileExceptions to include table/column information for the problematic column. [ticket:2361]
* | - [bug] removed an erroneous "raise" in theMike Bayer2012-01-281-3/+0
|/ | | | | | | | SQLite dialect when getting table names and view names, where logic is in place to fall back to an older version of SQLite that doesn't have the "sqlite_temp_master" table.
* - [feature] Added "false()" and "true()" expressionMike Bayer2012-01-181-0/+6
| | | | | | | constructs to sqlalchemy.sql namespace, though not part of __all__ as of yet. - [bug] sql.false() and sql.true() compile to 0 and 1, respectively in sqlite [ticket:2368]
* that's not a "name=0", that's a counter. so name is None unconditonally.Mike Bayer2012-01-071-6/+4
| | | | [ticket:2348]
* - [bug] the "name" of an FK constraint in SQLiteMike Bayer2012-01-071-0/+2
| | | | | | is reflected as "None", not "0" [ticket:2364]. SQLite does not appear to support constraint naming in any case (the names are ignored).
* happy new yearMike Bayer2012-01-043-3/+3
|
* fix a whole bunch of note:: / warning:: that were inline,Mike Bayer2011-12-251-4/+6
| | | | no longer compatible with docutils 0.8
* add BEGIN workaround to pysqlite docs, [ticket:2219]Mike Bayer2011-12-062-1/+28
|
* marathon doc updating session including a rewrite of unicode paragraphsMike Bayer2011-12-041-9/+8
|
* link date/time classes correctly, helps [ticket:2244]Mike Bayer2011-08-041-1/+1
|
* - SQLite dialect no longer strips quotesMike Bayer2011-07-281-4/+6
| | | | | | | | off of reflected default value, allowing a round trip CREATE TABLE to work. This is consistent with other dialects that also maintain the exact form of the default. [ticket:2189]
* - Failures on connect which raise dbapi.ErrorMike Bayer2011-07-011-1/+2
| | | | | | | | | | | | will forward the error to dialect.is_disconnect() and set the "connection_invalidated" flag if the dialect knows this to be a potentially "retryable" condition. Only Oracle ORA-01033 implemented for now. [ticket:2201] - Added ORA-01033 to disconnect codes, which can be caught during a connection event. [ticket:2201]
* - document that pysqlite does not share temporary tablesMike Bayer2011-06-291-0/+29
| | | | | across multiple connections therefore a non-standard pool should be used [ticket:2203]
* sqlite :memory: works across threads now hooray !Mike Bayer2011-06-201-24/+42
|
* - Accept None from SQLite cursor.fetchone() whenMike Bayer2011-06-041-1/+11
| | | | | | | | "PRAGMA read_uncommitted" is called to determine current isolation mode at connect time and default to SERIALIZABLE; this to support SQLite versions pre-3.3.0 that did not have this feature. [ticket:2173]
* random cleanupMike Bayer2011-05-041-1/+2
|
* - Fixed bug where reflection of foreign keyMike Bayer2011-04-101-0/+4
| | | | | | created as "REFERENCES <tablename>" without col name would fail. [ticket:2115] (also in 0.6.7)
* - REAL has been added to the core types. SupportedMike Bayer2011-04-052-5/+4
| | | | | | | by Postgresql, SQL Server, MySQL, SQLite. Note that the SQL Server and MySQL versions, which add extra arguments, are also still available from those dialects. [ticket:2081]
* - Documented SQLite DATE/TIME/DATETIME types.Mike Bayer2011-03-271-1/+101
| | | | | | [ticket:2029] (also in 0.6.7) - add "currentmodule" directive to all the dialect type docs to ensure users import from the dialect package, not the "base" module
* - some doc reorgMike Bayer2011-03-171-1/+1
| | | | | | | | | | - change engine.Connection to _connection_cls so sphinx doesn't get upset - globally add "." to all :class:`Foo` - start naming sections that are mostly docstrings "API Documentation - blah blah" - move some ad-hoc docstrings into "API" sections, there is some inconsistency here and it may be that we just have to leave it that way - add "internals" rsts to core, orm, I'm not super thrilled how these look but they are targeted by some of the public api docs, users typically become aware of these anyway
* - The path given as the location of a sqlite database is nowMike Bayer2011-02-101-0/+3
| | | | | | normalized via os.path.abspath(), so that directory changes within the process don't affect the ultimate location of a relative file path. [ticket:2036]
* - add connection and cursor to is_disconnect(). We aren't using it yet,Mike Bayer2011-02-091-1/+1
| | | | | | | | | | | | | | | but we'd like to. Most DBAPIs don't give us anything we can do with it. Some research was done on psycopg2 and it still seems like they give us no adequate method (tried connection.closed, cursor.closed, connection.status). mxodbc claims their .closed attribute will work (but I am skeptical). - remove beahvior in pool that auto-invalidated a connection when the cursor failed to create. That's not the pool's job. we need the conn for the error logic. Can't get any tests to fail, curious why that behavior was there, guess we'll find out (or not). - add support for psycopg2 version detection. even though we have no use for it yet... - adjust one of the reconnect tests to work with oracle's horrendously slow connect speed
* - execution_options() on Connection acceptsMike Bayer2011-01-161-1/+1
| | | | | | | | | | "isolation_level" argument, sets transaction isolation level for that connection only until returned to the connection pool, for thsoe backends which support it (SQLite, Postgresql) [ticket:2001] - disallow the option on Engine (use isolation_level to create_engine()), Executable (we don't want to check/set per statement) - docs
* - factor consistent set_isolation_level(), get_isolation_level()Mike Bayer2011-01-161-13/+29
| | | | | | per-connection methods for sqlite, postgresql, psycopg2 dialects - move isolation test suite to test engines/test_transaction - preparing for [ticket:2001]
* Regarding reflection for this case, reflection of an int PK colMike Bayer2011-01-151-0/+1
| | | | | | with a server_default sets the "autoincrement" flag to False, except in the case of a PG SERIAL col where we detected a sequence default. [ticket:2020] [ticket:2021]
* - fix reflection of unknown types with arguments, NullType() accepts no ↵Mike Bayer2011-01-121-4/+4
| | | | arguments.
* - A TypeDecorator of Integer can be used with a primary keyMike Bayer2011-01-111-2/+2
| | | | | | | | | | | | | | | | | | | column, and the "autoincrement" feature of various dialects as well as the "sqlite_autoincrement" flag will honor the underlying database type as being Integer-based. [ticket:2005] - Result-row processors are applied to pre-executed SQL defaults, as well as cursor.lastrowid, when determining the contents of result.inserted_primary_key. [ticket:2006] - Bind parameters present in the "columns clause" of a select are now auto-labeled like other "anonymous" clauses, which among other things allows their "type" to be meaningful when the row is fetched, as in result row processors. - TypeDecorator is present in the "sqlalchemy" import space.
* - whitespace removal bonanzaMike Bayer2011-01-022-30/+30
|
* - clean up copyright, update for 2011, stamp every file withMike Bayer2011-01-023-2/+15
| | | | | a consistent tag - AUTHORS file
* Ridding the world of a few wasteful imports.Michael Trier2010-12-192-7/+4
|
* - merge tipMike Bayer2010-12-191-1/+1
|\
| * this innocuous change allows sqlite to work with pypy. sadly, pypy is twice ↵Mike Bayer2010-12-171-2/+2
| | | | | | | | | | | | as slow even if i run the same test script four or five times to prime the jit.
* | - some good inlinings to the whole cascade_iterator() thing.Mike Bayer2010-12-181-1/+1
| | | | | | | | | | cascade_iterator() should probably not yield the "instance" at all and only deal in states. 30-40K methods taken off the orm2010 test.
* | - system to cache the bind/result processors in a dialect-wide registry.Mike Bayer2010-12-131-1/+2
|/ | | | its an idea with pointy edges.
* - ResultProxy and friends always reference the DBAPI connection at the same timeMike Bayer2010-12-051-3/+17
| | | | | | | | as the cursor. There is no reason for CursorFairy - the only use case would be, end-user is using the pool or pool.manage with DBAPI connections, uses a cursor, deferences the owning connection and continues using cursor. This is an almost nonexistent use case and isn't correct usage at a DBAPI level. Take out CursorFairy. - move the "check for a dot in the colname" logic out to the sqlite dialect.
* - NullPool is now used by default for SQLite file-Mike Bayer2010-11-281-21/+23
| | | | | | based databases. :memory: databases will continue to select SingletonThreadPool by default. [ticket:1921]
* merge tipMike Bayer2010-11-142-4/+19
|\
| * - On the same theme, the REFERENCES clause in a CREATE TABLEMike Bayer2010-11-121-1/+11
| | | | | | | | | | | | that includes a remote schema to a *different* schema than that of the parent table doesn't render at all, as cross-schema references do not appear to be supported.
| * - The REFERENCES clause in a CREATE TABLE that includesMike Bayer2010-11-121-0/+4
| | | | | | | | | | a remote schema name now renders the remote name without the schema clause, as required by SQLite. [ticket:1851]
| * doc editsMike Bayer2010-09-231-3/+4
| |
View Lorry Controller Status