semvec/pypi-packages huggingface dataset:
pysqlutil 1.0.1
parse sql , compare two .sql file , generate optimization hint for your sql and various other utilities
License: MIT
Requires Python: >=3.9.0


## dot.parser

[![Generic badge](https://img.shields.io/badge/python-3.10-success.svg)](https://shields.io/)
[![Generic badge](https://img.shields.io/badge/GUI-WIP-success.svg)](https://shields.io/)
[![Generic badge](https://img.shields.io/badge/CLI-no-red.svg)](https://shields.io/)
[![Generic badge](https://img.shields.io/badge/projectStatus-developing-yellow.svg)](https://shields.io/)
![Maintainer](https://img.shields.io/badge/maintainer-koushikdutta-blue)
[![Linux](https://svgshare.com/i/Zhy.svg)](https://svgshare.com/i/Zhy.svg)
[![Tests](https://github.com/macbre/sql-metadata/actions/workflows/python-ci.yml/badge.svg)](https://github.com/macbre/sql-metadata/actions/workflows/python-ci.yml)
[![Coverage Status](https://coveralls.io/repos/github/macbre/sql-metadata/badge.svg?branch=master&1)](https://coveralls.io/github/macbre/sql-metadata?branch=master)
<a href="https://github.com/psf/black"><img alt="Code style: black" src="https://img.shields.io/badge/code%20style-black-000000.svg"></a>
[![Maintenance](https://img.shields.io/badge/maintained%3F-yes-green.svg)](https://github.com/macbre/sql-metadata/graphs/commit-activity)

### Project Phase One:

- SQL ( Parsing SQL ) Till now I could only managed to create SQL Parser
- Phase Status - initial Development
- Due to beta version release you might face some difficulties

### SQL Dialects Supported 

- MySQL
- PostreSQL ( Redshift in progress )
- Sqlite 

[![forthebadge made-with-python](http://ForTheBadge.com/images/badges/made-with-python.svg)](https://www.python.org/)

[![PyPI license](https://img.shields.io/pypi/l/ansicolortags.svg)](https://pypi.python.org/pypi/ansicolortags/)

---

### How to use this python module

```
pip install pysqlutil
```

### Extracting raw sql-metadata tokens

```python
from pysqlutil import parser

# extract raw sql-metadata tokens
parser("SELECT * FROM test_table").tokens
parser("SELECT test, id FROM test_table1,test_table2").columns
# you will get column names

parser_object = parser("<your custom SQL>")
parser_object.columns
# you will get column names as a list

# but you can still extract aliases names
parser_object.columns_aliases
# column alias list 
```

### Soon , new featurers will be included like SQL File compare , DDL Compare , Analyze and optimize SQL
### Future Release list
- Jan-2023 : SQL Compare , Compare two versions of DDL 
- Feb-2023 : GUI Support .
changelogs-cli 1.0.0
Generates git changelog for Conventional Commits
License: MIT
Keywords: Generates git changelog for Conventional Commits

# Changelogs Generator
Hey! This Package is a [changelogs-cli](https://pypi.org/project/changelogs-cli/)  package that creates automatic changelogs that supports [Conventional Commits.](https://www.conventionalcommits.org/en/v1.0.0/)
Since we use Bitbucket, we needed something like this and I wanted to share it publicly in case you need it too.

# Emoji Support
If comments comply with conventional commit rules, they are supported with emoji.

```json
[
    "feat": "✅",
    "fix": "🚀",
    "build": "💚",
    "chore": "🚀",
    "docs": "📝",
    "style": "🎨",
    "refactor": "👷",
    "perf": "⚡️",
    "test": "🧪",
    "merge": "🎉",
    "revert": "⏪️"
]  
````
 
# Installing

    pip install changelogs-cli

# Example

First, let's get into the current your repository. 

Example;
    ```cd /home/repository/```

Example usage is as follows.
    changelogs ```example/commits/``` (this should be commit link to show reference  on changelogs md.)


# Demo

i will use this repo for example ; https://github.com/qoomon/git-conventional-commits

<img src="https://raw.githubusercontent.com/AliYmn/changelog/master/images/ex1.png">

<img src="https://raw.githubusercontent.com/AliYmn/changelog/master/images/ex2.png">

---

The sample check logs are as follows : [Check it!](./exChangelog.md)
DearPyGui-DragAndDrop 1.0.0
Working Drag-and-Drop for DearPyGui, Windows only
License: MIT
Requires Python: >=3.7

# DearPyGui-DragAndDrop

Working Drag-and-drop for DearPyGui, Windows only
![demo](https://user-images.githubusercontent.com/46572469/210178591-3011e753-82ed-4d8f-8652-87375d7366e0.gif)

## How to install/use

1) Install the DearPyGui-DragAndDrop package: </br>
   `pip install DearPyGui-DragAndDrop`

2) Import and then initialize the library after `dpg.create_context()`:

```python
import dearpygui.dearpygui as dpg

import DearPyGui_DragAndDrop as dpg_dnd

dpg.create_context()
dpg_dnd.initialize()
```

3) That's it, just set your function for `drop` and your minimal use case is ready:

```python
import dearpygui.dearpygui as dpg

import DearPyGui_DragAndDrop as dpg_dnd

dpg.create_context()
dpg_dnd.initialize()
dpg.create_viewport(title="Drag and drop example", width=600, height=600)


def drop(data, keys):
    print(f'{data}')
    print(f'{keys}')


dpg_dnd.set_drop(drop)

dpg.setup_dearpygui()
dpg.show_viewport()
dpg.start_dearpygui()
dpg.destroy_context()
```

### More examples of use are in the [Examples folder](https://github.com/IvanNazaruk/DearPyGui-DragAndDrop/Examples)

## Supported Formats

- [x] File(s) paths *(will be in the form of a `list of strings`)*
- [x] Text *(will be `string`)*

Everything else will be `None` or will be a `string`

## TODO list:

- [ ] Documentation and code/functions comments
- [ ] Add support for more and other data
  types: [maybe this is the right list](https://learn.microsoft.com/en-us/windows/win32/dataxchg/standard-clipboard-formats#constants)
a-selenium-some-js 0.10
A couple of useful JS scripts for Selenium
License: MIT
Keywords: Selenium,js,scripts


# A couple of useful JS scripts for Selenium


```python
# Tested with:
# https://github.com/ultrafunkamsterdam/undetected-chromedriver
# Python 3.9.13
# Windows 10

$pip install a-selenium-some-js

from a_selenium_some_js import *

execute_scripts_with_timeout(
        driver, script=f"window.scrollBy(0,{200})", script_timeout=3
    )
js_scrollby(driver, y=40, script_timeout=0)	
go_to_top_of_page(driver, script_timeout=1)
get_navigator_infos(driver)
zoom_website(driver, scaleFactor=2, x=0, y=0, relativeSpeed=800)

maximize_window(driver) # window is not maximized, but its size is like maximized

send_cmd(driver,'Input.synthesizePinchGesture', {
                        'x': 0,
                        'y': 0,
                        'scaleFactor': 2,
                        'relativeSpeed': 800, # optional
                        'gestureSourceType': 'default' # optional
                    }) # https://chromedevtools.github.io/devtools-protocol/
    
	
```