semvec/pypi-packages huggingface dataset:
pycopy-opcode 1.1
opcode module for Pycopy
License: MIT

This is a module for the standard library of Pycopy project:
https://github.com/pfalcon/pycopy . This module was implemented from
scratch specifically to target Pycopy, with efficient and lean design
in mind. Note that this module is likely work in progress and likely
supports just a subset of CPython’s corresponding module. Please help
with the development if you are interested in this module.
grafanacli 1.0.10
Library to manage Grafana API
License: MIT

# grafanacli [![GitHub license](https://img.shields.io/github/license/JeferCatarina/grafanacli.svg?style=flat-square)](https://github.com/JeferCatarina/grafanacli/blob/master/LICENSE) 

## What the heck is that?

GrafanaCLI is a Python library used to manage Grafana API

## Requirements

Python :: 2
Python :: 3

## Installation

Install the pip package:

```
pip install grafanacli
```

## Usage

```python
from grafanacli import GrafanaAdmin

ga = GrafanaAdmin('http://127.0.0.1:3000')

# Disable SSL verification
ga.verify = False
"""SSL verification must be disabled before use GrafanaAuth"""

# Authentication using username and password
ga.GrafanaAuth(Username='admin', Password='admin')

# Authentication using API-Key
ga.GrafanaAuth(AuthType='APIKey', Key='xxxxxxxxxxxxx')

# List your current organization
ga.CurrentOrganization()

# List all organizations
ga.OrganizationList()

# Search Organization
ga.OrganizationSearch('MyOrganization')

# Create Organization
ga.OrganizationCreate('MyNewOrganization')

# Update Organization
ga.OrganizationUpdate('1', 'NewOrganizationName')
Where "1" is the organization Id that will be updated.

# Delete Organization
ga.OrganizationDelete('1')
Where "1" is the organization Id that will be deleted.

# Switch Organization
ga.OrganizationSwitch('2')
Where "2" is the organization Id what I want to switch

# Search dashboard whitout filter
ga.DashboardSearch()

# Search dashboard by title
ga.DashboardSearch(DashboardName='My Dashboard')

# Search dashboard by tag
ga.DashboardSearch(Tag='My Tag')

# Search starred dashboards
ga.DashboardSearch(Starred=True)

# Search dashboard aplying more than one conditition
ga.DashboardSearch(Starred=True, Tag='My Tag')
ga.DashboardSearch(Name='My Dashboard', Tag='My Tag')
ga.DashboardSearch(Name='My Dashboard', Tag='My Tag', Starred=True)

# Download Dashboard
ga.DashboardDownload('DashboardUid', '/tmp/mydash.json')

# Upload Dashboard
ga.DashboardUpload('/tmp/mydash.json', Overwrite=True)
ga.DashboardUpload('/tmp/mydash.json')
ga.DashboardUpload('/tmp/mydash.json, FolderId=3'

# Create, List, Get, Update and Delete Folders
ga.FolderCreate('My Folder')
ga.FolderList()
ga.FolderGet('folderUID')
ga.FolderUpdate('folderUID', 'My Folder New Name', version=x) # Current Folder's version ID (int)
ga.FolderUpdate('folderUID', 'My Folder New Name', overwrite=True) # It will skip version confirmation
ga.FolderDelete('folderUID')

# Star and Unstar a dashboard
ga.DashboardStar(dashboadID)
ga.DashboardUnstar(dashboadID) 

# Get and Update Dashboard's permission
ga.DashboardGetPermissions(dashboadID)
ga.DashboardUpdatePermissions(dashboadID, new_json_permission)

```

## License

GrafanaCLI is licensed under the terms of the MIT License (see the
[LICENSE](LICENSE) file).
postgresqlinterface 0.0.2
Library to load and extract data from a PosgreSQL Database with Python with a simple SQL style language
License: MIT

# PostgreSQLInterface 
## Introduction
This package allows to load and extract data from a PosgreSQL Database using simple SQL style methods. At the moment,
it has only been tested on a Heroku Postgres Database, though it should not be hard to extended the *init* method 
to be able to interact with other cloud or premises providers that uses PosgresSQL technology (maybe the method 
*create_connection* will also need to be modified). Also, It could be used as reference to create new interfaces to connect
to other RDBS the same way this one is inspired on the one to connect to SQLServer located on the library berryworld.   

## Structure
The library has an unique class that handles the relations to a database allowing to load and extract data.

## Instantiate the class
To instantiate the class to connect to a Heroku Database:
```
heroku_db = PosgreSQL(database_url)
```
*database_url* can be found on the section *Config Vars* inside the tab *Settings* of your Heroku app or on the 
section *Database Credentials* of the tab *Settings* of your Heroku Datastore.

## Read data from Database
To retrieve a query from the database:
```
my_table = heroku._db.query("SELECT * FROM test.data")
```
It is also possible to do more complicated queries:
```
my_table = heroku._db.query("SELECT * FROM test.data d JOIN test.references r ON d.referencesid = r.id")
```

## Insert data
To insert data into a table
```
heroku_db.insert_table('test.simple', to_insert.copy())
```

## Update a table
To insert data into a table
```
heroku_db.update_table('test.simple', to_update, ['id', 'date'])
```


## Execute a general statement
To execute a general SQL statement you can use the method *execute*. This method returns no data. 
It is important to notice that it is not the SQL execute command. As an example, you can use it to create a schema:
```
heroku._db.execute("CREATE SCHEMA test")
```
You can also use it to execute a stored procedure
```
heroku._db.execute("EXECUTE test.sp_test1 @input = '%s" @ input)
```

## Tests
To be able to execute the tests, it is necessary to provide a '.env' file with the url to connect to a Heroku database.