Earlier this year

• Sep 02, 2009

  r24 (Updating test project to use newer relational saving and to ...) committed by jacwright   -   Updating test project to use newer relational saving and to follow the newer default "_id" schema.

  Updating test project to use newer relational saving and to follow the newer default "_id" schema.
• Sep 02, 2009

  r23 (Added more info for join error.) committed by jacwright   -   Added more info for join error.

  Added more info for join error.
• Sep 02, 2009

  r22 (Fixed new error where E4X didn't pull local variable name, b...) committed by jacwright   -   Fixed new error where E4X didn't pull local variable name, but used XML value of name. Added a toString so objects don't trace out as undefined.

  Fixed new error where E4X didn't pull local variable name, but used XML value of name. Added a toString so objects don't trace out as undefined.
• Sep 02, 2009

  r21 (Fixing table creator to not throw the schema error.) committed by jacwright   -   Fixing table creator to not throw the schema error.

  Fixing table creator to not throw the schema error.

Older

• Oct 20, 2008

  issue 4 (Integrate with Prana framework) reported by noirbizarre   -   It's not an issue but en enhancement. I could be great to have AIR Active Record integrated with Prana Framework. IoC enhance code quality. Having database settings in an xml file is an exemple of what can bring Prana.

  It's not an issue but en enhancement. I could be great to have AIR Active Record integrated with Prana Framework. IoC enhance code quality. Having database settings in an xml file is an exemple of what can bring Prana.
• Oct 20, 2008

  issue 1 (New schema not generating) commented on by noirbizarre   -   A quick fix could something like that: if (!schema) { try { var dbschema:SQLSchemaResult = DB.getSchema(obj.connection); } catch (e:SQLError) { //Do something } var schema:SQLTableSchema; // first, find the table this object represents if (dbschema) { for each (var tmpTable:SQLTableSchema in dbschema.tables) { if (tmpTable.name == tableName) { schema = tmpTable; break; } } } }

  A quick fix could something like that: if (!schema) { try { var dbschema:SQLSchemaResult = DB.getSchema(obj.connection); } catch (e:SQLError) { //Do something } var schema:SQLTableSchema; // first, find the table this object represents if (dbschema) { for each (var tmpTable:SQLTableSchema in dbschema.tables) { if (tmpTable.name == tableName) { schema = tmpTable; break; } } } }
• Oct 01, 2008

  issue 3 (Two separate project would be easier) reported by noirbizarre   -   It would be easier to have two separate Flex project instead of test-project inside project root folder. Recommanded layout: ROOT |-ActiveRecord | |-trunk | |-branches | |-tags |-ActiveRecord-Test |-trunk |-branches |-tags

  It would be easier to have two separate Flex project instead of test-project inside project root folder. Recommanded layout: ROOT |-ActiveRecord | |-trunk | |-branches | |-tags |-ActiveRecord-Test |-trunk |-branches |-tags
• Sep 28, 2008

  r20 (Updated swc after fixing bug) committed by jacwright   -   Updated swc after fixing bug

  Updated swc after fixing bug
• Sep 28, 2008

  r19 (Fixed bug with finding relational methods after switching th...) committed by jacwright   -   Fixed bug with finding relational methods after switching them out of the public scope

  Fixed bug with finding relational methods after switching them out of the public scope
• Sep 25, 2008

  r18 (assumed format for foreign keys changed from 'tableId' to 't...) committed by democracyspeaks   -   assumed format for foreign keys changed from 'tableId' to 'table_id'

  assumed format for foreign keys changed from 'tableId' to 'table_id'
• Sep 25, 2008

  r17 (Updated swc) committed by jacwright   -   Updated swc

  Updated swc
• Sep 25, 2008

  r16 (Took some methods out of the public scope) committed by jacwright   -   Took some methods out of the public scope

  Took some methods out of the public scope
• Sep 25, 2008

  r15 (Updated swc) committed by jacwright   -   Updated swc

  Updated swc
• Sep 25, 2008

  r14 (Fixed a bug that would save rogue items in the database) committed by jacwright   -   Fixed a bug that would save rogue items in the database

  Fixed a bug that would save rogue items in the database
• Sep 25, 2008

  issue 2 (DB.getSchema is failing to return a schema) commented on by democracyspeaks   -   OK, the problem was the at the location of the database. ActiveRecord was creating a new database in the local store instead of using the existing database that I had placed in the Application Directory. As a result, calls to conn.loadSchema() were failing because the new db didn't have any tables in it. DB.as, line 29, sets the path of the db to the applicationStorageDirectory, I changed it to applicationDirectory and it works. Now, if only I could figure out many to many relationships ;)

  OK, the problem was the at the location of the database. ActiveRecord was creating a new database in the local store instead of using the existing database that I had placed in the Application Directory. As a result, calls to conn.loadSchema() were failing because the new db didn't have any tables in it. DB.as, line 29, sets the path of the db to the applicationStorageDirectory, I changed it to applicationDirectory and it works. Now, if only I could figure out many to many relationships ;)
• Sep 24, 2008

  issue 2 (DB.getSchema is failing to return a schema) commented on by democracyspeaks   -   Since the tables are defined, maybe my database is in the wrong place?

  Since the tables are defined, maybe my database is in the wrong place?
• Sep 24, 2008

  issue 2 (DB.getSchema is failing to return a schema) commented on by democracyspeaks   -   Didn't intend to post as a 'Defect.' This is most likely user error on my part!

  Didn't intend to post as a 'Defect.' This is most likely user error on my part!
• Sep 24, 2008

  issue 2 (DB.getSchema is failing to return a schema) reported by democracyspeaks   -   What steps will reproduce the problem? 1. Create a sqlite db called main.db, and put it in the application directory. 2. Create a table in the database called "People" with id, fname, and lname columns. 3. generate a simple class that extends ActiveRecord: package { import flight.db.activeRecord.*; public dynamic class Person extends ActiveRecord { public var fname:String; public var lname:String; } } 4. Instantiate that class: person = new Person(); 5. Apply some properties: person.fname = 'Bill' person.lname = 'Johnson' 6. save the person person.save() What is the expected output? What do you see instead? =============================== I expect to see a new record in the People database. Instead I get this error: =============================== TypeError: Error #1009: Cannot access a property or method of a null object reference. at flight.db.activeRecord::ActiveRecord/http://withincode.com/sql/db::getDBProperties()[/Users/Mi ke/Sites/AR/ActiveRecord_test2/src/flight/db/activeRecord/ActiveRecord.as:544] at flight.db.activeRecord::ActiveRecord/save()[/Users/Mike/Sites/AR/ActiveRecord_test2/src/flight/ db/activeRecord/ActiveRecord.as:138] at ActiveRecord_test2/init()[/Users/Mike/Sites/AR/ActiveRecord_test2/src/ActiveRecord_test2.mxm l:30] at ActiveRecord_test2/___ActiveRecord_test2_WindowedApplication1_initialize()[/Users/Mike/Sites/ AR/ActiveRecord_test2/src/ActiveRecord_test2.mxml:2] at flash.events::EventDispatcher/dispatchEventFunction() at flash.events::EventDispatcher/dispatchEvent() at mx.core::UIComponent/dispatchEvent()[E:\dev\3.0.x\frameworks\projects\framework\src\mx\c ore\UIComponent.as:9051] at mx.core::UIComponent/set processedDescriptors()[E:\dev\3.0.x\frameworks\projects\framework\src\mx\core\UIComponen t.as:1215] at mx.core::Container/createComponentsFromDescriptors()[E:\dev\3.0.x\frameworks\projects\fra mework\src\mx\core\Container.as:3498] at mx.core::Container/createChildren()[E:\dev\3.0.x\frameworks\projects\framework\src\mx\core \Container.as:2587] at mx.core::WindowedApplication/createChildren()[E:\dev\3.0.x\frameworks\projects\airframework \src\mx\core\WindowedApplication.as:1766] at mx.core::UIComponent/initialize()[E:\dev\3.0.x\frameworks\projects\framework\src\mx\core\U IComponent.as:5262] at mx.core::Container/initialize()[E:\dev\3.0.x\frameworks\projects\framework\src\mx\core\Cont ainer.as:2524] at mx.core::Application/initialize()[E:\dev\3.0.x\frameworks\projects\framework\src\mx\core\App lication.as:847] at ActiveRecord_test2/initialize()[/Users/Mike/Sites/AR/ActiveRecord_test2/src/ActiveRecord_test2. mxml:0] at mx.managers::SystemManager/http://www.adobe.com/2006/flex/mx/internal::childAdded()[E:\ dev\3.0.x\frameworks\projects\framework\src\mx\managers\SystemManager.as:1625] at mx.managers::SystemManager/initializeTopLevelWindow()[E:\dev\3.0.x\frameworks\projects\fra mework\src\mx\managers\SystemManager.as:2482] at mx.managers::SystemManager/http://www.adobe.com/2006/flex/mx/internal::docFrameHandle r()[E:\dev\3.0.x\frameworks\projects\framework\src\mx\managers\SystemManager.as:2330] =============================== =============================== What version of the product are you using? On what operating system? SVN revision 13 from Google Code Mac OS 10.5.4 Flex Builder 3 Air 1.1 Please provide any additional information below. =============================== Here is my own trace of the execution: =============================== init in mxml creating new Person AR#constructor : Person AR#constructor : defaultConnectionAlias = main anonymous function assigned to init property is registerig a connection to main.db DB#registerConnectionAlias : fileNameOrObject = main.db DB#registerConnectionAlias : alias = main DB#getConnection : alias = main, isSync = true DB#getConnection : key = main - sync DB#getConnection : cache = [object Object] DB#getConnection : aliases = [object Object] DB#getConnection : alias = main DB#getConnection : aliases[alias] is File ? false DB#getConnection : opening synchronous connection to main.db DB#getConnection : caching connection with key : main - sync AR#constructor : should have created connection synchronously ? true AR#getDBProperties : tableName = people AR#getSchema : tableName = null, updateTable = false AR#getSchema : tableName = null AR#getSchema : tableName = people AR#getSchema : tableName in tableSchemaCache ? false AR#getSchema : connection ? [object SQLConnection] DB#getSchema : conn = [object SQLConnection] DB#getSchema : schemas = [object Dictionary] DB#getSchema : conn in schemas ? false DB#getSchema : loading schema conn.connected = true onSchemaStatus : e.type = No schema objects in database 'main' were found. DB#getSchema : conn.getSchemaResult() = null DB#getSchema : returning null =============================== ===============================

  What steps will reproduce the problem? 1. Create a sqlite db called main.db, and put it in the application directory. 2. Create a table in the database called "People" with id, fname, and lname columns. 3. generate a simple class that extends ActiveRecord: package { import flight.db.activeRecord.*; public dynamic class Person extends ActiveRecord { public var fname:String; public var lname:String; } } 4. Instantiate that class: person = new Person(); 5. Apply some properties: person.fname = 'Bill' person.lname = 'Johnson' 6. save the person person.save() What is the expected output? What do you see instead? =============================== I expect to see a new record in the People database. Instead I get this error: =============================== TypeError: Error #1009: Cannot access a property or method of a null object reference. at flight.db.activeRecord::ActiveRecord/http://withincode.com/sql/db::getDBProperties()[/Users/Mi ke/Sites/AR/ActiveRecord_test2/src/flight/db/activeRecord/ActiveRecord.as:544] at flight.db.activeRecord::ActiveRecord/save()[/Users/Mike/Sites/AR/ActiveRecord_test2/src/flight/ db/activeRecord/ActiveRecord.as:138] at ActiveRecord_test2/init()[/Users/Mike/Sites/AR/ActiveRecord_test2/src/ActiveRecord_test2.mxm l:30] at ActiveRecord_test2/___ActiveRecord_test2_WindowedApplication1_initialize()[/Users/Mike/Sites/ AR/ActiveRecord_test2/src/ActiveRecord_test2.mxml:2] at flash.events::EventDispatcher/dispatchEventFunction() at flash.events::EventDispatcher/dispatchEvent() at mx.core::UIComponent/dispatchEvent()[E:\dev\3.0.x\frameworks\projects\framework\src\mx\c ore\UIComponent.as:9051] at mx.core::UIComponent/set processedDescriptors()[E:\dev\3.0.x\frameworks\projects\framework\src\mx\core\UIComponen t.as:1215] at mx.core::Container/createComponentsFromDescriptors()[E:\dev\3.0.x\frameworks\projects\fra mework\src\mx\core\Container.as:3498] at mx.core::Container/createChildren()[E:\dev\3.0.x\frameworks\projects\framework\src\mx\core \Container.as:2587] at mx.core::WindowedApplication/createChildren()[E:\dev\3.0.x\frameworks\projects\airframework \src\mx\core\WindowedApplication.as:1766] at mx.core::UIComponent/initialize()[E:\dev\3.0.x\frameworks\projects\framework\src\mx\core\U IComponent.as:5262] at mx.core::Container/initialize()[E:\dev\3.0.x\frameworks\projects\framework\src\mx\core\Cont ainer.as:2524] at mx.core::Application/initialize()[E:\dev\3.0.x\frameworks\projects\framework\src\mx\core\App lication.as:847] at ActiveRecord_test2/initialize()[/Users/Mike/Sites/AR/ActiveRecord_test2/src/ActiveRecord_test2. mxml:0] at mx.managers::SystemManager/http://www.adobe.com/2006/flex/mx/internal::childAdded()[E:\ dev\3.0.x\frameworks\projects\framework\src\mx\managers\SystemManager.as:1625] at mx.managers::SystemManager/initializeTopLevelWindow()[E:\dev\3.0.x\frameworks\projects\fra mework\src\mx\managers\SystemManager.as:2482] at mx.managers::SystemManager/http://www.adobe.com/2006/flex/mx/internal::docFrameHandle r()[E:\dev\3.0.x\frameworks\projects\framework\src\mx\managers\SystemManager.as:2330] =============================== =============================== What version of the product are you using? On what operating system? SVN revision 13 from Google Code Mac OS 10.5.4 Flex Builder 3 Air 1.1 Please provide any additional information below. =============================== Here is my own trace of the execution: =============================== init in mxml creating new Person AR#constructor : Person AR#constructor : defaultConnectionAlias = main anonymous function assigned to init property is registerig a connection to main.db DB#registerConnectionAlias : fileNameOrObject = main.db DB#registerConnectionAlias : alias = main DB#getConnection : alias = main, isSync = true DB#getConnection : key = main - sync DB#getConnection : cache = [object Object] DB#getConnection : aliases = [object Object] DB#getConnection : alias = main DB#getConnection : aliases[alias] is File ? false DB#getConnection : opening synchronous connection to main.db DB#getConnection : caching connection with key : main - sync AR#constructor : should have created connection synchronously ? true AR#getDBProperties : tableName = people AR#getSchema : tableName = null, updateTable = false AR#getSchema : tableName = null AR#getSchema : tableName = people AR#getSchema : tableName in tableSchemaCache ? false AR#getSchema : connection ? [object SQLConnection] DB#getSchema : conn = [object SQLConnection] DB#getSchema : schemas = [object Dictionary] DB#getSchema : conn in schemas ? false DB#getSchema : loading schema conn.connected = true onSchemaStatus : e.type = No schema objects in database 'main' were found. DB#getSchema : conn.getSchemaResult() = null DB#getSchema : returning null =============================== ===============================
• Sep 15, 2008

  issue 1 (New schema not generating) commented on by mlegrand   -   Yeah, I can confirm this. Seems to be here (starting at line 54 in TableCreator.as): if (!schema) { var dbschema:SQLSchemaResult = DB.getSchema(obj.connection); var schema:SQLTableSchema; // first, find the table this object represents if (dbschema) { for each (var tmpTable:SQLTableSchema in dbschema.tables) { if (tmpTable.name == tableName) { schema = tmpTable; break; } } } } // if no table was found, create it, otherwise, update any missing fields if (!schema) { . . . I think it's a quick fix to the conditional statement or the placement of the conditional statement.

  Yeah, I can confirm this. Seems to be here (starting at line 54 in TableCreator.as): if (!schema) { var dbschema:SQLSchemaResult = DB.getSchema(obj.connection); var schema:SQLTableSchema; // first, find the table this object represents if (dbschema) { for each (var tmpTable:SQLTableSchema in dbschema.tables) { if (tmpTable.name == tableName) { schema = tmpTable; break; } } } } // if no table was found, create it, otherwise, update any missing fields if (!schema) { . . . I think it's a quick fix to the conditional statement or the placement of the conditional statement.
• Aug 15, 2008

  r13 (Fixed a bug that should have been a compile error but gave u...) committed by jacwright   -   Fixed a bug that should have been a compile error but gave us a weird runtime error

  Fixed a bug that should have been a compile error but gave us a weird runtime error