Titanium JIRA Archive
Appcelerator Community (AC)

[AC-453] Arrow - can't create a model based on a view

GitHub Issuen/a
TypeBug
Priorityn/a
StatusResolved
ResolutionNeeds more info
Resolution Date2015-11-11T02:39:15.000+0000
Affected Version/sAppcelerator Studio 4.3.0
Fix Version/sn/a
ComponentsAlloy
Labelsn/a
ReporterMitch Starnes
AssigneeShak Hossain
Created2015-10-11T21:16:44.000+0000
Updated2015-11-11T14:37:22.000+0000

Description

appc run Appcelerator Command-Line Interface, version 5.0.2 Copyright (c) 2014-2015, Appcelerator, Inc. All Rights Reserved. INFO | Arrow/1.2.62 OSD/1.0.0 INFO | APIKey is: --- INFO | starting connector/appc.mssql@1.1.3 {color:red}INFO | Skipping generation of model from table vappointments because it has no primary key in the schema.{color} INFO | started connector/appc.mssql INFO | starting connector/appc.arrowdb@1.1.3 INFO | started connector/appc.arrowdb INFO | Access the Arrow admin at http://127.0.0.1:8080/arrow. This will only be available on your dev environment. To enable in production, set enableAdminInProduction in your config INFO | Access the Arrow API doc at http://127.0.0.1:8080/apidoc INFO | started INFO | server started on port 8080 I want to create a model based on several tables including multiple instance of the same table (PERSON) where different people serve different roles. So, there is one row for OFFICE_VISIT but then there are two joins to the PERSON table for 1) the patient and 2) the provider. I have been unsuccessful in defining a model based on multiple instances of the PERSON table - Is there a way? Because I was unsuccessful, I decided to create a view that includes all the tables in a join. The view works but Arrow refuses to build a model because there is no primary key.

Comments

  1. Sharif AbuDarda 2015-11-10

    Hello [~mitch.starnes@bnsf.com], Are you following this doc link [here](http://docs.appcelerator.com/platform/latest/#!/guide/Arrow_Models-section-43299044_ArrowModels-CreateaCompositeModel). You can also look at this [blog post](http://www.appcelerator.com/blog/2015/06/arrow-builder-salesforce-composite-connector/). Thanks.
  2. Mitch Starnes 2015-11-11

    This was resolved with an unanswered question? The issue is that I can't create a model on a VIEW apparently because there is no primary key (on a view).
  3. Mitch Starnes 2015-11-11

    Let me add that you can't create a composite model when the joined tables have multi-column primary keys.

JSON Source