pyistanbul/dbpatterns

Dbpatterns is a service that allows you to create, share, explore database models on the web. Built on top of Django, Backbone. Patterns are stored on MongoDB, and uses Lettuce for BDD approach.

Db-patterns

Dbpatterns is a service that allows you to create, share, explore database models on the web.

Notes:

The previous domain is not active anymore.
Project might be relaunched under a different domain

Installation

Install mongodb:

sudo apt-get install mongodb
# or on mac
sudo brew install mongodb

Start mongodb:

mongod

Create a virtual env:

virtualenv dbpatterns
source dbpatterns/bin/activate

Clone the repository and install requirements:

cd dbpatterns
git clone git://github.com/fatiherikli/dbpatterns.git
pip install -r dbpatterns/conf/requirements.pip

Create a file that named settings_local.py Configure the database and secret key.

cd dbpatterns/web/dbpatterns
vim settings_local.py

The example of configuration:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.sqlite3',
        'NAME': 'data',
        'USER': '',
        'PASSWORD': '',
        'HOST': '',
        'PORT': '',
    }
}

SECRET_KEY = '<SECRET-KEY>'

And run the following commands:

cd ../
python manage.py syncdb
python manage.py runserver

That's all. You can access to dbpatterns on https://localhost:8000

dbpatterns's Issues

Exported SQLite Script FKs does not work

OS: Microsoft Windows [Version 10.0.14372]
SQLite Version: 3.10.1 2016-01-13 21:41:56 254419c36766225ca542ae873ed38255e3fb8588

I had to manually edit FK sections of exported Sqlite script since it throws syntax error.

• I splitted Column and FK definitions
• Moved FK definitions to last lines of table definitions.

Uploaded buggy and fixed scripts as a Gist , Download as Zip with

• Import scripts (bat and shell scripts)
• Original and fixed sql scripts
• With a simple diff file

---

Example:

I fixed manually changing this section:

CREATE TABLE "Led" (
    "id" int PRIMARY KEY,
    "oda_id" int FOREIGN KEY("oda_id") REFERENCES "Oda" ("id"),
    "status_id" int FOREIGN KEY("status_id") REFERENCES "Status" ("id")
);

To:

CREATE TABLE "Led" (
    "id" int PRIMARY KEY,
    "oda_id" int, 
    "status_id" int,
    FOREIGN KEY("oda_id") REFERENCES "Oda" ("id"),
    FOREIGN KEY("status_id") REFERENCES "Status" ("id")
);

Agree/Disagree counters on comments.

Please consider adding agree/disagree counters on comments (or some other reaction counter) to limit follow on comments like 👍 and help us build consensus.

new feature: export as django models

Default Type feature can be improved

dbpattern now supports automatically assigning field types by field name like id is integer, etc.
But more names and types can be supported, such as:

• done, open, closed, canceled, active, is_active: boolean
• amount, total, debit, credit, grand_total, sub_total: currency

(assumed that is_active, isActive and IsActive expressions are identical)

Entity notes

A "notes" feature may be helpful, like in mysql tables "table notes";

Patterns for document based dbs

User will be able to

• add embeded object
• export pattern as json formatted.

Remove an attribute

I doesn't seem to be currently possible to delete an attribute once it's been created – I found no shortcut nor button to achieve that. Is it possible and if so how ?

Export entire chart as image

Capturing the entire chart like this http://jsfiddle.net/hasantayyar/AqAE2/2/ will be a cool function.

Removing a FK doesn't reflect to diagram

When I remove a foreing key reference between two tables, it stays in the diagram.

Profile edit/delete

Hi, first sorry for posting this here but, how can I edit my profile or delete it? I want to change my username

Thanks

Msql Export Currency Type

currency type exported like field nvarchar,
must be like field numeric(15,2),

Web page does not work anymore

Web page does not work anymore

Support for UUID attribute type

Hi.

I was wondering if UUID could be added as Attribute type as it is used on Postgres and Oracle databases.

xss , iframe bug

fixlenecek yerler

1. Yorum kısmı
2. pattern title
3. pattern içerigi

örnek : http://dbpatterns.com/show/5095534c89cbad3c201a78bd

Multiple component primary keys are exported wrong

Create a table, add two fields, mark both as PRIMARY KEY. Export as Postgres. This is what's generated:

CREATE TABLE a(
  f1 int PRIMARY KEY,
  f2 int PRIMARY KEY
);

This is what's desired:

CREATE TABLE a(
  f1 int,
  f2 int,
  PRIMARY KEY(f1, f2)
);

Links to repository.

The site doesn't have any references to this repository on it at http://dbpatterns.com
Also there are twitter callouts but no official twitter account?

Missing feature: Download schemas in SQL-format

Perhaps I'm blind, but it doesn't appear to be possible downloading a schema as SQL? I.e. a list of CREATE TABLE statements.

multiple foreign keys

when adding multiple foreign keys from one table to the other, the connection lines(and the text) overlap making it hard to read the connection details.

[Security] Unvalidated Redirect in login page

Hi,

If I were to link to dbpatterns with this url: http://dbpatterns.com/accounts/login/?next=//malicious.example.com

Then after logging in you are redirected to malicious.example.com.

"Export pattern" feature

Redirect after login to referred page.

Actually not work.

Polymorphic foreign keys

Is it possible to show polymorphic foreign keys of that type, as done by Rails (Ruby) or Laravel (PHP) ?

column	type
illustrable_type	string
illustrable_id	integer

I'm assuming this is not possible because SQL doesn't have any structure for it but as DBPatterns is more of a "representation" tool to me it'd seem logical to be allow to "show" that, maybe by specifying a list of entities in the foreign key field, like Book,Author or something.

Github login doesn't work anymore

I try to login using "connect" button for Github. It doesn't work anymore.

Is it just me or is it really broken?

Import feature

Import from well formatted sql files will be a useful feature.

Bağlantılar Kayboluyor

Oluşturduğun entityleri birbirine bağlayıp kayıt ettikten sonra tekrar görüntülemek istediğimde bağlarının görünmediğini farkettim.

Zoom in/out feature

While working on big patterns zoom out feature will be useful.

github login

There should be a github oauth login.

Patterns with different Stati

I would very much like to be able to work on a pattern before it goes into the live system.

Similarly I would like the ability to have private patterns. I would suggest introducing a status to the pattern model. Then a publishing style platform.

p.s. If you were to include a private option, I would pay for this.

UI: Improvement for deleting attributes

It's really unclear that this dot will delete an attribute.
My suggestion is to make it a more obvious icon like a red 'x' for example.

bir local_settings.py.template alabilir miyiz?

Report User Feature

http://dbpatterns.com/accounts/profile/bockabockablock/
http://dbpatterns.com/documents/5706cbb61514b4252236da53/
Example of a spam user and his database

There should be a way to report users or report certain database designs.

Document Settings Edit

Clicking the Edit Gear icon to edit a doc's settings causes another dialog to popup, but with incomplete properties, as some are added to the original dialog box. Selecting the edit icon multiple times, creates more dialogs with the same issue.