github-starred/ultimatepp
2
0
Fork 0
mirror of https://github.com/ultimatepp/ultimatepp.git synced 2026-05-16 06:05:58 -06:00
Code Issues 33 Projects Packages Wiki Activity Actions
15803 commits 28 branches 11 tags 626 MiB
Commit graph

55 commits

Author SHA1 Message Date
cxl
c1ff7f34e2 Sql: Sqlite3 fixed SqlExp for AsTable 
git-svn-id: svn://ultimatepp.org/upp/trunk@13430 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2019-06-23 11:39:54 +00:00
cxl
648390149e Sql: RETURNING clause for PG (thanks busiek) 
git-svn-id: svn://ultimatepp.org/upp/trunk@12021 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2018-06-27 08:06:27 +00:00
cxl
8ebdcbb0d5 uppsrc: NAMESPACE_UPP / END_UPP_NAMESPACE removed 
git-svn-id: svn://ultimatepp.org/upp/trunk@10186 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2016-08-26 17:15:30 +00:00
cxl
8f807ca2de SqlExp: CreateTable legacy fix 
git-svn-id: svn://ultimatepp.org/upp/trunk@9021 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2015-10-15 07:59:10 +00:00
cxl
619d22f89d sqlexp: Changed CreateSqlTable 
git-svn-id: svn://ultimatepp.org/upp/trunk@9019 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2015-10-14 15:29:40 +00:00
cxl
6e81f4bb3e .cosmetics 
git-svn-id: svn://ultimatepp.org/upp/trunk@8854 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2015-08-27 10:50:40 +00:00
cxl
8afe62b9d9 Sql: Fixed to compile 
git-svn-id: svn://ultimatepp.org/upp/trunk@8842 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2015-08-24 09:38:34 +00:00
cxl
e24bf569b1 Sql: SqlSelect::AsTable for ORACLE (thanks wqcmaster!) 
git-svn-id: svn://ultimatepp.org/upp/trunk@8840 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2015-08-23 18:27:03 +00:00
cxl
484905f57d uppsrc: cosmetics: //$- around all Expands 
git-svn-id: svn://ultimatepp.org/upp/trunk@8537 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2015-06-13 18:13:59 +00:00
cxl
4f826c9f64 Sql: SqlCase renamed to SqlCode, Case is now SqlCase #1045 
git-svn-id: svn://ultimatepp.org/upp/trunk@8397 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2015-04-30 12:39:34 +00:00
cxl
c825c0d1e1 Sql: SqlExp: .Limit(n) in MSSQL emulated using TOP 
git-svn-id: svn://ultimatepp.org/upp/trunk@7805 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2014-10-20 18:43:25 +00:00
cxl
5cef0718ca SqlExp: Fixed issues with SqlUpdate/SqlInsert 
git-svn-id: svn://ultimatepp.org/upp/trunk@7777 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2014-10-13 18:15:42 +00:00
cxl
b5342b8255 Sql: SqlInsert/SqlUpdate refactored 
git-svn-id: svn://ultimatepp.org/upp/trunk@7775 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2014-10-13 17:37:21 +00:00
cxl
d6e5740da6 Sql/ODBC: Fixed MSSQL issues 
git-svn-id: svn://ultimatepp.org/upp/trunk@7773 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2014-10-13 11:40:07 +00:00
cxl
bfba290a81 .cosmetics 
git-svn-id: svn://ultimatepp.org/upp/trunk@7761 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2014-10-08 12:55:47 +00:00
cxl
8f4fa2966a CtrlLib: ValueMap ArrayCtrl::GetMap 
git-svn-id: svn://ultimatepp.org/upp/trunk@7760 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2014-10-08 12:00:06 +00:00
cxl
09efb74db8 SqlExp: temporary table support 
git-svn-id: svn://ultimatepp.org/upp/trunk@7708 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2014-09-21 10:33:51 +00:00
cxl
a56906aa29 Sql: With now supports Update/Insert/Delete 
git-svn-id: svn://ultimatepp.org/upp/trunk@7706 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2014-09-20 17:30:54 +00:00
cxl
60321cdd43 SqlExp: Support for with, with recursive 
git-svn-id: svn://ultimatepp.org/upp/trunk@7703 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2014-09-19 09:21:04 +00:00
cxl
6b354108d0 Sql: SqlExp support for 'union all' (as operator+) 
git-svn-id: svn://ultimatepp.org/upp/trunk@7701 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2014-09-19 06:29:21 +00:00
cxl
a81d713ddc Sql: SqlSelect::ForUpdate generates nothing for sqlite3 
git-svn-id: svn://ultimatepp.org/upp/trunk@7437 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2014-06-11 06:18:26 +00:00
cxl
50de50a36b Sql: SqlExp support for Insert...From...GroupBy...Having, S_* now has Get and GetColumnIds 
git-svn-id: svn://ultimatepp.org/upp/trunk@6365 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2013-09-17 13:22:26 +00:00
cxl
9f6f569297 Sql: SqlExp: new form of SqlInsert - select without table name 
git-svn-id: svn://ultimatepp.org/upp/trunk@6326 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2013-09-09 10:59:44 +00:00
cxl
545fafa5d0 *Sql: SqlSelect::AsTable fixed for PGSQL 
git-svn-id: svn://ultimatepp.org/upp/trunk@5897 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2013-03-11 09:39:20 +00:00
cxl
eab97075d7 Core: DeHtml, SqlExp: Insert, Update add methods with ValueMap parameter 
git-svn-id: svn://ultimatepp.org/upp/trunk@5535 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2012-11-09 09:48:03 +00:00
rylek
23de0aa4f6 .Sql/SqlStatement.cpp: modified SqlSelect::AsTable to keep extra parentheses around aliased subselect in all dialects except MS-SQL 
git-svn-id: svn://ultimatepp.org/upp/trunk@4620 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2012-02-24 22:45:46 +00:00
rylek
ee38cbd45b .Sql/SqlStatement.cpp: modified SqlSelect::AsTable to remove extra parentheses only in MS-SQL dialect 
git-svn-id: svn://ultimatepp.org/upp/trunk@4617 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2012-02-24 22:30:28 +00:00
rylek
347762810b .Sql/SqlStatement.cpp: bug fix in SqlSelect::AsTable to suppress extra parentheses around aliased subselect 
git-svn-id: svn://ultimatepp.org/upp/trunk@4612 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2012-02-24 07:26:26 +00:00
cxl
ff686cb02e Sql: SqlId escaping now tests whether escaped Id is indeed valid SQL id, no escaping otherwise (workaround for use of SqlId('table.*') and similar) 
git-svn-id: svn://ultimatepp.org/upp/trunk@4529 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2012-02-03 18:07:20 +00:00
cxl
e33ee7a3d1 Sql: SqlIds now quoted 
git-svn-id: svn://ultimatepp.org/upp/trunk@4526 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2012-02-03 17:44:48 +00:00
cxl
988e51f30a Sql: Refactored SQL 'default app cursor', added per-thread SQL option, added secondary SQLR 'default app cursor' 
git-svn-id: svn://ultimatepp.org/upp/trunk@4290 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2011-12-10 16:03:24 +00:00
cxl
10094501aa Core: Id is now String based, Sql: SqlCol erradicated 
git-svn-id: svn://ultimatepp.org/upp/trunk@4276 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2011-12-08 23:55:47 +00:00
cxl
8562dcf8ff Sql: More adjustments of sch introspection 
git-svn-id: svn://ultimatepp.org/upp/trunk@4275 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2011-12-08 19:42:54 +00:00
cxl
6a87dc1e46 .Sql: Fixing Joins/SqlId/SqlCol 
git-svn-id: svn://ultimatepp.org/upp/trunk@4266 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2011-12-07 08:49:45 +00:00
cxl
cebc2c14a2 Sql: JoinRef (first iteration) 
git-svn-id: svn://ultimatepp.org/upp/trunk@4264 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2011-12-07 07:38:09 +00:00
rylek
4a214fef29 Sql: added #ifndef flagNOAPPSQL to SqlStatement::Get() dependant on SQL 
git-svn-id: svn://ultimatepp.org/upp/trunk@4108 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2011-10-29 00:26:50 +00:00
cxl
346b011dd5 Sql: SqlStatement::Get() with SQL dialect 
git-svn-id: svn://ultimatepp.org/upp/trunk@4106 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2011-10-26 13:24:50 +00:00
cxl
8210eb5e01 SqlExp: select unions now have parenthesis around (so that the result can be sorted) 
git-svn-id: svn://ultimatepp.org/upp/trunk@3324 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2011-04-05 18:04:26 +00:00
cxl
070bb0312e .RasterEncoder fix 
git-svn-id: svn://ultimatepp.org/upp/trunk@2715 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2010-09-20 19:17:05 +00:00
cxl
fa2c8124f9 Sql: SqlSelect now can add individual fetch values using operator() 
git-svn-id: svn://ultimatepp.org/upp/trunk@2587 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2010-08-02 10:29:31 +00:00
rylek
91b4a18385 +Sql: new method SqlUpdate::Column(const SqlSet& cols, const SqlSet& vals) supports Oracle-style multicolumn SET in UPDATE (UPDATE xxx set (A, B, C) = select A, B, C from yyy) 
+TSql: new variants Force[Schema]Update support incremental updates according to comparison of 'old' and 'new' row data

git-svn-id: svn://ultimatepp.org/upp/trunk@2570 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2010-07-27 08:05:41 +00:00
cxl
f7c4550fc1 .uppsrc: Minor fixes 
git-svn-id: svn://ultimatepp.org/upp/trunk@2345 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2010-04-29 10:11:40 +00:00
rylek
5a010ced7a Minor priority-related fixes in SqlExp 
git-svn-id: svn://ultimatepp.org/upp/trunk@1896 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2010-01-15 22:02:07 +00:00
rylek
54af17f7bf Minor Sqlite-related fixes and improvements; new helper HttpContentDisposition to simplify generation of http response headers 
git-svn-id: svn://ultimatepp.org/upp/trunk@1881 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2010-01-12 13:53:13 +00:00
cxl
4616fc1710 Sql, SqlExp: InsertNoKey(Fields) ommits first column - intended for key with autoincrement 
git-svn-id: svn://ultimatepp.org/upp/trunk@1630 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2009-10-14 13:55:05 +00:00
cxl
a1143569bf PGSQL except/minus patch 
git-svn-id: svn://ultimatepp.org/upp/trunk@1548 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2009-09-04 12:19:39 +00:00
cxl
0e64379b75 SqlExp: SqlSelect AsTable, Joins accept SqlSet 
git-svn-id: svn://ultimatepp.org/upp/trunk@1530 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2009-08-24 13:35:55 +00:00
cxl
f485b819cc SqlExp: AsValue fix 
git-svn-id: svn://ultimatepp.org/upp/trunk@1526 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2009-08-24 12:18:41 +00:00
rylek
be6f0228a6 Fixed handling of SQL UPDATE without WHERE clause 
git-svn-id: svn://ultimatepp.org/upp/trunk@1517 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2009-08-17 18:38:33 +00:00
cxl
3d3d37b666 MSSQL: SQLDEFAULT 
git-svn-id: svn://ultimatepp.org/upp/trunk@1235 f0d560ea-af0d-0410-9eb7-867de7ffcac7
 2009-05-25 12:45:23 +00:00