DEV Community: Shreyas Ghanekar

Simplify GitHub Workflow Management with My-GitHub-Manager

Shreyas Ghanekar — Sun, 29 Dec 2024 07:16:12 +0000

Simplify GitHub Workflow Management with My-GitHub-Manager

Managing repositories, collaborators, and actions on GitHub can be a daunting task, especially when you have multiple projects to juggle. Introducing my-github-manager, a robust command-line tool designed to streamline your GitHub workflows with ease and efficiency.

Why My-GitHub-Manager?

GitHub provides a feature-rich platform for developers, but managing repositories programmatically can save a significant amount of time, especially for repetitive tasks. My-GitHub-Manager leverages the GitHub API to provide a seamless experience for repository management, collaborator tracking, workflow monitoring, and more.

Key Features:

List Users with Read Access: Identify collaborators who have read access to a repository.
List Repository Packages: Quickly fetch the packages associated with a repository.
Monitor Workflows and Actions: Retrieve workflows and actions to track automation within your repository.
Track Repository Projects: Access repository projects to keep an overview of ongoing development efforts.
Manage Discussions, Issues, and Pull Requests: Stay on top of repository activity with detailed information about discussions, issues, and pull requests.
Commit History: Review commit history to ensure consistent development practices.
Repository Invitations and Emails: Easily manage repository invitations and associated email addresses.
User Management: Follow users, list public repositories of any user, and fetch detailed profile data.

Getting Started

Installation

You can install my-github-manager globally using npm:

npm install -g my-github-manager

Prerequisites

GitHub Personal Access Token (PAT): Ensure you have a PAT with the following scopes:

repo

repo:status
repo_deployment
public_repo
repo:invite
security_events
read:user
user:email

You can create a PAT by navigating to your GitHub Developer Settings.

jq: Install jq for parsing JSON responses:

sudo apt-get install jq  # For Debian/Ubuntu
brew install jq          # For macOS

Usage

Run the tool with:

my-github-manager

The tool will prompt you to enter your GitHub username and PAT for authentication. Once authenticated, you can navigate through the interactive menu to perform various actions.

Highlighted Commands

List Collaborators with Read Access
Identify collaborators with pull access to your repository:

my-github-manager
Select "List users with read access"

Fetch Repository Packages

List all packages in a repository:

my-github-manager
Select "List packages in the repository"

Monitor Workflows and Actions

Retrieve workflows and actions for automation insights:

my-github-manager
Select "List workflows" or "List actions"

Manage Repository Discussions
Fetch and view repository discussions to stay updated:

my-github-manager
Select "List discussions"

Advanced Error Handling and Retry Mechanism

My-GitHub-Manager ensures robust error handling. For example, if a request fails due to an incorrect repository name or an expired PAT, the tool prompts you to retry the operation with corrected inputs.

Why Developers Love It

Interactive Menu: Navigate through repository management tasks effortlessly.
Error Feedback: Receive detailed error messages with actionable suggestions.

Customizable: Easily extend the script to add more GitHub API endpoints.

Open Source and Contributions

This project is open source and available on GitHub. Contributions are welcome! Feel free to raise issues, suggest features, or submit pull requests.

Conclusion

My-GitHub-Manager is your go-to tool for simplifying GitHub management tasks. With its interactive features and seamless integration with the GitHub API, it saves time and boosts productivity for developers.

Try my-github-manager today and revolutionize the way you manage your GitHub repositories!

Top 5 SQL questions asked in interviews

Shreyas Ghanekar — Sat, 09 Nov 2024 11:37:06 +0000

In this article , you will encounter top sql questions and their answers asked in interviews. This will help you prepare in for interviews.

Question 1 : What is the difference between DELETE and TRUNCATE ?

Ans :

delete command in sql is used to delete a particular row or a set of rows from the table which meet the conditions specified in the query. Syntax : delete from table_name where condition;
truncate command is used to delete all the rows from a table keeping the table structure intact.

Syntax : truncate table table_name;

Question 2 : What are the different subsets of SQL ?

Ans : The different subsets of SQL are DDL, DML, DCL, TCL . Each one is discused in detail below.

DDL ( Data Definition Language ) : This subset mainly consist of sql commands such as CREATE, ALTER, DROP. CREATE command is used to create a new table in sql. ALTER command is used to alter table structure. DROP command is used to drop tables.
DML ( Data Manipulation Language ) : In sql we use certain commands to update, delete or manipulate the contains of a table. These commands are SELECT , INSERT, UPDATE, DELETE. SELECT command is used to display rows of a table. INSERT command is used to add rows in a table. UPDATE command is used to update the values in rows of a table. DELETE command is used to delete rows of a table.
DCL ( Data Control Language ) : DCL in sql is used to revoke or grant access to a user. Example : REVOKE command is used to revoke access from a user. GRANT command is used to grant certain access to a user.
TCL ( Transaction Control Language ) : It is used to manage transactions within the database. TCL commands include COMMIT, ROLLBACK, and SAVEPOINT. COMMIT is used to commit changes made during a transaction, ROLLBACK is used to undo changes made during a transaction, and SAVEPOINT is used to mark a point within a transaction that can be rolled back to if necessary.

Question 3 : What do you mean by DBMS> What are its different types ?

Ans : A DBMS (Database Management System) is a software or technology used to manage data from a database. It allows users to store, modify and retrieve data in an organized way. It also provides security to the database.

These are the types of DBMS :

Hierarchical DBMS

Hierarchical DBMS organizes data in a tree-like structure with parent-child relationships.
Each parent can have multiple children, but a child can have only one parent.
Data navigation is done through paths.

Network DBMS

Network DBMS allows more flexible relationships, where a child can have multiple parents.
Uses a network model with sets and records.
Data navigation is done through sets.

Relational DBMS (RDBMS)

Relational DBMS stores data in tables with rows and columns.
Relationships are established using keys.
Data access is done using SQL (Structured Query Language).

NoSQL DBMS

NoSQL DBMS is designed for handling large volumes of unstructured or semi-structured data.
Includes document databases, key-value stores, column-family stores, and graph databases.
Data access varies depending on the specific NoSQL type.

Object Oriented DBMS (ODBMS)

Object Oriented DBMS stores data as objects, which can have attributes and methods.
Supports inheritance, encapsulation, and polymorphism.
Data access is done using object query language (OQL).

Question 4 : What do you mean by table and field in SQL ?

Ans : Table: A table is a structured collection of related data organized in rows and columns within a database. Each table represents an entity (e.g., “Students” or “Employees”) and stores data for that specific category. For example, a table named Students might store data like student ID, name, age, and department for each student.

Field (or Column): A field is a single attribute or data type in a table, defining what type of information each entry (row) in the table will hold. In the Students table example, fields could include StudentID, Name, Age, and Department. Each field has a specific data type, like INTEGER, VARCHAR, or DATE, which dictates the kind of data that can be stored in that column.

Question 5: What is foreign key?

Ans : A foreign key in SQL is a column (or a set of columns) in one table that references the primary key of another table. This key is used to create a link between two tables, ensuring referential integrity by making sure that the values in the foreign key column(s) match values in the primary key column(s) of the referenced table.
Example

Let’s say you have two tables: Orders and Customers.

Step 1: Create the Customers table

CREATE TABLE Customers (
    CustomerID INT PRIMARY KEY,
    CustomerName VARCHAR(100),
    ContactNumber VARCHAR(15)
);

Step 2: Create the Orders table with a foreign key referencing Customers

CREATE TABLE Orders (
    OrderID INT PRIMARY KEY,
    OrderDate DATE,
    CustomerID INT,
    FOREIGN KEY (CustomerID) REFERENCES Customers(CustomerID)
);

In this example:

CustomerID in the Orders table is the foreign key that references
CustomerID in the Customers table.
This ensures each order is linked to an existing customer.
Thanks for reading !!

useState in react explained in 5 mins

Shreyas Ghanekar — Fri, 08 Nov 2024 14:36:20 +0000

Understanding useState in React in 5 Minutes
When building web applications with React, we often rely on hooks to add functionality to functional components. Hooks allow us to use features typically reserved for class components — like managing state and lifecycle methods — without the need for classes or the this keyword. One of the most popular hooks in React is useState , lets explore it !!

What is useState?
The useState hook lets you add state to functional components. Whether you're working with numbers, strings, arrays, or objects, useState helps you manage updates to your data and re-render your component whenever the data changes. For example, you might use useState to keep track of a counter that increments each time a button is pressed.

useState Syntax
The syntax for useState is straightforward:

const [variableName, setVariableName] = useState(initialValue);

variableName is the state variable that holds the current value.
setVariableName is a function that updates the state.
initialValue is the initial value you want the variable to hold.
Example: Using useState for a Counter
Let’s look at a simple example where we create a counter that increments by one each time a button is pressed.

import React, { useState } from 'react';
function counter ()
{
const [count, setCount] =useState(0);

function increaseCount()
{
setCount(count+1);

}
return (
<div>
<p>{count}</p>
<button onclick={increaseCount}>Tap</button>
</div>
)
}

export default counter;

In this code:
count is the state variable with an initial value of 0.
setCount is a function that lets us update count.
Each time we call increaseCount, setCount is used to update count by incrementing it by 1.

A Few Tips

Rerendering on State Change: Every time you call setCount with a new value, React rerenders the component to display the updated state.
Avoid Direct State Modification: Always use the setter function (setCount here) instead of modifying the variable directly. This ensures React knows about the update.
Initial Value: You can pass any initial value to useState, whether it’s a string, array, or object.

Using useState is a simple yet powerful way to manage local state in React, and it’s often the first hook developers learn. Mastering it is essential for creating dynamic, interactive applications.