Posts: Discourse Posts
insert REST
- Katalog:
Discourse - Schema:
Posts - Label: Posts
Get a list of the latest posts across topics
Mit insert können Daten abgerufen und geändert werden.
Zusammenfassung
Get a list of the latest posts across topics
API-Quelle
- Endpunkt:
/posts.json - Operation:
get /posts.json
Leistungsmerkmale
| Characteristic | Value |
|---|---|
| Durchschnittliche Zugriffsverzögerung (ms) | 243 |
| Zeilen pro Minute schreiben | 219 |
Das Ergebnis kann auf dem Client im Cache zwischengespeichert werden.
Tabellenspalten
Die Spalten der Tabelle Posts sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.
| Name | Datentyp | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
accepted_ |
char |
Akzeptierte Antwort | filters on the platform, writable, accepted_ |
||
action_ |
varchar2 |
Aktionscode | filters on the platform, writable, action_ |
||
admin |
char |
Administrator | filters on the platform, writable, admin |
||
avatar_ |
varchar2 |
Avatar-Schablone | filters on the platform, writable, avatar_ |
||
avg_ |
varchar2 |
itgen_dce_avg_time | writable | The JSON text of the nested object. | |
bookmarked |
char |
Bookmarked | filters on the platform, writable, bookmarked |
||
can_ |
char |
Antwort als richtige Antwort markieren | filters on the platform, writable, can_ |
||
can_ |
char |
Kann löschen | filters on the platform, writable, can_ |
||
can_ |
char |
Kann bearbeiten | filters on the platform, writable, can_ |
||
can_ |
varchar2 |
Kann wiederhergestellt werden | writable | The JSON text of the nested object. | |
can_ |
char |
Antwort ablehnen | filters on the platform, writable, can_ |
||
can_ |
char |
View, Bearbeiten, Verlauf | filters on the platform, writable, can_ |
||
can_ |
char |
Ist wahlberechtigt | filters on the platform, writable, can_ |
||
can_ |
char |
Kann man das in ein Wiki-Format umwandeln? | filters on the platform, writable, can_ |
||
category_ |
decimal |
Kategorie-ID | filters on the platform, writable, category_ |
||
cooked |
varchar2 |
Cooked | filters on the platform, writable, cooked |
||
created_ |
varchar2 |
Erstellt bei | filters on the platform, writable, created_ |
||
deleted_ |
varchar2 |
Gelöscht am | writable | The JSON text of the nested object. | |
display_ |
varchar2 |
Benutzernamen anzeigen | filters on the platform, writable, display_ |
||
edit_ |
varchar2 |
Grund für die Bearbeitung | writable | The JSON text of the nested object. | |
hidden |
char |
Hidden | filters on the platform, writable, hidden |
||
id |
decimal |
ID | filters on the platform, writable, id |
||
incoming_ |
decimal |
#Eingehende Links | filters on the platform, writable, incoming_ |
||
moderator |
char |
Moderator | filters on the platform, writable, moderator |
||
name |
varchar2 |
Name | filters on the platform, writable, name |
||
notice_ |
varchar2 |
Art der Bekanntmachung | filters on the platform, writable, notice. |
||
post_ |
decimal |
Beitragsnummer | filters on the platform, writable, post_ |
||
post_ |
decimal |
Beitragstyp | filters on the platform, writable, post_ |
||
primary_ |
varchar2 |
itgen_dce_primary_group_flair_bg_color | writable | The JSON text of the nested object. | |
primary_ |
varchar2 |
itgen_dce_primary_group_flair_color | writable | The JSON text of the nested object. | |
primary_ |
varchar2 |
itgen_dce_primary_group_flair_url | writable | The JSON text of the nested object. | |
primary_ |
varchar2 |
Name der Hauptgruppe | writable | The JSON text of the nested object. | |
quote_ |
decimal |
#Quotes | filters on the platform, writable, quote_ |
||
raw |
varchar2 |
Raw | filters on the platform, writable, raw |
||
readers_ |
int32 |
Leserzahlen | filters on the platform, writable, readers_ |
||
reads |
decimal |
#Reads | filters on the platform, writable, reads |
||
reply_ |
decimal |
#Replies | filters on the platform, writable, reply_ |
||
reply_ |
varchar2 |
Auf Beitrag Nummer antworten | writable | The JSON text of the nested object. | |
reply_ |
varchar2 |
Antwort auf die Benutzer-Avatar-Schablone | filters on the platform, writable, reply_ |
||
reply_ |
varchar2 |
Antwort an Benutzer „Benutzername“ | filters on the platform, writable, reply_ |
||
reviewable_ |
int32 |
Anzahl der bewertbaren Punkte | filters on the platform, writable, reviewable_ |
||
reviewable_ |
int32 |
Anzahl der noch zu prüfenden Bewertungen | filters on the platform, writable, reviewable_ |
||
score |
decimal |
Score | filters on the platform, writable, score |
||
staff |
char |
Staff | filters on the platform, writable, staff |
||
static_ |
char |
Statisches Dokument | filters on the platform, writable, static_ |
||
title_ |
char |
Titel ist Gruppe | filters on the platform, writable, title_ |
||
topic_ |
varchar2 |
Thema HTML-Titel | filters on the platform, writable, topic_ |
||
topic_ |
decimal |
Themen-ID | filters on the platform, writable, topic_ |
||
topic_ |
varchar2 |
Themen-Slug | filters on the platform, writable, topic_ |
||
topic_ |
varchar2 |
Thementitel | filters on the platform, writable, topic_ |
||
trust_ |
decimal |
Vertrauensstufe | filters on the platform, writable, trust_ |
||
updated_ |
varchar2 |
Aktualisiert am | filters on the platform, writable, updated_ |
||
user_ |
char |
Benutzer wurde gelöscht | filters on the platform, writable, user_ |
||
user_ |
decimal |
Benutzer-Kennung | filters on the platform, writable, user_ |
||
user_ |
varchar2 |
Titel des Benutzers | writable | The JSON text of the nested object. | |
username |
varchar2 |
Benutzername | filters on the platform, writable, username |
||
version |
decimal |
Version | filters on the platform, writable, version |
||
via_ |
char |
Per E-Mail | filters on the platform, writable, via_ |
||
wiki |
char |
Wiki | filters on the platform, writable, wiki |
||
yours |
char |
Yours | filters on the platform, writable, yours |
Tasten
| Key | Column | Bezieht sich auf | Kind | Description |
|---|---|---|---|---|
Posts_ |
category_ |
Categories.id |
Candidate | Not stated by Discourse; found on the data of the smoke forum on 2026-10-31, where every filled value is in the referenced table. |
Verwiesen von
- Posts_Latest_postsActions_summary
id_2(Candidate)
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert:
Änderungen an dieser Tabelle, 26.0 bis 27.0
-avg_time~can_recover(database_data_type:varchar2→char)~can_recover(dotnet_data_type:string→boolean)~category_id(database_data_type:decimal→int64)~category_id(dotnet_data_type:decimal→int64)~id(database_data_type:decimal→int64)~id(dotnet_data_type:decimal→int64)~incoming_link_count(database_data_type:decimal→int64)~incoming_link_count(dotnet_data_type:decimal→int64)~post_number(database_data_type:decimal→int64)~post_number(dotnet_data_type:decimal→int64)~post_type(database_data_type:decimal→int64)~post_type(dotnet_data_type:decimal→int64)-primary_group_flair_bg_color-primary_group_flair_color
42 weitere Änderungen
Discourse.Posts.Posts: Typänderungen
Der Typ von „Discourse.Posts.Posts“ ändert sich von „Tabelle“ zu „Tabellenfunktion“.
Was ist zu tun?
Überprüfen Sie vor dem Upgrade alle Statements, Views und Skripte, die diese Spalte verwenden.
- kann ein Statement unterbrechen
table→tablefunction- Bedeutung 3
Der Parameter „before“ wird zu „Discourse.Posts.Posts“ hinzugefügt
Optional.
- Bedeutung 2
-primary_group_flair_url~quote_count(database_data_type:decimal→int64)~quote_count(dotnet_data_type:decimal→int64)~readers_count(database_data_type:int32→int64)~readers_count(dotnet_data_type:int32→int64)~reads(database_data_type:decimal→int64)~reads(dotnet_data_type:decimal→int64)~reply_count(database_data_type:decimal→int64)~reply_count(dotnet_data_type:decimal→int64)~reviewable_score_count(database_data_type:int32→int64)~reviewable_score_count(dotnet_data_type:int32→int64)~reviewable_score_pending_count(database_data_type:int32→int64)~reviewable_score_pending_count(dotnet_data_type:int32→int64)-static_doc~topic_id(database_data_type:decimal→int64)~topic_id(dotnet_data_type:decimal→int64)~trust_level(database_data_type:decimal→int64)~trust_level(dotnet_data_type:decimal→int64)~user_id(database_data_type:decimal→int64)~user_id(dotnet_data_type:decimal→int64)~version(database_data_type:decimal→int64)~version(dotnet_data_type:decimal→int64)+archetype(varchar2)+auto_track(char)+can_see_hidden_post(char)+category(int32)+embed_url(varchar2)+excerpt(varchar2)+external_id(varchar2)+flair_bg_color(varchar2)+flair_color(varchar2)+flair_group_id(varchar2)+flair_name(varchar2)+flair_url(varchar2)+post_url(varchar2)+posts_count(int64)+reviewable_id(varchar2)+target_recipients(varchar2)+title(varchar2)+truncated(char)