[asterisk-bugs] [Asterisk 0012745]: [branch] RT should adapt to existing columns on updates

[noreply at bugs.digium.com]

The following issue has been CLOSED 
====================================================================== 
http://bugs.digium.com/view.php?id=12745 
====================================================================== 
Reported By:                Corydon76
Assigned To:                Corydon76
====================================================================== 
Project:                    Asterisk
Issue ID:                   12745
Category:                   Resources/NewFeature
Reproducibility:            always
Severity:                   feature
Priority:                   normal
Status:                     closed
Asterisk Version:           SVN 
SVN Branch (only for SVN checkouts, not tarball releases):  trunk 
SVN Revision (number only!):  
Disclaimer on File?:        N/A 
Request Review:              
Resolution:                 fixed
Fixed in Version:           
====================================================================== 
Date Submitted:             05-28-2008 16:13 CDT
Last Modified:              06-10-2008 11:24 CDT
====================================================================== 
Summary:                    [branch] RT should adapt to existing columns on
updates
Description: 
http://svn.digium.com/svn/asterisk/team/tilghman/adaptive_realtime/

This branch does a number of things that will make adding new columns that
get updated by the database less trouble.

1. It registers columns that get keyed off of and updated from a module
through the realtime interface.  The RT engine then looks at the table
layout and ensures that each column exists and is of the proper type to
receive the data necessary.  If the column does not exist, then the engine
may either warn the user or, optionally, create the column automatically.

2. At update time, if a column to be updated does not exist, then the RT
engine will drop the column from the query, rather than what it does
currently, which is to execute a query with unknown columns, which causes
the entire update to fail.

3. Certain modules, such as voicemail, can check, for example, if a
password column is long enough to receive a password and warn the user if a
password truncation might otherwise result.  This should help
administrators a great deal in the future.
======================================================================
Relationships       ID      Summary
----------------------------------------------------------------------
child of            0011678 [depend:adaptive_realtime] Notification...
====================================================================== 

Issue History 
Date Modified   Username       Field                    Change               
====================================================================== 
06-10-08 11:24  Corydon76      Assigned To               => Corydon76       
06-10-08 11:24  Corydon76      Status                   ready for testing =>
closed
06-10-08 11:24  Corydon76      Resolution               open => fixed       
======================================================================