Metadata-Version: 2.4
Name: psql-temp
Version: 1.0.0
Summary: PostgreSQL Flask default templates - College Management, Auth Log, Admission, Custom
Home-page: https://github.com/psql-temp/psql-temp
Author: Tamilselvan Cyber security Researcher
Classifier: Development Status :: 4 - Beta
Classifier: Intended Audience :: Developers
Classifier: License :: OSI Approved :: MIT License
Classifier: Programming Language :: Python :: 3
Classifier: Programming Language :: Python :: 3.8
Classifier: Programming Language :: Python :: 3.9
Classifier: Programming Language :: Python :: 3.10
Classifier: Programming Language :: Python :: 3.11
Classifier: Topic :: Database
Classifier: Topic :: Software Development :: Libraries :: Python Modules
Requires-Python: >=3.8
Description-Content-Type: text/markdown
Requires-Dist: flask>=2.0.0
Requires-Dist: psycopg2-binary>=2.9.0
Requires-Dist: python-dotenv>=1.0.0
Dynamic: author
Dynamic: classifier
Dynamic: description
Dynamic: description-content-type
Dynamic: home-page
Dynamic: requires-dist
Dynamic: requires-python
Dynamic: summary

# psql-temp

**PostgreSQL Flask Default Templates** - Ready-to-use templates for Flask applications with PostgreSQL.

*Developed BY Tamilselvan Cyber security Researcher*

## Templates

1. **College Management System** - Departments, students, faculty management
2. **Authentication Log Management** - Login/logout, auth logs, activity tracking
3. **College Admission Registrations** - Courses, applicants, application forms
4. **Custom Template** - Choose options 1-3, add custom fields, generate template

## Installation

```bash
cd psql
pip install -e .
```

## Usage

### Interactive CLI

```bash
psql-temp
```

- Select template 1-4
- For **Custom (4)**: Choose from options 1, 2, 3; enter `0` to add custom options; `Y` to create

### Direct Template Selection

```bash
psql-temp 1 -o ./my_project     # College Management
psql-temp 2 -o ./auth_project   # Auth Log
psql-temp 3 -o ./admission      # Admission
psql-temp --custom              # Custom builder
```

### Run Templates (in package directory)

```bash
python run_template.py college_management
python run_template.py auth_log
python run_template.py admission
```

### Python Usage

```python
from psql_temp import create_app
from psql_temp.db import get_db_connection

app = create_app('college_management')  # or 'auth_log', 'admission', 'custom'
```

## Environment

Copy `.env.example` to `.env`:
```
DATABASE_URL=postgresql://user:password@localhost:5432/dbname
FLASK_SECRET_KEY=your-secret-key
```
