Skip to content

zerzru/UsefulDB

Repository files navigation

DEVELOPING've STOPPED FOR A WHILE

UsefulDB

Travis CI Github downloads PyPI - Version PyPI - Format

project_logo

Contents

License

This program is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License along with this program. If not, see https://www.gnu.org/licenses/.

Training

About training

Do you already have databases and their components? You want to use this utility, but are afraid to spoil something? Or just want to understand how it works? In any case, I recommend starting with this mode. It does not connect to the Internet, it only works with local files, so you can not worry about your databases. Just go to the "Education" folder, create a new file and import the init file

[installed/folder/Education/]
from __init__ import *

Now you can enter the same commands, open the folder where the utility is installed, and look at the JSON table files

Examples

Utility can create and delete files. So:

Creating

This command will create super-user:

create.user.params('Admin', '12345', confirm=True) #also create.user.params(name='Admin', password='12345', confirm=True)

This command will create database:

create.database.params('Test') #also create.database.params(name='Test')

And this command will create table:

create.table.params('Test', 3) #also create.table.params(name='Test', 3) or create.table.params(name='Test', '3')

Deleting

This command will delete user:

delete.user.params('Admin', '12345', confirm=True) #also delete.user.params(name='Admin', password='12345', confirm=True)

This command will delete database:

delete.database.params('Test', confirm=True)

This command will delete table:

delete.table.params('Test', confirm=True)

Main

About main

This is the main job of the utility. Now, with the wrong treatment, you can break something. Although the utility has a protection system for incorrect data entry, this does not guarantee the protection of your developments.

Exmaples

Creating

This command will create super-user:

create.user.params('Admin', '12345', confirm=True) #also create.user.params(name='Admin', password='12345', confirm=True)

This command will create database:

create.database.params('Test') #also create.database.params(name='Test')

And this command will create table:

create.table.params('Test', 3) #also create.table.params(name='Test', 3) or create.table.params(name='Test', '3')

Deleting

This command will delete user:

delete.user.params('Admin', '12345', confirm=True) #also delete.user.params(name='Admin', password='12345', confirm=True)

This command will delete database:

delete.database.params('Test', confirm=True)

This command will delete table:

delete.table.params('Test', confirm=True)

Installing

pip install UsefulDB

Installation via the PIP may not work, so for now, I recommend downloading the archive of the utility and unpacking it into the folder you need

Bug report

If you have bugs or another issues, please, send to mail scg-publicmail@yandex.ru 2 files:
-log.txt
-connection_log.txt

If you send all 2 files, I can more fastly fix utility problem. Thanks.

Change log

Version 1.0.4 Beta[right now]:
-Rewrited code
-Rewrited GUI mode
-Using PEP8
-New feature: settings
-New feature: logs
-New mode: trainig
-Added easter eggs
-Some bug fixes

Version 1.0.3:
-Some bug fixes

Version 1.0.2:
-Some bug fixes
-New feature: system of checking internet-connection
-New feature: command panel
-New feature: check avialable of new versions

Version 1.0.1:
-Some bug fixes

Version 1.0.0:
-Base utility work

Contact

© 2019; Elisey Sharov

elisey.sharow@yandex.ru - main e-mail
playofstiverz@gmail.com - second e-mail
scg-publicmail@yandex.ru - e-mail for your errors and another issues

About

Simplest utility for SQL databases control

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages