summaryrefslogtreecommitdiffstats
path: root/sqlchat
diff options
context:
space:
mode:
authort.me/xtekky <98614666+xtekky@users.noreply.github.com>2023-04-22 15:08:19 +0200
committert.me/xtekky <98614666+xtekky@users.noreply.github.com>2023-04-22 15:08:19 +0200
commit85a1961b640e552b3abebae2462a1b425cd87f4f (patch)
tree45b931f9458edc8903fad7f5dc4f08781296da5f /sqlchat
parentdocu (diff)
downloadgpt4free-85a1961b640e552b3abebae2462a1b425cd87f4f.tar
gpt4free-85a1961b640e552b3abebae2462a1b425cd87f4f.tar.gz
gpt4free-85a1961b640e552b3abebae2462a1b425cd87f4f.tar.bz2
gpt4free-85a1961b640e552b3abebae2462a1b425cd87f4f.tar.lz
gpt4free-85a1961b640e552b3abebae2462a1b425cd87f4f.tar.xz
gpt4free-85a1961b640e552b3abebae2462a1b425cd87f4f.tar.zst
gpt4free-85a1961b640e552b3abebae2462a1b425cd87f4f.zip
Diffstat (limited to 'sqlchat')
-rw-r--r--sqlchat/README.md42
-rw-r--r--sqlchat/__init__.py117
2 files changed, 159 insertions, 0 deletions
diff --git a/sqlchat/README.md b/sqlchat/README.md
new file mode 100644
index 00000000..89d38fae
--- /dev/null
+++ b/sqlchat/README.md
@@ -0,0 +1,42 @@
+### Example: `sqlchat` (use like openai pypi package) <a name="example-sqlchat"></a>
+
+```python
+# Import sqlchat
+import sqlchat
+
+# sqlchat.Completion.create
+# sqlchat.StreamCompletion.create
+
+[...]
+
+```
+
+#### Example Chatbot
+```python
+messages = []
+
+while True:
+ user = input('you: ')
+
+ sqlchat_cmpl = sqlchat.Completion.create(
+ prompt = user,
+ messages = messages
+ )
+
+ print('gpt:', sqlchat_cmpl.completion.choices[0].text)
+
+ messages.extend([
+ {'role': 'user', 'content': user },
+ {'role': 'assistant', 'content': sqlchat_cmpl.completion.choices[0].text}
+ ])
+```
+
+#### Streaming Response:
+
+```python
+for response in sqlchat.StreamCompletion.create(
+ prompt = 'write python code to reverse a string',
+ messages = []):
+
+ print(response.completion.choices[0].text)
+```
diff --git a/sqlchat/__init__.py b/sqlchat/__init__.py
new file mode 100644
index 00000000..b55c0e46
--- /dev/null
+++ b/sqlchat/__init__.py
@@ -0,0 +1,117 @@
+from requests import post
+from time import time
+
+headers = {
+ 'authority' : 'www.sqlchat.ai',
+ 'accept' : '*/*',
+ 'accept-language': 'en,fr-FR;q=0.9,fr;q=0.8,es-ES;q=0.7,es;q=0.6,en-US;q=0.5,am;q=0.4,de;q=0.3',
+ 'content-type' : 'text/plain;charset=UTF-8',
+ 'origin' : 'https://www.sqlchat.ai',
+ 'referer' : 'https://www.sqlchat.ai/',
+ 'sec-fetch-dest' : 'empty',
+ 'sec-fetch-mode' : 'cors',
+ 'sec-fetch-site' : 'same-origin',
+ 'user-agent' : 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/112.0.0.0 Safari/537.36',
+}
+
+class SqlchatResponse:
+ class Completion:
+ class Choices:
+ def __init__(self, choice: dict) -> None:
+ self.text = choice['text']
+ self.content = self.text.encode()
+ self.index = choice['index']
+ self.logprobs = choice['logprobs']
+ self.finish_reason = choice['finish_reason']
+
+ def __repr__(self) -> str:
+ return f'''<__main__.APIResponse.Completion.Choices(\n text = {self.text.encode()},\n index = {self.index},\n logprobs = {self.logprobs},\n finish_reason = {self.finish_reason})object at 0x1337>'''
+
+ def __init__(self, choices: dict) -> None:
+ self.choices = [self.Choices(choice) for choice in choices]
+
+ class Usage:
+ def __init__(self, usage_dict: dict) -> None:
+ self.prompt_tokens = usage_dict['prompt_chars']
+ self.completion_tokens = usage_dict['completion_chars']
+ self.total_tokens = usage_dict['total_chars']
+
+ def __repr__(self):
+ return f'''<__main__.APIResponse.Usage(\n prompt_tokens = {self.prompt_tokens},\n completion_tokens = {self.completion_tokens},\n total_tokens = {self.total_tokens})object at 0x1337>'''
+
+ def __init__(self, response_dict: dict) -> None:
+
+ self.response_dict = response_dict
+ self.id = response_dict['id']
+ self.object = response_dict['object']
+ self.created = response_dict['created']
+ self.model = response_dict['model']
+ self.completion = self.Completion(response_dict['choices'])
+ self.usage = self.Usage(response_dict['usage'])
+
+ def json(self) -> dict:
+ return self.response_dict
+
+class Completion:
+ def create(
+ prompt: str = 'hello world',
+ messages: list = []) -> SqlchatResponse:
+
+ response = post('https://www.sqlchat.ai/api/chat', headers=headers, stream=True,
+ json = {
+ 'messages': messages,
+ 'openAIApiConfig':{'key':'','endpoint':''}})
+
+ return SqlchatResponse({
+ 'id' : f'cmpl-1337-{int(time())}',
+ 'object' : 'text_completion',
+ 'created': int(time()),
+ 'model' : 'gpt-3.5-turbo',
+ 'choices': [{
+ 'text' : response.text,
+ 'index' : 0,
+ 'logprobs' : None,
+ 'finish_reason' : 'stop'
+ }],
+ 'usage': {
+ 'prompt_chars' : len(prompt),
+ 'completion_chars' : len(response.text),
+ 'total_chars' : len(prompt) + len(response.text)
+ }
+ })
+
+class StreamCompletion:
+ def create(
+ prompt : str = 'hello world',
+ messages: list = []) -> SqlchatResponse:
+
+ messages.append({
+ 'role':'user',
+ 'content':prompt
+ })
+
+ response = post('https://www.sqlchat.ai/api/chat', headers=headers, stream=True,
+ json = {
+ 'messages': messages,
+ 'openAIApiConfig':{'key':'','endpoint':''}})
+
+ for chunk in response.iter_content(chunk_size = 2046):
+ yield SqlchatResponse({
+ 'id' : f'cmpl-1337-{int(time())}',
+ 'object' : 'text_completion',
+ 'created': int(time()),
+ 'model' : 'gpt-3.5-turbo',
+
+ 'choices': [{
+ 'text' : chunk.decode(),
+ 'index' : 0,
+ 'logprobs' : None,
+ 'finish_reason' : 'stop'
+ }],
+
+ 'usage': {
+ 'prompt_chars' : len(prompt),
+ 'completion_chars' : len(chunk.decode()),
+ 'total_chars' : len(prompt) + len(chunk.decode())
+ }
+ }) \ No newline at end of file