semvec/pypi-packages huggingface dataset:
databaseops 1.0.0
Work with Database as it is dataframe, No need to remember sql queries
License: MIT

# DatabaseOps

---

A lightweight and fast database operation module without using queries with the ease of python.

## Table of Contents

- [Install](#install)
- [Dependencies](#Dependencies)
- [Usage](#usage)
- [Contributing](#Contributing)
- [License](#license)
- [Project status](#Project-status)


## Install

``` python
 pip install databaseops
```

**Note:** Above example will always fetch the latest version. To fetch a specific version, use `pip install
 databaseops==Version`
Visit [databseops/history](https://pypi.org/project/databaseops/#history) to see older versions.

## Dependencies
- [pandas](https://pandas.pydata.org/pandas-docs/stable/index.html)
- [sqlalchemy](https://www.sqlalchemy.org/)
- [PyMySQL](https://pymysql.readthedocs.io/en/latest/#)

**Note:** You don't need to worry about dependencies as all those will install automatically 
at the installing databaseops. This information is just for your knowledge. 

## Usage

``` python
from databaseops import MySQLTable
my_sql_table = MySQLTable(host="localhost", user="root", password="1234", db_name="Test", table_name="Test_table")
```

Explanation and usage of different methods available to user are as follows
``` python
# Populate Table: Add data frame to database table
my_sql_table.populate_table(dataframe=pandas.DataFrame, if_exists: str = 'append')

# Update Table
my_sql_table.update_table(dataframe=pandas.DataFrame, if_exists: str = 'append')

# Set Primary Key
my_sql_table.set_primary_key(column_name= "single column name" or ["list of column names"],
 remove_duplicates=True) 

# Set Unique Keys
my_sql_table.set_unique_keys(column_name= "single column name" or ["list of column names"],
 remove_duplicates=True)

# Read Table
my_sql_table.read_table(chunksize: int = None)

# Table Filter
my_sql_table.table_filter(where: [list of condition], select= "single column name" or ["list of column names"],
 limit: int = None, chunksize: int = None)

# Remove Duplicates
my_sql_table.remove_duplicates(list_of_columns= ["list of column names"])


# Sort Table
my_sql_table.sort_table(column: str or dict, order="ascending" or "descending")

# Get Data Type
my_sql_table.get_data_type()
```

## Roadmap

Plan for future releases is to add multi-table join and other query to MySqlOps class.
After that plan is add support to multiple databases like [redis](https://redis.io/), 
[mongoDB](https://www.mongodb.com/what-is-mongodb)


## Contributing
Pull requests are welcome.
For major changes, please open an issue first to discuss what you would like to change.

## License

[![License](https://img.shields.io/badge/license-MIT-blue.svg)](/LICENSE)

Released 2020 by [Ankush Bhise](https://github.com/AnkushBhise)

## Project status
This project is in development mode, not completely developed yet.
It will developed at slower speed.
vcg 1.3.0
Shared toolkit for VCG@XMU
License: MIT
Keywords: VCG@XMU

# VCG
## Install
```bash
pip install git+http://git.hypercube.top/ipic/vcg.git
```
or through pypi

```bash
pip install vcg
```


## Functions

### list_dir
```python
from vcg import list_dir,get_postfix

for name,file in list_dir(".", condition=get_postfix(".mp4"),key=lambda x:x[0]):
    print(name,file)
```
### notify
```python
from vcg import notify
with notify("admin@hypercube.top", debug=True):
    raise NotImplementedError
```
set `debug=True` to disable notify temporary.

### make_join
```python
import vcg

folder=vcg.make_join("data","what")
print(folder)

# so you created a folder named "data/what"
```
### mkdir
```python
import vcg
vcg.mkdir("data","ping") # create two folders "data" and "ping"
```

### partition

Returns a new list with elements of which is a list of certain size.

```python 
partition([1, 2, 3, 4], 3) # you get [[1, 2, 3], [4]]
```
### flatten

```python
from vcg import flatten
flatten([[1, 2, 3], [4]]) #[1,2,3,4]
```

### save_json
```python
save_json(file, obj)
```
### load_json
```python
obj=load_json(file)
```
## Classes

### HostSpecific
```python
from vcg import HostSpecific
spec = HostSpecific("data/spec.json")
print(spec.what)
print(spec["what"])
```

### Config
```python
from vcg import Config
config = Config(key="cfg")
config.add_post_arg("name", lambda args: args.cfg)
config.add_argument(
    "--no_flip", action="store_true", help="specified if no flipping"
)
print(config.parse_args())
# Namespace(cfg='data/test.yaml', name='data/test.yaml', no_flip=True)
```
gormanian 0.0.7
A simple library to convert a datetime date to use the superior Gormanian Calendar.
License: MIT
Keywords: Gormanian,Gormanuary,Dave Gorman

# Gormanian

## Gormanian Calendar Calculator/Converter

### What is it?

Put simply, it is a library to calculate an alternative date structure based on the comedic sketch of [Dave Gorman](http://davegorman.com/).  In an episode of '*Modern Life is Goodish*', Dave Gorman proposed a new calendar format to replace the existing Gregorian calendar.  In particular, he takes umbridge at the fact that the length of a month varies, when all other units of time are fixed and identical.

You can watch the video in question [here](https://www.youtube.com/watch?v=vunESk53r5U&feature=youtu.be) on Dave Gorman's official YouTube channel.

### But why?

Why not?  I happen to agree with the calendar, and decided to write this for a laugh.

### How to Use

#### To convert the current date


    import gormanian
    
    response = gormanian.now()
    
    print(response.as_string)



#### To convert a specific date
Use the standard datetime format for any given date.

    from datetime import datetime
    import gormanian
    
    response = gormanian.convert(datetime(2000, 12, 1))
    
    print(response.as_string)

#### ISO-8601 format:
You can also retrieve the date in ISO-8601 basic format.

    from datetime import datetime
    import gormanian
    
    response = gormanian.convert(datetime(2000, 12, 31))
    
    print(response.isoformat)