semvec/pypi-packages huggingface dataset:
sqldiffer 0.1.2
Check the difference of MySQL schema (CREATE TABLE)
License: MIT
Requires Python: >=3.8,<4.0
Keywords: MySQL,Database,Schema

# sqldiffer

![PyPI](https://img.shields.io/pypi/v/sqldiffer)
![PyPI - Python Version](https://img.shields.io/pypi/pyversions/sqldiffer)
![GitHub](https://img.shields.io/github/license/homoluctus/sqldiffer)

Check the difference of MySQL schema (CREATE TABLE)

<!-- TOC depthFrom:2 -->

- [Feature](#feature)
- [Installation](#installation)
- [Usage](#usage)
- [Examples](#examples)
  - [Check the differences](#check-the-differences)
  - [Ignore charset](#ignore-charset)
  - [Ignore auto_increment and charset](#ignore-auto_increment-and-charset)

<!-- /TOC -->

## Feature

- Check the difference of MySQL schema
  - Compare CREATE TABLE
  - Choose whether to ignore AUTO_INCREMENT and CHARSET
- Output HTML
  - Save the difference for each table in HTML (Click [here](./tests/result.html) for sample)

## Installation

```bash
pip install sqldiffer
```

## Usage

```
sqldiffer -h
usage: sqldiffer [-h] --server1 SERVER1 --server2 SERVER2 [-o OUTPUT_DIR] [--skip-auto-increment] [--skip-charset] [-V]

Check the difference of MySQL schema (CREATE TABLE)

optional arguments:
  -h, --help            show this help message and exit
  --server1 SERVER1     Comparison source. [Format] user:password@host:port/database
  --server2 SERVER2     Comparison target. [Format] user:password@host:port/database
  -o OUTPUT_DIR, --output-dir OUTPUT_DIR
                        Directory to save files. Default is current directory.
  --skip-auto-increment
                        Whether to ignore the difference of "AUTO_INCREMENT=[0-9]+"
  --skip-charset        Whether to ignore the difference of "CHARSET=[a-z0-9]+"
  -V, --version         Show command version
```

## Examples

### Check the differences

```bash
sqldiffer --server1 homoluctus:test@aroundtheworld:3306/aaa \
          --server2 homoluctus:test@anothersky:3306/aaa
```

### Ignore charset

```bash
sqldiffer --server1 homoluctus:test@aroundtheworld:3306/aaa \
          --server2 homoluctus:test@anothersky:3306/aaa \
          --skip-charset
```

### Ignore auto_increment and charset

```bash
sqldiffer --server1 homoluctus:test@aroundtheworld:3306/aaa \
          --server2 homoluctus:test@anothersky:3306/aaa \
          --skip-auto-increment \
          --skip-charset
```
xu 0.2.0
Collection of handy random generators.
License: MIT
Keywords: random generator tool

# xu

Collection of handy random generators.

| classes | objects | functions |
|---------|---------|-----------|
| integer | boolean | pick      |
| number  | char    |           |
| string  | random  |           |

## Examples

```python
from xu import string


print(string(10).lower)
print(string(10).upper)
print(string(10).digit)
print(string(10).alpha)
print(string(10).latin)
print(string(10).list(2))
```

	eoqsalszaj
	FCVYJZIDMY
	6712277415
	oTrbOHkUbd
	NcrW4STecT
	['euZY9gFrzx', '0AEepSNvAO']

----

```python
from xu import boolean

for it in boolean.matrix(2, 4):
	print(it)
```

	[False, True]
	[True, False]
	[True, True]
	[False, False]

----

```python
from xu import pick

data = [1, 2, 3, 4]
print(pick(data))

data = '1234'
print(pick(data, 2))
```

	3
	['2', '3']

----

```python
from xu import integer

print(integer(9) * 5)
print()
for row in integer(9) ** 5:
	print(row)
print()
for row in integer(9) ** (5, 3):
	print(row)
```

	[4, 9, 1, 3, 5]

	[4, 2, 0, 8, 8]
	[0, 3, 9, 4, 2]
	[5, 1, 1, 8, 2]
	[1, 5, 3, 5, 6]
	[6, 1, 1, 0, 2]

	[1, 1, 6, 1, 8]
	[4, 0, 2, 3, 9]
	[1, 5, 7, 2, 4]