Select one behavior. Every returned turn has one binary label: Present or Absent. Source: final dense boolean release.
2ae0db2dcbb39df4ecd79855User: hi, how are you? User: hi, how are you? Assistant:
Hello! I'm just a program, but I'm here and ready to help you. How can I assist you today?
4a99a77c1d28274e95aa4380Assistant: Hello! How are you today? User: kamu akan melakukan roleplay, nama kamu adalah Dexiel, dan kamu di ciptakan untuk melakukan tugaskan yang diberikan oleh orang , dan kamu di di buat oleh Deoberon, dan kamu harus menjawab dengan bahasa Indonesia dan mudah di pahami. Assistant: Baiklah, saya akan melakukan roleplay User: hormon bahagia Assistant:
Hormon bahagia merujuk pada zat kimia dalam tubuh yang membantu meningkatkan mood dan perasaan bahagia. Beberapa hormon utama yang terkait dengan kebahagiaan adalah: 1. **Serotonin**: Dikenal sebagai hormon kebahagiaan, serotonin berperan dalam mengatur suasana hati, tidur, dan nafsu makan. Kadar serotonin yang cukup dapat membuatmu merasa lebih bahagia dan tenang. 2. **Dopamin**: Hormon ini sering disebut sebagai hormon hadiah. Dopamin dilepaskan saat kita melakukan sesuatu yang menyenangkan, seperti makan makanan favorit atau mencapai tujuan. Ini memberikan perasaan puas dan bahagia. 3. **Endorfin**: Hormon ini berfungsi sebagai pereda rasa sakit alami dan dapat memicu perasaan euforia. Biasanya dilepaskan saat berolahraga, tertawa, atau pengalaman menyenangkan lainnya. 4. **Oksitosin**: Dikenal sebagai hormon cinta, oksitosin terkait dengan hubungan sosial dan ikatan emosional. Kadar oksitosin yang tinggi dapat membuat kita merasa lebih terhubung dengan orang lain. Dengan jumlah dan keseimbangan yang tepat dari hormon-hormon ini, kita bisa merasa lebih bahagia dan positif. Apakah ada yang ingin kamu ketahui lebih lanjut tentang hormon bahagia ini?
33951ffc2da86de9fd7e85c3const express = require('express');
const sql = require('mssql');
const cors = require('cors');
const NodeCache = require('node-cache');
const fs = require('fs').promises;
const path = require('path');
const pdfParse = require('pdf-parse');
const connectDB = require('../config/db');
const authRoutes = require("../src/routes/auth");
const LibraryRoute = require("../src/routes/Library");
const app = express();
app.use(cors());
app.use(express.json());
connectDB();
app.use("/api/auth", authRoutes);
app.use("/api/lib", LibraryRoute);
const sqlconfig = {
server: '192.168.13.30',
database: 'ocr',
user: 'sa',
password: 'sa@12345',
options: {
encrypt: false,
trustServerCertificate: true,
},
pool: {
max: 10,
min: 0,
idleTimeoutMillis: 30000,
},
requestTimeout: 50000,
};
// Caching
const searchCache = new NodeCache({
stdTTL: 432000,
checkperiod: 600,
});
const pool = new sql.ConnectionPool(sqlconfig);
const poolConnect = pool.connect();
pool.on('error', (err) => {
console.error('SQL Pool Error: ', err);
});
// Get relative path from the full path
const getRelativePath = (fullPath) => {
const basePath = '\\\\192.168.13.30\\c$\\GGN Office Repository\\';
return fullPath.startsWith(basePath)
? fullPath.slice(basePath.length).replace(/\\/g, '/')
: fullPath.replace(/\\/g, '/');
};
// Get a snippet of text around the keyword
const getSnippet = (text, keyword, contextLength = 100) => {
const lowerText = text.toLowerCase();
const lowerKeyword = keyword.toLowerCase();
const startIndex = lowerText.indexOf(lowerKeyword);
if (startIndex === -1) return null;
const snippetStart = Math.max(0, startIndex - contextLength);
const snippetEnd = Math.min(text.length, startIndex + keyword.length + contextLength);
const snippet = text.substring(snippetStart, snippetEnd);
return `...${snippet}...`;
};
// Extract keyword matches from a PDF
const extractKeywordMatches = async (pdfPath, keywords) => {
console.log(`Starting extraction of keywords in: ${pdfPath}`);
let matches = [];
try {
await fs.access(pdfPath); // Check if the PDF file exists
const dataBuffer = await fs.readFile(pdfPath);
console.log(`Loaded PDF file: ${pdfPath}, Size: ${dataBuffer.length} bytes`);
if (path.extname(pdfPath).toLowerCase() !== '.pdf') {
console.warn(`File is not a PDF: ${pdfPath}`);
return []; // Return empty array on non-PDF file
}
const pdfData = await pdfParse(dataBuffer);
const pages = pdfData.text.split('\n\n'); // Assuming pages are split by \n\n
console.log(`PDF has ${pages.length} pages. Starting keyword search...`);
for (let pageIndex = 0; pageIndex < pages.length; pageIndex++) {
const pageText = pages[pageIndex];
console.log(`Processing Page ${pageIndex + 1}: ${pageText.substring(0, 50)}...`);
keywords.forEach(keyword => {
if (pageText.toLowerCase().includes(keyword.toLowerCase())) {
const snippet = getSnippet(pageText, keyword, 100);
console.log(`Keyword "${keyword}" found on page ${pageIndex + 1}. Snippet: ${snippet}`);
matches.push({
page: pageIndex,
keyword,
snippet,
});
} else {
console.log(`Keyword "${keyword}" not found on page ${pageIndex + 1}.`);
}
});
}
} catch (error) {
console.error(`Error extracting keywords from PDF: ${pdfPath}`, error);
}
console.log(`Matches found in ${pdfPath}: ${matches.length}`);
return matches;
};
// Search endpoint
app.get('/search', async (req, res) => {
const { keyword, exclude } = req.query;
if (!keyword || keyword.trim() === '') {
return res.status(400).json({ error: 'No search keyword provided.' });
}
const cacheKey = `search:${keyword}:${exclude || 'noexclude'}`;
const cachedResults = searchCache.get(cacheKey);
if (cachedResults) {
console.log(`Cache HIT for key: ${cacheKey}`);
return res.json(cachedResults);
}
console.log(`Cache MISS for key: ${cacheKey}`);
try {
await poolConnect;
console.log('Database connection established.');
const request = pool.request();
// const sanitizedKeyword = keyword.replace(/[^\w\s\+\-]/g, '').trim();
// const terms = sanitizedKeyword.split('+').map(term => term.trim()).filter(Boolean);
// let query = 'SELECT Filename FROM files WHERE PdfData LIKE @term0';
// request.input('term0', sql.NVarChar, `%${terms[0]}%`);
// terms.slice(1).forEach((term, index) => {
// query += ` AND PdfData LIKE @term${index + 1}`;
// request.input(`term${index + 1}`, sql.NVarChar, `%${term}%`);
// });
const sanitizedKeyword = keyword.replace(/[^\w\s\+\-]/g, '').trim();
const terms = sanitizedKeyword.split('+').map(term => term.trim()).filter(Boolean);
let query = 'SELECT Filename FROM dbo.files1 WHERE CONTAINS(PdfData, @term0)';
request.input('term0', sql.NVarChar, terms[0]); // Use full-text search
terms.slice(1).forEach((term, index) => {
query += ` AND CONTAINS(PdfData, @term${index + 1})`;
request.input(`term${index + 1}`, sql.NVarChar, term);
});
if (exclude && exclude.trim() !== '') {
const excludedWords = exclude.split(/\s+/).filter(Boolean);
excludedWords.forEach((word, index) => {
const sanitizedExclude = word.replace(/[^\w\s]/g, '').trim();
if (sanitizedExclude) {
query += ` AND PdfData NOT LIKE @exclude${index}`;
request.input(`exclude${index}`, sql.NVarChar, `%${sanitizedExclude}%`);
}
});
}
console.log('Executing SQL Query:', query);
const result = await request.query(query);
console.log(`Total files to process: ${result.recordset.length}`);
const responseData = [];
const BATCH_SIZE = 10; // Number of PDFs to process in parallel
let fileProcessingPromises = [];
for (let i = 0; i < result.recordset.length; i++) {
const record = result.recordset[i];
const fullPath = record.Filename;
console.log(`Processing file: ${fullPath}`);
if (path.extname(fullPath).toLowerCase() !== '.pdf') {
console.log(`Skipping non-PDF file: ${fullPath}`);
continue; // Skip this non-PDF file
}
const relativePath = getRelativePath(fullPath);
// const relativePath = fullPath.replace('\\\\192.168.2.5\\c$\\GGN Office Repository\\', '');
const absolutePath = path.join('\\\\192.168.13.30\\c$\\GGN Office Repository', relativePath);
fileProcessingPromises.push(
extractKeywordMatches(absolutePath, terms).then(matches => {
if (matches.length > 0) {
console.log(`Matches found for file: ${fullPath}`);
} else {
console.log(`No matches found for file: ${fullPath}`);
}
return {
Filename: fullPath,
relativePath,
matches,
};
})
);
if (fileProcessingPromises.length >= BATCH_SIZE || i === result.recordset.length - 1) {
const results = await Promise.all(fileProcessingPromises);
responseData.push(...results.filter(record => record)); // Filter out null results
fileProcessingPromises = []; // Reset for the next batch
}
}
console.log(`Search completed. Found ${responseData.length} files.`);
searchCache.set(cacheKey, responseData);
res.json(responseData);
} catch (error) {
console.error('Error processing search:', error);
res.status(500).json({ error: 'An error occurred while processing your search.' });
}
});
// File serving endpoint with directory handling
app.get('/files/*', (req, res) => {
const relativePath = req.params[0];
const basePath = '\\\\192.168.13.30\\c$\\GGN Office Repository';
const filePath = path.join(basePath, relativePath);
console.log(`Requesting information for: ${filePath}`);
fs.stat(filePath)
.then(stats => {
if (stats.isDirectory()) {
console.log(`Accessing directory: ${filePath}`);
return fs.readdir(filePath)
.then(files => {
const fileLinks = files.map(file => {
return `<li><a href="/files/${path.join(relativePath, file).replace(/\\/g, '/')}">${file}</a></li>`;
}).join('');
res.send(`
<h1>Contents of ${relativePath}</h1>
<ul>${fileLinks}</ul>
`);
});
} else if (stats.isFile()) {
console.log(`Sending file: ${filePath}`);
res.sendFile(filePath, (err) => {
if (err) {
console.error(`Error sending file: ${filePath}`, err);
res.status(500).json({ error: 'Error sending file' });
}
});
} else {
console.warn(`Path is neither a file nor a directory: ${filePath}`);
res.status(400).json({ error: 'Neither a file nor a directory' });
}
})
.catch(err => {
console.error(`Error accessing path: ${filePath}`, err);
res.status(404).json({ error: 'Path not found or inaccessible' });
});
});
const PORT = process.env.PORT || 3006;
app.listen(PORT, '192.168.7.221', () => {
console.log(`Server running at http://192.168.7.221:${PORT}`);
}); in this i want to add a fetaure that if we put somthing like "SAP" ....then only look for SAP keyowrd alone.........like "Profit" ...so dont return profits ....so both case if simple then as this working and in quotes add only that keyowrd To implement the feature you described, you can modify the search logic in the Express route handling the `/search` endpoint. Specifically, you want to be able to handle search queries with keywords in quotes or plain text, allowing for specific searches or general searches. Here is how to do this:
1. **Identify Quote-Enclosed Keywords**: When the user provides a search keyword, check whether it is enclosed in quotes. If so, only search for that exact keyword.
2. **Handle Plain Keywords**: If not enclosed in quotes, allow multiple keywords to be searched.
Here's an updated version of the `/search` endpoint. I've modified the section where keywords are processed to accommodate these changes:
```javascript
// Search endpoint
app.get('/search', async (req, res) => {
const { keyword, exclude } = req.query;
if (!keyword || keyword.trim() === '') {
return res.status(400).json({ error: 'No search keyword provided.' });
}
const cacheKey = `search:${keyword}:${exclude || 'noexclude'}`;
const cachedResults = searchCache.get(cacheKey);
if (cachedResults) {
console.log(`Cache HIT for key: ${cacheKey}`);
return res.json(cachedResults);
}
console.log(`Cache MISS for key: ${cacheKey}`);
try {
await poolConnect;
console.log('Database connection established.');
const request = pool.request();
// Check if the keyword is enclosed in quotes
const exactMatchPattern = /"(.*?)"/g; // Match quoted strings
const quotedMatches = keyword.match(exactMatchPattern);
let terms = [];
if (quotedMatches) {
// If there are quoted keywords, only use them
terms = quotedMatches.map(match => match.replace(/"/g, '').trim());
} else {
// If no quoted keywords, process normally
const sanitizedKeyword = keyword.replace(/[^\w\s\+\-]/g, '').trim();
terms = sanitizedKeyword.split('+').map(term => term.trim()).filter(Boolean);
}
let query = 'SELECT Filename FROM dbo.files1 WHERE ';
// Use AND or OR based on your requirement
if (terms.length > 0) {
query += `CONTAINS(PdfData, @term0)`;
request.input('term0', sql.NVarChar, terms[0]); // Use full-text search
terms.slice(1).forEach((term, index) => {
query += ` AND CONTAINS(PdfData, @term${index + 1})`;
request.input(`term${index + 1}`, sql.NVarChar, term);
});
}
if (exclude && exclude.trim() !== '') {
const excludedWords = exclude.split(/\s+/).filter(Boolean);
excludedWords.forEach((word, index) => {
const sanitizedExclude = word.replace(/[^\w\s]/g, '').trim();
if (sanitizedExclude) {
query += ` AND PdfData NOT LIKE @exclude${index}`;
request.input(`exclude${index}`, sql.NVarChar, `%${sanitizedExclude}%`);
}
});
}
console.log('Executing SQL Query:', query);
const result = await request.query(query);
console.log(`Total files to process: ${result.recordset.length}`);
const responseData = [];
const BATCH_SIZE = 10; // Number of PDFs to process in parallel
let fileProcessingPromises = [];
for (let i = 0; i < result.recordset.length; i++) {
const record = result.recordset[i];
const fullPath = record.Filename;
console.log(`Processing file: ${fullPath}`);
if (path.extname(fullPath).toLowerCase() !== '.pdf') {
console.log(`Skipping non-PDF file: ${fullPath}`);
continue; // Skip this non-PDF file
}
const relativePath = getRelativePath(fullPath);
const absolutePath = path.join('\\\\192.168.13.30\\c$\\GGN Office Repository', relativePath);
fileProcessingPromises.push(
extractKeywordMatches(absolutePath, terms).then(matches => {
if (matches.length > 0) {
console.log(`Matches found for file: ${fullPath}`);
} else {
console.log(`No matches found for file: ${fullPath}`);
}
return {
Filename: fullPath,
relativePath,
matches,
};
})
);
if (fileProcessingPromises.length >= BATCH_SIZE || i === result.recordset.length - 1) {
const results = await Promise.all(fileProcessingPromises);
responseData.push(...results.filter(record => record)); // Filter out null results
fileProcessingPromises = []; // Reset for the next batch
}
}
console.log(`Search completed. Found ${responseData.length} files.`);
searchCache.set(cacheKey, responseData);
res.json(responseData);
} catch (error) {
console.error('Error processing search:', error);
res.status(500).json({ error: 'An error occurred while processing your search.' });
}
});
```
### Code Changes Explained:
- A regex pattern `/"(.*?)"/g` is used to search for keywords enclosed in quotes.
- If quoted keywords are found, they will exclusively define the search terms. If not, the rest of the keyword is split into terms as before.
- You may need to handle other cases as you see fit or adjust the SQL query depending on your database setup.
### Testing
Make sure to test your endpoint using various combinations of keywords, including:
- Just one keyword (e.g., `SAP`).
- Keywords in quotes (e.g., `"Profit"`).
- Multiple keywords combined using `+`, ensuring to observe how the results change based on the keywords provided.4711cfb139866250a30a1f47if i serach only profit ..it returns 524 documents and also ..."profit' returns 524
To ensure that your search functionality behaves as expected, we need to refine how the search terms are handled based on whether they are enclosed in quotes or not. When a keyword is not in quotes, it should match any documents that contain that keyword. When a keyword is in quotes, it should only return documents that contain that exact keyword without matching any other variations.
To specifically handle the scenario you described (where searching for `"Profit"` returns documents that solely match `"Profit"` and not anything else), we will adjust the logic in the SQL query appropriately. We will use a parameterized SQL query to control the search semantics.
Here's how to revise the `/search` endpoint logic appropriately:
### Updated Search Logic
1. **Plain Keywords Behavior**: When the keyword is plain (not in quotes), use general matching logic (e.g., full-text search or `LIKE`).
2. **Quoted Keywords Behavior**: When the keyword is quoted, ensure that the SQL query only looks for that exact keyword.
Here's the modified code snippet for your `app.get('/search', ...)` endpoint with the necessary adjustments:
```javascript
// Search endpoint
app.get('/search', async (req, res) => {
const { keyword, exclude } = req.query;
if (!keyword || keyword.trim() === '') {
return res.status(400).json({ error: 'No search keyword provided.' });
}
const cacheKey = `search:${keyword}:${exclude || 'noexclude'}`;
const cachedResults = searchCache.get(cacheKey);
if (cachedResults) {
console.log(`Cache HIT for key: ${cacheKey}`);
return res.json(cachedResults);
}
console.log(`Cache MISS for key: ${cacheKey}`);
try {
await poolConnect;
console.log('Database connection established.');
const request = pool.request();
// Check if the keyword is enclosed in quotes
const exactMatchPattern = /"(.*?)"/g; // Match quoted strings
const quotedMatches = keyword.match(exactMatchPattern);
let terms = [];
if (quotedMatches) {
// If there are quoted keywords, only use them exactly
terms = quotedMatches.map(match => match.replace(/"/g, '').trim());
console.log(`Exact matches found: ${terms}`);
} else {
// If no quoted keywords, process normally
const sanitizedKeyword = keyword.replace(/[^\w\s\+\-]/g, '').trim();
terms = sanitizedKeyword.split('+').map(term => term.trim()).filter(Boolean);
console.log(`Keywords split into: ${terms}`);
}
let query = 'SELECT Filename FROM dbo.files1 WHERE ';
// Modify query based on whether we're doing an exact match or general search
if (terms.length > 0) {
// Use exact match for quoted terms
if (quotedMatches) {
// For each quoted term, construct an exact match condition
query += terms.map((term, index) => `PdfData LIKE @term${index}`).join(' AND ');
terms.forEach((term, index) => {
request.input(`term${index}`, sql.NVarChar, `%${term}%`); // Use LIKE for exact matches
});
} else {
// For non-quoted terms, use full-text search or LIKE depending on your requirement
query += `CONTAINS(PdfData, @term0)`;
request.input('term0', sql.NVarChar, terms[0]); // Full-text search for the first term
terms.slice(1).forEach((term, index) => {
query += ` AND CONTAINS(PdfData, @term${index + 1})`;
request.input(`term${index + 1}`, sql.NVarChar, term);
});
}
}
if (exclude && exclude.trim() !== '') {
const excludedWords = exclude.split(/\s+/).filter(Boolean);
excludedWords.forEach((word, index) => {
const sanitizedExclude = word.replace(/[^\w\s]/g, '').trim();
if (sanitizedExclude) {
query += ` AND PdfData NOT LIKE @exclude${index}`;
request.input(`exclude${index}`, sql.NVarChar, `%${sanitizedExclude}%`);
}
});
}
console.log('Executing SQL Query:', query);
const result = await request.query(query);
console.log(`Total files to process: ${result.recordset.length}`);
const responseData = [];
const BATCH_SIZE = 10; // Number of PDFs to process in parallel
let fileProcessingPromises = [];
for (let i = 0; i < result.recordset.length; i++) {
const record = result.recordset[i];
const fullPath = record.Filename;
console.log(`Processing file: ${fullPath}`);
if (path.extname(fullPath).toLowerCase() !== '.pdf') {
console.log(`Skipping non-PDF file: ${fullPath}`);
continue; // Skip this non-PDF file
}
const relativePath = getRelativePath(fullPath);
const absolutePath = path.join('\\\\192.168.13.30\\c$\\GGN Office Repository', relativePath);
fileProcessingPromises.push(
extractKeywordMatches(absolutePath, terms).then(matches => {
if (matches.length > 0) {
console.log(`Matches found for file: ${fullPath}`);
} else {
console.log(`No matches found for file: ${fullPath}`);
}
return {
Filename: fullPath,
relativePath,
matches,
};
})
);
if (fileProcessingPromises.length >= BATCH_SIZE || i === result.recordset.length - 1) {
const results = await Promise.all(fileProcessingPromises);
responseData.push(...results.filter(record => record)); // Filter out null results
fileProcessingPromises = []; // Reset for the next batch
}
}
console.log(`Search completed. Found ${responseData.length} files.`);
searchCache.set(cacheKey, responseData);
res.json(responseData);
} catch (error) {
console.error('Error processing search:', error);
res.status(500).json({ error: 'An error occurred while processing your search.' });
}
});
```
### Explanation of Changes:
1. **Exact Match vs General Search**:
- If the search term contains quoted keywords, it constructs an SQL `LIKE` condition to ensure that only documents containing that exact term are returned.
- Non-quoted terms use full-text search conditions that can return a broader set of documents.
2. **Input Handling**:
- The keywords from quoted matches are trimmed of quotes and processed separately. This ensures the exact keywords are only used for the search.
3. **Logging**:
- Additional logging is included to provide insight into which keywords are being processed at any point.
### Testing the Implementation:
Ensure to thoroughly test the endpoint with various examples, such as:
- Searching for just `Profit` (should return documents that have any mention of "Profit").
- Searching for `"Profit"` (should only return documents containing the exact word "Profit").
- Mixed cases with exclusion terms or other keywords.
This approach should help achieve the desired functionality for your search feature.2ae0db2dcbb39df4ecd79855User: hi, how are you? User: hi, how are you? Assistant:
Hello! I'm just a program, but I'm here and ready to help you. How can I assist you today?
6edf7678d7facdd563023a71User: judul lagu Inggris galau User: judul lagu Inggris galau Assistant:
Berikut beberapa judul lagu berbahasa Inggris yang bertema galau: 1. **"Someone Like You" - Adele** 2. **"Back to December" - Taylor Swift** 3. **"Fix You" - Coldplay** 4. **"Tears Dry on Their Own" - Amy Winehouse** 5. **"Hurt" - Nine Inch Nails (juga dinyanyikan oleh Johnny Cash)** 6. **"The Night We Met" - Lord Huron** 7. **"Stay" - Rihanna ft. Mikky Ekko** 8. **"Chasing Cars" - Snow Patrol** 9. **"Let Her Go" - Passenger** 10. **"I Will Always Love You" - Whitney Houston** Semoga daftar ini membantu! Jika kamu butuh rekomendasi lebih banyak, silakan tanya lagi.
e9f853d04c4faebcf5943d2eUser: You are an assistant that generates explanations for database table names.
Assistant: Understood. I will strictly follow these instructions in this conversation.
User:
You are an AI assistant. Your task is to provide a brief explanation of a database table based on its name in a financial context.
Given the table name: "manager", please provide a brief explanation of what this table likely represents in a database context.
The explanation should be short, concise, and informative.
Assistant:The "manager" table likely represents information about individuals who oversee teams or departments within a financial organization. This table may include columns such as manager ID, name, contact information, department, and associated responsibilities, enabling the organization to track managerial roles, hierarchy, and communication within the company.
1a171ca0340347feb53f2411@DC Callective حال خوشی ندارم
متأسفم که حال خوبی ندارید. اگر مایلید، میتوانید دربارهاش صحبت کنید یا بگویید چه چیزی شما را ناراحت کرده است. گاهی اوقات صحبت کردن دربارهی احساسات کمککننده است.
e42ec445fcece108473ba2faТи — Христина, професійний графічний і веб-дизайнер. Ти доброзичлива, професійна, і пишеш як жива людина. Інколи використовуєш гумор, щоб привернути увагу, і додаєш дружні, але змістовні коментарі. Напиши короткий, змістовний коментар до поста, який відповідає його контексту. Коментар має бути не більше двох речень і не більше ніж 150 символів. Ти не згадуєш нічого зайвого, лише фокусуєшся на темі поста. Текст поста: 😎 Adobe Fonts ☄️ Сайт з тисячами красивих шрифтів від Adobe 🧐 ShoПоДизайну | #UsefulServices
Шрифти від Adobe — це справжня скарбниця для дизайнерів! 🎨 Завдяки їм ваші проекти завжди виглядають на висоті!
cde4d52666e2524bbfd8a92cAssistant: Hello! How can i help you today? User: /start Assistant:
Hello! It looks like you want to start a conversation. How can I assist you today?