2017 © Pedro Peláez
 

library tidbit

Random data generator for Sugar

image

sugarcrm/tidbit

Random data generator for Sugar

  • Thursday, July 19, 2018
  • by mmarum-sugarcrm
  • Repository
  • 104 Watchers
  • 33 Stars
  • 121 Installations
  • PHP
  • 0 Dependents
  • 0 Suggesters
  • 44 Forks
  • 12 Open issues
  • 21 Versions
  • 32 % Grown

The README.md

Tidbit v3.0 (bleeding edge) -- Tidbit v2.0 (stable)

Master Develop
Build status ![Build status][Develop image]
![Coverage Status][Master coverage image] ![Coverage Status][Develop coverage image]

Tidbit is random data generator for Sugar versions 7.8 and later. By optimizing the communications with the database, large amounts of data can be inserted into the system for testing without manual intervention., (*1)

Documentation in the wiki!

Please visit the wiki for detailed documentation on using and configuring Tidbit., (*2)

Requirements

PHP 5.6+ Sugar Already installed (7.8+ versions), (*3)

Installation

To install Tidbit, unpack the Tidbit-v###.tar.bz2 file, and place the Tidbit/ directory within your SugarCRM installation (Tidbit Directory need to be created inside SugarCRM Installation folder)., (*4)

Download composer, (*5)

curl -sS https://getcomposer.org/installer | php

Install composer dependencies inside Tidbit directory, (*6)

./composer.phar install

The only other requirement of Tidbit is that you have an installed and properly configured copy of Sugar in the directory above it., (*7)

Installation of Vagrant Stack (Example):

  1. SSH into vagrant stack you are using via command line., (*8)

    $ vagrant ssh
    
  2. Navigate to Sugar directory., (*9)

    $ cd /
    $ cd var/www/html/ (sugar instance).
    
  3. Download zip file from repo (master.zip) into the sugar instance. e.g. /SugarEnt-Full-7.6.0.0/., (*10)

    $ wget (url to zip file)
    
  4. Unzip file (master.zip). Directory created by zip file is called Tidbit-master., (*11)

    $ unzip master.zip
    
  5. Change Directory to /Tidbit e.g., mv /Tidbit-master /Tidbit., (*12)

    $ mv /Tidbit-master /Tidbit
    
  6. Navigate to /Tidbit and follow instructions under usage, below, from within /Tidbit directory., (*13)

    $ cd /Tidbit
    
  7. Install Composer dependencies, (*14)

    $ ./composer.phar install
    

Configuration

Tidbit has default config files in tidbit_root/config/ folder.
Here:
    - config.php          -- main config file
    - data/*.php          -- customization of filling for separate fields if
                             bean tables
    - relationships/*.php -- customization of filling for separate fields if
                             bean relation tables
Tidbit settings can be fully overrided in tidbit_root/custom/config.php file
by php arrays in the same manner as in original configs

Usage

NOTES:, (*15)

  • Usage of Tidbit could affect your data in DB Please make sure you have a backup, before running data Generation commands, (*16)

  • In case of generation csv (--storage csv) We suppose what csv-dump will be used on empty DB, so for speed up, we'll generate values (integer starting with 1) for autoincrement-type fields., (*17)

Tidbit uses a command line interface. To run it from the Tidbit directory:, (*18)

$ ./bin/tidbit (or ./vendor/bin/tidbit for package dependency installation)

Various options are available to control the number of entries generated. To view them:, (*19)

$ ./bin/tidbit -h

Example usages:, (*20)

* Clean out existing seed data when generating new data set:
  $ ./bin/tidbit -c

* Insert 500 users:
  $ ./bin/tidbit -u 500

* Generate data into csv (mysql is default):
  $ ./bin/tidbit --storage csv

* Generate records for all out-of-box and custom modules, plus find all relationships
  $ ./bin/tidbit --allmodules --allrelationships

* Obliterate all data when generating new records with 400 users:
  $ ./bin/tidbit -o -u 400

* Use profile (pre-existing one: simple, simple_rev2, average, high) file to generate data
  $ ./bin/tidbit -o --profile simple --sugar_path /some/sugar/path

* Use custom profile (located in /path/to/profile/file)
  $ ./bin/tidbit -o --profile /path/to/profile --sugar_path /some/sugar/path

* Generate TeamBasedACL action restrictions for chosen level (check level options in config files)
  $ ./bin/tidbit -o --tba -tba_level full

* Controlling INSERT_BATCH_SIZE (MySQL Support only for now)
  $ ./bin/tidbit -o --insert_batch_size 1000

* Setting path to SugarCRM installation
  $ ./bin/tidbit -o --sugar_path /some/sugar/path

* Using DB2 storage example (mysql/oracle/db2 can be used, depending on Sugar installation and DB usage)
  $ ./bin/tidbit -o --sugar_path /some/sugar/path --storage db2

Contributing:

See CONTRIBUTING for how you can contribute changes back into this project., (*21)

All Pull Requests should be targeted to "develop" branch and follow PSR2 Code Style Standard To run quick code check use, (*22)

$ ./composer.phar check-style

or call PHP CS directly, (*23)

$ ./vendor/bin/phpcs --standard=./ruleset.xml

to run PHPUnit tests locally please use, (*24)

$ ./composer.phar tests

or call PHPUnit directly, (*25)

$ ./vendor/bin/phpunit -c ./phpunit.xml.dist

There are automated PR checks enabled on TravisCI (https://travis-ci.org/sugarcrm/Tidbit) For each PR code-style and phpunit tests will be executed for verification, (*26)

The Versions

19/07 2018

dev-develop

dev-develop https://github.com/sugarcrm/tidbit

Random data generator for Sugar

  Sources   Download

proprietary

The Requires

  • php >=5.4

 

The Development Requires

sugar sugarcrm tidbit

05/07 2018

dev-team_name_incname

dev-team_name_incname https://github.com/sugarcrm/tidbit

Random data generator for Sugar

  Sources   Download

proprietary

The Requires

  • php >=5.4

 

The Development Requires

sugar sugarcrm tidbit

29/06 2018

dev-fix_priv_team_name_2

dev-fix_priv_team_name_2 https://github.com/sugarcrm/tidbit

Random data generator for Sugar

  Sources   Download

proprietary

The Requires

  • php >=5.4

 

The Development Requires

sugar sugarcrm tidbit

02/05 2018

dev-parallel_csv

dev-parallel_csv https://github.com/sugarcrm/tidbit

Random data generator for Sugar

  Sources   Download

proprietary

The Requires

  • php >=5.4

 

The Development Requires

sugar sugarcrm tidbit

28/04 2018

dev-empty_descriptio

dev-empty_descriptio https://github.com/sugarcrm/tidbit

Random data generator for Sugar

  Sources   Download

proprietary

The Requires

  • php >=5.4

 

The Development Requires

sugar sugarcrm tidbit

28/04 2018

dev-parallel

dev-parallel https://github.com/sugarcrm/tidbit

Random data generator for Sugar

  Sources   Download

proprietary

The Requires

  • php >=5.4

 

The Development Requires

sugar sugarcrm tidbit

27/04 2018

dev-no_counters_in_rel_id

dev-no_counters_in_rel_id https://github.com/sugarcrm/tidbit

Random data generator for Sugar

  Sources   Download

proprietary

The Requires

  • php >=5.4

 

The Development Requires

sugar sugarcrm tidbit

26/04 2018

dev-get_rid_of_as_for_good

dev-get_rid_of_as_for_good https://github.com/sugarcrm/tidbit

Random data generator for Sugar

  Sources   Download

proprietary

The Requires

  • php >=5.4

 

The Development Requires

sugar sugarcrm tidbit

26/04 2018

dev-generate_tags_always

dev-generate_tags_always https://github.com/sugarcrm/tidbit

Random data generator for Sugar

  Sources   Download

proprietary

The Requires

  • php >=5.4

 

The Development Requires

sugar sugarcrm tidbit

25/04 2018

dev-rewrite_favorites

dev-rewrite_favorites https://github.com/sugarcrm/tidbit

Random data generator for Sugar

  Sources   Download

proprietary

The Requires

  • php >=5.4

 

The Development Requires

sugar sugarcrm tidbit

25/04 2018

dev-simplify_rel_id_calc

dev-simplify_rel_id_calc https://github.com/sugarcrm/tidbit

Random data generator for Sugar

  Sources   Download

proprietary

The Requires

  • php >=5.4

 

The Development Requires

sugar sugarcrm tidbit

25/04 2018

dev-redo_rel_multiplier

dev-redo_rel_multiplier https://github.com/sugarcrm/tidbit

Random data generator for Sugar

  Sources   Download

proprietary

The Requires

  • php >=5.4

 

The Development Requires

sugar sugarcrm tidbit

11/04 2018

dev-skip_total_0

dev-skip_total_0 https://github.com/sugarcrm/tidbit

Random data generator for Sugar

  Sources   Download

proprietary

The Requires

  • php >=5.4

 

The Development Requires

sugar sugarcrm tidbit

19/03 2018

dev-erased_fields

dev-erased_fields https://github.com/sugarcrm/tidbit

Random data generator for Sugar

  Sources   Download

proprietary

The Requires

  • php >=5.4

 

The Development Requires

sugar sugarcrm tidbit

07/03 2018

dev-master

9999999-dev https://github.com/sugarcrm/tidbit

Random data generator for Sugar

  Sources   Download

proprietary

The Requires

  • php >=5.4

 

The Development Requires

sugar sugarcrm tidbit

06/03 2018

dev-precalculate_field_rules

dev-precalculate_field_rules https://github.com/sugarcrm/tidbit

Random data generator for Sugar

  Sources   Download

proprietary

The Requires

  • php >=5.4

 

The Development Requires

sugar sugarcrm tidbit

06/03 2018

dev-fix_division_by_zero

dev-fix_division_by_zero https://github.com/sugarcrm/tidbit

Random data generator for Sugar

  Sources   Download

proprietary

The Requires

  • php >=5.4

 

The Development Requires

sugar sugarcrm tidbit

04/02 2018

dev-spec_user_start

dev-spec_user_start

  Sources   Download

25/01 2018

dev-mt_srand_issue

dev-mt_srand_issue https://github.com/sugarcrm/tidbit

Random data generator for Sugar

  Sources   Download

proprietary

The Requires

  • php >=5.4

 

The Development Requires

sugar sugarcrm tidbit

17/12 2017

dev-ISSUE-98

dev-ISSUE-98 https://github.com/sugarcrm/tidbit

Random data generator for Sugar

  Sources   Download

proprietary

The Requires

  • php >=5.4

 

The Development Requires

sugar sugarcrm tidbit

21/09 2016

2.0.0

2.0.0.0 https://github.com/sugarcrm/tidbit

Random data generator for Sugar

  Sources   Download

proprietary

The Requires

  • php >=5.3.27

 

The Development Requires

sugar sugarcrm tidbit