Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | no message |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | sourceforge |
| Files: | files | file ages | folders |
| SHA1: |
c28e7456916b3468c26cb1f7bfd12016 |
| User & Date: | rmsimpson 2005-08-25 23:05:46 |
Context
|
2005-08-26
| ||
| 03:08 | no message check-in: c2d292b29a user: rmsimpson tags: sourceforge | |
|
2005-08-25
| ||
| 23:05 | no message check-in: c28e745691 user: rmsimpson tags: sourceforge | |
| 18:42 | pre 3.2.5 update check-in: 4d201cb5ab user: rmsimpson tags: sourceforge | |
Changes
Changes to SQLite.Interop/src/expr.c.
11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 |
** May you find forgiveness for yourself and forgive others. ** May you share freely, never taking more than you give. ** ************************************************************************* ** This file contains routines used for analyzing expressions and ** for generating VDBE code that evaluates expressions in SQLite. ** ** $Id: expr.c,v 1.11 2005/08/25 18:42:32 rmsimpson Exp $ */ #include "sqliteInt.h" #include <ctype.h> /* ** Return the 'affinity' of the expression pExpr if any. ** |
| |
11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 |
** May you find forgiveness for yourself and forgive others. ** May you share freely, never taking more than you give. ** ************************************************************************* ** This file contains routines used for analyzing expressions and ** for generating VDBE code that evaluates expressions in SQLite. ** ** $Id: expr.c,v 1.12 2005/08/25 23:07:59 rmsimpson Exp $ */ #include "sqliteInt.h" #include <ctype.h> /* ** Return the 'affinity' of the expression pExpr if any. ** |
Changes to bin/Designer/SQLiteDataObjectSupport.xml.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 .. 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 .. 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 ... 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 ... 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 ... 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 ... 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 ... 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 ... 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 ... 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 ... 567 568 569 570 571 572 573 574 575 576 577 578 579 580 581 582 583 584 585 586 ... 605 606 607 608 609 610 611 612 613 614 615 616 617 618 619 620 621 622 623 624 625 ... 628 629 630 631 632 633 634 635 636 637 638 639 640 641 642 643 644 645 646 647 ... 671 672 673 674 675 676 677 678 679 680 681 682 683 684 685 686 687 688 689 690 691 692 693 694 |
<?xml version="1.0" encoding="utf-8"?> <!-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Copyright (c) Microsoft Corporation, All rights reserved. This code sample is provided "AS IS" without warranty of any kind, it is not recommended for use in a production environment. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --> <VSDataObjectSupport xmlns="http://tempuri.org/VSDataObjectSupport.xsd"> <Types> <!-- The root type provides a single object with no identifier. Properties on this object are global to a connection. --> <RootType> <Properties> <Property name="Server" type="System.String" itemName="DataSource"/> <Property name="Database" type="System.String" itemName="Database"/> </Properties> <Actions> <!-- This enumerator provides access to properties on the ADO .NET DbConnection object as well as access to each connection string keyword value. --> <Action name="Enumerate" guid="61CC0372-384D-42e5-9707-6D7C8DC5287A" handler="Microsoft.VisualStudio.Data.AdoDotNet.AdoDotNetRootObjectEnumerator"/> </Actions> </RootType> <!-- Defines a type that represents a table. --> <Type name="Table" defaultSort="Database, Schema, Name"> <Concepts> <!-- This type maps to the "Table" concept. The restrictions attribute specifies how to map the generic restrictions for the concept (catalog, schema and name) into the specific restrictions for this type. In this case the generic and specific restrictions are identical. The filter indicates that generic enumerations should only get BASE TABLE rows. --> <Concept name="Table" restrictions="{Catalog},null,{Name},TABLE"/> </Concepts> <Identifier> <!-- The concepts here specify which data represents the generic identifier of the table (catalog, schema and name). In this case the generic and specific identifier are identical. --> <Part name="Database" itemName="table_catalog"> <Concepts> <Concept name="Identifier0"/> </Concepts> </Part> <Part name="Schema" itemName="table_schema"> <Concepts> ................................................................................ <Part name="Name" itemName="table_name"> <Concepts> <Concept name="Identifier2"/> </Concepts> </Part> </Identifier> <Restrictions> <!-- Since the set of restrictions available for this type are different from the set of identifier parts, we explicitly specify what data can be restricted on here. --> <Restriction name="Database"/> <Restriction name="Schema"/> <Restriction name="Name"/> <Restriction name="Type"/> </Restrictions> <Properties> <Property name="Name" type="System.String" itemName="table_name"/> ................................................................................ <Property name="Schema" type="System.String" itemName="table_schema"/> <Property name="Type" type="System.String" itemName="table_type"/> </Properties> <Actions> <Action name="Enumerate" guid="61CC0372-384D-42e5-9707-6D7C8DC5287A" handler="Microsoft.VisualStudio.Data.AdoDotNet.AdoDotNetObjectEnumerator"> <Parameter value="Tables"/> </Action> <!-- The BuildDSRef action allows objects to be dragged from the server explorer to various built in data designers. The parameters to the base DSRefBuilder implementation specify how to build the DSRef tree given parts of an identifier of this object type. --> <Action name="BuildDSRef" guid="7C030900-E8DD-471b-8F18-D83DA7036144" handler="Microsoft.VisualStudio.Data.DSRefBuilder"> <Parameter> <Parameter value="{2}"/> <Parameter value="{1}"/> <Parameter value="Table"/> <Parameter/> <Parameter> ................................................................................ </Parameter> </Parameter> </Parameter> </Action> </Actions> </Type> <!-- Defines a type that represents a table column. --> <Type name="TableColumn" defaultSort="Database, Schema, Table, Ordinal"> <Concepts> <Concept name="TableColumn" restrictions="{Catalog}, null, {Table}, {Name}"/> </Concepts> <Identifier> <Part name="Database" itemName="table_catalog"> <Concepts> <Concept name="Identifier0"/> </Concepts> </Part> ................................................................................ </Part> </Identifier> <Properties> <Property name="Name" type="System.String" itemName="column_name"/> <Property name="Ordinal" type="System.Int32" itemName="ordinal_position"> <Concepts> <Concept name="Ordinal"> <!-- The Ordinal concept is defined as an Int32 so we must convert it to the expected type. --> </Concept> </Concepts> </Property> <Property name="SystemType" type="System.String" itemName="data_type"> <Concepts> <!-- We can produce reasonable values for all data type concepts given just the system type. The default ADO .NET object concept mapper uses the ADO .NET DataTypes schema collection to map underlying system type to the provider specific type and framework data type. The System.Data.DbType is then inferred from the framework type. --> <Concept name="UserDataType"/> <Concept name="NativeDataType"/> <Concept name="ProviderDataType"> <Conversion mapper="Microsoft.VisualStudio.Data.AdoDotNet.AdoDotNetObjectConceptMapper"/> </Concept> <Concept name="ProviderDbType"> <Conversion mapper="Microsoft.VisualStudio.Data.AdoDotNet.AdoDotNetObjectConceptMapper"/> ................................................................................ <Property name="Scale" type="System.Int32" itemName="numeric_scale"> <Concepts> <Concept name="Scale"/> </Concepts> </Property> <Property name="Nullable" type="System.Boolean" itemName="is_nullable"> <Concepts> <!-- The nullable concept is defined as a boolean value but the enumeration returns a 'YES' or 'NO' string. We can do the conversion inline using an expression. --> <Concept name="Nullable"> </Concept> </Concepts> </Property> <Property name="Default" type="System.String" itemName="column_default"> <Concepts> <Concept name="Default"/> ................................................................................ </Parameter> </Parameter> </Parameter> </Action> </Actions> </Type> <!-- Defines a type that represents a view. --> <Type name="View" defaultSort="Database, Schema, Name"> <Concepts> <Concept name="View" restrictions="{Catalog}, null,{Name}"/> </Concepts> <Identifier> <Part name="Database" itemName="table_catalog"> <Concepts> <Concept name="Identifier0"/> </Concepts> </Part> ................................................................................ </Action> </Actions> </Type> <!-- Defines a type that represents a view column. --> <Type name="ViewColumn" defaultSort="Database, Schema, View, Ordinal"> <Concepts> <Concept name="ViewColumn" restrictions="{Catalog},null,{View},{Name}"/> </Concepts> <Identifier> <Part name="Database" itemName="table_catalog"> <Concepts> <Concept name="Identifier0"/> ................................................................................ </Parameter> </Action> </Actions> </Type> <!-- Defines a type that represents an index. --> <Type name="Index" defaultSort="Database, Schema, Table, Name"> <Concepts> <!-- In SQL Server all unique keys are described as indexes, so we can map this type to the TableUniqueKey concept. However not all indexes are unique keys, so we must filter the objects based on the IsUnique property. --> <Concept name="TableUniqueKey" restrictions="{Catalog},{Schema},{Table},{Name}" filter="IsUnique = true"/> </Concepts> <Identifier> <Part name="Database" itemName="table_catalog"> <Concepts> <Concept name="Identifier0"/> </Concepts> </Part> ................................................................................ </Parameter> </Parameter> </Parameter> </Action> </Actions> </Type> <!-- Defines a type that represents an index column. --> <Type name="IndexColumn" defaultSort="Database, Schema, Table, Index, Ordinal"> <Concepts> <Concept name="TableUniqueKeyColumn" restrictions="{Catalog},{Schema},{Table},{TableUniqueKey},{Name}"/> </Concepts> <Identifier> <Part name="Database" itemName="table_catalog"> <Concepts> <Concept name="Identifier0"/> </Concepts> </Part> ................................................................................ </Parameter> </Parameter> </Parameter> </Action> </Actions> </Type> <!-- Defines a type that represents a foreign key. --> <Type name="ForeignKey" defaultSort="Database, Schema, Table, Name"> <Concepts> <Concept name="TableForeignKey" restrictions="{Catalog},{Schema},{Table},{Name}"/> </Concepts> <Identifier> <Part name="Database" itemName="table_catalog"> <Concepts> <Concept name="Identifier0"/> </Concepts> </Part> ................................................................................ <Property name="ReferencedTableDatabase" type="System.String" itemName="fkey_to_catalog"> <Concepts> <Concept name="ReferencedTableId0"/> </Concepts> </Property> <Property name="ReferencedTableSchema" type="System.String" itemName="fkey_to_schema"> <Concepts> <!-- The ForeignKey type concept specifies that there should be property concepts that fully identify the referenced table. These concepts are defined similar to the identifier concepts. If a reference concept is missing (e.g. ReferencedTableId0) it is assumed to be the same as the main object identifier part. --> <Concept name="ReferencedTableId1"/> </Concepts> </Property> <Property name="ReferencedTableName" type="System.String" itemName="fkey_to_table"> <Concepts> <Concept name="ReferencedTableId2"/> </Concepts> ................................................................................ <Actions> <Action name="Enumerate" guid="61CC0372-384D-42e5-9707-6D7C8DC5287A" handler="Microsoft.VisualStudio.Data.AdoDotNet.AdoDotNetObjectEnumerator"> <Parameter value="ForeignKeys"/> </Action> </Actions> </Type> <!-- Defines a type that represents a foreign key column. --> <Type name="ForeignKeyColumn" defaultSort="Database, Schema, Table, ForeignKey, Ordinal"> <Concepts> <Concept name="TableForeignKeyColumn" restrictions="{Catalog},{Schema},{Table},{TableForeignKey},{Name}"/> </Concepts> <Identifier> <Part name="Database" itemName="table_catalog"> <Concepts> <Concept name="Identifier0"/> </Concepts> </Part> ................................................................................ <Property name="Ordinal" type="System.Int32" itemName="fkey_from_ordinal_position"> <Concepts> <Concept name="Ordinal"/> </Concepts> </Property> <Property name="ReferencedColumnName" type="System.String" itemName="fkey_to_column"> <Concepts> <!-- The ForeignKeyColumn type concept specifies that there should be a property concept that gives the name of the referenced column in the referenced table. --> <Concept name="ReferencedTableColumn"/> </Concepts> </Property> </Properties> <Actions> <Action name="Enumerate" guid="61CC0372-384D-42e5-9707-6D7C8DC5287A" handler="Microsoft.VisualStudio.Data.AdoDotNet.AdoDotNetObjectEnumerator"> <Parameter value="ForeignKeys"/> </Action> </Actions> </Type> </Types> </VSDataObjectSupport> |
| < > | | < > > > > < < < < < < < < < < < < | < < < < < < < < < < < < < < < < < < < < < < < < < < | | < < < < < < < < < < < < < < < < < < < | | | < < < < < < | < < < | | < < < | | < < < < < < < < < < | | < < < < < |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 .. 39 40 41 42 43 44 45 46 47 48 49 50 51 52 .. 53 54 55 56 57 58 59 60 61 62 63 64 65 66 .. 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 ... 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 ... 137 138 139 140 141 142 143 144 145 146 147 148 149 150 ... 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 ... 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 ... 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 ... 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 ... 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 ... 539 540 541 542 543 544 545 546 547 548 549 550 551 552 ... 555 556 557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 ... 595 596 597 598 599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 |
<?xml version="1.0" encoding="utf-8"?> <!-- /******************************************************** * ADO.NET 2.0 Data Provider for SQLite Version 3.X * Written by Robert Simpson (robert@blackcastlesoft.com) * * Released to the public domain, use at your own risk! ********************************************************/ --> <VSDataObjectSupport xmlns="http://tempuri.org/VSDataObjectSupport.xsd"> <Types> <RootType> <Properties> <Property name="Server" type="System.String" itemName="DataSource"/> <Property name="Database" type="System.String" itemName="Database"/> </Properties> <Actions> <Action name="Enumerate" guid="61CC0372-384D-42e5-9707-6D7C8DC5287A" handler="Microsoft.VisualStudio.Data.AdoDotNet.AdoDotNetRootObjectEnumerator"/> </Actions> </RootType> <Type name="Table" defaultSort="Database,Schema,Name"> <Concepts> <Concept name="Table" restrictions="{Catalog},null,{Name},TABLE"/> </Concepts> <Identifier> <Part name="Database" itemName="table_catalog"> <Concepts> <Concept name="Identifier0"/> </Concepts> </Part> <Part name="Schema" itemName="table_schema"> <Concepts> ................................................................................ <Part name="Name" itemName="table_name"> <Concepts> <Concept name="Identifier2"/> </Concepts> </Part> </Identifier> <Restrictions> <Restriction name="Database"/> <Restriction name="Schema"/> <Restriction name="Name"/> <Restriction name="Type"/> </Restrictions> <Properties> <Property name="Name" type="System.String" itemName="table_name"/> ................................................................................ <Property name="Schema" type="System.String" itemName="table_schema"/> <Property name="Type" type="System.String" itemName="table_type"/> </Properties> <Actions> <Action name="Enumerate" guid="61CC0372-384D-42e5-9707-6D7C8DC5287A" handler="Microsoft.VisualStudio.Data.AdoDotNet.AdoDotNetObjectEnumerator"> <Parameter value="Tables"/> </Action> <Action name="BuildDSRef" guid="7C030900-E8DD-471b-8F18-D83DA7036144" handler="Microsoft.VisualStudio.Data.DSRefBuilder"> <Parameter> <Parameter value="{2}"/> <Parameter value="{1}"/> <Parameter value="Table"/> <Parameter/> <Parameter> ................................................................................ </Parameter> </Parameter> </Parameter> </Action> </Actions> </Type> <Type name="TableColumn" defaultSort="Database,Schema,Table,Ordinal"> <Concepts> <Concept name="TableColumn" restrictions="{Catalog},null,{Table},{Name}"/> </Concepts> <Identifier> <Part name="Database" itemName="table_catalog"> <Concepts> <Concept name="Identifier0"/> </Concepts> </Part> ................................................................................ </Part> </Identifier> <Properties> <Property name="Name" type="System.String" itemName="column_name"/> <Property name="Ordinal" type="System.Int32" itemName="ordinal_position"> <Concepts> <Concept name="Ordinal"> </Concept> </Concepts> </Property> <Property name="SystemType" type="System.String" itemName="data_type"> <Concepts> <Concept name="UserDataType"/> <Concept name="NativeDataType"/> <Concept name="ProviderDataType"> <Conversion mapper="Microsoft.VisualStudio.Data.AdoDotNet.AdoDotNetObjectConceptMapper"/> </Concept> <Concept name="ProviderDbType"> <Conversion mapper="Microsoft.VisualStudio.Data.AdoDotNet.AdoDotNetObjectConceptMapper"/> ................................................................................ <Property name="Scale" type="System.Int32" itemName="numeric_scale"> <Concepts> <Concept name="Scale"/> </Concepts> </Property> <Property name="Nullable" type="System.Boolean" itemName="is_nullable"> <Concepts> <Concept name="Nullable"> </Concept> </Concepts> </Property> <Property name="Default" type="System.String" itemName="column_default"> <Concepts> <Concept name="Default"/> ................................................................................ </Parameter> </Parameter> </Parameter> </Action> </Actions> </Type> <Type name="View" defaultSort="Database, Schema, Name"> <Concepts> <Concept name="View" restrictions="{Catalog}, null, {Name}"/> </Concepts> <Identifier> <Part name="Database" itemName="table_catalog"> <Concepts> <Concept name="Identifier0"/> </Concepts> </Part> ................................................................................ </Action> </Actions> </Type> <!-- Defines a type that represents a view column. --> <Type name="ViewColumn" defaultSort="Database,Schema,View,Ordinal"> <Concepts> <Concept name="ViewColumn" restrictions="{Catalog},null,{View},{Name}"/> </Concepts> <Identifier> <Part name="Database" itemName="table_catalog"> <Concepts> <Concept name="Identifier0"/> ................................................................................ </Parameter> </Action> </Actions> </Type> <!-- Defines a type that represents an index. --> <Type name="Index" defaultSort="Database,Schema,Table,Name"> <Concepts> <Concept name="TableUniqueKey" restrictions="{Catalog},null,{Table},{Name}" filter="IsUnique = true"/> </Concepts> <Identifier> <Part name="Database" itemName="table_catalog"> <Concepts> <Concept name="Identifier0"/> </Concepts> </Part> ................................................................................ </Parameter> </Parameter> </Parameter> </Action> </Actions> </Type> <Type name="IndexColumn" defaultSort="Database,Schema,Table,Index,Ordinal"> <Concepts> <Concept name="TableUniqueKeyColumn" restrictions="{Catalog},null,{Table},{TableUniqueKey},{Name}"/> </Concepts> <Identifier> <Part name="Database" itemName="table_catalog"> <Concepts> <Concept name="Identifier0"/> </Concepts> </Part> ................................................................................ </Parameter> </Parameter> </Parameter> </Action> </Actions> </Type> <Type name="ForeignKey" defaultSort="Database,Schema,Table,Name"> <Concepts> <Concept name="TableForeignKey" restrictions="{Catalog},null,{Table},{Name}"/> </Concepts> <Identifier> <Part name="Database" itemName="table_catalog"> <Concepts> <Concept name="Identifier0"/> </Concepts> </Part> ................................................................................ <Property name="ReferencedTableDatabase" type="System.String" itemName="fkey_to_catalog"> <Concepts> <Concept name="ReferencedTableId0"/> </Concepts> </Property> <Property name="ReferencedTableSchema" type="System.String" itemName="fkey_to_schema"> <Concepts> <Concept name="ReferencedTableId1"/> </Concepts> </Property> <Property name="ReferencedTableName" type="System.String" itemName="fkey_to_table"> <Concepts> <Concept name="ReferencedTableId2"/> </Concepts> ................................................................................ <Actions> <Action name="Enumerate" guid="61CC0372-384D-42e5-9707-6D7C8DC5287A" handler="Microsoft.VisualStudio.Data.AdoDotNet.AdoDotNetObjectEnumerator"> <Parameter value="ForeignKeys"/> </Action> </Actions> </Type> <Type name="ForeignKeyColumn" defaultSort="Database,Schema,Table,ForeignKey,Ordinal"> <Concepts> <Concept name="TableForeignKeyColumn" restrictions="{Catalog},null,{Table},{TableForeignKey},{Name}"/> </Concepts> <Identifier> <Part name="Database" itemName="table_catalog"> <Concepts> <Concept name="Identifier0"/> </Concepts> </Part> ................................................................................ <Property name="Ordinal" type="System.Int32" itemName="fkey_from_ordinal_position"> <Concepts> <Concept name="Ordinal"/> </Concepts> </Property> <Property name="ReferencedColumnName" type="System.String" itemName="fkey_to_column"> <Concepts> <Concept name="ReferencedTableColumn"/> </Concepts> </Property> </Properties> <Actions> <Action name="Enumerate" guid="61CC0372-384D-42e5-9707-6D7C8DC5287A" handler="Microsoft.VisualStudio.Data.AdoDotNet.AdoDotNetObjectEnumerator"> <Parameter value="ForeignKeys"/> </Action> </Actions> </Type> </Types> </VSDataObjectSupport> |
Changes to bin/Designer/SQLiteDataViewSupport.xml.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
<?xml version="1.0" encoding="utf-8"?> <!-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Copyright (c) Microsoft Corporation, All rights reserved. This code sample is provided "AS IS" without warranty of any kind, it is not recommended for use in a production environment. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --> <VSDataViewSupport xmlns="http://tempuri.org/VSDataViewSupport.xsd"> <DataViews> <!-- This sample defines a single data view --> <DataView name="SQLite"> <DisplayName>SQLite</DisplayName> <!-- The connection node is static, i.e. has no underlying object --> |
| < > | | < > > > > |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
<?xml version="1.0" encoding="utf-8"?> <!-- /******************************************************** * ADO.NET 2.0 Data Provider for SQLite Version 3.X * Written by Robert Simpson (robert@blackcastlesoft.com) * * Released to the public domain, use at your own risk! ********************************************************/ --> <VSDataViewSupport xmlns="http://tempuri.org/VSDataViewSupport.xsd"> <DataViews> <!-- This sample defines a single data view --> <DataView name="SQLite"> <DisplayName>SQLite</DisplayName> <!-- The connection node is static, i.e. has no underlying object --> |