sqlpower / power-architect Goto Github PK
View Code? Open in Web Editor NEWAutomatically exported from code.google.com/p/power-architect
License: GNU General Public License v3.0
Automatically exported from code.google.com/p/power-architect
License: GNU General Public License v3.0
This README refers to the Power*Architect source-only package. The source-only package is intended to be a bare-bones distribution intended only for automatic packaging systems that manage their own library dependencies. If you are looking for the source code with the dependencies included, you can check out a copy of the project using Subversion. You can anonymously check out a read-only copy using Subversion with the following command: svn checkout http://power-architect.googlecode.com/svn/trunk/ power-architect If you are interested in commiting changes to the project source, you can visit our project website at http://code.google.com/p/power-architect/
I tried creating a Kettle job with Architect. Architect did not save the database name in the Kettle connection settings. (Kettle has been renamed to Penaho Data Integration, PDI)
How to reproduce:
So far, I can only "forward a database" by recreating it. Would be nice if
possible to just apply the changes to existing schema.
For example, if user rename a column, when generating forward script, if the
column already exists in the old name, then it shall provide the
alter table XXXX rename column YYYY to PPPP
etc.
Regards,
Edson
Original issue reported on code.google.com by [email protected]
on 6 May 2014 at 11:02
When generating Kettle jobs, Architect has the option to write the files to a database repository or to the file system. There should also be an option to save the Kettle files to a file based repository.
Steps to recreate issue.
This populated dropdown's width is less. you have to use scroll to select the any column. Its little hard and not user friendly.
Requirements:
width of dropdown needs to increase.
The issue was reported earlier in bugzilla with bug id: Bug 3172
To resolve the issue 3172decision was made to break big kettle job in batch.
The solution committed in comfit # 7403975
Is there a way to change the path to pl.ini
? Currently is ~/pl.ini
. I've searched for a way to do this but I couldn't find one.
When create a database(SQL Server) connection in Architect with specific data base which has a tables start with reporting and dbo.
Table start with dbo imported but the table start with reporting doesn't import to database connection tree.
This is more of an enhancement
It would be nice if these features can be added.
Show/hide
1. Columns
2. Column Data Types
Also if Remarks on a table, relationship link if can be shown on the
playpen it would be nice. That would enable to describe on the roles that
a table plays in a relation or any implementation notes that developers
can share between them
Original issue reported on code.google.com by [email protected]
on 23 Apr 2008 at 11:12
We are using latest version of SQL Power Architect software (v1.0.9), while designing Database tables, we checked that it is not supporting DateTime data type for Column.
So can you please provide reason why basic datatypes are not supported and what is alternative to add this data type?
When I try to delete an index on a table in the tree view I get the following error message :
No items to delete!
Hi!
Thanks for your interest in filing a bug report or enhancement request
against the Power*Architect.
We don't currently use this issue tracker provided by Google Code
Hosting--we have our own issue tracker that we've been using since before
moving the Architect here. You can access it at:
http://trillian.sqlpower.ca/bugzilla/
We also have a user support forum, which you can access at:
http://www.sqlpower.ca/forum
Once again, please don't post bugs here. We do not monitor this issue
tracker. Use one of the above resources instead.
-Jonathan
Original issue reported on code.google.com by [email protected]
on 29 Jul 2008 at 9:07
What steps will reproduce the problem?
1. Create a model
2. Sync the model with the MySQL database
3. Add an index
4. Use tools compare DM to update the database to the most recent model
What is the expected output? What do you see instead?
I would expect a create index statement, however the compare DM tool reports no
differences
What version of the product are you using? On what operating system?
1.0.7 on OSX 10.9.4
Please provide any additional information below.
Using MySQL 5.5.21
Original issue reported on code.google.com by [email protected]
on 21 Aug 2014 at 10:08
What steps will reproduce the problem?
1. Launch architect from Eclipse
2. Load test environment connection
3. select HR database
4. select either Employees or Location table
What is the expected output? What do you see instead?
The expected out out is Employees or Location table is in PlayPen. But instead
it displays 'NullPointerException' as below:
java.lang.RuntimeException: java.lang.RuntimeException:
java.lang.NullPointerException
at ca.sqlpower.architect.swingui.PlayPen$AddObjectsTask.cleanup(PlayPen.java:1700)
at ca.sqlpower.swingui.SPSwingWorker$1.run(SPSwingWorker.java:114)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:702)
at java.awt.EventQueue.access$400(EventQueue.java:82)
at java.awt.EventQueue$2.run(EventQueue.java:663)
at java.awt.EventQueue$2.run(EventQueue.java:661)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:672)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:296)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:211)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:201)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:196)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:188)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
Caused by: java.lang.RuntimeException: java.lang.NullPointerException
at ca.sqlpower.sqlobject.SQLTable.populateRelationshipsWithList(SQLTable.java:820)
at ca.sqlpower.sqlobject.SQLTable$5.run(SQLTable.java:737)
at ca.sqlpower.architect.swingui.ArchitectSwingSessionImpl.runInForeground(ArchitectSwingSessionImpl.java:1166)
at ca.sqlpower.object.AbstractSPObject.runInForeground(AbstractSPObject.java:669)
at ca.sqlpower.sqlobject.SQLTable.populateRelationships(SQLTable.java:732)
at ca.sqlpower.sqlobject.SQLTable.createTableFromSource(SQLTable.java:300)
at ca.sqlpower.sqlobject.SQLTable.createInheritingInstance(SQLTable.java:287)
at ca.sqlpower.architect.swingui.PlayPen.importTableCopy(PlayPen.java:1258)
at ca.sqlpower.architect.swingui.PlayPen$AddObjectsTask.cleanup(PlayPen.java:1621)
... 15 more
Caused by: java.lang.NullPointerException
at ca.sqlpower.sqlobject.SQLRelationship.attachRelationship(SQLRelationship.java:578)
at ca.sqlpower.sqlobject.SQLRelationship.attachRelationship(SQLRelationship.java:531)
at ca.sqlpower.sqlobject.SQLTable.populateRelationshipsWithList(SQLTable.java:796)
... 23 more
19341 [AWT-EventQueue-0] ERROR ca.sqlpower.swingui.SPSUtils - dialog parent
component null is neither JFrame nor JDialog
Original issue reported on code.google.com by [email protected]
on 9 Apr 2013 at 5:57
In Pentaho transformation generated from Architect in some cases, The initial step(Table input) includes the target table as well.
i.e. It include target(output) table as an Input table.
Kettle job generated from Architect when open in Petaho it gives message to add sort before merge join for both tables.
So before merge join sorting of incoming rows is required to produce proper output result, In auto generated kettle transformation sorting is not performed
What steps will reproduce the problem?
1. Create a new project
2. Connect to a database
3. Import tables from a database to the new model
What is the expected output? What do you see instead?
Would be interesting a ordering option in the Data Model List, so we could
order the tables that was imported by name for example.
For me the order of the list is the one that the table was imported
What version of the product are you using? On what operating system?
SQL-Power-Architect-Setup-Windows-jdbc-1.0.6
Please provide any additional information below.
Original issue reported on code.google.com by [email protected]
on 16 Nov 2011 at 10:52
What is the expected output? What do you see instead?
I can't find a way to update remote database table structure.
What version of the product are you using? On what operating system?
0.9.10 on Leopard OSX
Please provide any additional information below.
If I create a db connection (to MySQL in my case), and then I edit tables via
Power Architect
submitting new fields/tables via Compare tool, I don't get remote structure
updated.
Same problem if I update something on DB not via Power Architect, it doesn't
see any modification
and the only way is creating a new project reimporting all data in the new
project.
Original issue reported on code.google.com by [email protected]
on 29 May 2008 at 1:23
Hello is it a dead project ?
It will be very interessting to allow the creation and the manipulation of
normal dimension. That is to say dimension directly available in a cube. Fow
now only shared dimension is supported.
Best regards.
Original issue reported on code.google.com by [email protected]
on 22 Aug 2010 at 9:41
When a new column is added to a table, in the play pen the scale value is
displayed for all types.
It would be nice if
1. Precision is alone displayed for character types
2. For int types none of precision or scale are displayed.
3. For numeric types both the precision and scale are displayed
Version being used: 0.9.10
Original issue reported on code.google.com by [email protected]
on 23 Apr 2008 at 11:08
What steps will reproduce the problem?
1. connect to a SQL Server Database
2. create a table and document its fields using MS SQL Server Management Studio
(via the Description Field)
3. import the table into SQL Power Architect
What is the expected output? What do you see instead?
The column descriptions should be imported as "remarks". Instead there are no
remarks imported but everything is empty.
What version of the product are you using? On what operating system?
MS Sql server 2008 R2 on Windows, SQL Power Architect on Mac OSX 10.8 (dont
think it matters though).
Please provide any additional information below.
Original issue reported on code.google.com by [email protected]
on 26 Jul 2013 at 4:43
This is an enhancement to split the job into multiple jobs by selecting the table for each sub job.
So the output of kettle job will have a job with a multiple jobs inside it.
It would be interesting to make more than one diagram and to export them in a PDF file.
This issue occurred due to not specifying the [JOIN_KEY] in a Select statement.
Transformation generated from Architect doesn't include a join key in a Select statement.
1. Open a Power Architect file.
2. Click Save (not Save As)
3. It prompts you for a location.
I think that if you just click "Save" it shouldn't ask you for a file location.
Original issue reported on code.google.com by [email protected]
on 22 Oct 2007 at 8:23
What steps will reproduce the problem?
1. Launch test_environment database
2. explore OE schema
3. select & drop ACTION_TABLE
it draw Action_Table into playpen with following error message.
java.lang.IllegalArgumentException: Table ACTION_TABLE is not in this rowset
at ca.sqlpower.sql.jdbcwrapper.IndexedCachedRowSet.extractSingleTable(IndexedCachedRowSet.java:87)
at ca.sqlpower.sql.jdbcwrapper.OracleDatabaseMetaDataDecorator.getColumns(OracleDatabaseMetaDataDecorator.java:661)
at ca.sqlpower.sqlobject.SQLColumn.fetchColumnsForTable(SQLColumn.java:482)
at ca.sqlpower.sqlobject.SQLTable.populateAllColumns(SQLTable.java:407)
at ca.sqlpower.sqlobject.SQLTable.populateColumns(SQLTable.java:365)
at ca.sqlpower.sqlobject.SQLTable.populateImpl(SQLTable.java:1335)
at ca.sqlpower.sqlobject.SQLObject.populate(SQLObject.java:186)
at ca.sqlpower.sqlobject.SQLTable.getChildren(SQLTable.java:1963)
at ca.sqlpower.sqlobject.SQLObject.getChildren(SQLObject.java:285)
at ca.sqlpower.architect.swingui.PlayPen$AddObjectsTask.ensurePopulated(PlayPen.java:1577)
at ca.sqlpower.architect.swingui.PlayPen$AddObjectsTask.doStuff(PlayPen.java:1552)
at ca.sqlpower.swingui.SPSwingWorker.run(SPSwingWorker.java:104)
at java.lang.Thread.run(Thread.java:680)
Please use labels and text to provide additional information.
Original issue reported on code.google.com by [email protected]
on 16 May 2013 at 9:03
Website down: sqlpower.ca has an invalid SSL certificate and error 400
This is a new requirement to export the transformation job which allow to save the out put to a different types like "Output Table or "Insert/Update'.
Currently Architect by default save the transformation output to the 'Table output' type.
Need to add an option to select the different type of out put for transformation job.
Update the project for Java8
What steps will reproduce the problem?
I have a connection with POSTGRESQL and database with tables, and many tables
have on data type = "TEXT"
So if I
1. Open design table
2. Sayme Choose a type for xcolumn, but I dont want change data type, because
postgresql 9.1 support type text.
What is the expected output? What do you see instead?
Open design table with type "TEXT"
What version of the product are you using? On what operating system?
1.06
Original issue reported on code.google.com by [email protected]
on 15 Aug 2012 at 2:06
What steps will reproduce the problem?
Power-architect will be a very good mondrian schema designer when we can
create, and manage view
as that
<Dimension name="ProductFood" primaryKey="product_id" primaryKeyTable="product">
<Hierarchy hasAll="true" allMemberName="All Products" primaryKey="product_id">
<View alias="Product">
<SQL dialect="generic">
select
pc.product_family as product_family,
p.product_id as product_id,
p.product_name as product_name,
p.brand_name as brand_name,
pc.product_subcategory as product_subcategory,
pc.product_category as product_category,
pc.product_department as product_department
from
product as p, product_class as pc
where
p.product_class_id = pc.product_class_id
and pc.product_family = 'food'
</SQL>
</View>
<Level name="Product Family" column="product_family" uniqueMembers="false"/>
<Level name="Product Department" column="product_department" uniqueMembers="false"/>
<Level name="Product Category" column="product_category" uniqueMembers="false"/>
<Level name="Product Subcategory" column="product_subcategory" uniqueMembers="false"/>
<Level name="Brand Name" column="brand_name" uniqueMembers="false"/>
<Level name="Product Name" column="product_name" uniqueMembers="true"/>
</Hierarchy>
</Dimension>
Original issue reported on code.google.com by [email protected]
on 22 Aug 2010 at 9:36
Steps to recreate the issue
This will create the kettle job at specified location.
Go to Pentaho open the job that you just created.
You will see Kets for step1 and 'keys for step2' missing.
The expected behaviour should be:
Keys for 1st step should be the (primary key from your First Step ( e.g Student Table)
Keys for 2nd step should be the (Foreign key from your second Step ( e.g address2Table)
Expected output should be as below:
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.