Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
Newer
Older
100755 121 lines (60 sloc) 3.558 kb
47905b5 @roojs update TODO list..
roojs authored
1 Development of DB_DataObject
2e31417 @roojs yet more TODO items
roojs authored
2
47905b5 @roojs update TODO list..
roojs authored
3 Ok.. major revamp (or 2nd NG thread not feasible... - features will continue to be added gradually..)
2e31417 @roojs yet more TODO items
roojs authored
4
5
6
94628d0 @roojs adding todo
roojs authored
7
f5ab70c @roojs mega update on TODO list - thx to Brian Micheal for these.. now lets see...
roojs authored
8 Current TODO list:
22eb0f2 @roojs updating todo list
roojs authored
9 ----------------------------------
b63d60b @roojs update TODO list..
roojs authored
10 Issue: float support..
11 Add type support for floats, testing and casting etc..
12
13
14 Issue: ini structure is big when using many tables.
15
16 Intend to move the structure to to footer of the class file.
17 where it sets the $GLOBALS[_DB_DATAOBJECT][ini][{databasename}]....
18
19
20
21
94628d0 @roojs adding todo
roojs authored
22
23
f5ab70c @roojs mega update on TODO list - thx to Brian Micheal for these.. now lets see...
roojs authored
24 Issue: More detailed cached table information
25
26 make available an extra ini file database.details.ini, which contains
b63d60b @roojs update TODO list..
roojs authored
27 [table__sizes]
28 column = size
f5ab70c @roojs mega update on TODO list - thx to Brian Micheal for these.. now lets see...
roojs authored
29
b63d60b @roojs update TODO list..
roojs authored
30 ** initially to enable testing of field lenghts etc..
31 ** secondarily to enable database creation...!!
32
33
34
35
f5ab70c @roojs mega update on TODO list - thx to Brian Micheal for these.. now lets see...
roojs authored
36
37 Issue: Table Rebuilds
38
b63d60b @roojs update TODO list..
roojs authored
39 ** not really practicall - running with on-the-fly querying should solve this for the most part..
f5ab70c @roojs mega update on TODO list - thx to Brian Micheal for these.. now lets see...
roojs authored
40
41
42
43 Issue: Replace
44
45 Mysql has a nice replace feature, It would be nice to have in dataObjects
46
47 Solution:
48 Add a method, if the database is mysql, use the native 'REPLACE call'
49 otherwise, do a select on ID then insert|update..
b63d60b @roojs update TODO list..
roojs authored
50
51 Maybe??? - bloated api already????
f5ab70c @roojs mega update on TODO list - thx to Brian Micheal for these.. now lets see...
roojs authored
52
53
54
55 Issue: Simplify the connection configuration.
56
57 Current suggestion is to replace
58 database = dsn
59 with
60 default_database = dsn
61 and treat default more like a database name
b63d60b @roojs update TODO list..
roojs authored
62
63
f5ab70c @roojs mega update on TODO list - thx to Brian Micheal for these.. now lets see...
roojs authored
64
65 Issue: adding more realms to configuration
66
67 Proposal here is to add realms for database dsn's, table mappings etc. along
68 with hard coding the location of database cache files...
69
b63d60b @roojs update TODO list..
roojs authored
70 mostly fixed with
71 {project}_database = dsn
72 {project}_ini = /location/.....
73
74 need to add {project}/dataobject to factory...
f5ab70c @roojs mega update on TODO list - thx to Brian Micheal for these.. now lets see...
roojs authored
75
76
b63d60b @roojs update TODO list..
roojs authored
77
f5ab70c @roojs mega update on TODO list - thx to Brian Micheal for these.. now lets see...
roojs authored
78
79
80 Issue: Persistant Storage..
81
82 At present DB_DataObject, caches results to get queries, within the same page, this can be
83 expected to work 'most of the time', as most of the time concurrent updates are not that frequent.
84 however, it is expected that the object may be used in a situation where this may affect it.
85
86 As well as this, there may be times where it is preferable to have persistant storage over a number
87 of page calls..
88
89 The plan here is to implement a configuation option, that defaults to no caching, and can be set
90 to either
91 a) do caching withing a single page request (as per current)
92 b) do full caching with manual clearing...
93 c) do no caching.....
94
95 along with this expanding the quantity of data being cached may be considered.
96
97 either this, or a method, that specifically tags something as cachable.......
98
99
b63d60b @roojs update TODO list..
roojs authored
100
f5ab70c @roojs mega update on TODO list - thx to Brian Micheal for these.. now lets see...
roojs authored
101 Issue: $__DB->dsn["database'] does not work with oracle.
102
103 Need to work around this somehow... ???
104
105 Issue :Generator does not work with oracle..
106
107 Looks like it is using the wrong data from the Oracle getTableInfo call...
108
109 Issue: use isset rather than @
110
111 as it tokenizes down to one opcode, and is 'better practice..'
112
6511b55 @roojs more wishfull thinking in TODO :)
roojs authored
113 Issue: dependant deletes.. / updates./ inserts
114
115 Links.ini (or the future XML alternative?) could provide details on
116 foreign keys - and force the deletion of data that is dependant on
117 one item..
118 (updates & inserts could also do checks..)
119
4483815 @roojs testing pear-cvs github blocking script
roojs authored
120
Something went wrong with that request. Please try again.